database-replication - w3toppers.com

SQL Server Update Trigger, Get Only modified fields

I’ve another completely different solution that doesn’t use COLUMNS_UPDATED at all, nor does it rely on building dynamic SQL at runtime. (You might want to use dynamic SQL at design time but thats another story.) Basically you start with the inserted and deleted tables, unpivot each of them so you are just left with the … Read more

How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?

This is the full step-by-step procedure to resync a master-slave replication from scratch: At the master: RESET MASTER; FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; And copy the values of the result of the last command somewhere. Without closing the connection to the client (because it would release the read lock) issue the command … Read more