MySQL 服务器 : What is the Difference between "Stop Server" and "Bring Offline"?

Question

我可以在 mysql workbench 中看到 Stop Server 和 Bring Offline。

我希望两者都用于停止服务，但在何时使用 Stop Server 和 Bring Offline？

方面仍然混淆两者之间的区别

Answer 1

停止服务器只是停止mysql进程

离线模式 是 MySQL 5.7.5 中引入的新功能，基本上排除了除 DBA 之外的所有用户:

MySQL Server now supports an “offline mode” with these characteristics:

• Connected client users who do not have the SUPER privilege are disconnected on the next request, with an appropriate error. Disconnection includes terminating running statements and releasing locks. Such clients also cannot initiate new connections, and receive an appropriate error.

• Connected client users who have the SUPER privilege are not disconnected, and can initiate new connections to manage the server.

• Replication slave threads are permitted to keep applying data to the server.

Only users who have the SUPER privilege can control offline mode. To put a server in offline mode, change the value of the new offline_mode system variable from OFF to ON. To resume normal operations, change offline_mode from ON to OFF. In offline mode, clients that are refused access receive an ER_SERVER_OFFLINE_MODE error.

来源:Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)