Re: Replication broken. Stale data in slave Database

Not sure if I can do that when the master database is shut down
On 24 Jun 2015 6:36 pm, "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
wrote:

> > Hi,
> >
> > Yes we have failover. If after a few minutes the master database goes up
> > the replication works again which is fine.
> >
> > But I need something that deletes all records in the slave database
> > meanwhile master database is down. The reason is because we are sending
> > not
> > updated data when this happens and we prefer deleted what it is in the
> > slave database.
>
> Uhmmmm, use rsync of the folder wal in the master and slave.
>
>
>
> Saludos,
> Gilberto Castillo
> ETECSA, La Habana, Cuba
>
>

--
*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*