From: Claudio Nanni Date: March 24 2009 2:59pm Subject: Re: if there're a tool which can replace mysql-proxy? List-Archive: http://lists.mysql.com/mysql/216873 Message-Id: <53bcf3a60903240759l10a78a70t7ee5ec049b334dc5@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd28750e367b60465dea155 --000e0cd28750e367b60465dea155 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Great, thanks guys, I think after subqueries,triggers , stored procs and views is the most awaited thingie now! Cheers Claudio 2009/3/24 Jimmy Guerrero > Forgot to post the URL in the event you are interested: > > http://www.mysql.com/news-and-events/web-seminars/display-306.html > > -- Jimmy > > > Jimmy Guerrero wrote: > >> Hello, >> >> One additional note in regards to learning more about the current state of >> MySQL Proxy and connecting with Proxy developers... >> >> Check out the "Simulating Workload with MySQL Proxy" webinar on April 2, >> with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality >> Assurance Engineer @ Sun who will be talking about Proxy in general, but >> also some advanced topics. >> >> Thanks, >> >> -- Jimmy >> >> Mark Matthews wrote: >> >>> >>> On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: >>> >>> Question: >>>> >>>> >>> Hello Claudio, >>> >>> my company tried the mysql-proxy about one year ago(may be more) but >>>> could >>>> not use it >>>> >>>> for not being multithreaded. They say they spoke to the 'mysql-proxy' >>>> developer. >>>> >>>> Is this still true? Are there any limitation on using mysql proxy on a >>>> high >>>> load production server? >>>> >>> >>> It's still not multi-threaded, but work is progressing in this area, see: >>> >>> https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html >>> >>> There are people using it on high-load production servers, for various >>> flavors of "high load". How much impact *any* proxy will have depends a lot >>> on the type of workload you run through it, and what you do with the data >>> while it's in the proxy itself, since what's going to hurt you >>> performance-wise is directly related to latency, caused by the extra network >>> "hop", and anything else you do that delays the data being forwarded. >>> >>> >>>> Will it be completely(almost) transparent? >>>> >>> >>> Once again, that depends on what you do to the data flowing through it. >>> The only major non-transparent part of the proxy is the permissions system, >>> in that clients connecting through the proxy will always *appear* to be >>> connecting *from* the proxy from mysqld's point of view, since there is no >>> way to "forward" the client address to mysqld itself. >>> >>> For proxy-related questions, you'll probably get more detailed, quicker >>> responses if you join the launchpad project's mailing list at: >>> >>> https://launchpad.net/~mysql-proxy-discuss >>> >>> If you're considering using mysql-proxy, I highly recommend tracking the >>> project via the mailing list and staying in touch with the developers and >>> the community, to both get a better idea if it's going to work for your >>> situation in it's current (and always changing) state, and also to provide >>> input into the direction of the developers. >>> >>> Best regards, >>> >>> -Mark >>> >> >> --000e0cd28750e367b60465dea155--