Show pagesourceOld revisionsBacklinksBack to top Share via Share via... Twitter LinkedIn Facebook Pinterest Telegram WhatsApp Yammer RedditRecent ChangesSend via e-MailPrintPermalink × Table of Contents Mariadb101 by software collections Introduction Maintainer Installation Usage Backup Mysql port and socket E-smith database Log Admin's Feedbacks Bugs Is this Nethserver module helpful to you? Please consider donating to the author Thank you kindly! 2019/03/04 11:32 · HF Mariadb101 by software collections Available NS7 Introduction rh-mariadb101 - A recent stable release of MariaDB 10.1. 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. Maintainer Stephane de Labrusse at stephdl@de-labrusse.fr Installation First you need to install my repository, see how to do it then install the rpm yum install nethserver-rh-mariadb101 --enablerepo=stephdl Usage 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 mysql101 mysqladmin101 mysqlbinlog101 mysqlcheck101 mysql_config_editor101 mysqld_multi101 mysqldump101 mysqlimport101 mysql_plugin101 mysqlshow101 mysqlslap101 - if you want to launch mariadb101 in your terminal, just do mysql101 - 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 backup and restore mariadb101 with the official way (install nethserver-backup-data for this) Mysql port and socket The port is TCP 3311 restricted to the local network, else change access property to public config setprop rh-mariadb101-mariadb access public signal-event nethserver-rh-mariadb101-save the socket is : /var/lib/rh-mariadb101/mariadb.sock 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 cannot use localhost:3311', this direct to the mysql socket and you will use the default mysql version. E-smith database [root@ns7dev9 ~]# config show rh-mariadb101-mariadb rh-mariadb101-mariadb=configuration LocalNetworkingOnly=no MaxAllowedPacket=16M TCPPort=3311 access=private status=enabled any change needs to launch the event 'nethserver-rh-mariadb101-save'. For example config setprop rh-mariadb101-mariadb MaxAllowedPacket 32M signal-event nethserver-rh-mariadb101-save Log the log is at: /var/log/rh-mariadb101/mariadb.log Admin's Feedbacks Bugs Please raise Issues on github module stephdl mariadb101.txt Last modified: 2020/12/21 18:40by Stephane de Labrusse