Shulou(Shulou.com)06/01 Report--

Part 1. classification

Stored Programs

-Stored Routines

-Procedure

-Function

-Event Scheduler

-Trigger

Part 2. Summary

In addition, there is a little bit about Event Scheduler and Trigger, which should be understood.

Event Scheduler in the MHA environment, manual online switching, there will be the following message prompt, to temporarily turn off Event Scheduler.

Wed Sep 13 10:55:43 2017-[error] [/ usr/local/share/perl5/MHA/MasterRotate.pm, ln161] We should not start online master switch when one of connections are running long updates on the current master (192.168.19.168) Currently 1 update thread (s) are running.

Details:

{'Time' = >' 147223 'event_scheduler','State' = >' Daemon','db' = > undef,'Id' = > '117223' event_scheduler','State' = > Waiting on empty queue','Host' = > 'localhost'}

Wed Sep 13 10:55:43 2017-[error] [/ usr/local/share/perl5/MHA/ManagerUtil.pm, ln177] Got ERROR: at / usr/local/bin/masterha_master_switch line 53.

Trigger cannot be built on the mysql database, there will be the following error.

ERROR 1465 (HY000): Triggers can not be created on system tables

If you are interested, please follow Subscription account's Database Best practices (DBBestPractice).

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.