OCP – MySQL 5.6 DBA

  1. Objectives
    1. exam at August
    2. wordpress application
    3. comparison with Oracle 11g, 12c, noSQL, MSSQL 2008,
  2. TOC
    1. Introduction to MySQL Database
    2. Concepts of MySQL Database
    3. MySQL Server Configuration Option
    4. Login Access to MySQL Server
    5. Granting Privileges on MySQL Server
    6. MySQL Metadata
    7. Log and Status Files
    8. MySQL Enterprise Audit Log
    9. Backup and Recovery
    10. High Availability: Replication
  3. Contents
    1. Introduction to MySQL Database
      1. MySQL editions: community / standard / enterprise (exam);
      2. two-tier processing model: a SQL/optimizer tier and a storage engine tier;
      3. MySQL Enterprise Edition provides the MySQL Thread Pool – sustain performance and scalability – by reduce overhead in managing client connections and statement execution;
      4. ACID: Atomicity, Consistency, Isolation and Durability;
        1. Atomicity requires each transaction be all / nothing;
        2. Durability the result of a transaction remains after it has been committed, even with power loss or system crashes;
    2. Concepts of MySQL Database
    3. MySQL Server Configuration Option
    4. Login Access to MySQL Server
    5. Granting Privileges on MySQL Server
    6. MySQL Metadata
    7. Log and Status Files
    8. MySQL Enterprise Audit Log
    9. Backup and Recovery
    10. High Availability: Replication
  4. References
Advertisements
OCP – MySQL 5.6 DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s