In my last job I wrote several automated backup systems for MySQL servers, and they continue to run as part of a SaaS hosting service. Holy cow, I'm an expert! Thanks for reminding me! ;)
Of course, one never feels like an expert, because part of being an expert is that one knows the names of some real experts, who are better than you. In this case, some real experts in MySQL backup work at Percona. Hire them. Alternatively, buy the O'Reilly book High Performance MySQL, which is partly the work of Percona's founders and has chapters about backups.
(If you are the foremost expert in a field, of course, you probably don't feel like an expert either, because you're at the frontier, where everything is confused and all the other experts are most lost than you. I don't understand this field! The references are irrelevant and confused and make no sense! I don't know how to make progress and I can't find anyone else who does! I must be really stupid!)
Of course, one never feels like an expert, because part of being an expert is that one knows the names of some real experts, who are better than you. In this case, some real experts in MySQL backup work at Percona. Hire them. Alternatively, buy the O'Reilly book High Performance MySQL, which is partly the work of Percona's founders and has chapters about backups.
(If you are the foremost expert in a field, of course, you probably don't feel like an expert either, because you're at the frontier, where everything is confused and all the other experts are most lost than you. I don't understand this field! The references are irrelevant and confused and make no sense! I don't know how to make progress and I can't find anyone else who does! I must be really stupid!)