Hello there, it’s me again, with another blog about a DBA situation that a typical Linux Administrator may find themselves in.
In this blog, i’m going to review a recent MySQL upgrade I have done on one of the systems I am involved in administering. This is a real world example of an upgrade project, and hopefully when we’re done, there may even be an overall performance boost.
There are several reasons to perform upgrades (of any kind), for
me an important one is to keep current for security and bug
fixes, but general performance improvements and new features are
always welcome as well.
This system is running Bacula, an open source enterprise backup system. In this particular case Bacula is configured to store data in a MySQL database. The data stored include status reports, backup content lists, lists of all the files on all the systems, schedules and other related information. While everything has been …