From: ranjeet walunj (ranjeet.walunjgmail.com)
Date: Mon Oct 06 2008 - 06:20:40 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Uma Bhat wrote:

Hey guys!

*MySQL version 5.0*
Hence before doing this, *we want to ensure that
there is ABSOLUTE *no* difference in schema between each of them. (all
datatypes, and other such database objects, engines, MUST be IDENTICAL).*

*QUESTION* - what's the *EASIET way to compare* the schema's of ALL these 50
databases ?

*WORKAROUND* i could think of - taking *mysqldump* of database (with *
--no-data* option) and compare with *'diff'* UNIX command.

BUT, this is a VERY TEDIOUS to carry out this process for 50 databases!!!

 It is not ... a simple shell script will do it for you and can even mail
you the results about mismatch.

Btw Why don't you consider having a single database replicated across 50
diff machines/servers ?
Or is it sharding/partitioning of data across different instances ?

Regards,
Ranjeet Walunj

 *Are there any tools available* to accomplish this task?

Many Thanks!
Uma

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]