Mysql-backup

Adresse : 10.13.102.104

Vérification de la réplication :

sur mysql :

# mysql
>SHOW SLAVE HOSTS;

doit retourner :

+-----------+---------------------------+------+-------------------+-----------+
| Server_id | Host                      | Port | Rpl_recovery_rank | Master_id |
+-----------+---------------------------+------+-------------------+-----------+
|         2 | mysql-backup.dr13.cnrs.fr | 3306 |                 0 |         1 |
+-----------+---------------------------+------+-------------------+-----------+
1 row in set (0.00 sec)

Sur mysql-backup

> SHOW PROCESSLIST \G;

voir a la fin les infos concernant l'utilisateur repl :

*************************** 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)