Author : Bilery Zoo(bilery.zoo@gmail.com) Date : 2021-04-24
|\_/|
| ・x・ |
\_____/ |
| |
\ ノ
((( (/ ̄ ̄ ̄ ̄(/ヽ)
About engineering:
This project(scripts) is to easily deploy a castrated MySQL InnoDB Cluster.
The castration is mainly represented at
① without MySQL Shell
② perform a "one PRIMARY - one SECONDARY" group replication without fault-tolerance
See also
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html
https://dev.mysql.com/doc/refman/8.0/en/group-replication-fault-tolerance.html
The cluster is to deploy at IBM Cloud VM(CentOS8 Linux) set menu 'BL2.2x8'(2 CPUs & 8G MEMs).
Packages to be installed are
mysql-8.0.24-linux-glibc2.12-x86_64
mysql-router-8.0.24-linux-glibc2.12-x86_64
Script usage:
0. mysql_v8.0generic_glibc_deploy.sh
deploy mysql service
1. mysqlrouter_v8.0generic_glibc_deploy.sh
deploy mysqlrouter service
2. async_replication_set.sh
set asynchronous M-S replication(deprecated)
3. group_replication_set.sh
set synchronous group replication(recommended)
Your attention:
Each of scripts should optionally do the parameters resetting at mascot area before executing