…to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades…procedures, which are more difficult to analyze because you have to pull out the statements and analyze them individually. The goal is always to…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
From my experience upgrading MySQL can be trivial to rather a pain. Here I’m talking about major version changes such as 5.0 to 5.1. This also… run mysql_check followed by mysql_upgrade. That works pretty well as long as you don’t have stored procedures or triggers which the 5.1 upgrade…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
…upgrade procedures – dump your data and reload. Little tip to mention – upgrading to the new major version make sure you upgrade to latest current version at first. Ie upgrade to recent MySQL 5.0 before upgrading to MySQL 5.1…
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
…to do it: WARNING! Resuming replication gracefully only works if you run RDS with MySQL version 5.1.62 or 5.5…from its default “{TrueIfReplica}” to “0“. When we’re done with pt-upgrade checks, I will just run the following to resume replication: replica> CALL mysql…
Comment: MySQL - to use or not to use
May 29, 2007 By 10 Comments
…MySQL 5.0 seem to be unnoticed by the public and I’ve not yet seen widespread use. I think many projects need compatibility to MySQL…procedures for most applications – but if you need them, they are there. I recently started to upgrade my old 4.1 servers to 5.0…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql-bin.000022 | mysql mysql> select count(*) from salaries where emp_no = 10001; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql…to execute a long running ALTER or server upgrade, this method can be good quick rollback procedure…
Comment: Watch out for Marketing benchmarks
August 24, 2006 By 7 Comments
…MySQL 4 -> 5 upgrade there are variants. 1) If you application was not well optimized for MySQL 4 it may work much faster on MySQL 5…to memory size – in this case saving 10-20% space is very important. 3) The way to benefit from MySQL 5.0 is to… faster with 5.0… but if you use Stored procedures. …
