"extend the structure" --
If you mean extra databases and/or tables, either should work.
If you mean extra/diff indexes, either(?) should work. [My previous
email was fishing for this answer.]
If you mean diff "engine" (MyISAM vs InnoDB), probably only
statement-based-repl will work. And there may be caveats with
If you mean extra columns, only statement-based-repl will work.
If you mean missing/changed columns, good luck.
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: SolidEther [mailto:solidether@stripped]
> Sent: Sunday, August 10, 2008 12:10 PM
> To: replication@stripped
> Subject: Re: changes in slave db layout
> Hi Fellows,
> I just wanted to explain my initial question again: we are in the
> planing phase of a large database project, where two copies of the
> content are to be hosted in 2 different countries. One of the
> will act as a master, since this is where the data will be supplied,
> while the other location is supposed to run a mirrored data-set. As
> the research purpose is to extend the structure of the second
> database, the question is to which extend "replication" of
> mysql could
> be used for the mirroring?
> Thx again for any suggestions!
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: