I found Dennis the Menace, he now has a job as system administrator for a hosting company. Scenario: client has a problem with a server becoming unavailable (cause unknown) and has it restarted. MySQL had some page corruption in the InnoDB tablespace. The hosting provider, being really helpful, goes in as root and first deletes [...]
Filed under: Good practice / Bad practice by arjen on Monday, October 31, 2011 | Social tagging: destruction > helpful > hosting > InnoDB > logfile > mysql > recovery > sysadmin > tablespace
21 Comments »
Of course it’s not quite that simple. I’ve just decomissioned an old Red Hat 7.1 box (hosted dedicated server) that had been in service since 2002, so about 7 years. Specs? Celeron 1.3GHz, 512M, 60GB HD. Not too bad in the RAM and disk realm. It did a good job but goodness am I glad [...]
Filed under: Uncategorized by arjen on Thursday, July 30, 2009 | Social tagging: cloud > hosting > mysql > VM > xen
No Comments »
EC2 is nifty, but it doesn’t appear suitable for all needs, and that’s what this post is about. For instance, a machine can just “disappear”. You can set things up to automatically start a new instance to replace it, but if you just committed a transaction it’s likely to be lost: MySQL replication is asynchronous, [...]
Filed under: Uncategorized by arjen on Friday, June 19, 2009 | Social tagging: Amazon > cloud > EBS > EC2 > GoGrid > hosting > Linode > Mosso > mysql > RightScale > S3
6 Comments »