The invention discloses a
database operation and maintenance method and a
database operation and maintenance device, which are applied to a monitoring
server and are used for executing the following
processing on each monitored
database client: establishing a monitoring channel between the monitoring
server and the monitored database
client, creating a monitoring task aiming at the monitored database
client, and monitoring the monitored database client through the established monitoring channel, acquiring
monitoring data corresponding to the monitoring task of the monitored database client, and judging whether the acquired
monitoring data meets an automatic operation and maintenance triggering condition; and if the automatic operation and maintenance triggering condition is met, triggering an automatic operation and maintenance instruction, and sending the automatic operation and maintenance instruction to the monitored database client, so that the monitored database client executes an automatic operation and maintenance operation. By the adoption of the technical method, the
system can achieve automatic operation and maintenance under the condition that a
database administrator is absent, the situation that the database crashes due to the fact that
processing is not conducted in time is solved, part of services are prevented from being affected, the availability and convenience of the
system are improved, and the working efficiency is improved.