[Sqlrelay-discussion] relaying mysql datas

[Xor <xo...@ps...>]

Hi,

Recently i think sqlrelay is a solution for me, but now i don't know. I 
try to explain what I would like to do. I have written a software on 
win32 platform in c++. It's using mysql database and connecting to it 
with libmysql.dll. The task is connect two local network throught the 
internet using "one" database. (or master / slave database ?) The 
modifications have to come into force immediately on local networks but 
the syncronization between networks can be late.

I have no problem on local network of course. The problem is come 
forward when i would like to connect to the mysql server throught 
internet. When i'm running querys which hit a lot of records it takes a 
long time to get result and while mysql serves this query the local 
clients is waiting too because of select read lock. (nolock is not a 
solution)

I planed to use one database server and sqlrelay, but unfortunately i 
have to realize that sqlrelay is not "transparent" - so i can't connect 
to it like to a mysql server. I can't rewrite the win32 software to use 
sqlrelay c++ api so i can't use it?

Please help if you have any idea / software to handle this situation! 
MySQL master/slave replication maybe a solution but i don't know what's 
happening when i trying to modifiy the slave database? The modification 
not get on the master, am i right?

Thank you in advance!

Best Regards
    Zsolt