Nethserver-rh-mariadb101 needs testers

testing
module

(Stéphane de Labrusse) #1

Hi folks

I made a rpm to install rh-mariadb101 from the centos software collection, at this time the 10.2 version is not available, it will be the next upgrade.

yum install http://mirror.de-labrusse.fr/NethDev/nethserver-rh-mariadb101/nethserver-rh-mariadb101-0.0.3-1.ns7.sdl.noarch.rpm

It is supposed to

  • install and start mariadb101
  • manage mariadb101 by phpMyAdmin (install after nethserver-phpmyadmin or launch the event nethserver-phpmyadmin-save)
  • backup and restore mariadb101 with the official way (install nethserver-backup-data for this)

the mariadb101 password is stored at /root/.my.cnf

you have several shorters to ease the usage of this scl

[root@ns7dev8 ~]# ls /usr/bin/|grep 101
mysql101
mysqladmin101
mysqlbinlog101
mysqlcheck101
mysql_config_editor101
mysqld_multi101
mysqldump101
mysqlimport101
mysql_plugin101
mysqlshow101
mysqlslap101

the log is at /var/log/rh-mariadb101/mariadb.log

This rpm can be used with the official nethserver-mysql, somehow you just need to use the port 3311 in your web application to adjust the mysql server (rather the official 3306).

  • 127.0.0.1:3311
  • YourIP:3311

You can also use the new socket

/var/lib/rh-mariadb101/mariadb.sock


(Stéphane de Labrusse) #2

I have an issue on the official mariadb restoration, please wait before to install on a production server :slight_smile:


(Stéphane de Labrusse) #3

in the meanwhile I need to modify nethserver-automysqlbackup to backup mariadb101


(Stéphane de Labrusse) #4

@davidep @giacomo I have a problem

https://github.com/NethServer/nethserver-mysql/blob/master/root/etc/e-smith/events/actions/mysql-load-tables#L62

when I install both nethserver-mysql and nethserver-rh-mariadb101, the server doesn’t kill enough quickly all the mysqld processus, then the script mysql-load-tables fails.

The rh-mariadb101-mariadb.service should not be the guilty (I bet) because I tried to stop it by an action in S01…

If I increase to 2 seconds, then the error disappears

Is it possible to do a PR, Or I need to look after another solution ?


(Davide Principi) #5

OMG “sleep 1” :fearful:

If possibile, we should find another solution definitely!

git blame could explain why it is implemented like that…


(Stéphane de Labrusse) #6

-/usr/bin/killall mysqld
-sleep 1
+mysqladmin shutdown

did the trick for me, it seems it is the correct/official way to stop mysqld_safe


(Giacomo Sanchietti) #7

Your code seems much better, I also would like to have a shorter timeout as Davide suggested inside the pull request.

Give me a little time, a lot of things have piled up on my todo list these days :wink:

Ugly, but works.
It’s “code from passed experiences”. :smiley:

I’d like to switch to mysqladmin command and also retain the sleep.


(Stéphane de Labrusse) #8

please can you test this version, what you can expect, see the first post

Actually you should not install it with nethserver-mysql, during the time @giacomo changes some lines of code in nethserver-mysql, but we can try to debug this module.


(Markus Neuberger) #9

Nice one again!

I did a quick test on 7.4.1708 (beta1) on a Proxmox VM.

Command line:

[root@nethvm ~]# mysql101 -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 18
Server version: 10.1.19-MariaDB MariaDB Server

Filled a new database:

zcat /usr/share/doc/zabbix-server-mysql-3.4.2/create.sql.gz | mysql101 -u zabbix -p zabbix

Windows tool HeidiSQL access:


(Stéphane de Labrusse) #10

do just l’mysql101’

thanks :slight_smile:


(Stéphane de Labrusse) #11

The backup/restoration could be tested also


(Giacomo Sanchietti) #12

New nethserver-mysql-1.1.2-1.3.gfffaeeb.ns7.noarch.rpm pushed to 7.4/updates.

Thanks Stéphane!


(Markus Neuberger) #13

Installed nethserver-mysql-1.1.2-1.3.gfffaeeb by @giacomo and tested backup and restore with rh-mariadb101. Made a data backup and dropped the zabbix database, that I created earlier. Then I made a file restore but phpmyadmin didn’t show the zabbix db. After uploading the config backup and restoring it, the zabbix database was back up again.
MariaDB 10.1 backup/restore Ă  la NethServer works fine for me.

Just another screenshot of a working connection to mariadb101 with squirrelsql:


(Stéphane de Labrusse) #14

cool :slight_smile:

merci beaucoup (thank you so much)


(Alessio Fattorini) #15

You made a man happy :stuck_out_tongue_closed_eyes:

So that, can we close the discussion?


(Stéphane de Labrusse) #16

documentation created -> https://wiki.nethserver.org/doku.php?id=mariadb101

rpm released

thread closed


(Stéphane de Labrusse) #17