Mariadb

What we really want to set up is a galera cluster. We will use 3 systems for this

192.168.1.55 mariadb01
192.168.1.56 mariadb02
192.168.1.57 mariadb03

Software

apt-get install mariadb-server rsync

Configuration

Set the mariadb root password.

mysql_secure_installation

Stop mariadb on all nodes.

service mariadb stop

Add the configuration for galera to /etc/mysql/conf.d/galera.cnf. Replace names so they fit the current node.

[galera]
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://mariadb01,mariadb02,mariadb03
wsrep_node_address=mariadb01
wsrep_node_name=mariadb01.kallenberg.dk
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_cluster_name="mariadb_galera" 
wsrep_sst_method=rsync
bind-address=0.0.0.0

On the first node the cluster is started.

galera_new_cluster

On additional nodes the service is started.

service mariadb start

References

https://blog.cloudandheat.com/index.php/en/2016/09/09/tutorial-simple-mariadb-galera-cluster-with-haproxy-load-balancing/
https://linode.com/docs/databases/mariadb/set-up-mariadb-clusters-with-galera-debian-and-ubuntu/
http://galeracluster.com/documentation-webpages/sslcert.html

-  ⇤ ← Revision 9 as of 2018-01-20 18:57:45 → 
  Size: 1269
  Editor: Kristian Kallenberg
  Comment:
+   ← Revision 14 as of 2018-01-20 21:59:17 → ⇥
  Size: 1390
  Editor: Kristian Kallenberg
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 19:
+Set the mariadb root password.
{{{
mysql_secure_installation
}}}
-Line 20:
+Line 25:
-{{ service mariadb stop
+{{{
service mariadb stop
-Line 34:
+Line 40:
-# Custom settings
-Line 49:
+Line 54:
-Line 52:
+Line 58:
+ * http://galeracluster.com/documentation-webpages/sslcert.html