Mysql-backup : Différence entre versions
| Ligne 16 : | Ligne 16 : | ||
+-----------+--------------------+------+-------------------+-----------+ | +-----------+--------------------+------+-------------------+-----------+ | ||
1 row in set (0.00 sec) | 1 row in set (0.00 sec) | ||
| + | |||
| + | |||
| + | > SHOW PROCESSLIST \G; | ||
| + | |||
| + | voir a la fin : | ||
| + | |||
| + | *************************** 13. row *************************** | ||
| + | Id: 3001942 | ||
| + | User: repl | ||
| + | Host: 10.13.102.104:33651 | ||
| + | db: NULL | ||
| + | Command: Binlog Dump | ||
| + | Time: 656 | ||
| + | State: Has sent all binlog to slave; waiting for binlog to be updated | ||
| + | Info: NULL | ||
Version du 16 juillet 2012 à 09:10
Adresse : 10.13.102.104
pour vérifier la réplication :
sur mysql :
# mysql >SHOW SLAVE HOSTS;
doit retourner :
+-----------+--------------------+------+-------------------+-----------+ | Server_id | Host | Port | Rpl_recovery_rank | Master_id | +-----------+--------------------+------+-------------------+-----------+ | 2 | mysql.dr13.cnrs.fr | 3306 | 0 | 1 | +-----------+--------------------+------+-------------------+-----------+ 1 row in set (0.00 sec)
> SHOW PROCESSLIST \G;
voir a la fin :
*************************** 13. row ***************************
Id: 3001942
User: repl
Host: 10.13.102.104:33651
db: NULL
Command: Binlog Dump
Time: 656
State: Has sent all binlog to slave; waiting for binlog to be updated
Info: NULL
Sur mysql-backup :
# mysql -u root -p k72muzik
>SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 193.49.133.9
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.093233
Read_Master_Log_Pos: 96483
Relay_Log_File: mysqld-relay-bin.075140
Relay_Log_Pos: 96628
Relay_Master_Log_File: mysql-bin.093233
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 96483
Relay_Log_Space: 96827
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)
