I need to be able to notify the other servers that use the same SQL database as one server when that one server updates, inserts, or deletes information on the table.
I thought of 2 solutions myself, and I wanted to know which is better, and if there was a better way than these 2.
1. Constantly retrieve the information from the database (scheduled tasks).
2. Use sockets and send a unique piece of data from one server to all the other servers (all ips are found in a .ini file) and then those servers know to read the database again.