mysql相关

MySQL 是最流行的关系型数据库管理系统

kubectl exec -it mysql-standalone-0 -- mysql -uroot -ptest      #进入自助云数据库（6.9.2版本）

kubectl exec -it mysql-standalone-0 -- mysql -ptest -e "select * from performance_schema.replication_group_members;"      #查看当前集群(自助云)数据库的状态

kubectl exec -it mysql-standalone-0 -- mysqldump -ptest -q -Q --default-character-set=utf8 --single-transaction --routines --events --all-databases > sip.sql     #备份自助云sql

kubectl exec -it mysql-0 -- mysql -uuser1 -p123456Abc         #进入监控云数据库（6.9.2版本）

kubectl exec -it mysql-0 -- mysql -ptstack_monitor -e "select * from performance_schema.replication_group_members;"      #查看当前集群(监控云)数据库的状态

kubectl exec -it mysql-0 -- mysqldump -ptstack_monitor -q -Q --default-character-set=utf8 --single-transaction --routines --events --all-databases > mon.sql    ##备份监控云sql

恢复数据集群：

、查看集群状态
kubectl exec -it mysql-0 -- mysql -ptstack_monitor -e "select * from performance_schema.replication_group_members;"

2、备份监控的sql
kubectl exec -it mysql-0 -- mysqldump -ptstack_monitor -q -Q --default-character-set=utf8 --single-transaction --routines --events --all-databases > mon.sql

3、恢复 mysql-1
kubectl exec -it mysql-1 bash
# mysql -ptstack_monitor
mysql> set sql_log_bin = 0;
Query OK, 0 rows affected (0.00 sec)
mysql> stop group_replication;
Query OK, 0 rows affected (1.02 sec)
mysql> set global super_read_only = 0;
Query OK, 0 rows affected (0.00 sec)
mysql> reset master;
Query OK, 0 rows affected (0.06 sec)
mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit

4、导入sql
kubectl exec -it mysql-1 -- mysql -ptstack_monitor < mon.sql

5、开启同步
kubectl exec -it mysql-1 bash
# mysql -ptstack_monitor
mysql> change master to master_host='mysql-0';
Query OK, 0 rows affected (0.21 sec)
mysql> change master to master_user='repl',master_password='password' for
channel 'group_replication_recovery';
Query OK, 0 rows affected, 2 warnings (0.06 sec)
mysql> set sql_log_bin=1;
Query OK, 0 rows affected (0.00 sec)
mysql> start group_replication;
Query OK, 0 rows affected (3.93 sec)
mysql> select * from performance_schema.replication_group_members;
# RECOVERING 一段时间后会恢复为 ONLINE


依次恢复其他节点

最后查看一下集群状态
kubectl exec -it mysql-0 -- mysql -ptest -e "select * from performance_schema.replication_group_members;"

注：
1、如果修复监控云mysql后，发现walle pod无法启动
检查hanah-api日志
kubectl exec -it hanah-api-8b5f7657f-blmc7 bash
cd /data/monitorcloud/hanah_api/logs
tail -f hanah-api.log
查看日志发现proxysql异常
重启proxysql pod
kubectl delete pods proxysql-sip-proxysql-cl-79fbdcd54f-hq4xv proxysqlproxysql-cluste-6b4cdf9fbf-qx47t

openstack底层数据库mariaDB

1、查看Galera集群状态:
show status like 'wsrep%';

2、检查集群是否正常
Show global status like “wsrep_local_state”;