A feature to pause the execution of queries once all active transactions have finished would allow controlled switchover of masters without needing to replay transactions.

Another feature that closely matches this is the ability to put a server into maintenance without forcefully closing open transactions. Having a grace period during which open transactions can finish would guarantee a consistent point in time at which the connection is closed. This also removes the need to replay the transaction in the case where a server is put into maintenance mode.

There are three modes of operation that make this feature very compelling:

• Set server maintenance but wait for transactions to complete, effectively draining one server: set server 10.8.1.105 maintenance with-drain
• Put all servers into maintenance mode at once, effectively draining all servers: set server ALL maintenance with-drain
• Put all servers into maintenance mode before a shutdown: shutdown maxscale with-drain