0

I have 9 MySQL servers in different environments. One of them is in the testing server. That one will be the first server if I have to make the change.

Is there any way I can sync the table from the testing server to all other ones very quickly to ensure the column consistency? I tried MySQL replication but I don't want to sync data, I only want to sync the table.

Is there a --no-data option in the MySQL replica?

I am very new to MySQL, any help is appreciated!

0

1 Answer 1

0

If the "test" server is the "Primary" in a replication setup, then performing ALTER will be propagated to the "Replicas".

But that's about the only thing relating to your question. And it does not seem like what you want.

There are some 3rd party packages that attempt to orchestrate schema changes. (It's a non-trivial task.)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.