Hi Tank, You are right about its support for php, infact it comes in built in with new php4 version. … apply it fully on our application. For you i guess mysql proxy would be a suitable option, spoken to a solution architect… centre and she says most of our clients are using mysql proxy….. Are you aware of any hardware based load balancer, do…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “… spoon feeding. You can place squid in front, use apache proxy module or even use lighttpd with FastCGI all can fix… it. Persistent connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could…
Comment: Slow Query Log analyzes tools
July 26, 2007 By 83 Comments
… mySQL server? This would make it much easier to use: 1. No need to compile the mySQL server. 2. Logging (use of mySQL Proxy) can be switched on and off by redirecting the port with iptables: http://forge.mysql.com/snippets/view.php?id=82 The mySQL Proxy…
Comment: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
….1 to 6.0, using MySQL Proxy with an appropriate script. http://forge.mysql.com/snippets/view.php?id=81 To reroute the traffic without need of disconnecting the clients, you can use a IPTABLES command http://forge.mysql.com/snippets/view.php?id=82 Cheers Giuseppe
Comment: Shard-Query adds parallelism to queries
February 24, 2011 By 16 Comments
Hi Matt, I’m working on a MySQL proxy interface to shard-query. Once this is completed, then you … be able to point Mondrian at it like any other MySQL data source. Combine scale-out with Shard-Query with aggregate…/ directory. You would need to create a class (like include/mysql.php) which implements the interface and provides functions for the necessary…
Comment: MySQL Sizing questions
February 9, 2012 By 4 Comments
… HA proxy. PHP installed. Apache Server. 2 Database server with the same configuration, but active-pasive controlled by load balancing using HT proxy. MySQL…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication… course one can just enter commands from cli, execute some php/python/ruby script or anything else. Most importantly – this must… must change application to use different IP for MySQL or ensure some load balancer/proxy does this, set read-only manually on…
Comment: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… application chance of going from MySQL to something else is probably less than rewriting them from PHP to something else 
4) It… if someone would implement connection pooling daemon implemented as a proxy for MySQL protocol supporting persistent connections would automatically allow to take…
