Skip to content

Instantly share code, notes, and snippets.

View yarko686's full-sized avatar

Yaroslav Zdyrko yarko686

3 followers · 4 following
View GitHub Profile
@yarko686
yarko686 / gist:a67e94afaa4ecc57ccb985d897ee3e87
Created July 31, 2018 11:38
/etc/maxscale.cnf
# Globals
[maxscale]
threads=1
# Servers
[server1]
type=server
address=176.12.12.50
port=3306
protocol=MySQLBackend
@yarko686
yarko686 / gist:5adb7b24784c4c3c24a526519623d930
Created July 31, 2018 11:39
/etc/my.cnf.d/server.cnf
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://176.12.12.50,176.12.12.51,176.12.12.52
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
@yarko686
yarko686 / gist:a63c925b3275d239f38d50f0651e45ef
Created July 31, 2018 11:49
show global status like 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| wsrep_cluster_size | 3 |
+--------------------+-------+
1 row in set (0.00 sec)
@yarko686
yarko686 / gist:950ea62f79638a6f293c28b99dd19f7b
Created July 31, 2018 11:54
MySQL Queries for Galera user
CREATE USER 'galer_root'@'%' IDENTIFIED BY 'my_pw';
GRANT USAGE ON *.* TO 'galera_root'@'$%' IDENTIFIED BY 'my_pw';
GRANT ALL privileges ON *.* TO '$galera_root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;