[MariaDB] Setup MariaDB Galera Cluster with HAProxy

最新推荐文章于 2023-12-19 21:21:42 发布

yin_bill_wang

最新推荐文章于 2023-12-19 21:21:42 发布

阅读量2.4k

点赞数

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

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

版权

mariaDB 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文详细介绍了在 CentOS 7 上使用 MariaDB 10.1.10 版本部署 Galera 集群的过程。特别强调了初始化集群时应使用 galera_new_cluster 命令而非 systemctl start mysql --wsrep-new-cluster。此外，文章还提供了 HAProxy 的配置指南，包括防火墙设置、监听指令等关键步骤。

摘要由CSDN通过智能技术生成

Working in Progress

Setup MariaDB Galera Cluster

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

Setup HAProxy

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