mysql.rds_replica_status - Amazon Relational Database Service
SyntaxUsage notesExamples

mysql.rds_replica_status

Shows the replication status of a MariaDB read replica.

Call this procedure on the read replica to show status information on essential parameters of the replica threads.

Syntax

CALL mysql.rds_replica_status;

Usage notes

This procedure is only supported for MariaDB DB instances running MariaDB version 10.5 and higher.

This procedure is the equivalent of the SHOW SLAVE STATUS command. This command isn't supported for MariaDB version 10.5 and higher DB instances.

In prior versions of MariaDB, this command required the REPLICATION SLAVE privilege. In MariaDB version 10.5, it requires the REPLICATION SLAVE ADMIN privilege. To protect the RDS management of MariaDB 10.5 DB instances, this new privilege isn't granted to the RDS master user.

Examples

The following example shows the status of a MariaDB read replica:

call mysql.rds_replica_status;

The response is similar to the following:

*************************** 1. row ***************************
                Slave_IO_State: Waiting for master to send event
                   Master_Host: XX.XX.XX.XXX
                   Master_User: rdsrepladmin
                   Master_Port: 3306
                 Connect_Retry: 60
               Master_Log_File: mysql-bin-changelog.003988
           Read_Master_Log_Pos: 405
                Relay_Log_File: relaylog.011024
                 Relay_Log_Pos: 657
         Relay_Master_Log_File: mysql-bin-changelog.003988
              Slave_IO_Running: Yes
             Slave_SQL_Running: Yes
               Replicate_Do_DB:
           Replicate_Ignore_DB:
            Replicate_Do_Table:
        Replicate_Ignore_Table: mysql.rds_sysinfo,mysql.rds_history,mysql.rds_replication_status
       Replicate_Wild_Do_Table:
   Replicate_Wild_Ignore_Table:
                    Last_Errno: 0
                    Last_Error:
                  Skip_Counter: 0
           Exec_Master_Log_Pos: 405
               Relay_Log_Space: 1016
               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:
   Replicate_Ignore_Server_Ids:
              Master_Server_Id: 807509301
                Master_SSL_Crl:
            Master_SSL_Crlpath:
                    Using_Gtid: Slave_Pos
                   Gtid_IO_Pos: 0-807509301-3980
       Replicate_Do_Domain_Ids:
   Replicate_Ignore_Domain_Ids:
                 Parallel_Mode: optimistic
                     SQL_Delay: 0
           SQL_Remaining_Delay: NULL
       Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
              Slave_DDL_Groups: 15
Slave_Non_Transactional_Groups: 0
    Slave_Transactional_Groups: 3658
1 row in set (0.000 sec)

Query OK, 0 rows affected (0.000 sec)