1台apache服务器，2台mysql服务器（服务器使用之前搭建mysql-ab）。mysql实现读写分离
在apache上安装httpd
yum install httpd -y
需要在apache上把mysql-w-r这个包解压到/var/www/html下
启动httpd服务
[root@www ~]# service httpd restart
停止 httpd： [确定] 启动 httpd： [确定] 打开浏览器访问
点击create table是调用mysql-c.php ，是写的
在master上mysql数据库创建一个用户
mysql> GRANT ALL PRIVILEGES ON *.* TO identified by '123';
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec) 辅助slave数据库会同步，所以不用在slave上创建了，slave上同步过来了。mysql> show grants for ;
+----------------------------------------------------------------------------------+ | Grants for | +----------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY PASSWORD '773359240eb9a1d9' | +----------------------------------------------------------------------------------+ 1 row in set (0.00 sec)在apache服务器修改vim mysql-c.php ，目录在/var/www/html/mysql-w-r下
填写master的IP地址以及用户名和密码。数据库和表我使用默认的
$con = mysql_connect("192.168.1.200","a","123");
在浏览器页面上输入，点击create table。
在master上查看数据库，my_db数据库，进入数据库my_db后查看表
mysql> show databases;
+--------------------+ | Database | +--------------------+ | information_schema | | my_db | | mysql | | niba | | nimei | | test | +--------------------+ 6 rows in set (0.01 sec)mysql> use my_db
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> show tables; +-----------------+ | Tables_in_my_db | +-----------------+ | person | +-----------------+ 1 row in set (0.00 sec)在apache服务器Web页面上返回，点击insert values 之后，修改insert.php
[root@www mysql-w-r]# pwd
/var/www/html/mysql-w-r [root@www mysql-w-r]# ls index.html insert.php mysql-c.php mysql-i.html mysql-r.phpvim insert.php
$con = mysql_connect("192.168.1.200","a","123");输入内容
修改vim mysql-r.php ，输入slave上IP地址以及用户名和密码
$con = mysql_connect("192.168.1.201","a","123"); 点击web页面上select U values
create table insert values select U values
apache服务器读写分离了~！