… with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the… you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…. Do push concurrency too high Many developers will test script with multiple level of concurrency and find out doing work from 32…
Post: High Availability Deep Dive tutorial at PLMCE
April 6, 2012 By Leave a Comment
… which you will find useful. As our tutorial is going to be highly interactive, every attendee …walk you through several deployment scenarios for Pacemaker MySQL high availability. We’re coming with pre-installed … be a wonderful move if you could copy your downloads onto a USB thumbdrive and share …
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy…”? 3. Thirdly, thanks for your help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org, and I find…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it… on! How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL is the number of possible HA… MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills and strong Sysadmin skills 7. How deep are your…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over…. Also, you need to consider the environmental factors. If your ISP cannot guarantee you a level of availability of more…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… what is the most popular HA solution for MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL… the availability of the MySQL service. A high availability solution based on MMM requires at the 2 MySQL servers configured in a Master…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
… Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted…, Yves put recently, http://www.mysqlperformanceblog.com/2009/10/16/finding-your-mysql-high-availability-solution-%e2%80%93-the-questions/. I am not… write to, your transaction rollback rate may increase, especially if you working on the same dataset. You can find some results on…
Comment: Finding your MySQL High-Availability solution – The questions
December 19, 2011 By 36 Comments
I cant’ save this url in delicious 
http://www.mysqlperformanceblog.com/2009/10/16/finding-your-mysql-high-availability-solution-%E2%80%93-the-questions/ Looks like and strange character on: —
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…determine normal versus abnormal, the higher quality your results will be. Find and change the following lines: # This… Sometimes it’s glaringly obvious even at a high level, but not always. Most of the … many things that can cause a stall in MySQL, and they usually begin microscopically and get worse…
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… talk MySQL High Availability Sprint: Launch the Pacemaker! will talk about MySQL High Availability using DRBD and Pacemaker (Heartbeat) which have been a high availability… probably the most accomplished and experienced person you can find to talk about High Availability with DRBD, and with his experience both… are not only helpful for your MySQL Server but can be used for other applications such as designing highly available storage systems. Johan…
