…-query-digest, pt-upgrade, and pt-online-schema-change). Here are some highlights: Official support for MySQL 5.6 and Percona XtraDB Cluster… XtraDB Cluster, and MariaDB Galera Cluster), upgrades are fashionable, so to speak. Problem is: “original” pt-upgrade was too noisy and too complex…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… NDB and 5.5.x clusters with not just simple queries or simple transactions but high concurrency with complex transactions as well — items… far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… a 3 node PXC cluster. Let’s create a table to test on and insert some data: node2 mysql> create table autoinc… mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query… some ideas from simplest to most complex: Only write to a single node in the cluster (at a time)– all the pessimistic…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…are used to compose the complex object which was previously normalized to several tables or perform complex queries finding relationships between objects. …sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by one for query execution, …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… them to scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master… ? From MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy… appliance around the corner which more focuses on CPU bound complex queries and there are more in development. Though I think most…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not… need arises but we still can’t deny – MySQL does not handle complex queries well, being able to use only one CPU effectively on single node and no true federation support. 4. Be Solid MySQL…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. What does this have to do with InnoDB? Data clustering. InnoDB’s primary keys define the physical order rows are… in a complex query with many joins. I have never seen this approach scale well. Use The Best Technologies You Can MySQL is… workloads out-of-the-box than MySQL is, especially for more complex queries. Percona is not tied to MySQL, although we’re most famous…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… not take you that far. MySQL concept of Single Query=Single Thread works well when few … more and more complex algorithms as they mature. Interesting enough so far MySQL does not have …. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster in terms of …
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
…index live as it can now do on Cluster ? Is it expected to rebuild index by sort…you examine your queries manually but if you have automatic tool which catches possibly complex queries it can give…output format is good but with growing MySQL Server complexity it is getting impossible to present all …
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… analysis of the data will be more complex in this form, but that this complexity is an acceptable trade off for historical… query execution, clustered tables and materialized views. These features make working with a star schema much easier than it may be on MySQL, but it is definitely possibly to use MySQL as long as the right tools…
