You are correct, in a master slave setup the slave does not accept writes.
On 22 November 2010 11:06, Machiel Richards <machielr@stripped> wrote:
> Hi All
> sorry to bother everyone again..... but now I have a question from a
> client which I am sure about my answer, however need to confirm.
> When setting up a master/slave replication set.
> As I understand it, the slave server can't accept any writes,
> however it will be able to accept reads.
> Is this correct, or will the slave server still be able to
> accept writes as well (even though it may not be replicated) ?
> Kind Regards
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621