Mysql Database Administration
Introduction to MYSQL
• Introduction to MYSQL database
• Understand the role of MYSQL in Industry
• Different versions of MYSQL
MYSQL Architecture
• Understanding Relational Database Management systems
• Comparing MYSQL with other relational databases
• What is a module
• Interaction of core modules
Types of Engines In MYSQL
Introduction to storage engine
Types of storage engines:
MYISAM Engine
MERGE Engine
FEDERATED Engine
ISAM Engine
BERKLEYDB Engine
INNODB Engine
And many other types of engines available
Installing MYSQL
Understanding MYSQL open source license
Install MYSQL on Linux Platform
Tar ball installation-linux generic
Different RPMs required to Install MYSQL
Troubleshoot common installation issues
Learn how to use MYSQL command line.
Logs In MYSQL
The Error Log
The General Query Log
The Binary Log
The Slow Query Log
Types of Buffers In MYSQL
Key Buffer
Buffer Cache
Mysql Query Cache
MYSQL Administration
Introduction to mysqld
Using system variables
Connection to mysql database
Creating database in MYSQL
Creation of tables and load data
Different data types available in MYSQL
Security In MYSQL
General guidelines for maintaining security
Password security
Privileges provided by MYSQL
User Administration
Adding user accounts
Specifying connection for users to databases in MYSQL
Setting account resource limits
Assigning account passwords
Backup and Recovery
Physical versus Logical Backups
Online Versus Offline Backups
Local versus Remote Backups
Full versus Incremental Backups
Different backup methods
Using mysqlhotcopy,mysqldump,mysqlimport methods
Myisam table Maintenance
To check Myisam tables for errors
Repair Myisam tables
Locking In MYSQL
MYSQL table locking
MYSQL row locking
Compare table and row locking
Advantages and disadvantages of locking
Replication in Mysql
Master to slave replication
Master to salve to salve replication
Master master replication
Troubleshooting replication
Replication methods
Performance Tuning in Mysql
Discussing the different area of performance problems
Operating system, application, database instance, queries performance
Instance tuning
Using top commands and checking users information