Get the App
SLTechnology News&Howtos  ›  Database  › 

View the configuration and running status of HARD

Shulou Source: shulou.com Published: 2022-06-01 12:15:33 09月15日 Update

View the configuration and running status of HARD

HADR connection status:

When the HADR of the standby database starts, it first enters the local synchronous update state. The log files in the local system are retrieved and replayed according to the configuration parameters of the local log path and the settings of the log archiving method. When the local log file is replayed, the standby database enters the remote synchronization pending state. When a connection is established with the primary database, the standby database enters a remote synchronous update state. That is, the primary database sends its log files to the standby database through the TCPIP protocol, and the standby database receives the log files and replays them until all the log files are replayed, and the standby database and the primary database enter a peer-to-peer state. See the following figure:

Observe the connection status of the primary and standby databases through the GET SNAPSHOT command.

The GET DB CFG command allows you to view the configuration of HADR, that is, several database parameter values related to HADR.

Tags: Data database status log standby file configuration synchronization parameters commands update run following figure situation method system path peer retrieval observation Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information OPPO Reno NVidia Huawei Xiaomi