procedures:check_cluster_mysql
no way to compare when less than two revisions
Différences
Ci-dessous, les différences entre deux révisions de la page.
— | procedures:check_cluster_mysql [2022/06/13 14:05] (Version actuelle) – créée gizmo | ||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
+ | Pour db01/ | ||
+ | Pour vérifier le status du master : | ||
+ | ``` | ||
+ | [root@db01 ~]# mysql | ||
+ | Welcome to the MariaDB monitor. | ||
+ | Your MariaDB connection id is 1825077 | ||
+ | Server version: 10.5.12-MariaDB-log FreeBSD Ports | ||
+ | |||
+ | Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. | ||
+ | |||
+ | Type ' | ||
+ | |||
+ | root@localhost [(none)]> | ||
+ | *************************** 1. row *************************** | ||
+ | File: master1-bin.000222 | ||
+ | Position: 720362048 | ||
+ | Binlog_Do_DB: | ||
+ | Binlog_Ignore_DB: | ||
+ | 1 row in set (0.001 sec) | ||
+ | ``` | ||
+ | |||
+ | Pour vérifier le status du slave : | ||
+ | ``` | ||
+ | db02 ~ # mysql | ||
+ | Welcome to the MariaDB monitor. | ||
+ | Your MariaDB connection id is 571819 | ||
+ | Server version: 10.5.9-MariaDB-log Source distribution | ||
+ | |||
+ | Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. | ||
+ | |||
+ | Type ' | ||
+ | |||
+ | MariaDB [(none)]> | ||
+ | *************************** 1. row *************************** | ||
+ | Slave_IO_State: | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | Relay_Log_File: | ||
+ | | ||
+ | | ||
+ | Slave_IO_Running: | ||
+ | | ||
+ | | ||
+ | | ||
+ | Replicate_Do_Table: | ||
+ | Replicate_Ignore_Table: | ||
+ | | ||
+ | | ||
+ | Last_Errno: 0 | ||
+ | Last_Error: | ||
+ | Skip_Counter: | ||
+ | | ||
+ | | ||
+ | | ||
+ | Until_Log_File: | ||
+ | | ||
+ | Master_SSL_Allowed: | ||
+ | Master_SSL_CA_File: | ||
+ | Master_SSL_CA_Path: | ||
+ | | ||
+ | | ||
+ | Master_SSL_Key: | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | Last_SQL_Errno: | ||
+ | Last_SQL_Error: | ||
+ | | ||
+ | Master_Server_Id: | ||
+ | Master_SSL_Crl: | ||
+ | Master_SSL_Crlpath: | ||
+ | Using_Gtid: No | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | Slave_DDL_Groups: | ||
+ | Slave_Non_Transactional_Groups: | ||
+ | Slave_Transactional_Groups: | ||
+ | 1 row in set (0.001 sec) | ||
+ | ``` |
procedures/check_cluster_mysql.txt · Dernière modification : 2022/06/13 14:05 de gizmo