472,145 Members | 1,304 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Upgrading DB Schema to multiple Mysql Instances automatically

Hi Guys,

I have multiple Mysql DB instances containing same schema but different data in the tables, running in my unix server.
I always have the issue of not upgrading all the instances at the same time, this leads into inconsistent of DB schema.
My question, is there any tool/script that can sync all my DB instances automatically once i upgrade one instance.(Sync only at schema level not data).
I have heard about Mysql replication,but can it sync only schema and i consider each instance as independent because i run application on every instance.!!
Please let me know if I am not clear with the above message.

Cheers
Dec 9 '09 #1
0 1466

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Ben Smith | last post: by
reply views Thread by Craig Westerman | last post: by
reply views Thread by Mark Adams | last post: by
2 posts views Thread by wellington fan | last post: by
4 posts views Thread by Yasaswi Pulavarti | last post: by
5 posts views Thread by Shiraz | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.