The invention discloses an
intelligent database switching method and device,
computer equipment and a storage medium, belongs to the technical field of
big data, and is applied to a financial
database downtime processing scene. According to the method, the node state of the
database is monitored in real time, multi-dimensional load evaluation is combined, the optimal main and standby
database combination is automatically selected, second-level fault sensing and rapid switching are achieved, and a minute-level time window needed by traditional database
recovery is remarkably shortened. The database identifier is embedded in the service main key, so that the request can accurately position the corresponding database node, complex cross-
database query and routing overhead are avoided, and the
system response efficiency is improved. In addition, through data seamless transmission and automatic abnormal switching between the main database and the standby database, the risk of service interruption caused by database faults is reduced. According to the scheme, the
high availability and the fault
recovery speed of the database are improved, repeated construction of a multi-product-line database cluster is reduced through
resource integration, and a large amount of hardware and operation and maintenance cost are saved.