On Mon, 24 Mar 2025 at 16:40, edi mari <edim2525@gmail.com> 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