Hello. Start solving the locking issues with reading this part of the manual: http://dev.mysql.com/doc/refman/5.0/en/locking-issues.html
Xor wrote: > 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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
