Comments on: How to Perform Compatible Schema Changes in Percona XtraDB Cluster (Advanced Alternative)? https://www.percona.com/blog/how-to-perform-compatible-schema-changes-in-percona-xtradb-cluster-advanced-alternative/ Sun, 31 May 2020 20:14:34 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Stofa https://www.percona.com/blog/how-to-perform-compatible-schema-changes-in-percona-xtradb-cluster-advanced-alternative/#comment-10972295 Sun, 31 May 2020 20:14:34 +0000 https://www.percona.com/blog/?p=54113#comment-10972295 Hi Malkowski,

Great help for DDL issues on Galeda cluster
Concerning the “Manual RSU” solution, what happens if in Session 2, we have a transaction running ( INSERT, UPDATE , DELETE ) on the table modified ( by alter ) in Session 1.
Should we stop all write on db1.sbtest1 table in the Node where “Manual RSU” is performed as required by RSU method ( SET SESSION wsrep OSU method = ’RSU’ ) ?
From what i tested, NO DML done on db1.sbtest1 in other sessions different from which the alter command is running will be aborted but all are fully replicated to other nodes. Do you confirm ?

Thanks.

]]> By: zarere https://www.percona.com/blog/how-to-perform-compatible-schema-changes-in-percona-xtradb-cluster-advanced-alternative/#comment-10971188 Tue, 10 Sep 2019 17:59:31 +0000 https://www.percona.com/blog/?p=54113#comment-10971188 Nice article Przemysław,

I think we can achieve the same in PXC with:

select count(*) from sysbench.sbtest1 a join sysbench.sbtest1 b where a.id<10000 on 1-session
optimize local table sbtest1 on the 2-nd session

optimize local will be run only on the local node and will not cause issues on the other nodes in PXC.

]]>