8Mysql的主从复制和读写分离.docxVIP

linux企业级知识点总结Mysql主从复制与读写分离原理图Mysql的主从复制：从服务器在主服务器上自动同步数据。Mysql的读写分离：通过amoeba服务器控制用户读数据在从服务器上进行，写数据从主服务器上进行，这样可以做到负载均衡。案例环境：搭建mysql主从复制：建立时间同步环境#yum -y install ntp#vim /etc/ntp.conf修改相关内容：Server 127.127.1.0Fudge 127.127.1.0 stratum 8#service ntpd restart#yum -y install ntpdate#/usr/sbin/ntpdate 1.1.1.1安装mysql数据库# yum -y install ncurses-devel# yum -y install cmake# tar xzvf mysql-5.5.22.tar.gz # cd mysql-5.5.22#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DSYSCONFDIR=/etc#make make install#useradd mysql -s /sbin/nologin -M -g mysql# chown -R mysql.mysql /usr/local/mysql/# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf# cd /usr/local/mysql/scripts/# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data# echo PATH=$PATH:/usr/local/mysql/bin /etc/profile# . /etc/profile# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld# chkconfig --add mysqld# chkconfig mysqld on#service mysqld start# mysqladmin -u root password 123修改master主服务器配置文件#vim /etc/my.cnfserver-id = 11log-bin=master-binlog-slave-updates=true重启服务#Service mysqld restart登陆mysql数据库，给从服务器授权#mysql -u root -p123MysqlGRANT REPLICATION SLAVE ON *.* TO ‘ren’@’1.1.1.%’ IDENTIFIED BY ‘123’;MysqlFLUSH PRIVILEGES;Mysqlshow master status;注：*.*表示所有数据库下所有表配置从服务器#vim /etc/my.cnf修改内容：Server-id = 22Relay-log=relay-log-binRelay-log-index=slave-relay-bin.index注：这里的ID号不能与主服务器相同重启服务#service mysqld restart登陆mysql配置同步#mysql -u root -p123,Mysqlchange master to master_host=1.1.1.1,master_user=ren ,master_password=’123’, master_log_file=’master-bin.000001’,master_log_pos=339启动同步Mysqlstart slave;Mysqlshow slave status\G;验证方法:在主服务器上创建一个新的数据库，在从服务器上查看是否同步过来。Mysql的读写分离搭建amoeba服务器安装JAVA环境# chmod +x jdk-6u14-linux-x64.bin# ./jdk-6u14-linux-x64.bin # mv jdk1.6.0_14/ /usr/local/jdk1.6#vim /etc/profile添加内容：export JAVA_HOME=/usr/local/jdk1.6export CLAS