MySQL主从复制/SSL加密
MySQL主从复制/SSL加密
MySQL主从复制原理及拓扑结构:
准备工作:
1)配置好主机名和IP地址
node1.forman.com 172.16.220.11
node2.forman.com 172.16.220.12
2)时间同步和双机互连
- Master:
- #hwclock -s
- #vim /etc/hosts
- 添加如下:
- 172.16.220.11 node1.forman.com node1
- 172.16.220.12 node2.forman.com node2
- # ssh-keygen -t rsa
- # ssh-copy-id -i .ssh/id_rsa.pub root@node2
- # ssh node2 'ifconfig'
- Slave #hwclock -s # vim /etc/hosts
- 添加如下:
- 172.16.220.11 node1.forman.com node1
- 172.16.220.12 node2.forman.com node2
- # ssh-keygen -t rsa
- # ssh-copy-id -i .ssh/id_rsa.pub root@node1
- # ssh node1 'ifconfig'
一、准备两台mysql服务器
- Master Slave:
- #fdisk /dev/sda
- ....
- 1个大小为20G 类型8e的分区,为sda5
- ....
- #partprobe /dev/sda
- #pvcreate /dev/sda5
- #vgcreate myvg /dev/sda5
- #lvcreate -L 10G -n mydata myvg
- #mke2fs -j /dev/myvg/mydata
- #mkdir /data/mydata -pv
- #vim /etc/fstab
- /dev/myvg/mydata /data/mydata ext3 defaults 0 0
- #mount -a
- #useradd -r mysql
- #chown -R mysql:mysql /data/mydata
- 安装mysql
- # tar xf mysql-5.5.22-linux2.6-i686.tar.gz -C /usr/local
- #cd /usr/local
- # ln -sv mysql-5.5.22-linux2.6-i686 mysql
- # cd mysql
- # chown -R mysql:mysql .
- # scripts/mysql_install_db --user=mysql --datadir=/data/mydata
- #chown -R root .
- # cp support-files/my-large.cnf /etc/my.cnf
- # vim /etc/my.cnf
- [mysqld]
- thread_concurrency = 2
- datadir = /data/mydata
- # cp support-files/mysql.server /etc/rc.d/init.d/mysqld
- # chmod +x /etc/rc.d/init.d/mysqld
- # chkconfig --add mysqld
- #service mysqld start
|
评论暂时关闭