项目作者: Bilery-Zoo

项目描述 :
easily deploy a castrated MySQL InnoDB Cluster
高级语言: Shell
项目地址: git://github.com/Bilery-Zoo/Castrated-MySQL-InnoDB-Cluster-Deploy.git


Author : Bilery Zoo(bilery.zoo@gmail.com)
Date : 2021-04-24

  1.             |\_/|
  2.             | x |
  3.    \_____/    |
  4.      |         |
  5.     \       ノ
  6.  ((( (/ ̄ ̄ ̄ ̄(/ヽ)

About engineering:

  1. This project(scripts) is to easily deploy a castrated MySQL InnoDB Cluster.
  2. The castration is mainly represented at
  3. without MySQL Shell
  4. perform a "one PRIMARY - one SECONDARY" group replication without fault-tolerance
  5. See also
  6. https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html
  7. https://dev.mysql.com/doc/refman/8.0/en/group-replication-fault-tolerance.html
  8. The cluster is to deploy at IBM Cloud VM(CentOS8 Linux) set menu 'BL2.2x8'(2 CPUs & 8G MEMs).
  9. Packages to be installed are
  10. mysql-8.0.24-linux-glibc2.12-x86_64
  11. mysql-router-8.0.24-linux-glibc2.12-x86_64

Script usage:

  1. 0. mysql_v8.0generic_glibc_deploy.sh
  2. deploy mysql service
  3. 1. mysqlrouter_v8.0generic_glibc_deploy.sh
  4. deploy mysqlrouter service
  5. 2. async_replication_set.sh
  6. set asynchronous M-S replication(deprecated)
  7. 3. group_replication_set.sh
  8. set synchronous group replication(recommended)

Your attention:

  1. Each of scripts should optionally do the parameters resetting at mascot area before executing