CentOS 上 SQL Admin 集群搭建指南
一 架构与名词澄清
二 方案总览
三 数据库层部署
sudo yum update -y && sudo yum install -y mysql-serversudo systemctl start mysqld && sudo systemctl enable mysqldsudo mysql_secure_installationserver-id=1log_bin=/var/log/mysql/mysql-bin.logbinlog_do_db=your_db(可选,按需)auto_increment_increment=2auto_increment_offset=1sudo systemctl restart mysqldserver-id=2relay_log=/var/log/mysql/mysql-relay-bin.loglog_bin=/var/log/mysql/mysql-bin.logbinlog_do_db=your_db(与主库一致)auto_increment_increment=2auto_increment_offset=2read_only=1sudo systemctl restart mysqldCREATE USER 'replicator'@'%' IDENTIFIED BY 'StrongPass!';GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%';FLUSH PRIVILEGES;SHOW MASTER STATUS;(记录 File 与 Position)CHANGE MASTER TO MASTER_HOST='192.168.1.11', MASTER_USER='replicator', MASTER_PASSWORD='StrongPass!', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=154;START SLAVE;SHOW SLAVE STATUS\G(确保 Slave_IO_Running 与 Slave_IO_Running 均为 Yes)[NDBD DEFAULT] NoOfReplicas=2[MYSQLD DEFAULT][NDB_MGMD DEFAULT][TCP DEFAULT][NDB_MGMD] HostName=192.168.1.10[NDBD] HostName=192.168.1.11 DataDir=/var/lib/mysql-cluster[NDBD] HostName=192.168.1.12 DataDir=/var/lib/mysql-cluster[MYSQLD] [MYSQLD]ndb_mgmd -f /var/lib/mysql-cluster/config.inindbclusterndb-connectstring=192.168.1.10/usr/local/mysql/bin/ndbd --initial(仅首次)/etc/init.d/mysqld startndb_mgm 进入控制台,执行 show 查看节点状态。四 SQL Admin 集群部署
sudo yum install -y httpd php php-mysql php-mbstring php-xmlsudo systemctl start httpd && sudo systemctl enable httpd$cfg['blowfish_secret'] = '随机长字符串';$cfg['DefaultLang'] = 'en';sudo yum install -y haproxy keepalivedsudo systemctl start haproxy && sudo systemctl enable haproxysudo systemctl start keepalived && sudo systemctl enable keepalived五 安全与运维要点
mysqldump 全量 + 增量 binlog 备份;NDB:使用 ndbbackup。