mysql读写分离
来源:互联网 发布:知乎日语自学用书 编辑:程序博客网 时间:2024/06/11 15:01
jdk下载地址http://7dx.pc6.com/wwb5/jdk7u79linuxx64.tar.gz
mycat下载地址https://github.com/MyCATApache/Mycat-download/blob/master/1.4-RELEASE/Mycat-server-1.4-release-20151019230038-linux.tar.gz
搭建前准备:
主:172.25.67.2
从:172.25.67.3
mycat client:172.25.67.1
主从上需要线配置好主从复制
现在mycat的主机上配置jdk:
jdk-7u79-linux-x64.tar.gz
解压到/usr/local/:# tar zxf jdk-7u79-linux-x64.tar.gz /usr/local/
做软链接:# ln -s jdk1.7.0_79/ java
# vim /etc/profile
export JAVA_HOME=/usr/local/java
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$PATH:$JAVA_HOME/bin
# source /etc/profile
配置mycat:
安装包:Mycat-server-1.4-beta-20150604171601-linux.tar.gz
解压到/usr/local:
# tar zxf Mycat-server-1.4-beta-20150604171601-linux.tar.gz -C /usr/local/
添加用户:
# useradd mycat
# passwd mycat
# chown mycat.mycat -R /usr/local/mycat/
添加环境变量:
# vim /etc/profile
export MYCAT_HOME=/usr/local/mycat
export PATH=$PATH:$MYCAT_HOME/bin
# source /etc/profile
# cd /usr/local/conf
配置:
# vim schema.xml
# vim server.xml
# vim log4j.xml
<root>
<level value="debug" />
<appender-ref ref="FILE" />
<!--<appender-ref ref="FILE" />-->
</root>
启动mycat:
因为之前把环境变量配置到了/etc/profile里了,所以
# mycat console&
读写分离:
在远端登录mycat:
[kiosk@foundation90 Desktop]$ mysql -h172.25.90.2 -P 8066 -u root -predhat
MySQL [(none)]> show databases;
+------------+
| DATABASE |
+------------+
| pcx_schema |
+------------+
1 row in set (0.00 sec)
MySQL [(none)]> use pcx_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MySQL [pcx_schema]> show tables;
+----------------------+
| Tables_in_pcx_schema |
+----------------------+
| travelrecord |
+----------------------+
1 row in set (0.01 sec)
MySQL [pcx_schema]> select * from travelrecord;
+---------+--------------+------------+------+------+
| id | user_id | traveldate | fee | days |
+---------+--------------+------------+------+------+
| 1 | mysql-server | 2017-10.19| 100 | 10 |
| 2 | mysql-server | 2017-10.19 | 100 | 10 |
| 5000001 | mysql-server | 2017-10-19 | 100 | 10 |
+---------+--------------+------------+------+------+
3 rows in set (0.01 sec)
MySQL [pcx_schema]> delete from travelrecord where id='1';
Query OK, 1 row affected (0.11 sec)
一开始,主和从是同步的:
mysql> select * from travelrecord;
+---------+--------------+------------+------+------+
| id | user_id | traveldate | fee | days |
+---------+--------------+------------+------+------+
| 1 | mysql-server | 2017-10-19| 100 | 10 |
| 2 | mysql-server | |2017-10-19 100 | 10 |
| 5000001 | mysql-server | 2017-10-19 | 100 | 10 |
+---------+--------------+------------+------+------+
现在间从机上的io_thread关闭
mysql> stop slave io_thread;
Query OK, 0 rows affected (0.12 sec)
我们在远端对数据库修改:
MySQL [pcx_schema]> delete from travelrecord where id='1';
Query OK, 1 row affected (0.11 sec)
MySQL [pcx_schema]> select * from travelrecord;
+---------+--------------+------------+------+------+
| id | user_id | traveldate | fee | days |
+---------+--------------+------------+------+------+
| 1 | mysql-server | 2017-10-19| 100 | 10 |
| 2 | mysql-server |2017-10-19 | 100 | 10 |
| 5000001 | mysql-server |2017-10-19 | 100 | 10 |
+---------+--------------+------------+------+------+
我们再来看看主和从:
主:
mysql> select * from travelrecord;
+---------+--------------+------------+------+------+
| id | user_id | traveldate | fee | days |
+---------+--------------+------------+------+------+
| 2 | mysql-server |2017-10-19 | 100 | 10 |
| 5000001 | mysql-server | 2017-10-19 | 100 | 10 |
+---------+--------------+------------+------+------+
2 rows in set (0.00 sec)
从:
mysql> select * from travelrecord;
+---------+--------------+------------+------+------+
| id | user_id | traveldate | fee | days |
+---------+--------------+------------+------+------+
| 1 | mysql-server |2017-10-19 | 100 | 10 |
| 2 | mysql-server | 2017-10-19 | 100 | 10 |
| 5000001 | mysql-server |2017-10-19 | 100 | 10 |
+---------+--------------+------------+------+------+
3 rows in set (0.00 sec)
- mysql读写分离
- Mysql 读写分离
- MYSQL实现读写分离
- Mysql读写分离
- mysql读写分离实现
- mysql读写分离实战
- mysql amoeba读写分离
- mysql 读写分离
- MySQL 读写分离
- mysql读写分离
- mysql服务器端读写分离
- mysql读写分离实战
- mysql数据库读写分离
- mysql 读写分离
- mysql读写分离
- mysql 读写分离
- Mysql proxy读写分离
- MySQL Proxy读写分离
- SAP物料移动过账之差异科目
- 怎么迅速将Java对象的详细内容打印下来
- 补丁(patch)的制作与应用
- pnp估计相机的姿态
- 10月18日,德国法兰克福,阿里云MaxCompute2.0,全面布局AI人工智能
- mysql读写分离
- oracle 中检查点 及SCN的用法(白话解释)
- 数据库中的1和0在页面中显示进和出
- PullToRefresh的使用
- Photoshop详细教程六之蒙版处理大山晴天变彩虹的效果
- 大数据竞赛平台——Kaggle 入门篇
- photoshop常用功能
- Activiti工作流之项目中的使用
- mysql 权限管理