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/

-  ⇤ ← Revision 1 as of 2017-12-24 22:11:05 → 
  Size: 13
  Editor: Kristian Kallenberg
  Comment:
+   ← Revision 12 as of 2018-01-20 19:06:35 → ⇥
  Size: 1323
  Editor: Kristian Kallenberg
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
+incomplete, do not use!
-Line 2:
+Line 4:
+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/