How does row-based replication trigger updates to index blocks??
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Marcus Bointon [mailto:marcus@stripped]
> Sent: Thursday, August 07, 2008 1:28 AM
> To: SolidEther
> Cc: replication@stripped
> Subject: Re: changes in slave db layout
> On 7 Aug 2008, at 08:42, SolidEther wrote:
> > Regarding the option of doing replication on just certain
> tables of
> > a database, or even row-based replication, is it possible
> to alter a
> > database layout on the slave side, in particular by extending the
> > replicated tables by additional keys?
> If you make the changes on the master, they will be
> replicated to the
> slaves. The only problem I can see in adding keys on the slave alone
> is if they impose constraints (i.e. unique) that clash with data
> coming from the master.
> Marcus Bointon
> Synchromedia Limited: Creators of http://www.smartmessages.net/
> UK resellers of info@hand CRM solutions
> marcus@stripped | http://www.synchromedia.co.uk/