MySQL master-slave replication/SSL encryption

Principle and topology of MySQL master-slave replication:

650) this. width = 650; "border = 0>

Preparations:
1) configure the Host Name and IP address
Node1.forman.com 172.16.220.11
Node2.forman.com 172.16.220.12
2) time synchronization and dual-host Interconnection

 
 

  
  
Master:
  
  
# Hwclock-s
  
  
# Vim/etc/hosts
  
  
Add as follows:
  
  
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
  
  
Add as follows:
  
  
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' 
 
 

I. Prepare two mysql servers

 
 

  
  
Master Slave:
  
  
# Fdisk/dev/sda
  
  
....
  
  
1 partition with a size of 20 GB type 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-
  
  
# Useradd-r mysql
  
  
# Chown-R mysql: mysql/data/mydata
  
  
Install 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
 
 

1 2 3 4 Next Page