Replication broken. Stale data in slave Database

[Alberto Olivares <alberto.olivares@xxxxxxxxxxxxxxxxxxxxx>]

Hi all,

We have set up a Streaming replication. 

Master database serves temporal data being replicated on the Slave database.

In the event that we shut down the Master database, the slave database contains residual data that we do not need. 

Is there any way to trigger a SQL to delete all data from the slave database in the event that the replication is broken?

Thank you for your answers.

Regards,

Alberto.

Alberto Olivares Colas
Technical Consultant

Snowflake Software

Tel.: +44 (0)2380 386578

Email: alberto.olivares@xxxxxxxxxxxxxxxxxxxxx

Website: www.snowflakesoftware.com
Twitter: @sflakesoftware

Follow us on LinkedIn

Winner of IHS Jane's ATC Award - Enabling Technology

Read more

Registered in England & Wales. Registered Number: 4294244

-----------------------------------------------------------------------------------------

Winner of IHS Jane's ATC Award - Enabling Technology

Read more