… threading and internal queues) that accepted connections from the app (php, java, python, etc) and then passed the traffic over to… far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this… service that can be used to host rapidly scalable NDB clusters (commence with inserting a shameless plug that users can then…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… going down. Then we did some R&D on Percona MYSQL server and found that Percona need some configuration setting regarding… again performance degradation started and now it is slow again. MySQL load is not going very high. We have also noticed….15 (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not… not think MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication – the…
Page: Consulting for MySQL
July 31, 2006 By
…your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting …performance issues lie outside of MySQL. We’re ready to work with you on PHP code optimization, Server Side caching…
Post: A closer look at Percona XtraDB Cluster for MySQL
December 4, 2012 By Leave a Comment
The Web And PHP Magazine just published an article describing Percona XtraDB Cluster written by Liz van Dijk and Kenny Gryp. It…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… Percona XtraDB Cluster nodes in parallel with MySQL asynchronous calls [/caption] This post is followup to Peter’s recent post, “Investigating MySQL Replication… that using PHP with MySQLnd drivers we can execute 5 MySQL asynchronous queries in parallel against 5 different nodes of Percona XtraDB Cluster.
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… feature complexity. MySQL 5.2 will give you many storage engines to play with (many with transactions an some with clustering) with…. Someone could be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how… area MySQL Cluster, which was always best isolated of MySQL source leads the pack – there are bunch of interfaces to talk to MySQL cluster as PHP…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still… any other issues we should look for? A: Percona XtraDB Cluster is a synchronous replication technology, therefore the slaves should never… traditional MySQL asynchronous replication. edit: PXC is really a bit like semi-synchronous replication, in that changes are queued on all cluster…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… cluster of 1 to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php… 1 (assuming a 20 node cluster): cd shard-query ./start_workers 80 I normally start (2 * TOTAL_CLUSTER_CORES) workers. That is…-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…traditional database background. Things are different with MySQL. There are many successful applications, using tens… much online. You also get good data clustering so table becomes hot very quickly due…however start to crawl. So developing you PHP applications use test database with reasonable amount…
