We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
MySQL 5 Administration-Part 1 Tutorials
Introduction / What This Course Will Cover
Subtitles of the Movie (MySQL 5 Administration-Part 1 / Introduction / What This Course Will Cover)
Let's have a quick discussion about what we're actually going to cover in this course. The purposes of the MySQL 5 Administration course are these, we want to provide a good foundation for you to understand proper database administrative practices as they relate to MySQL 5. I'm going to be using version 5.5 which is the Generally Available or GA version of MySQL at this point. But there are other versions in the works, there always are and you can always go to the MySQL website, to the developer website, Dev.MySQL.com to learn more about those things that are coming up. We want you to know how to perform basic administrative functions, what are those functions in the first place? What are their purpose? What are we trying to do here with each of these things? And how do we perform them correctly? In Part 1 we're going to cover things like installation, how the internal architecture of MySQL server is set up, how to configure the server after we've installed it and what some of the configuration options are. Security and user accounts, data storage and how to optimize that data storage and basic table maintenance. Okay. That's quite a bit for this first course really since we have to do a lot of background information as well. Part 2 then goes into some more interesting things backup and recovery that's a biggie. Data transfer of the data from one server to another without having to go through a backup and recovery process as such. Data integrity issues, referential integrity issues, how to monitor the server then how to analyze the information you get from monitoring the server and how to use that to determine ways of optimizing how the server is operating. Partitioning of large tables can be a very important part of that so we have a whole chapter on that and we're also going to take an introductory look at replication. We may give a course later on that's a more advanced course on further details of replication as it relates to general availability of the server and so on. But I think you'll find that the replication treatment is going to be fairly thorough for an introductory topic. So what are our objectives then? When you get done with this course you should be able to understand the ins and outs of MySQL server installation. Now yes we covered installation in the Developer course and that's all well and good. But we're really going to get into the nitty gritty details of server installation, all the different options that you have and things like that. So there's a lot more to it here than there was in the Developer course. We're going to spend some time understanding the various subsystems of the MySQL Server and how they interact with one another and some of the system variables then that can be used for tweaking them and allocating more or fewer resources to them. We're going to cover in some detail how to manage user accounts, how to set them up how to grant privileges to people or revoke privileges from people and other kinds of issues involving them. We want you to be able to assess and optimize your data storage at the end of this course. We want you to understand how to have access to and how to interpret much of the administrative metadata that's available to us from various locations. Some things in the MySQL database, some things in the information schema database, some things that we get from Show Commands. There are a number of different ways of accessing this. We want you to become familiar with the Table Maintenance Commands, how they're used and what storage engines they apply to and what storage engines they don't apply to and other kinds of things having to do with table maintenance. So this is things like dealing with fragmentation issues, updating index statistics, that kind of thing. So here are the topics that we're going to cover. We're going to start out with some introductory things including giving you a fairly good idea about how the DBA works in with the rest of the team working on MySQL. We're then going to cover a lot of things about the internals of MySQL, the various subsystems that we have. And the RAM allocation and disk allocations that are used by them. We're going to take a detailed look at how you acquire MySQL for different platforms, how you install it, how you configure it. We're then going to spend some time discussion administrative clients. Now, we're not going to use all of those administrative clients in this course, at least not in the Part 1 version of this course because many of them we won't get to until Part Two. But we want you to at least have an idea of what's available out there for you both Command Line clients and GUI clients. We're then going to spend a fair amount of time on the details of security, specifically with user accounts but we'll also talk about other forms of security as well. We're going to go into more detail, much more detail about the various storage engines that are available and mention a few more that we didn't mention in the previous course the developer course. We are then going to get into details of how data is actually stored, how indexes are actually stored, why we want to have them, how to decide how to set up an index. It's not as simple as saying just index the column, for character strings there's some other things you might want to consider. We want to introduce you to administrative metadata, metadata that we didn't even talk about in the Developer course. And finally we are going to cover some things about table maintenance and go through some exercises where we're going to fragment a table horribly and then bring it back to life it again. Fragment it to the point where it can't be used. So that's a lot to cover. In the next lesson we are now going to talk about what kind of a system you need to be able to install MySQL in the first place.
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
