\u76ee\u5f55<\/p>\n
\u4e00：MySQL\u4e3b\u4ece\u590d\u5236\u539f\u7406<\/p>\n
1：MySQL\u652f\u6301\u7684\u590d\u5236\u7c7b\u578b<\/p>\n
(1) \u57fa\u4e8e\u8bed\u53e5\u7684\u590d\u5236(SBR)<\/p>\n
(2) \u57fa\u4e8e\u884c\u7684\u590d\u5236(RBR)<\/p>\n
(3) \u6df7\u5408\u6a21\u5f0f\u590d\u5236(MBR)<\/p>\n
2：\u590d\u5236\u7684\u5de5\u4f5c\u8fc7\u7a0b<\/p>\n
(1) \u4e3b\u670d\u52a1\u5668\u64cd\u4f5c<\/p>\n
(2) \u4ece\u670d\u52a1\u5668\u64cd\u4f5c<\/p>\n
(3) \u8be6\u7ec6\u6d41\u7a0b<\/p>\n
\u4e8c：MySQL\u8bfb\u5199\u5206\u79bb\u539f\u7406<\/p>\n
1：\u57fa\u4e8e\u7a0b\u5e8f\u4ee3\u7801\u5185\u90e8\u5b9e\u73b0<\/p>\n
2：\u57fa\u4e8e\u4e2d\u95f4\u4ee3\u7406\u5c42\u5b9e\u73b0<\/p>\n
（1）MySQL-Proxy.<\/p>\n
（2）Amoeba.<\/p>\n
（3）MyCAT.<\/p>\n
\u4e09：\u6848\u4f8b\u73af\u5883<\/p>\n
1. \u670d\u52a1\u5668\u89c4\u5212<\/p>\n
2. \u7f51\u7edc\u8981\u6c42<\/p>\n
\u56db：\u4e3b\u4ece\u590d\u5236\u6848\u4f8b\u5b9e\u65bd<\/p>\n
1：\u914d\u7f6emaster\u4e3b\u670d\u52a1\u5668<\/p>\n
（1）\u4fee\u6539MySQL\u914d\u7f6e\u6587\u4ef6(my.cnf)<\/p>\n
（2）\u91cd\u542fMySQL\u670d\u52a1<\/p>\n
（3）\u521b\u5efa\u590d\u5236\u4e13\u7528\u7528\u6237<\/p>\n
（4）\u67e5\u770b\u4e3b\u670d\u52a1\u5668\u72b6\u6001<\/p>\n
2：\u914d\u7f6eslave\u4ece\u670d\u52a1\u5668<\/p>\n
（1）\u4fee\u6539MySQL\u914d\u7f6e\u6587\u4ef6(my.cnf)<\/p>\n
（2）\u91cd\u542fMySQL\u670d\u52a1<\/p>\n
（3）\u767b\u5f55MySQL，\u914d\u7f6e\u540c\u6b65<\/p>\n
（4）\u542f\u52a8\u540c\u6b65<\/p>\n
（5）\u67e5\u770bslave\u72b6\u6001，\u786e\u4fdd\u4e00\u4e0b\u4e24\u4e2a\u503c\u4e3aYES<\/p>\n
3：\u9a8c\u8bc1\u4e3b\u4ece\u590d\u5236\u6548\u679c<\/p>\n
（1）\u5728\u4e3b\u670d\u52a1\u5668\u521b\u5efa\u6d4b\u8bd5\u6570\u636e\u5e93<\/p>\n
（2）\u5728\u4ece\u670d\u52a1\u5668\u9a8c\u8bc1<\/p>\n
\u4e94：\u8bfb\u5199\u5206\u79bb\u6848\u4f8b\u5b9e\u65bd<\/p>\n
1：\u5b89\u88c5Mycat2<\/p>\n
2：\u5b89\u88c5\u5e76\u914d\u7f6eMycat\u8f6f\u4ef6<\/p>\n
3：\u914d\u7f6eMycat\u8bfb\u5199\u5206\u79bb<\/p>\n
（1）\u521b\u5efaMycat2\u5de5\u4f5c\u6240\u5fc5\u987b\u7684\u8d26\u53f7<\/p>\n
（2）\u542f\u52a8Mycat2<\/p>\n
（3）Mycat2\u914d\u7f6e\u8bfb\u5199\u5206\u79bb<\/p>\n
\u7b2c\u4e00\u6b65：mycat\u589e\u52a0\u6570\u636e\u6e90<\/p>\n
\u7b2c\u4e8c\u6b65：\u521b\u5efamycat\u96c6\u7fa4<\/p>\n
4：\u9a8c\u8bc1Mycat\u8bfb\u5199\u5206\u79bb<\/p>\n
\u4e3b\u670d\u52a1\u5668\u8bb0\u5f55\u6267\u884c\u7684SQL\u8bed\u53e5<\/p>\n<\/li>\n
\u4ece\u670d\u52a1\u5668\u91cd\u653e\u8fd9\u4e9bSQL\u8bed\u53e5<\/p>\n<\/li>\n
\u4f18\u70b9：\u65e5\u5fd7\u91cf\u5c0f<\/p>\n<\/li>\n
\u7f3a\u70b9：\u67d0\u4e9b\u51fd\u6570(\u5982UUID(), NOW())\u53ef\u80fd\u5bfc\u81f4\u4e0d\u4e00\u81f4<\/p>\n<\/li>\n<\/ul>\n
\u4e3b\u670d\u52a1\u5668\u8bb0\u5f55\u884c\u7ea7\u522b\u7684\u53d8\u66f4<\/p>\n<\/li>\n
\u4ece\u670d\u52a1\u5668\u76f4\u63a5\u5e94\u7528\u8fd9\u4e9b\u884c\u53d8\u66f4<\/p>\n<\/li>\n
\u4f18\u70b9：\u6570\u636e\u4e00\u81f4\u6027\u9ad8<\/p>\n<\/li>\n
\u7f3a\u70b9：\u65e5\u5fd7\u91cf\u5927<\/p>\n<\/li>\n<\/ul>\n
\u9ed8\u8ba4\u4f7f\u7528\u57fa\u4e8e\u8bed\u53e5\u7684\u590d\u5236<\/p>\n<\/li>\n
\u5728\u7279\u5b9a\u60c5\u51b5\u4e0b\u81ea\u52a8\u5207\u6362\u5230\u57fa\u4e8e\u884c\u7684\u590d\u5236<\/p>\n<\/li>\n
\u7ed3\u5408\u4e86\u4e24\u8005\u7684\u4f18\u70b9<\/p>\n<\/li>\n<\/ul>\n
\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8bb0\u5f55：\u4e3b\u670d\u52a1\u5668\u5c06\u6240\u6709\u6570\u636e\u66f4\u6539\u64cd\u4f5c(DDL\u548cDML)\u8bb0\u5f55\u5230\u4e8c\u8fdb\u5236\u65e5\u5fd7(binlog)\u4e2d<\/p>\n<\/li>\n
\u65e5\u5fd7\u5237\u65b0：\u901a\u8fc7sync_binlog\u53c2\u6570\u63a7\u5236\u65e5\u5fd7\u5237\u65b0\u5230\u78c1\u76d8\u7684\u9891\u7387<\/p>\n<\/li>\n
I\/O\u7ebf\u7a0b：<\/p>\n
\u8fde\u63a5\u5230\u4e3b\u670d\u52a1\u5668<\/p>\n<\/li>\n
\u8bf7\u6c42\u4e3b\u670d\u52a1\u5668\u53d1\u9001binlog\u4e2d\u7684\u66f4\u65b0<\/p>\n<\/li>\n
\u63a5\u6536binlog\u5e76\u5199\u5165\u4ece\u670d\u52a1\u5668\u7684\u4e2d\u7ee7\u65e5\u5fd7(relay log)<\/p>\n<\/li>\n<\/ul>\n<\/li>\n
SQL\u7ebf\u7a0b：<\/p>\n
\u8bfb\u53d6\u4e2d\u7ee7\u65e5\u5fd7\u4e2d\u7684\u4e8b\u4ef6<\/p>\n<\/li>\n
\u91cd\u653e\u8fd9\u4e9b\u4e8b\u4ef6，\u66f4\u65b0\u4ece\u670d\u52a1\u5668\u6570\u636e<\/p>\n<\/li>\n<\/ul>\n<\/li>\n
\u4e3b\u5e93\u5f00\u542fbinlog，\u4ece\u5e93\u901a\u8fc7change master\u547d\u4ee4\u914d\u7f6e\u8fde\u63a5\u4e3b\u5e93\u7684\u4fe1\u606f<\/p>\n<\/li>\n
\u4ece\u5e93\u542f\u52a8\u590d\u5236\u540e，I\/O\u7ebf\u7a0b\u4e0e\u4e3b\u5e93\u5efa\u7acb\u8fde\u63a5<\/p>\n<\/li>\n
\u4e3b\u5e93\u9a8c\u8bc1\u4ece\u5e93\u8fde\u63a5\u540e，\u5f00\u59cb\u53d1\u9001binlog\u4e8b\u4ef6<\/p>\n<\/li>\n
\u4ece\u5e93I\/O\u7ebf\u7a0b\u63a5\u6536\u4e8b\u4ef6\u5e76\u5199\u5165relay log<\/p>\n<\/li>\n
\u4ece\u5e93SQL\u7ebf\u7a0b\u8bfb\u53d6relay log\u5e76\u5e94\u7528\u8fd9\u4e9b\u4e8b\u4ef6<\/p>\n<\/li>\n
\u4ece\u5e93\u8bb0\u5f55\u5df2\u7ecf\u5904\u7406\u7684\u4e8b\u4ef6\u4f4d\u7f6e(relay-log.info)<\/p>\n<\/li>\n
\u76ee\u524d\u8f83\u4e3a\u5e38\u89c1\u7684MySQL\u8bfb\u5199\u5206\u79bb\u5206\u4e3a\u4e24\u79cd\u3002<\/p>\n
\u539f\u7406：\u5728\u5e94\u7528\u7a0b\u5e8f\u4ee3\u7801\u4e2d\u76f4\u63a5\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\u7684\u903b\u8f91，\u901a\u8fc7\u5224\u65adSQL\u8bed\u53e5\u7684\u7c7b\u578b（\u8bfb\u6216\u5199），\u5c06\u8bf7\u6c42\u8def\u7531\u5230\u5bf9\u5e94\u7684\u4e3b\u5e93（\u5199）\u6216\u4ece\u5e93（\u8bfb）<\/span>\u3002<\/p>\n<\/li>\n \u4f18\u70b9：<\/p>\n \u5b9e\u73b0\u7075\u6d3b，\u53ef\u4ee5\u6839\u636e\u4e1a\u52a1\u9700\u6c42\u5b9a\u5236\u8def\u7531\u903b\u8f91\u3002<\/p>\n<\/li>\n \u65e0\u9700\u989d\u5916\u7684\u4e2d\u95f4\u4ef6，\u51cf\u5c11\u4e86\u67b6\u6784\u7684\u590d\u6742\u6027\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n \u7f3a\u70b9：<\/p>\n \u5bf9\u4ee3\u7801\u4fb5\u5165\u6027\u5f3a，\u9700\u8981\u5728\u4e1a\u52a1\u903b\u8f91\u4e2d\u5d4c\u5165\u6570\u636e\u5e93\u8def\u7531\u4ee3\u7801\u3002<\/p>\n<\/li>\n \u7ef4\u62a4\u6210\u672c\u9ad8，\u4fee\u6539\u8def\u7531\u903b\u8f91\u53ef\u80fd\u9700\u8981\u91cd\u65b0\u90e8\u7f72\u5e94\u7528\u3002<\/p>\n<\/li>\n \u96be\u4ee5\u5b9e\u73b0\u52a8\u6001\u6269\u5c55\u6216\u8d1f\u8f7d\u5747\u8861\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n \u539f\u7406：MySQL\u5b98\u65b9\u63d0\u4f9b\u7684\u8f7b\u91cf\u7ea7\u4ee3\u7406，\u901a\u8fc7Lua\u811a\u672c\u5b9e\u73b0\u8def\u7531\u903b\u8f91\u3002<\/p>\n<\/li>\n \u4f18\u70b9：<\/p>\n \u5b98\u65b9\u652f\u6301，\u4e0eMySQL\u517c\u5bb9\u6027\u597d\u3002<\/p>\n<\/li>\n \u7075\u6d3b\u6027\u5f3a，\u53ef\u4ee5\u901a\u8fc7\u811a\u672c\u5b9a\u5236\u8def\u7531\u89c4\u5219\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n \u7f3a\u70b9：<\/p>\n \u6027\u80fd\u8f83\u5dee，\u4e0d\u9002\u5408\u9ad8\u5e76\u53d1\u573a\u666f\u3002<\/p>\n<\/li>\n \u9879\u76ee\u5df2\u505c\u6b62\u7ef4\u62a4，\u4e0d\u63a8\u8350\u751f\u4ea7\u73af\u5883\u4f7f\u7528\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n \u539f\u7406：\u5f00\u6e90\u4ee3\u7406\u4e2d\u95f4\u4ef6，\u652f\u6301\u8bfb\u5199\u5206\u79bb\u548c\u5206\u5e93\u5206\u8868\u3002<\/p>\n<\/li>\n \u4f18\u70b9：<\/p>\n \u914d\u7f6e\u7b80\u5355，\u652f\u6301\u8d1f\u8f7d\u5747\u8861\u548c\u9ad8\u53ef\u7528\u3002<\/p>\n<\/li>\n \u5bf9\u5e94\u7528\u900f\u660e，\u65e0\u9700\u4fee\u6539\u4ee3\u7801\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n \u7f3a\u70b9：<\/p>\n \u793e\u533a\u6d3b\u8dc3\u5ea6\u4f4e，\u540e\u7eed\u7ef4\u62a4\u4e0d\u8db3\u3002<\/p>\n<\/li>\n \u6027\u80fd\u548c\u5904\u7406\u80fd\u529b\u6709\u9650\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n \u539f\u7406：\u57fa\u4e8e\u963f\u91cc\u5f00\u6e90\u7684Cobar\u6539\u8fdb\u800c\u6765\u7684\u5206\u5e03\u5f0f\u6570\u636e\u5e93\u4e2d\u95f4\u4ef6，\u652f\u6301\u8bfb\u5199\u5206\u79bb\u3001\u5206\u5e93\u5206\u8868\u7b49\u3002<\/p>\n<\/li>\n \u4f18\u70b9：<\/p>\n \u529f\u80fd\u5f3a\u5927，\u652f\u6301\u590d\u6742\u7684\u5206\u5e03\u5f0f\u573a\u666f\u3002<\/p>\n<\/li>\n \u793e\u533a\u6d3b\u8dc3，\u6587\u6863\u4e30\u5bcc\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n \u7f3a\u70b9：<\/p>\n \u914d\u7f6e\u548c\u7ba1\u7406\u8f83\u590d\u6742\u3002<\/p>\n<\/li>\n \u5bf9\u6027\u80fd\u6709\u4e00\u5b9a\u5f71\u54cd，\u9700\u5408\u7406\u8c03\u4f18\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n \u64cd\u4f5c\u7cfb\u7edf: openEuler<\/p>\n<\/li>\n MySQL\u7248\u672c: 5.7 \u6216 8.0 (\u5efa\u8bae\u4f7f\u7528\u76f8\u540c\u7248\u672c)<\/p>\n<\/li>\n<\/ul>\n \u786e\u4fdd\u4e3b\u4ece\u670d\u52a1\u5668\u4e4b\u95f4\u7f51\u7edc\u4e92\u901a<\/p>\n<\/li>\n \u5f00\u653eMySQL\u9ed8\u8ba4\u7aef\u53e33306<\/p>\n<\/li>\n \u5173\u95ed\u9632\u706b\u5899\u6216\u8bbe\u7f6e\u76f8\u5e94\u89c4\u5219<\/p>\n<\/li>\n<\/ul>\n [client] [mysqld_safe] systemctl restart mysqld <\/p>\n mysql -uroot -ppwd123 flush privileges;<\/p>\n show master status; \u5728Slave1，Slave2\u670d\u52a1\u5668\u4e0a\u9762\u5206\u522b\u6267\u884c\u4e0b\u9762\u6b65\u9aa4：<\/p>\n [client] [mysqld_safe] systemctl restart mysqld <\/p>\n mysql -uroot -ppwd123 start slave; <\/p>\n start slave status\\\\G;<\/p>\n CREATE DATABASE test_db; USE test_db; dnf -y install jdk-8ul71-linux-x64.rpm <\/p>\n #\u89e3\u538b\u8f6f\u4ef6\u5305 #\u6dfb\u52a0\u8def\u5f84 #\u79fb\u52a8\u76ee\u5f55 #\u6dfb\u52a0\u6267\u884c\u6743\u9650 #\u9a8c\u8bc1\u5b89\u88c5\u7684\u6b63\u786e\u6027 mysql -uroot -ppwd123 vim \/usr\/local\/mycat\/conf\/datasources\/prototypeDs.datasource.json mysql -uroot -p123456 -p8066 -h192.168.10.206 #slave2： #\u67e5\u770b\u6570\u636e\u6e90\u4fe1\u606f #\u521b\u5efa\u96c6\u7fa4 #\u67e5\u8be2\u521b\u5efa #\u542f\u52a8\u96c6\u7fa4 #\u767b\u5f55mycat\u96c6\u7fa4，\u521b\u5efa\u6d4b\u8bd5\u5e93\u548c\u6d4b\u8bd5\u8868 #\u91cd\u542f #\u505c\u6b62\u8282\u70b9\u4e3b\u4ece\u540c\u6b65 #\u521b\u5efa\u6d4b\u8bd5\u6570\u636e #\u6d4b\u8bd5\u8bfb\u64cd\u4f5c \u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1k\u6b21\uff0c\u70b9\u8d5e15\u6b21\uff0c\u6536\u85cf22\u6b21\u3002\u4e3b\u670d\u52a1\u5668\u5c06\u6240\u6709\u6570\u636e\u66f4\u6539\u64cd\u4f5c(DDL\u548cDML)\u8bb0\u5f55\u5230\u4e8c\u8fdb\u5236\u65e5\u5fd7(binlog)\u4e2d\u3002\u4e3b\u5e93\u5f00\u542fbinlog\uff0c\u4ece\u5e93\u901a\u8fc7change master\u547d\u4ee4\u914d\u7f6e\u8fde\u63a5\u4e3b\u5e93\u7684\u4fe1\u606f\u3002\u63a5\u6536binlog\u5e76\u5199\u5165\u4ece\u670d\u52a1\u5668\u7684\u4e2d\u7ee7\u65e5\u5fd7(relay log)\u4ece\u5e93\u8bb0\u5f55\u5df2\u7ecf\u5904\u7406\u7684\u4e8b\u4ef6\u4f4d\u7f6e(relay-log.info)MySQL\u7248\u672c: 5.7 \u6216 8.0 (\u5efa\u8bae\u4f7f\u7528\u76f8\u540c\u7248\u672c)\u4ece\u5e93SQL\u7ebf\u7a0b\u8bfb\u53d6relay log\u5e76\u5e94\u7528\u8fd9\u4e9b\u4e8b\u4ef6\u3002\u4ece\u5e93I\/O\u7ebf\u7a0b\u63a5\u6536\u4e8b\u4ef6\u5e76\u5199\u5165relay log\u3002\u4e3b\u5e93\u9a8c\u8bc1\u4ece\u5e93\u8fde\u63a5\u540e\uff0c\u5f00\u59cb\u53d1\u9001binlog\u4e8b\u4ef6\u3002\u8bfb\u53d6\u4e2d\u7ee7\u65e5\u5fd7\u4e2d\u7684\u4e8b\u4ef6\u3002_mysql\u81ea\u52a8\u4e3b\u4ece\u590d\u5236<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114,100],"topic":[],"class_list":["post-39942","post","type-post","status-publish","format-standard","hentry","category-server","tag-mysql","tag-100"],"yoast_head":"\n\n
\n
2：\u57fa\u4e8e\u4e2d\u95f4\u4ee3\u7406\u5c42\u5b9e\u73b0<\/h3>\n
（1）MySQL-Proxy.<\/h4>\n
\n
\n
\n
（2）Amoeba.<\/h4>\n
\n
\n
\n
（3）MyCAT.<\/h4>\n
\n
\n
\n
\u4e09：\u6848\u4f8b\u73af\u5883<\/h2>\n
1. \u670d\u52a1\u5668\u89c4\u5212<\/h4>\n
\n
\n \u6848\u4f8b\u73af\u5883 <\/p>\n\n
\n \u4e3b\u673a<\/td>\n \u64cd\u4f5c\u7cfb\u7edf<\/td>\n ip\u5730\u5740<\/td>\n \u5e94\u7528<\/td>\n<\/tr>\n \n Master<\/td>\n openEuler\u00a0 24.03<\/td>\n 192.168.10.101<\/td>\n Mysql-server<\/td>\n<\/tr>\n \n Slave1<\/td>\n openEuler\u00a0 24.03<\/td>\n 192.168.10.102<\/td>\n Mysql-server<\/td>\n<\/tr>\n \n Slave2<\/td>\n openEuler\u00a0 24.03<\/td>\n 192.168.10.103<\/td>\n Mysql-server<\/td>\n<\/tr>\n \n mycat<\/td>\n openEuler\u00a0 24.03<\/td>\n 192.168.10.104<\/td>\n mycat2<\/td>\n<\/tr>\n \n \u5ba2\u6237\u7aef<\/td>\n openEuler\u00a0 24.03<\/td>\n 192.168.10.105<\/td>\n mysql<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/h4>\n
<\/h4>\n
<\/h4>\n
<\/h4>\n
<\/h4>\n
<\/h4>\n
<\/h4>\n
<\/h4>\n
2. \u7f51\u7edc\u8981\u6c42<\/h4>\n
\n
\u56db：\u4e3b\u4ece\u590d\u5236\u6848\u4f8b\u5b9e\u65bd<\/h2>\n
1：\u914d\u7f6emaster\u4e3b\u670d\u52a1\u5668<\/h3>\n
（1）\u4fee\u6539MySQL\u914d\u7f6e\u6587\u4ef6(my.cnf)<\/h4>\n
\nsocket=\/usr\/local\/mysql\/data\/mysql.sock
\n[mysqld]
\nserver-id=1
\nsocket=\/usr\/local\/mysql\/data\/mysql.sock
\nbind-address = 0.0.0.0
\nskip-name-resolve
\nport = 3306
\nbasedir=\/usr\/local\/mysql
\ndatadir=\/usr\/local\/mysql\/data
\nmax_connections=2048
\ncharacter-set-server=utf8
\ndefault-storage-engine=INNODB
\nlower_case_table_names=1
\nmax_allowed_packet=16M<\/p>\n
\nlog-error=\/usr\/local\/mysql\/data\/error.log
\npid-file=\/var\/run\/mariadb\/mariadb.pid <\/p>\n（2）\u91cd\u542fMySQL\u670d\u52a1<\/h4>\n
（3）\u521b\u5efa\u590d\u5236\u4e13\u7528\u7528\u6237<\/h4>\n
\ncreate user 'myslave'@'%' identified by '123456';
\ngrant replication slave on *.* to 'myslave'@'%';
\nalter user 'myslave'@'%' identified with mysql_native_password by '123456';<\/p>\n（4）\u67e5\u770b\u4e3b\u670d\u52a1\u5668\u72b6\u6001<\/h4>\n
\n#\u8bb0\u5f55\u8f93\u51fa\u4e2d\u7684File\u548cPosition\u503c，\u4f8b\u5982：
\n+——————+———-+————–+——————+——————-+
\n| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
\n+——————+———-+————–+——————+——————-+
\n| mysql-bin.000001 | 745 | test_db | mysql | |
\n+——————+———-+————–+——————+——————-+ <\/p>\n2：\u914d\u7f6eslave\u4ece\u670d\u52a1\u5668<\/h3>\n
（1）\u4fee\u6539MySQL\u914d\u7f6e\u6587\u4ef6(my.cnf)<\/h4>\n
\nsocket=\/usr\/local\/mysql\/data\/mysql.sock
\n[mysqld]
\nserver-id=2
\nsocket=\/usr\/local\/mysql\/data\/mysql.sock
\nbind-address = 0.0.0.0
\nskip-name-resolve
\nport = 3306
\nbasedir=\/usr\/local\/mysql
\ndatadir=\/usr\/local\/mysql\/data
\nmax_connections=2048
\ncharacter-set-server=utf8
\ndefault-storage-engine=INNODB
\nlower_case_table_names=1
\nmax_allowed_packet=16M<\/p>\n
\nlog-error=\/usr\/local\/mysql\/data\/error.log
\npid-file=\/var\/run\/mariadb\/mariadb.pid <\/p>\n（2）\u91cd\u542fMySQL\u670d\u52a1<\/h4>\n
（3）\u767b\u5f55MySQL，\u914d\u7f6e\u540c\u6b65<\/h4>\n
\nchange master to master_host='192.168.10.201',master_user='myslave',master_password='123456',master_log_file='mysql-bin.00001',master_log_pos=157;<\/p>\n（4）\u542f\u52a8\u540c\u6b65<\/h4>\n
（5）\u67e5\u770bslave\u72b6\u6001，\u786e\u4fdd\u4e00\u4e0b\u4e24\u4e2a\u503c\u4e3aYES<\/h4>\n
3：\u9a8c\u8bc1\u4e3b\u4ece\u590d\u5236\u6548\u679c<\/h3>\n
（1）\u5728\u4e3b\u670d\u52a1\u5668\u521b\u5efa\u6d4b\u8bd5\u6570\u636e\u5e93<\/h4>\n
\nUSE test_db;
\nCREATE TABLE test_table (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50));
\nINSERT INTO test_table (name) VALUES ('\u6d4b\u8bd5\u6570\u636e1'), ('\u6d4b\u8bd5\u6570\u636e2'); <\/p>\n（2）\u5728\u4ece\u670d\u52a1\u5668\u9a8c\u8bc1<\/h4>\n
\nSELECT * FROM test_table; <\/p>\n\u4e94：\u8bfb\u5199\u5206\u79bb\u6848\u4f8b\u5b9e\u65bd<\/h2>\n
1：\u5b89\u88c5Mycat2<\/h3>\n
2：\u5b89\u88c5\u5e76\u914d\u7f6eMycat\u8f6f\u4ef6<\/h3>\n
\nunzip mycat2-install-template-1.20.zip -d \/usr\/local\/
\nls \/usr\/local\/mycat\/<\/p>\n
\necho 'export PATH=$PATH:\/usr\/local\/mycat\/bin' >> \/etc\/profile
\nsource \/etc\/profile<\/p>\n
\ncp mycat2-1.21-release-jar-with-dependencies.jar mysql-connector-java-8.0.18.jar \/usr\/local\/mycat\/lib<\/p>\n
\nchmod -R +x \/usr\/local\/mycat\/bin<\/p>\n
\nmycat -h <\/p>\n3：\u914d\u7f6eMycat\u8bfb\u5199\u5206\u79bb<\/h3>\n
（1）\u521b\u5efaMycat2\u5de5\u4f5c\u6240\u5fc5\u987b\u7684\u8d26\u53f7<\/h4>\n
\ncreate user 'myslave'@'%' identified by 'pwd123';
\ngrant all on *.* to 'myslave'@'%';
\nalter user 'myslave'@'%' identified with mysql_native_password by 'pwd123';
\nflush privileges;
\nshow master status;<\/p>\n（2）\u542f\u52a8Mycat2<\/h4>\n
\n\u4fee\u6539："password":"pwd123",
\n "url":"—-192.168.10.203—–",
\n "user":"mycat",
\nmycat start
\nnetstat -anpt | grep 8066
\ntail -f \/usr\/local\/mycat\/logs\/wrapper.log
\ncat \/usr\/local\/mycat\/conf\/users\/root.users.json
\ndnf -y install mariadb
\nmysql -uroot -p123456 -p8066 -h192.168.10.203<\/p>\n（3）Mycat2\u914d\u7f6e\u8bfb\u5199\u5206\u79bb<\/h4>\n
\u7b2c\u4e00\u6b65：mycat\u589e\u52a0\u6570\u636e\u6e90<\/h5>\n
\n#\u589e\u52a0\u4e3b\u5e93master：
\nmysql>\/*+ mycat:createDataSource{ "name":"master","url":"jdbc:mysql:\/\/192.168.10.101:3306\/?useSSL=false&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true","instanceType":"WRITE","user":"mycat","password":"pwd123"} *\/;
\n#\u589e\u52a0\u4ece\u5e93slave1\u548cslave2：
\n#slave1：
\nmysql>\/*+ mycat:createDataSource{ "name":"slave1","url":"jdbc:mysql:\/\/192.168.10.102:3306\/?useSSL=false&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true","instanceType":"READ","user":"mycat","password":"pwd123"} *\/;<\/p>\n
\nmysql>\/*+ mycat:createDataSource{ "name":"slave2","url":"jdbc:mysql:\/\/192.168.10.103:3306\/?useSSL=false&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true","instanceType":"READ","user":"mycat","password":"pwd123"} *\/;<\/p>\n
\n\/*+ mycat:showDataSources{} *\/\\\\G
\n#\u5982\u6570\u636e\u6e90\u914d\u7f6e\u6709\u8bef\u53ef\u4f7f\u7528，\u91cd\u65b0\u914d\u7f6e：
\n\/*+ mycat:resetConfig{} *\/；
\nll \/usr\/local\/mycat\/conf\/datasources <\/p>\n\u7b2c\u4e8c\u6b65：\u521b\u5efamycat\u96c6\u7fa4<\/h5>\n
\nmysql>\/*! mycat:createCluster{"name":"cls01","masters":["master"],"replicas":["slave1","slave2"]} *\/;<\/p>\n
\ncat \/usr\/local\/mycat\/conf\/clusters\/cls01.cluster.json
\ncat server.json<\/p>\n
\nmycat restart<\/p>\n4：\u9a8c\u8bc1Mycat\u8bfb\u5199\u5206\u79bb<\/h3>\n
\nmysql -uroot -p123456 -p8066 -h192.168.10.206
\ncreate database test;<\/p>\n
\nmycat restart<\/p>\n
\nslave1,slave2:
\nmysql -uroot -ppwd123
\nstop slave;<\/p>\n
\nmaster,slave1,slave2:
\nuse test;
\ninsert into test.zang values('1','zhangsan','this_is_master'); #master
\ninsert into test.zang values('2','zhangsan','this_is_slave1'); #slave1
\ninsert into test.zang values('3','zhangsan','this_is_slave2'); #slave2<\/p>\n
\nmysql -uroot -p123456 -p8066 -h192.168.10.206
\nselect * from test.zang #\u7b2c\u4e00\u6b21\u67e5\u8be2
\nselect * from test.zang #\u7b2c\u4e8c\u6b21\u67e5\u8be2 <\/p>\n","protected":false},"excerpt":{"rendered":"