[MariaDB] Setup MariaDB Galera Cluster with HAProxy

最新推荐文章于 2021-09-29 17:54:18 发布

yin_bill_wang

最新推荐文章于 2021-09-29 17:54:18 发布

阅读量2.4k

点赞数

分类专栏： mariaDB 文章标签： maria db haproxy

本文链接：https://blog.csdn.net/beer_do/article/details/50474910

版权

1 篇文章 0 订阅

订阅专栏

Working in Progress

The setup for Galera Cluster is reasonably easy if you follow the instructions in this article.

!!!IMPORTANT!!!

Initializing cluster
On setups on CentOS 7 with MariaDB 10.1.10, please use galera_new_cluster to start the first node. systemctl start mysql --wsrep-new-cluster will give you the unrecognized option error.
Shutdown and restart entire cluster
Shutdown all the nodes normally using systemctl stop mysql
Restart is a bit complicated, it involves following steps:
1. Find the node with the most advanced sequence number
```
cat /var/lib/mysql/grastate.dat
```
2. On the node with the most advanced seq number, start it using galera_new_cluster
3. Start the rest of the nodes as normal systemctl start mysql

The setup for HAProxy is also fairly easy with the instructions.

!!!IMPORTANT!!!

Allow firewall to pass tcp port used by clustercheck on every Cluster Node.
Define timeout connect, timeout client, timeout server under each listen directive.
Use bind inside listen directive, instead of putting0.0.0.0:xxxx directly after listen

关注