Galera replication ignore table

Question

With normal Mysql replication we can ignore tables with: replicate_ignore_table

I can't find any information on whether or not it's possible to do this with Galera cluster replication.

I'd like to ignore a table that is not important so that no cluster wide locks have to be acquired when performing an action on the database.

have you found the answer?? I've got the same issue here – Smiley Oct 27 '15 at 14:54 — Smiley, Oct 27 '15 at 14:54

score 1 · Answer 1 · answered Aug 17 '15 at 00:11

1

One workaround is to make the table MyISAM or MEMORY.

answered Aug 17 '15 at 00:11

Rick James

score 0 · Answer 2 · answered Nov 09 '16 at 09:11

0

For ignore a table that is not important, convert this like MyISAM and the galera cluster ignore this automaticaly.

answered Nov 09 '16 at 09:11

el fuser

2 Answers2