Re: slave to master

On 4/28/2016 5:20 PM, Thomas wrote:
> Hi,
>
> I have setup an master slave replication.
> This works fine.
> I have running an Apache webserver and some other programms accessing the
> master.
> Whats the standard pocedure if master fail?
>
> I want to start up the programms on the slave by hand and then they are
> accessing the mySQL slave. Can they write to the slave or do I have to change
> something before in the mysql slave configuration?
>
>
> thanks
> Thomas
>
>The simple answer is that you don't have to do anything.
At some point you will want to stop the slave so that it will not 
start replicating when the master comes back up.

When the master is repaired and up you need to stop the programs 
on the slave from accessing mysql (ie: stop the programs on the 
slave), make a database copy of the slave, copy it to the master 
and reload the database on the master, and then use the Change 
Master to command on the slave to set up the slave to begin 
replicating and start slave.

This is the poor man's failover for low volume systems.
In essence the slave becomes the main database server until you 
are ready to restart the master and replication.

bill



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql