Thanks for helping us identify and fix bottlenecks in our application. Things are now running smoother than ever.
Planet
Checked your MySQL recovery process recently?
I sound like a broken record with every client when I talk to about the resilience of their production environments. It’s very simple in theory, however in practice many organizations fail.
Ask yourself these checklist questions for your MySQL backup and recovery process?
- Do you have MySQL backups in place?
- Do you backup ALL your MySQL data?
- Do you have consistent MySQL backups?
- Do you have backups that include both static snapshot and point in time transactions?
- Do you review your backup logs EVERY SINGLE day or have tested backup monitoring in place?
- Do you perform a test recovery of your static backup?
- Do you perform a test recovery to point in time?
- Do you time your backup and recovery process and review over time?
- Do you have off-site copies of your backups?
- Do you backup your primary binary logs?
In the past month I’ve discovered clients that have an online only business (i.e. Their MySQL data is their only tangible asset), they perform daily backups but they don’t have binary logging enabled. I’ve also discovered an example of backup logs not being checked, and an underlying mysqldump error was resulting in an incomplete backup, yet the backup script apparently completed successfully.
Disaster is inevitable.
If you don’t score 8 or better in the above checklist in your business, you are at higher risk. If you are a owner/founder/executive this should keep you awake at night if your not sure of your business viability. If your organization needs help, please contact me for assistance.
- Can you recover from a small or large disaster?
- Do you have confidence in your DR plan?
- Do you know how long your DR plan will take.
- What does your online business look like or operate during your DR time?
Percona is hiring a consultant
We’re hiring. We are looking for the following qualifications:
- Expert knowledge of MySQL. Not just “certified” — years of production experience with it. You need to know server internals, for example. You need to be able to do anything from optimizing difficult queries to moving high-volume services between data centers without interruption.
- Expert knowledge of InnoDB. You should understand its inner workings well enough to answer questions about its internals from memory, such as “how does the insert buffer work?” or “how does MVCC work on secondary indexes?” You should also know why it has trouble on some workloads and how to solve that.
- Expert knowledge of Linux systems administration. You need to know how to solve issues with filesystems, hardware, and networking. You need to be able to use tools such as gdb, strace, tcpdump, etc to solve weird problems.
- Expert with Apache, memcached, and other technologies you’d typically find in a LAMP application. You need to be able to administer and troubleshoot a variety of popular open-source server software.
- Proficient with Maatkit and MMM.
- Proven success working in a distributed environment where e-mail, IRC and voice calls are your only interaction with clients, colleagues and managers on a daily basis. You must be a self-starter.
We need all of the above, but if you’re a little weaker in some areas that might be OK. Highly desirable skills include:
- Non-core MySQL technologies: NDB Cluster, third-party storage engines and appliances, etc.
- Technologies such as LVS, Nginx, Sphinx, and load balancers.
- Other operating systems such FreeBSD and OpenSolaris.
- Amazon’s cloud offerings.
- Programming languages and platforms, especially frameworks such as Ruby On Rails and Django.
If you think you’re a good candidate, please fill out the contact form on our website. Thanks!
Entry posted by Baron Schwartz |
No comment
Add to: 
| 
| 
| 
| 
MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS
You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.
(note: give the mirrors some hours to sync up)
Quick overview
See the Release Notes for relevant bugfixes.
Drop-in replacement for stock ...
