Mysql读写分离
安装依赖
安装mysql
配置
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DSYSCONFDIR=/etc
生成配置文件,生成服务控制文件
设置开机自启
优化mysql命令
初始化数据库
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=
/usr/local/mysql --datadir=/usr/local/mysql/data
重启测试
设置密码
登录
修改配置文件
配置从mysql去主复制数据
change master to master_host='192.168.100.10',master_user='slave',master_password='pwd@123',master_log_file='mysql-bin.000005',master_log_pos=107;
启动服务并查看状态
创建测试
配置mysql读写分离
修改hosts文件
/etc/hosts
Ping测试
安装jdk
修改jdk安装位置
修改amoeba安装位置
配置环境变量jdk和amoeba协同工作
export JAVA_HOME=/usr/local/jdk
export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib/
export PATH=$JAVA_HOME/lib:$JAVA_HOME/jre/bin:$PATH:$HOME/bin
export AMOEBA_HOME=/usr/local/amoeba
export PATH=$PATH:$SAMOEBA_HOME/bin
生效配置
授权amoeba访问mysql数据库
grant all on *.* to 'bob'@'192.168.100.%' identified by 'pwd@123';
修改amoeba主配置文件
30 <property name="user">amoeba</property>
31 <property name="password">pwd@123</property>
114 <property name="defaultPool">master</property>
115 <property name="writePool">master</property>
116 <property name="readPool">slaves</property>
修改amoeba配置文件添加读写服务器
25 <property name="user">bob</property>
26 <property name="password">pwd@123</property>
40 <dbServer name="master" parent="abstractServer">
41 <factoryConfig>
42 <property name="ipAddress">192.168.100.10</property>
43 </factoryConfig>
44 </dbServer>
45 <dbServer name="slave01" parent="abstractServer">
46 <factoryConfig>
47 <property name="ipAddress">192.168.100.20</property>
48 </factoryConfig>
49 </dbServer>
50 <dbServer name="slave02" parent="abstractServer">
51 <factoryConfig>
52 <property name="ipAddress">192.168.100.30</property>
53 </factoryConfig>
54 </dbServer>
55 <dbServer name="slaves" virtual="true">
56 <poolConfig class="com.meidusa.amoeba.server.MultipleServerPool">
57 <property name="loadbalance">1</property>
58 <property name="poolNames">slave01,slave02</property>
59 </poolConfig>
安装mysql客户端