since I upgrade percona xtrabackup to 2.1.3. My node is crashed …, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… Percona Playback you can measure how a server or database upgrade, change in my.cnf or schema change can affect the… MySQL can also help evaluate new server versions, patches and hardware against existing setups to allow users to make an informed…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… suggest hardware upgrade and when it is not in a simple checklist form. How good is hardware ? Sometimes people use so crappy hardware it… choice than hardware upgrade and it also can be done easily. Is MySQL, Queries, Architecture optimized well enough ? Do not advice hardware upgrade as…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… getting more powerful MySQL Server hardware the cost is going to be increasing dramatically after certain hardware size. For example right now… tuned applications when further tunings are expensive you may well upgrade hardware instead but as you grow further you’ve got to… from economic standpoint until you think about resources and risks – hardware upgrade is straightforward and can be done by operations and data…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… might need to do staged upgrades for your replicated setup or plan some downtime for upgrade. Q: Upgrading to MySQL 5.5 do… Plan changes for the worst during Upgrade? This is one of the big challenges with upgrade which can’t be resolved in…. It also can be used for testing if hardware if there is little extra hardware available. If you’re doing performance testing…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
…-upgrade can help you identify what to expect and test your upgrades better which is one important step when upgrading your servers. pt-upgrade… if you are upgrading your hardware alongside your MySQL version, you should also consider running these tests on similar hardware and OS configuration…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… ? First if you followed MySQL upgrade best practices such as testing your workload with pt-upgrade the chances of this happening are… at the same time, operating system is upgraded or system is moved to “better” hardware. It is best if you can isolate… these – make sure changing only MySQL version on the same hardware with same settings causes regression. You can always improve them…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… MySQL version upgrade involves new Operating System and hardware and any of them could be potential cause of rollback. MySQL Upgrade in my… experience. Also problems you encounter during upgrade are very different depending on the upgrade version – upgrade from MySQL 4.1 to 5.0 had a lot of different issues than upgrade from MySQL…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… week I already had two serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5… not it mentioned in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to… recovery, but at the same time you should not have hardware RAID or have one without battery backed up cache (BBU…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… way. Let’s say you have a server with standard hardware RAID setup running conventional HDDs. RAID setup For the sake… separated from the OS in case you ever want to upgrade the OS, but otherwise keep it simple. My suggestion? Plan… excellent blogs on both the theory of Aligning IO on hardware RAID and some good benchmarks to emphasize the point, go…
