Impact of Full Table Copy

8 views
Skip to first unread message

Christian Becker

unread,
Mar 4, 2017, 2:46:11 AM3/4/17
to codership
Hi There,

at the moment I'm running a huge operation (Modify Table), which leads to a full table copy. On a "normal" MariaDB System I wouldn't even care, but how about Galera. Will there be any problems, after Modifications are finished? 

Couldn't find any information about this.

Bests
Chris

Philip Stoev

unread,
Mar 6, 2017, 2:21:36 AM3/6/17
to Christian Becker, codership
Hello,

By default, in Galera 3.x, a DDL statement will lock the entire cluster for
commits for the duration of the statement. After the statement is completed,
the cluster will resume processing new transactions.

It is also possible to run the DDL on one node at a time, letting the
remaining nodes continue running.

You can read more about Galera and DDLs here:

http://galeracluster.com/documentation-webpages/schemaupgrades.html
--
You received this message because you are subscribed to the Google Groups
"codership" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to codership-tea...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages