mycat搭建环境

踩过的坑:

mycat1.6不支持单库分表;

最少要mycat1.6.5版本才支持单库分表;,

下载地址:

http://dl.mycat.io/1.6.5/

 

mycat自增主键的解决方案:

https://segmentfault.com/a/1190000015862596?utm_source=tag-newest

 

 

忘记root密码;

①关闭服务：

sudo service mysql stop;

②安全模式+免验证启动服务

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

 

  ①新开一个终端，连接服务器：
新开一个终端:

mysql -u root

 ②切换到mysql数据库：

use mysql;

 

③修改密码 

update user set password = password('123456') where user='root';

4.重启mysql;

service mysqld restart; 

 

5.允许所有ip访问:

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

 

 

 

相关命令:

mysql -uroot -p123456 -e "GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO 'backup'@'%' IDENTIFIED BY '123456';"

mysql -uroot -p123456 -e "flush privileges;"

change master to master_host='11.8.39.198',master_user='backup',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=120;
start slave;

mysql -uroot -p123456 -e "show slave status\G;"

GRANT ALL PRIVILEGES ON *.* TO 'backup'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

 

 

 

学习链接:

https://blog.csdn.net/mbytes/article/details/86711508

https://www.cnblogs.com/linjiqin/p/8047437.html

 

主主同步:

https://www.cnblogs.com/kevingrace/p/6256603.html

 
读写分离策略理解:
https://www.cnblogs.com/kevingrace/p/9365840.html

转载于:https://www.cnblogs.com/chenzeyong/p/11592218.html