469,943 Members | 2,741 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,943 developers. It's quick & easy.

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 1424

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
By using this site, you agree to our Privacy Policy and Terms of Use.