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