老男孩-标杆班级-MySQL-分布式架构-MyCAT

b 站链接：
https://www.bilibili.com/video/BV157411K7sf?p=155

简书：
https://www.jianshu.com/p/5e0062f6cf62

1.创建mysql 双主双从的环境

脚本入下

mysqld --initialize-insecure --user=mysql --datadir=/data/3307/data  --basedir=/usr/local/mysql/
mysqld --initialize-insecure --user=mysql --datadir=/data/3308/data  --basedir=/usr/local/mysql/
mysqld --initialize-insecure --user=mysql --datadir=/data/3309/data  --basedir=/usr/local/mysql/
mysqld --initialize-insecure --user=mysql --datadir=/data/3310/data  --basedir=/usr/local/mysql/
mysqld --initialize-insecure --user=mysql --datadir=/data/3311/data  --basedir=/usr/local/mysql/
mysqld --initialize-insecure --user=mysql --datadir=/data/3312/data  --basedir=/usr/local/mysql/
mysqld --initialize-insecure --user=mysql --datadir=/data/3313/data  --basedir=/usr/local/mysql/
mysqld --initialize-insecure --user=mysql --datadir=/data/3314/data  --basedir=/usr/local/mysql/

cat >/data/3307/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3307/data
socket=/data/3307/mysql.sock
port=3307
log-error=/data/3307/mysql.log
log_bin=/data/3307/mysql-bin
binlog_format=row
skip-name-resolve
server-id=7
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF

cat >/data/3308/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3308/data
port=3308
socket=/data/3308/mysql.sock
log-error=/data/3308/mysql.log
log_bin=/data/3308/mysql-bin
binlog_format=row
skip-name-resolve
server-id=8
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF

cat >/data/3309/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3309/data
socket=/data/3309/mysql.sock
port=3309
log-error=/data/3309/mysql.log
log_bin=/data/3309/mysql-bin
binlog_format=row
skip-name-resolve
server-id=9
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF

cat >/data/3310/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3310/data
socket=/data/3310/mysql.sock
port=3310
log-error=/data/3310/mysql.log
log_bin=/data/3310/mysql-bin
binlog_format=row
skip-name-resolve
server-id=10
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF

cat >/etc/systemd/system/mysqld3307.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3307/my.cnf
LimitNOFILE = 5000
EOF

cat >/etc/systemd/system/mysqld3308.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3308/my.cnf
LimitNOFILE = 5000
EOF

cat >/etc/systemd/system/mysqld3309.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3309/my.cnf
LimitNOFILE = 5000
EOF

cat >/etc/systemd/system/mysqld3310.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3310/my.cnf
LimitNOFILE = 5000
EOF

========db02===============

cat >/data/3311/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3311/data
socket=/data/3311/mysql.sock
port=3311
log-error=/data/3311/mysql.log
log_bin=/data/3311/mysql-bin
binlog_format=row
skip-name-resolve
server-id=11
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF

cat >/data/3312/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3312/data
port=3312
socket=/data/3312/mysql.sock
log-error=/data/3312/mysql.log
log_bin=/data/3312/mysql-bin
binlog_format=row
skip-name-resolve
server-id=12
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF

cat >/data/3313/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3313/data
socket=/data/3313/mysql.sock
port=3313
log-error=/data/3313/mysql.log
log_bin=/data/3313/mysql-bin
binlog_format=row
skip-name-resolve
server-id=13
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF


cat >/data/3314/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3314/data
socket=/data/3314/mysql.sock
port=3314
log-error=/data/3314/mysql.log
log_bin=/data/3314/mysql-bin
binlog_format=row
skip-name-resolve
server-id=14
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
EOF

cat >/etc/systemd/system/mysqld3311.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3311/my.cnf
LimitNOFILE = 5000
EOF

cat >/etc/systemd/system/mysqld3312.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3312/my.cnf
LimitNOFILE = 5000
EOF

cat >/etc/systemd/system/mysqld3313.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3313/my.cnf
LimitNOFILE = 5000
EOF
cat >/etc/systemd/system/mysqld3314.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3314/my.cnf
LimitNOFILE = 5000
EOF


systemctl start mysqld3307
systemctl start mysqld3308
systemctl start mysqld3309
systemctl start mysqld3310
systemctl start mysqld3311
systemctl start mysqld3312
systemctl start mysqld3313
systemctl start mysqld3314

可能某几台 mysql 实例启动不了， 是内存不够