Overview

The binlog service provides SQL statements for you to manage binlog tasks, instances, and files.

The management statements of the binlog service must be executed on the binlog server and are categorized as follows:

• Node management statements: These statements are used for managing binlog nodes, such as querying all OBServer nodes where the binlog service resides and querying information about the node where the primary binlog instance of the specified tenant resides.
• Task management statements: These statements are used for managing binlog tasks, such as creating, querying, modifying, and releasing tasks. Tenants and binlog tasks are in one-to-one correspondence. In other words, you can create only one binlog task for each tenant.
• Instance management statements: These statements are used for managing binlog instances, such as creating, querying, modifying, and starting/stopping instances, and switching the primary instance. Binlog tasks and binlog instances are in one-to-many correspondence. In other words, you can create multiple binlog instances in one binlog task.
• Session management statements: These statements are used for managing binlog sessions, such as querying and deleting sessions.
• File management statements: At present, only the PURGE BINARY LOGS statement is supported for you to purge binlog files.

The following table describes the management statements provided by the binlog service. Click the name of each statement category to access the relevant documentation.