Docs

Database Transmission Service

Common general questions

How to obtain the instance's GTID_EXECUTED?

You can obtain the instance's GTID_EXECUTED through the following actions.

Log on to the server that needs to connect to MySQL, such as an ECS server or a local server.

For the operation steps on how to log on to an ECS, refer to Log on to an ECS instance.

Execute the following command to connect to the target instance.

mysql -h<Connection URL> -P<Port> -u<UserName> -p -D<DataName>

Parameter description

Parameter	Description
-h	The internal or external network connection address of the MySQL instance. tip For information on how to get the private or public address, refer to Connecting to an instance via private network and Applying for or releasing a public address.
-P	The port number of the MySQL instance. The port number varies depending on the connection address, as follows: When using an internal network connection, you must enter the internal network port of the MySQL instance. When using an external network connection, you must enter the external network port of the MySQL instance. P must be capitalized, and the default port is 3306. If the port number is the default port, this parameter can be left blank.
-u	The account name in the MySQL instance.
-p	The password of the account in the MySQL instance. tip To ensure password security, do not enter the password after -p. You are prompted to enter the password after the command is run. Press Enter after entering the password to log on. If this parameter is filled in, a space is not allowed between -p and password.
-D	The name of the database to log on to. This parameter is optional. You can omit -D and enter only the database name.

Execute the following command to obtain the instance's GTID_EXECUTED.

show master status

Execution result example

+---------------+------------------+--------------+------------------+---------------------------------------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set. |
+---------------+------------------+--------------+------------------+---------------------------------------------------+
| binlog.000992 | 302355 | | | 5d3ffd44-9614-11ed-aaf2-5254ac13e820:1-3514674 |
+-------------+--------------------+--------------+------------------+---------------------------------------------------+
1 row in set (0.01 sec)

You can view the execution results in Executed_Gtid_Set. Get the GTID_EXECUTED of the instance from 中, that is, the value of this example is 5d3ffd44-9614-11ed-aaf2-5254ac13e820:1-3514674.

Last updated: 2026.08.13 11:47:37