| 1 | #!/usr/bin/bash |
|---|
| 2 | |
|---|
| 3 | logfile=/tmp/nodedb1.log |
|---|
| 4 | container_name=nodedb1 |
|---|
| 5 | /usr/bin/docker start $container_name |
|---|
| 6 | echo "docker start $container_name" >> $logfile |
|---|
| 7 | sleep 10 |
|---|
| 8 | if [ "$( docker container inspect -f '{{.State.Status}}' $container_name )" == "running" ]; then |
|---|
| 9 | echo "$container_name is running" >> $logfile |
|---|
| 10 | else |
|---|
| 11 | echo "$container_name is not running, we will start again" >> $logfile |
|---|
| 12 | /usr/bin/docker start $container_name |
|---|
| 13 | echo "start $container_name Done!!" >> $logfile |
|---|
| 14 | fi |
|---|
| 15 | |
|---|
| 16 | if [ "$( docker container inspect -f '{{.State.Status}}' $container_name )" == "running" ]; then |
|---|
| 17 | cmd1="/usr/bin/docker exec -i $container_name mysql -uroot -pmypass -e \"STOP GROUP_REPLICATION;\" \ |
|---|
| 18 | -e \"SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';\" \ |
|---|
| 19 | -e \"SET @@GLOBAL.group_replication_local_address='$container_name:33061';\"\ |
|---|
| 20 | -e \"SET @@GLOBAL.group_replication_group_seeds='$container_name:33061,nodedb2:33061,nodedb3:33061';\" \ |
|---|
| 21 | -e \"change master to master_user='repl' for channel 'group_replication_recovery';\" \ |
|---|
| 22 | -e \"START GROUP_REPLICATION;\" " |
|---|
| 23 | echo "$cmd1" >> $logfile |
|---|
| 24 | eval "$cmd1" 2> /tmp/err.log 1>> $logfile |
|---|
| 25 | sleep 10 |
|---|
| 26 | echo "$container_name join group_replication" >> $logfile |
|---|
| 27 | cmd2="/usr/bin/docker exec -i $container_name mysql -uroot -pmypass -e \"SELECT * FROM performance_schema.replication_group_members;\" " |
|---|
| 28 | echo "$cmd2" >> $logfile |
|---|
| 29 | eval "$cmd2" 2> /tmp/err.log 1>> $logfile |
|---|
| 30 | else |
|---|
| 31 | echo "$container_name still not start" >> $logfile |
|---|
| 32 | fi |
|---|