实验环境:
redhat6.5:
server1.example.com 172.25.55.1
server2.example.com 172.25.55.2
server3.example.com 172.25.55.3
1、设置,开mysqld 服务(server1)
:::drbdadm primary dbdata
:::chown mysql.mysql /var/lib/mysql
:::mount /dev/drbd1/ /var/lib/mysql
:::/etc/init.d/mysqld start
:::mysql ##看是否可以登录数据库,如果可以就正确
:::mysql_secure_installation
:::mysql -uroot -pwestos
:::grant select on . to test@’172.25.55.%’ identified by ‘westos’;
:::/etc/init.d/mysqld stop
:::umount /var/lib/mysql
:::/etc/init.d/heartbeat stop
:::vim /etc/ha.d/haresources
(修改配置文件最后一行为:server1.example.com IPaddr::172.25.55.10/24/eth0 drbddisk::dbdata Filesystem::/dev/drbd1::/var/lib/mysql::ext4 mysqld
)
:::/etc/init.d/heartbeat start
:::scp /etc/ha.d/haresources root@172.25.55.2:/etc/ha.d/
(注意:server1为主节点,同步往往伴随写)
:::ip addr show
测试:(server3)
mysql -h 172.25.55.10 -utest -pwestos
注:两个节点不能同时设置为主节点,这样会导致连接断开,即脑裂。这是一个潜在的有害状态,因为它意味着不能复制数据到对等节点,就可能导致两个节点的数据产生分歧,产生不可合并的分裂。
DRBD+mysql
最新推荐文章于 2022-09-02 06:40:02 发布