List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:October 8 2007 9:05pm
Subject:Re: How to set up Users for Replication
View as plain text  
On 8 Oct 2007, at 21:38, Jesse wrote:

>> On the server. Think of the slave as a client that needs to log in  
>> to  the master to fetch updates, and just as you might expect, you  
>> need  to set permissions on the server, and use them in your  
>> CHANGE MASTER  options on the slave.
>
> OK, so I add a user named Replication@DLGSrv on the master, right,  
> and give it REPLICATION rights? What user will it use on the slave  
> to execute the commands it finds in the BIN LOG on the master?   
> Does it by-pass the user system on the slave to do this?

Yes. The slave connects to the master using the replication user  
info, retrieves the changes from the master's binary log and applies  
the changes locally. The master is a passive data source. There isn't  
a local user to speak of at the slave end, you're giving the slave  
the ability to do this at a global level, so it has an implicit user  
of 'itself'.

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
How to set up Users for ReplicationJesse8 Oct
  • Re: How to set up Users for ReplicationMarcus Bointon8 Oct
  • Re: How to set up Users for ReplicationJesse8 Oct
    • Re: How to set up Users for ReplicationMarcus Bointon8 Oct