List:Replication« Previous MessageNext Message »
From:Rick James Date:August 8 2008 2:46am
Subject:RE: changes in slave db layout
View as plain text  
How does row-based replication trigger updates to index blocks??

 
Rick James
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
> -- 
> Marcus Bointon
> Synchromedia Limited: Creators of http://www.smartmessages.net/
> UK resellers of info@hand CRM solutions
> marcus@stripped | http://www.synchromedia.co.uk/
> 
> 
> 
Thread
changes in slave db layoutSolidEther7 Aug
  • Re: changes in slave db layoutMarcus Bointon7 Aug
    • RE: changes in slave db layoutRick James8 Aug
      • Re: changes in slave db layoutMark Callaghan8 Aug
        • Re: changes in slave db layoutSolidEther10 Aug
          • RE: changes in slave db layoutRick James12 Aug
            • Re: changes in slave db layoutSolidEther12 Aug