search

github / gh-ost

GitHub's Online Schema-migration Tool for MySQL
MIT License
12.44k stars 1.26k forks source link

Useing gh-ost to alter instance in a MGR group #779

Open xuewindy opened 5 years ago

xuewindy commented 5 years ago

there is no slave status on a secondary instance in a Mgr group ,so that gh-ost can't judge other instance delay，to handlle throttle . instead of slave status . could gh-ost useing performance_schema.replication_group_member_stats(COUNT_TRANSACTIONS_IN_QUEUE) to judge if need to decrease the throught of current migrating .

shlomi-noach commented 5 years ago

Hi,

What is Mgr? MariaDB Group Replication?

gh-ost does not support group replication at this time; to be honest, I don't expect it to.

xuewindy commented 5 years ago

thanks for response, yeah mgr means mysql group replication,
what's the risk when using gh-ost to alter the node on Group Replication? i didn't find any description on previous issue

shlomi-noach commented 5 years ago

I don't know first hand what the risks are -- I hear there's risk of complete locking of the database during DDL.

jiangnanora commented 4 years ago

Recently we have also launched mysql group replcation. The delay of ghost is based on traditional replication. Can it also be integrated?

xuewindy commented 3 years ago

Recently we have also launched mysql group replcation. The delay of ghost is based on traditional replication. Can it also be integrated?

maybe don't need to check the relay, master will hang the write op until slave reache it's relay Threshold

jiangnanora commented 3 years ago

@xuewindy Because of cross-idc reasons, the flow control is closed, so I still want to do some control from gt-ost