← Back to team overview

maria-discuss team mailing list archive

Re: transactional sql update patch system ?

 

Hi, launchpad!

On Feb 28, launchpad@xxxxxxxx wrote:
> Hello,
> 
> we want, that a sql patch file can ONLY be applied if all commands in
> it can applied successful !

If you want that you can only use statements that can be rolled back.

Or set up a replication, make sure that the slave is up to date, stop
replication, apply your sql patch file and then either
start replication - and the slave will catch up - or remove the master
and promote the slave to the new master.

Or do something similar without replication.

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx


References