List:Replication« Previous MessageNext Message »
From:Andy Smith Date:March 18 2008 1:12pm
Subject:Basic questions on slave servers
View as plain text  
Hi list,


  hopefully a couple of easy to answer fundamental questions on a simple master slave
setup.

1) When a DB is in slave mode, does MySQL prevent any other updates to the DB other than
those from the master?
ie, can someone accidentally update the slave with data that doesnt match the master DB or
is this prevented, or put
another way, is the slave effectively in read-only mode whilst it is running as a slave?

2) If the master should fail and I want my slave to run as a normal standalone read/write
DB what do I have to do? Is it
just:
stop slave;
reset master;
?

thanks in advance! Andy.
Thread
Basic questions on slave serversAndy Smith18 Mar
  • Re: Basic questions on slave serversChris.Leeworthy18 Mar
    • Re: Basic questions on slave serversEd W23 Mar
      • Re: Basic questions on slave serversArthur Fuller23 Mar
        • Re: Basic questions on slave serversEd W23 Mar
  • RE: Basic questions on slave serversEdward F. Pauley II18 Mar
Re: Basic questions on slave serversAndy Smith18 Mar
  • RE: Basic questions on slave serversRick James19 Mar
Re: Basic questions on slave serversAndy Smith20 Mar
  • Re: Basic questions on slave serversMartin MC Brown20 Mar
Re: Basic questions on slave serversAndy Smith20 Mar
  • Re: Basic questions on slave serversMarcus Bointon20 Mar
  • RE: Basic questions on slave serversRick James20 Mar
    • Re: Basic questions on slave serversEric Frazier20 Mar
      • RE: Basic questions on slave serversRick James20 Mar
        • Re: Basic questions on slave serversMoon's Father21 Mar
Re: Basic questions on slave serversAndy Smith21 Mar