Re: [Sqlrelay-discussion] Question about SQLRelay and mysql

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

Hello Ashish,

Sorry to take so long to respond.  Let me know if you're still 
interested in using SQL Relay and I can help you out.

There is no document that directly compares the MySQL proxy to using SQL 
Relay directly.  If you use SQL Relay directly, you will have more 
control over a few things, like how many rows are cached on the client 
side and when the client disconnects from the server.  There are also 
some mysql functions that have not been fully implemented, so if your 
app uses them, then they may or may not work as expected.  I have done a 
lot of work on the proxy lately but the current version is a bit behind.

With regard to the second question, what database are you using on the 
back end?  Is it still MySQL, or another db?  The most common issue 
people have when switching databases is the different bind-variable 
format between them.  Again, I have done some work recently to remedy 
this problem but it's not in the released version.

If you are still looking into SQL Relay, please send me some more 
information and I should be able to help you out.

David Muse
dav...@fi...

On 10/17/2011 02:06 AM, Ashish Mukherjee wrote:
> Hi,
>
> I have been using mysql with perl for my Web applications and recently 
> started exploring SQLRelay for load-balancing and connection pooling. 
> I would like to pose couple of questions related to this -
>
> 1) For the purpose for which I am evaluating SQL Relay 
> (load-balancing, connection pooling, read/write splitting), which is 
> the preferred option - MySQL Proxy or SQLRelay? Is there any 
> documented comparison of these? What are the known 
> advantages/disadvantages of picking one over the other?
>
> 2) I followed the documentation at 
> http://sqlrelay.sourceforge.net/sqlrelay/programming/perldbi.html to 
> use perl DBI with SQLRelay. However, DBD::SQLRelay does not seem to 
> understand what is passed to it and therefore does not work. Is there 
> any documentation of how I can get existing perl DBI code to work 
> unchanged with SQLRelay?
>
> Thanks,
> Ashish
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion