… not new to the toolkit. We developed it some time ago for a client and quietly included it, without knowing how much…-online-schema-change tool and how it enables zero-downtime schema changes on May 2nd. In addition to pt-online-schema-change… talk about using it to verify replication Peter will discuss using it to verify upgrades I’ll show how to use it to forecast scalability and…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… haven’t made it closed-source, what they do appear to have done is shift a lot of bugs into their… and look to the possibility of switching to MariaDB (who keeps the whole process public) instead for the longer run. Upgrading to the latest… why distributions like to pin release versions.) Given MariaDB is MySQL with patches, I’m not sure quite how much that gains…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
…% full, should I be thinking about upgrading memory already?” This is a wrong way to put the question. Unless you have very… all buffer pool busy sooner or later. How to figure out if it is time for upgrade when ? Look at number of misses per second Check number of innodb file reads and writes per second and see how…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
… application to the version you’ve upgraded to. Let’s look at how one Percona Toolkit tool, pt-upgrade can help you identify what to expect and test your upgrades better… when upgrading your servers. pt-upgrade This tool lets you test your SELECT queries against multiple MySQL servers and reports on how each…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
…. When consultant should suggest hardware upgrade and when it is not in a simple checklist form. How good is hardware ? Sometimes people use so crappy hardware it would be much cheaper for them to upgrade before purchasing much of professional services. Though in some cases people like their system to be optimal and so they want to…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to work with group commit… this problem, so lets see who is affected, how to check you’re affected and how to fix it. Who is affected ? The good… these are probably most obvious and easy to use. How to fix the problem ? Assuming getting back to MySQL 4.1 is not the…
Comment: Upgrading MySQL
November 10, 2011 By 23 Comments
How to upgrade mysql from 5.1.47 to 5.1.53 only, not later 5.1.53 or latest version using mysql_upgrade command …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… lot of things like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non… scalability, ability to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades, rewriting queries, or…
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
… much that changes. The biggest thing that changes is just how you pay your bill. Having said that, there’s still… a floating IP address which is used for the application to connect to the current master. With EC2, you can’t do… Dell online store, it costs $2094 to upgrade an R900 from 4G memory to 64G (or $4378 to upgrade to 128G) which justifies that some problems…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… with one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL… trivial. I’d like to share my experience. The article does not cover MMM installation nor how to do this without MMM. It… db2 in our case) have caught-up, we are ready to upgrade the application. The sequence is: $ mmm_control @C1 set_offline…
