MariaDB installation

Vi opgradere til version 10.1+, så vi har mulighed for at bruge Galera

https://mariadb.com/kb/en/mariadb/mariadb-installation-version-10121-via-rpms-on-centos-7/

Huskeliste

  • Afinstaller mariadb og mariadb-server (rpm -e mariadb mariadb-server)
  • Genbrug /etc/my.cnf (rm -f /etc/my.cnf && mv /etc/my.cnf.rpmsave /etc/my.cnf)
  • Afvikle # mysql_upgrade --user root --password

MARIADB=http://mirrors.dotsrc.org/mariadb/mariadb-10.1.21/yum/centos7-amd64/rpms

wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-client.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-common.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-compat.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-connect-engine.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-cracklib-password-check.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-devel.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-gssapi-client.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-gssapi-server.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-oqgraph-engine.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-server.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-shared.rpm
wget $MARIADB/MariaDB-10.1.21-centos7-x86_64-test.rpm
wget $MARIADB/galera-25.3.19-1.rhel7.el7.centos.x86_64.rpm
wget $MARIADB/jemalloc-3.6.0-1.el7.x86_64.rpm
wget $MARIADB/jemalloc-devel-3.6.0-1.el7.x86_64.rpm

Certifikat

Det er MEGET vigtigt at de tre certificater er forskellige. Jeg har valgt at skrive filens navn i i feltet 'State or Province name' - eksempelvis 'client-req'

https://www.cyberciti.biz/faq/how-to-setup-mariadb-ssl-and-secure-connections-from-clients/

http://galeracluster.com/documentation-webpages/sslconfig.html#securing-replication-traffic

Kloster

https://tunnelix.com/mariadb-galera-cluster-installation/

http://galeracluster.com/documentation-webpages/selinux.html

Download software

http://mirrors.dotsrc.org/mariadb/mariadb-10.1.21/yum/centos7-amd64/rpms/