Hi, Gordan, MariaDB has a solution for that since 10.8.1, see https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#binlog_alter_two_phase https://mariadb.com/kb/en/alter-table/#replication
On Mar 22, Gordan Bobic via discuss wrote: > On Sat, 22 Mar 2025, 20:02 edi mari, <edim2...@gmail.com> wrote: > > > Thanks Gordan. > > This is a cluster and I have slaves. > > How does the ALGORITHM=INPLACE, LOCK=NONE; configuration impact the > > slaves ? > > The slaves will start the ALTER when it gets in the binlog - which > will happen when ALTER completes. So if it takes an hour for that > ALTER to complete, your slaves will get a 1 hour lag spike that won't > start to clear until they finish executing the ALTER they replicated > down. Regards, Sergei Chief Architect, MariaDB Server and secur...@mariadb.org _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-le...@lists.mariadb.org
