…your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including…Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search indexing or help …
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… end up in Galera Cluster Best Practices, though I’ve heard that talk from Seppo (Codership) before. MySQL Query Anti-Patterns that… sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job… kind of architecture. Case Study: Designing a synchronous multi-master cluster for elastic scale-out and scale-in in the cloud…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… it to technologies in MySQL space. First I think MongoDB is best compared no to MySQL Server but MySQL Cluster, especially in newer versions… MySQL Cluster without replication, MongoDB is practically the same. Second – if we look at Replication Sets we find them very similar to MySQL Cluster… fails driver fails over to different master. Things are again tuned to deal with Asynchronous Replication. Consistency is maintained but at…
Post: My talks on PL MySQL Conference (+free book inside)
February 14, 2012 By Leave a Comment
…: Percona XtraDB Cluster: New HA solution. There I will cover XtraDB Cluster features and usage scenarios. MySQL and SSD: usage and tuning. This talk… to MySQL, XtraBackup, XtraDB Cluster, etc. More interesting, by the time of conference we will have published our new book: High Performance MySQL…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… in the conference Anders and David barely mentioned it. Performance Tuning Presentations – I’ve visited two of these, one by Anders… Marketing side perhaps the speaker kept quoting benefits of MySQL Enterprise from MySQL Marketing Materials . There is not much of technical insight… of MySQL Cluster – for example quite possible their solution could help a lot to shorten latency dealing with MemCache servers etc. MySQL High…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… around 100ms. All environments used Percona Server or Percona XtraDB Cluster server 5.5.24. Innodb durability was disabled for all…). XtraDB Cluster 1-colo 3 nodes in one datacenter. Writes were only done on a single node. The cluster contained the tuning: wsrep… availability and disaster recovery than semi-synchronous replication in stock MySQL.
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… Optimizer – such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB… it is not tuned to exploit full performance potential of any given storage engine. Synchronization The top level on MySQL side, such… transactions which require a lot of complications and performance overhead. MySQL has to do several fsync() calls per transaction commit to…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…, maybe a bit longer. This is common in MySQL servers I work with when they’re running …of the typical response time (which will usually be clustered tightly, given that this is an exponential distribution). … we get some “static”, sort of like de-tuning the radio just a little bit (if you …
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… cache and the interface between it and MySQL. It’s now possible to completely disable it… that. Here’s my favorite query cache tuning guide. The second important change is really minor…miss your opportunity to learn subjects from NDB Cluster to InnoDB Architecture and Performance Optimization. These …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… PBXT (1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled… previous question). Two things contributed to this decision: Supporting clustered indexes would have made the implementation of PBXT more complicated… decrease clustering of data will become less and less important. What is the page size in PBXT, and can it be tuned…
