[MDEV-15452] Better implementation for SQL RESTART server Created: 2018-03-02  Updated: 2018-03-02

Status: Open
Project: MariaDB Server
Component/s: Admin statements
Fix Version/s: None

Type: Task Priority: Major
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

MySQL 8 introduce a SQL restart command
https://dev.mysql.com/doc/refman/8.0/en/restart.html

With the trend of containers it would be nice to get a RESTART command that keep the mysqld process alive, stop start controlled within the server with SHUTDOWN SOFT and RESTART SOFT

Such restart would

  • block new connections
  • Flush all file descriptors
  • unload SE
  • reload config
  • reload SE
  • reopen connections

Reseeding MariaDB backup can be done such way without HARD shutdown
Docker shutdown the container if the mysqld process id 1 , it's not clear for me how Galera manage reseeding without shutdown but looks like exposing some SST magic to SQL command!


Generated at Thu Feb 08 08:21:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.