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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]