mariadb103


Is this Nethserver module helpful to you?
Please consider donating to the author

Thank you kindly!

2019/03/04 11:32 · HF

Available NS7

rh-mariadb103 - A recent stable release of MariaDB 10.3. This Software Collection gives users of CentOS and RHEL an alternative to MySQL, which is binary compatible with MariaDB in most practical cases and can be replaced with it. This version provides several new features and enhancements like Galera Cluster, a synchronous multi-master cluster. It also introduces table, tablespace and log encryption, and page compression.

Stephane de Labrusse at stephdl@de-labrusse.fr

First you need to install my repository, see how to do it then install the rpm

yum install nethserver-rh-mariadb103 --enablerepo=stephdl

You have no panels. If you need one, please install after nethserver-phpmyadmin

you have several shorters to ease the usage of this scl in your terminal

mysql103
mysqladmin103
mysqlbinlog103
mysqlcheck103
mysql_config_editor103
mysqld_multi103
mysqldump103
mysqlimport103
mysql_plugin103
mysqlshow103
mysqlslap103

- if you want to launch mariadb103 in your terminal, just do

mysql103

- If you want to start the software collection after the server reboot, please be aware that you could make issues with softwares not compatible with the software collection version.

Please read the Redhat certified solution.

With that package, you can enable userspace environment automatically by creating a new file under /etc/profile.d with the following content (example for python33 collection): Raw

$ cat /etc/profile.d/enablepython33.sh
#!/bin/bash
source scl_source enable python33

With such file all users will have python 3.3 collection enabled by default in shell.

backup and restore mariadb103 with the official way (install nethserver-backup-data for this)

  • The port is TCP 3313

restricted to the local network, else change access property to public

config setprop rh-mariadb103-mariadb access public
signal-event nethserver-rh-mariadb103-save
  • the socket is : /var/lib/rh-mariadb103/mariadb.sock

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

127.0.0.1:3313
YourIP:3313

You cannot use localhost:3313, this direct to the mysql socket and you will use the default mysql version.

[root@ns7dev9 ~]# config show rh-mariadb103-mariadb 
rh-mariadb103-mariadb=configuration
    LocalNetworkingOnly=no
    MaxAllowedPacket=16M
    TCPPort=3313
    access=private
    status=enabled

any change needs to launch the event 'nethserver-rh-mariadb103-save'. For example

config setprop rh-mariadb103-mariadb MaxAllowedPacket 32M
signal-event nethserver-rh-mariadb103-save

the log is at:

/var/log/rh-mariadb103/mariadb.log

FIXME

Please raise Issues on github