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/
Tags : MariaDB
Created 14/02-2017 by Michael Bornholdt Nielsen
Updated 15/02-2017 by Michael Bornholdt Nielsen