One of the secrets to anticipating any possible operational issues or the growth of a transactional system is to have a strong collection of statistical data. There is no doubt about this. The real question is, how can we get useful statistics KPIs for operational platforms?
Once and again, developers ask me the same question: “I want to build the following index, do you think it is right?”
I will assume that the developer analyzed the functional use of the index correctly, so I can explain you how to test the impact of the index in your production environment.
MySQL replication is a feature that allows you to keep multiple copies of a MySQL database by automatically copying them from a master database to a slave database or you have two active databases in continuous replication. This can be useful for many reasons, including facilitating a backup of the data or simply as a means to scale out.
If you are an experienced production database administrator, I am pretty sure that from time to time you have to hear “The problem is the database, it is running slow”.
If you are a junior DBA, trust me when I tell you that you will hear that, more times and more frequently than you would wish to on your daily job.