Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: ranjeet walunj (ranjeet.walunjgmail.com)
Date: Mon Oct 06 2008 - 06:20:40 CDT
Uma Bhat wrote:
*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
*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 ?
*Are there any tools available* to accomplish this task?