Re: [Sqlrelay-discussion] relaying mysql datas

[David M. <dav...@fi...>]

Zsolt,

I'm afraid SQL Relay probably won't help you with this problem.  SQL
Relay does have a mysql-drop-in replacement library that you could use
in place of libmysql.dll that would make it so the program would
transparently use SQL Relay rather than MySQL without having to recode
it, but it doesn't currently work on windows.

It also appears that you're looking for a way to keep the 2 databases
synchronized.  SQL Relay doesn't currently provide a way to do that
either.  You'd have to use MySQL's replication feature.

So, even if you could get your apps to use SQL Relay, I'm not sure that
it would help out too much in this case.

David Muse
dav...@fi...

On Tue, 2006-01-17 at 00:21 +0100, 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
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>