Read the original article at Top MySQL DBA interview questions (Part 2)
Continuing from our Top MySQL DBA interview questions (Part 1) here are five more questions that test a MySQL DBA’s knowledge, with two that will help suss out some personality traits.
- Disk I/O
Disk performance should be an ever present concern to a DBA. So although they don’t need to be a storage specialist, they should have a working knowledge. Ask them about RAID versions, mirroring versus striping, and so forth. Mirroring combines two disks as a unit. Every write is duplicated on both disks. If you lose one disk, you have an immediate copy. Like a tandem truck that has spare tires running …[Read more]