Nethserver-rh-mariadb101 needs testers

stephdl · September 30, 2017, 2:25pm

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

stephdl · October 1, 2017, 8:02am

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

stephdl · October 1, 2017, 8:32am

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

stephdl · October 1, 2017, 9:32am

@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 ?

davidep · October 1, 2017, 4:05pm

OMG “sleep 1”

If possibile, we should find another solution definitely!

git blame could explain why it is implemented like that…

stephdl · October 1, 2017, 5:15pm

-/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 · October 2, 2017, 9:54am

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

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

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

stephdl · October 2, 2017, 7:49pm

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.

mrmarkuz · October 2, 2017, 10:39pm

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:

stephdl · October 3, 2017, 5:31am

do just l’mysql101’

thanks

stephdl · October 3, 2017, 8:32am

The backup/restoration could be tested also

giacomo · October 3, 2017, 1:17pm

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

Thanks Stéphane!

mrmarkuz · October 3, 2017, 8:53pm

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:

stephdl · October 4, 2017, 5:16am

cool

merci beaucoup (thank you so much)

alefattorini · October 4, 2017, 4:10pm

You made a man happy

So that, can we close the discussion?

stephdl · October 4, 2017, 7:47pm

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

rpm released

thread closed