Posts: 4
Threads: 2
Joined: May 2010
Reputation:
0
Hello everyone i have 2 servers connected on 1 database using mysql @ some servers i found that they can send a message from server 1 to server 2 i wonder how this works i know how to script but can someone give me an idea how can i make it work. Thanks
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation:
0
Quite simple - you need to set a timer which will check if there are any changes in table, and if there were any, grab them.
Posts: 4
Threads: 2
Joined: May 2010
Reputation:
0
i though about this but this dosen`t lag the server? because the timer always checking and reading the database even when updating it
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation:
0
SQL query is the heaviest thing any code does. You can do it in some other way - f.e run some other language (php/python) script on the server machine, and if detects changes in db, then create temporary file which if detected by your script runs real sql query. Or something like that.
Posts: 4
Threads: 2
Joined: May 2010
Reputation:
0
hmmm Thanks for help i`ll try the both and see the result reputation for you
