Re: Questions about mysql-proxy...
On Fri, Apr 6, 2012 at 2:46 PM, shawn green shawn.l.gr...@oracle.com wrote: On 4/5/2012 3:14 PM, Wes Modes wrote: No one here has any experience with it? We use the proxy between master/slaves for the last 3 years. I didn't implement it, but I look after it. I'm just about to switch to 0.8.2, but the only real issues so far has been memory creep/leak. -Kristian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Questions about mysql-proxy...
On 4/5/2012 3:14 PM, Wes Modes wrote: No one here has any experience with it? ... Probably not. If you notice the version number for MySQL Proxy still starts with a 0. which the universally accepted indicator that it is of pre-production quality. Thanks to the corporate changes of the last few years, the sole developer has been too busy doing his primary job to really put any more time into the project and no person or group from the community has stepped forward to help push the project to a final deliverable state. Now, with that in mind, we do use the very same Proxy code as the critical component to the MySQL Enterprise Monitor Agent that is used to collect QUery ANalysis data (QUAN). The difference here is that we wrote the script it executes and stress tested it in our labs to prove to our satisfaction that it will operate exactly as we wanted it to. The 'master/slave write/read splitting' sample code on the Proxy site has NOT been through such rigorous testing. It was provided merely as a sample on which other, more robust, scripts could be constructed and as a demonstration of some of the possible uses of MySQL Proxy. You are more than encouraged to take this as a starting point, adjust it to match your execution environment and coding styles, then test it in your lab environment. Once it passes your internal quality review checks, then you should have the confidence to push it into production. In conclusion, I am not at all surprised that the population of people on this list who has either written code for or used MySQL Proxy in production situations may be very small or none. Regards, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Questions about mysql-proxy...
No one here has any experience with it? W. On 4/4/2012 2:17 PM, Claudio Nanni wrote: Wes, Thanks for these questions about this 'ghost' of the MySQL world, it seems more a legend than a real thing! I am sorry I do not have the answers but I would love to hear some. All I can say is that MySQL Proxy is currently (still) in Alpha http://dev.mysql.com/downloads/mysql-proxy/ https://launchpad.net/mysql-proxy so it is unlikely to be used in production. Such a shame that it was not developed further, this and other features (like online backups) really miss in MySQL, according to me. Cheers Claudio 2012/4/4 Wes Modes wmo...@ucsc.edu mailto:wmo...@ucsc.edu I asked these questions in context of my clustering enquiries, but here it is more specific to mysql-proxy: 1. First, what is the best place to ask specific questions about mysql-proxy? 2. Does the proxy sit on a separate server and route all MySQL requests, or is it installed on each of the MySQL nodes and re-shuffle MySQL requests to the appropriate place? 3. Can multiple proxies be run in concert to provide redundancy and scalability as well as eliminate SPoF and bottlenecks? 4. In 2007 when RW Splitting was new, there were a few problems and limitations. What is the current status of development of this important feature? Thanks! Wes -- Wes Modes Systems Designer, Developer, and Administrator University Library ITS University of California, Santa Cruz -- Claudio -- Wes Modes Systems Designer, Developer, and Administrator University Library ITS University of California, Santa Cruz
Re: Questions about mysql-proxy...
Wes, Thanks for these questions about this 'ghost' of the MySQL world, it seems more a legend than a real thing! I am sorry I do not have the answers but I would love to hear some. All I can say is that MySQL Proxy is currently (still) in Alpha http://dev.mysql.com/downloads/mysql-proxy/ https://launchpad.net/mysql-proxy so it is unlikely to be used in production. Such a shame that it was not developed further, this and other features (like online backups) really miss in MySQL, according to me. Cheers Claudio 2012/4/4 Wes Modes wmo...@ucsc.edu I asked these questions in context of my clustering enquiries, but here it is more specific to mysql-proxy: 1. First, what is the best place to ask specific questions about mysql-proxy? 2. Does the proxy sit on a separate server and route all MySQL requests, or is it installed on each of the MySQL nodes and re-shuffle MySQL requests to the appropriate place? 3. Can multiple proxies be run in concert to provide redundancy and scalability as well as eliminate SPoF and bottlenecks? 4. In 2007 when RW Splitting was new, there were a few problems and limitations. What is the current status of development of this important feature? Thanks! Wes -- Wes Modes Systems Designer, Developer, and Administrator University Library ITS University of California, Santa Cruz -- Claudio