Is there any way to graceful restart mysqld? [duplicate]

Posted on

Question :

I think my question is impossible but I sure I do not know everything.

In my opinion, when mysqld restart, some transaction is not still completed will be rollback on startup. Mysqld use undo log to do it. But is there any way to keep long transactions on restarting mysqld ?

I am using MariaDB Galera with three nodes.

Answer :

Exact duplicate?

Is there a graceful or safe restart for mysql like for apache httpd?

Basically, it involves some SQL scripting along with whatever operating system scripts or controls you are using to do the server restart.
Just be mindful of how the locking interacts with transactions:

Leave a Reply

Your email address will not be published. Required fields are marked *