On Mon, 24 Mar 2025 at 16:40, edi mari <[email protected]> wrote: > > Hi Gordan, > > Do you see any reason why we shouldn't first run the CREATE INDEX statement > on the slaves and then run the same command on the master, > while ensuring it's not written to the binary log? > > In this order, we will eliminate the slave lag. > > For example, on the master, we could disable binary logging temporarily: > > -- Disable binary logging for the current session > SET sql_log_bin = 0; > -- Run the CREATE INDEX command > CREATE INDEX ix_index ON t1 (col1, col2) ALGORITHM=INPLACE, LOCK=NONE; > -- Re-enable binary logging > SET sql_log_bin = 1;
You can, but it taints GTID consistency across the server, if you care about that kind of thing. -- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
