只是自己做的时候一些简单的记录
mysql端口号:3305
mysql的密码:$mysql -uroot -pmysql123
mysql创建的用户:ltmysql 密码:Ltmysql123!
/tmp/mysql-5.7.36 放MySQL的解压包
双主:
master1:134 master2:135
1.安装好MySQL
2.在master1和master2上创建用户并赋权
master1:
[admin@xhw365 ~]$ mysql -uroot -pmysql123
mysql> create user 'ltmysql'@'%' identified by 'Ltmysql123!';
mysql> grant all on *.* to 'ltmysql'@'%'; 授权 ( 扩展:revoke insert on *.* from'ltmysql'@'10.248.51.*'; 撤销)
mysql> flush privileges;
master2:
[admin@xhw366 ~]$ mysql -uroot -pmysql123
mysql> create user 'ltmysql'@'%' identified by 'Ltmysql123!';
mysql> grant all on *.* to 'ltmysql'@'%';
mysql> flush privileges;
3.配置master1和master2的 my.cnf文件
master1:
[mysqld]
server-id = 1
log-bin = mysql-bin
auto-increment-increment= 2 # 应设为整个结构中服务器的总数
master2:
[mysqld]
server-id = 2
log-bin = mysql-bin
auto-increment-increment= 2 #
4.重启两台mysql服务
5.在master1上指定master2为主:
master1:
在master2上查二进制日志的file 和Position (show master status;)
mysql>change master to master_host='10.248.51.135',master_user='ltmysql',master_port=3305,master_password='Ltmysql123!',master_log_file='mysql-bin.000002',master_log_pos=154;
mysql> start slave;
6.在master2上指定master1为主:
master2:
在master1上查二进制日志的file 和Position (show master status;)
mysql>change master to master_host='10.248.51.134',master_user='ltmysql',master_port=3305,master_password='Ltmysql123!',master_log_file='mysql-bin.000004',master_log_pos=154;
mysql> start slave;
在134/135上安装mycat:
mycat:
准备工作
1. 上传mycat包
scp /tmp/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz admin@10.248.51.134:/tmp
scp /tmp/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz admin@10.248.51.135:/tmp
mycat的tar包放在 /tmp
2.查看JDK版本
[admin@xhw366 ~]$ java -version
openjdk version "1.8.0_102"
OpenJDK Runtime Environment (build 1.8.0_102-b14)
OpenJDK 64-Bit Server VM (build 25.102-b14, mixed mode)
3.在MySQL里创建一个库 testdb
[admin@xhw365 tmp]$ tar -zxf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz -C /usr/local/
[admin@xhw365 ~]$ sudo adduser mycat
[sudo] password for admin:
[admin@xhw365 ~]$ cd /usr/local/
[admin@xhw365 local]$ sudo chown -R mycat:mycat mycat/
[admin@xhw365 local]$ cd /usr/local/mycat/conf/
[admin@xhw365 conf]$ sudo vi server.xml
改:
<user name="mycat">
<property name="password">mycat123</property>
<property name="schemas">TESTDB</property>
[admin@xhw365 conf]$ sudo vi schema.xml
schema.xml的配置文件:
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
</schema>
<dataNode name="dn1" dataHost="host1" database="testdb" />
<dataHost name="host1" maxCon="1000" minCon="10" balance="1"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<writeHost host="hostM1" url="10.248.51.134:3305" user="ltmysql"
password="Ltmysql123!">
<readHost host="hostS1" url="10.258.51.135:3305" user="ltmysql" password="Ltmysql123!" />
</writeHost>
<writeHost host="hostM2" url="10.248.51.135:3305" user="ltmysql"
password="Ltmysql123!">
<readHost host="hostS2" url="10.248.51.134:3305" user="ltmysql" password="Ltmysql123"/>
</writeHost>
</dataHost>
</mycat:schema>
[admin@xhw365 conf]$ sudo vi wrapper.conf +31
改:wrapper.java.additional.5=-XX:MaxDirectMemorySize=4096m
[admin@xhw365 bin]$ sudo ./mycat console start &
[admin@xhw365 ~]$ mysql -h 10.248.51.134 -P 8066 -umycat -pmycat123
[admin@xhw365 ~]$ cd /usr/local/mycat/bin/
[admin@xhw365 bin]$ sudo ./mycat status
Mycat-server is running (12530).