MySQL-分布式架构-MyCAT _MySQL

1、MyCAT基础架构准备
MyCAT基础架构图

文章插图

摘自oldguo
1.1 MyCAT基础架构准备
1.1.1 环境准备：
两台虚拟机 db01（10.0.0.51） db02（10.0.0.52）每台创建四个MySQL实例：3307 3308 3309 3310 1.1.2 删除历史环境：
pkill mysqldrm -rf /data/330* mv /etc/my.cnf /etc/my.cnf.bak1.1.3 创建相关目录初始化数据
mkdir /data/33{07..10}/data -pmysqld --initialize-insecure --user=mysql --datadir=/data/3307/data --basedir=/Application/mysqlmysqld --initialize-insecure --user=mysql --datadir=/data/3308/data --basedir=/application/mysqlmysqld --initialize-insecure --user=mysql --datadir=/data/3309/data --basedir=/application/mysqlmysqld --initialize-insecure --user=mysql --datadir=/data/3310/data --basedir=/application/mysql1.1.4 准备配置文件和启动脚本
========db01==============cat >/data/3307/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3307/datasocket=/data/3307/mysql.sockport=3307log-error=/data/3307/mysql.loglog_bin=/data/3307/mysql-binbinlog_format=rowskip-name-resolveserver-id=7gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/data/3308/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3308/dataport=3308socket=/data/3308/mysql.socklog-error=/data/3308/mysql.loglog_bin=/data/3308/mysql-binbinlog_format=rowskip-name-resolveserver-id=8gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/data/3309/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3309/datasocket=/data/3309/mysql.sockport=3309log-error=/data/3309/mysql.loglog_bin=/data/3309/mysql-binbinlog_format=rowskip-name-resolveserver-id=9gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/data/3310/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3310/datasocket=/data/3310/mysql.sockport=3310log-error=/data/3310/mysql.loglog_bin=/data/3310/mysql-binbinlog_format=rowskip-name-resolveserver-id=10gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/etc/systemd/system/mysqld3307.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3307/my.cnfLimitNOFILE = 5000EOFcat >/etc/systemd/system/mysqld3308.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3308/my.cnfLimitNOFILE = 5000EOFcat >/etc/systemd/system/mysqld3309.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3309/my.cnfLimitNOFILE = 5000EOFcat >/etc/systemd/system/mysqld3310.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3310/my.cnfLimitNOFILE = 5000EOF========db02===============cat >/data/3307/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3307/datasocket=/data/3307/mysql.sockport=3307log-error=/data/3307/mysql.loglog_bin=/data/3307/mysql-binbinlog_format=rowskip-name-resolveserver-id=17gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/data/3308/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3308/dataport=3308socket=/data/3308/mysql.socklog-error=/data/3308/mysql.loglog_bin=/data/3308/mysql-binbinlog_format=rowskip-name-resolveserver-id=18gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/data/3309/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3309/datasocket=/data/3309/mysql.sockport=3309log-error=/data/3309/mysql.loglog_bin=/data/3309/mysql-binbinlog_format=rowskip-name-resolveserver-id=19gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/data/3310/my.cnf<<EOF[mysqld]basedir=/application/mysqldatadir=/data/3310/datasocket=/data/3310/mysql.sockport=3310log-error=/data/3310/mysql.loglog_bin=/data/3310/mysql-binbinlog_format=rowskip-name-resolveserver-id=20gtid-mode=onenforce-gtid-consistency=truelog-slave-updates=1EOFcat >/etc/systemd/system/mysqld3307.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3307/my.cnfLimitNOFILE = 5000EOFcat >/etc/systemd/system/mysqld3308.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3308/my.cnfLimitNOFILE = 5000EOFcat >/etc/systemd/system/mysqld3309.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3309/my.cnfLimitNOFILE = 5000EOFcat >/etc/systemd/system/mysqld3310.service<<EOF[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3310/my.cnfLimitNOFILE = 5000EOF

MySQL-分布式架构-MyCAT

推荐阅读

如果漂流遇到搁浅应该怎么办？漂流注意事项有哪些

科技行者|精确人工智能——核物理与粒子物理领域的新生力量

爱养生爱自己|你不敢再熬了！，还在熬夜吗？相信看完这些“危害”

正山小种的特征，都有哪些呢？

香辣炒牛肚

aso优化功能解读 aso优化推广好做吗有什么作用

春运里的铁路桥梁工：攀爬检查犹如“蜘蛛侠”

卓弈云Duo规格泄密，配备骁龙855处理器，微软Surface

什么是蒙顶茶？哪些茶属于蒙顶茶？

悠游侠|《少女前线》神枪少女联动不会说谎的匹诺曹通关图文攻略

老车主说车▲296马力零百时间5秒，2020款大众途观R现场测试曝光

科技|科技创新引领智慧南水北调中线健康成长

婚姻的句子经典语录伤感婚姻的句子经典语录

娄烨|秦昊陈思诚访谈表白娄烨，陈思诚巨大失落只因亲了秦昊

球哥扯八卦|心形T恤配微喇裤现身，妆容精致有气质，57岁关之琳少女心满满

热门知讯@享受美好生活，iPark影音电器：享受优质音效

测评黑马|亚马逊测评英国站和德国站返款周期是多久？也是用礼品卡支付吗？汇率差是多少

北京的一些乞讨是有组织的吗

加盟其他女鞋的优势介绍

因山火突发被疏散的他们，遇到这样一群人……