Hi, Otto, On Jul 29, Otto Kekäläinen wrote:
The switchover is initiated and decided by the DBA controlling the server. You cannot possibly expect it to be controlled by the client - and in particular to be decided by the *slowest* client. The server can allow some time for the draining of existing connections to happen, but eventually it needs to tell old client connections to stop, and only after the redirect has started for new connections + all existing connections have been dropped can the actual switchover proceed by promoting a new primary.
Yes, exactly. In the model I was talking about, the server tells all clients to redirect, waits for a certain period of time and then kills all connections or shuts down. And during that period of time, while the server is waiting, the client can decide what is the best moment to disconnect. But if client doesn't disconnect - the server will kill the connection anyway eventually, it won't wait forever. Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org