Upgrading MySQL Server is a very interesting task as you can approach it … when you upgrade to different major version, especially if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path… 4.1 to 5.1 just because so much more people have followed that road. So how do people approach the upgrade process…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
…MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
… important step when upgrading your servers. pt-upgrade This tool lets you test your SELECT queries against multiple MySQL servers and reports on how each type… privileges. It is also important to note to run pt-upgrade itself on a 3rd server if the servers you are testing against are on…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance …to get new version to pick the old plan no matter how you try and you might be forced to…to Percona Server bug tracking system check whenever the bug is in Percona Server indeed by running the same test on MySQL server…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL…MySQL upgrade usually would have an option to upgrade operating system as well Or is MySQL Upgrade to new version while sticking to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to…to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which can cause surprises. Master and few slaves need to… sure the write traffic replicates properly to the new setup. It was the time to check how read traffic behaves. We stopped both…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… lets leave this aside – this is how Sales and Marketing frequently works – …expected to reach end of life faster, so you will need to upgrade to new MySQL …to use CentOS for servers on production – Fedora Cores keep coming up and become unsupported. Of course in theory I could upgrade servers to…
Page: Presentations
May 3, 2006 By
… to our team. Good reading if you’re planing on upgrading to MySQL 5.0 Download Optimizing MySQL on Source Code Level MySQL…MySQL/Innodb Performance: Server and Schema MySQL Users Conference 2004, Orlando, FL Presentation shows how much you can improve performance by adjusting schema and MySQL Server…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… How good is hardware ? Sometimes people use so crappy hardware it would be much cheaper for them to upgrade… current hardware usage balanced ? Say you have 10 servers one of them is overloaded and 8 …moving from 4 Core systems to 8 Core reduced performance for many MySQL systems even though hardware …
