MySQL 5 Administration-Part 1 Tutorials
The Job of the DBA / The Company DBA Team
Subtitles of the Movie (MySQL 5 Administration-Part 1 / The Job of the DBA / The Company DBA Team)
So let's talk a little bit about the organization of our database administrator team at whatever company we're working. It's very important that we have one of these. As we pointed out in the last lesson the job of a database administrator is just too much for any one person to do. And you can't possibly be awake all the time and yet your database system is going to have to be awake all the time. So what do we do about that? Well the first thing is we need to make sure that we've got a few other people on staff to whom we can delegate some of these responsibilities. Now, we may be the lead database administrator, we may be in charge of the department or we may be one of the people that's working our way up and so on and doing only certain kinds of things. But the team is really, really important and it's very important that we begin to develop specialists among all those people in the staff. So this could be maybe one person who's the ultimate backup and recovery person, the go to person for that who understands all the nitty gritty details about exactly how that should go. They're involved in helping to establish policies and, and follow through on those policies and train other people about all of this. So you want to have little onsite seminars every once in a while where people who are specialist in one area can help educate the other people. We might have someone else who is a monitoring specialist, who understands what all of these variables are that we're looking at and the implications of combinations of those things. Things that indicate that maybe there are improvements that could be made and then how we can make those improvements and we'll talk about that later in the course. We also might have a person who is a security specialist. They're in charge of user accounts and privileges and how security is going to be managed. And that's a very important person as well. They can help establish the security policies, the procedures for setting up new user accounts. The policies for who gets to have what privileges and so on. We might also want to develop specialists for individual storage engines even if we're using a number of different storage engines. Because that interfaces with backup and recovery that interfaces with certain kinds of tuning. So all of those specialties are really, really important. But even though we have specialists, we want to make sure that everyone is cross trained on every system that we've got. We want to build redundancy not just into our storage system and our server system but we want to build redundancy into the staff itself so that we can replace parts if you will. So if somebody has an accident, if somebody gets stuck out of town for too long or if somebody just has to take vacation every once in a while or get sick, then we have someone else who can cover for them, at least in the short term. Very important to be able to do those things and we need them to be able to cover for us as well. Everybody needs downtime, do not take this job home it's just too much. So make sure that you're covered for all those times when you aren't going to be there. And finally set up a rotating on call schedule for more senior members of your staff. Again so that you are not always the one that everybody calls up as soon as some little thing goes wrong at three o'clock in the morning. That's not going to help your life at all. And you deserve a life so try to set these things up in advance and get people trained well and you'll have a really well organized team, a really well organized company and that's really important. Okay. But the database administrative staff is not the only staff that we need to deal with. So in the next lesson we're going to talk about the greater MySQL Eco System within your company and how we can approach that.
Tutorial Information
| Course: | MySQL 5 Administration-Part 1 |
| Author: | David Swain |
| SKU: | 34307 |
| ISBN: | 978-1-61866-086-2 |
| Release Date: | 2012-12-31 |
| Duration: | 16 hrs / 171 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
