Ignition - MySQLCamp for the Oracle DBA

IGNITION is the preparation necessary for a successful launch of a MySQL ecosystem for an Oracle DBA. This volume covers the preparation needed to be ready for the ongoing production administration of MySQL.

We discuss:

* Translation – Understanding the MySQL terminology
* Installation – Knowing the options for MySQL distributions
* Protection Detail – Security of MySQL information
* The Dashboard – Understanding what to monitor in MySQL
* Mechanics – Understanding more of MySQL Internals including storage engines
* Redundancy – Maintaining multiple copies via MySQL replication
* Checklists – Double checking and cross-referencing your ecosystem

NOTE: This is Volume 1 of a two-part series

Transcript

1. LIFTOFF - 2010.04 MySQL4OracleDBA.com IGNITION Ronald Bradford - Instructor http://ronaldbradford.com Class of 2010.04 MySQLCamp for the Oracle DBA
2. LIFTOFF - 2010.04 MySQL4OracleDBA.com Translation Installation Protection Detail The Dashboard Mechanics Redundancy Checklists OPERATING PLAN
3. LIFTOFF - 2010.04 MySQL4OracleDBA.com TRANSLATION Don’t Assume
4. LIFTOFF - 2010.04 MySQL4OracleDBA.com READ_COMMITTED != READ_COMMITTED TRANSLATION
5. LIFTOFF - 2010.04 MySQL4OracleDBA.com NUMBER != NUMERIC/DECIMAL TRANSLATION
6. LIFTOFF - 2010.04 MySQL4OracleDBA.com START; SQL ... ; COMMIT; != Successful Transaction TRANSLATION
7. LIFTOFF - 2010.04 MySQL4OracleDBA.com TRANSLATION Don’t Assume MySQL is not Oracle What you won’t find What you will find Terminology
8. LIFTOFF - 2010.04 MySQL4OracleDBA.com Operating Systems Products Versions Package Types OS Distributions Release Cycles INSTALLATION
9. LIFTOFF - 2010.04 MySQL4OracleDBA.com Filesystem Locations Multiple Instances Upgrade Procedure Downgrade Procedure INSTALLATION
10. LIFTOFF - 2010.04 MySQL4OracleDBA.com Best Practice INSTALLATION /mysql /etc /data /binlog /log /mysql-version /etc/my.cnf /etc/profile.d/mysql.sh /etc/init.d/mysqld
11. LIFTOFF - 2010.04 MySQL4OracleDBA.com Default Minimal Recommended PROTECTION DETAIL
12. LIFTOFF - 2010.04 MySQL4OracleDBA.com Users Privileges PROTECTION DETAIL
13. LIFTOFF - 2010.04 MySQL4OracleDBA.com SQL_MODE PROTECTION DETAIL
14. LIFTOFF - 2010.04 MySQL4OracleDBA.com Operating System MySQL Logs MySQL Instance INFORMATION_SCHEMA (I_S) THE DASHBOARD
15. LIFTOFF - 2010.04 MySQL4OracleDBA.com Transactions Locking Storage Engines Communication Protocol MECHANICS
16. LIFTOFF - 2010.04 MySQL4OracleDBA.com Replication Asynchronous Master/Slave(s) Hybrid Topologies The Weakest Link REDUNDANCY
17. LIFTOFF - 2010.04 MySQL4OracleDBA.com Installation Security Instance Application CHECKLISTS
18. LIFTOFF - 2010.04 MySQL4OracleDBA.com MySQL Software MySQL Sandbox RTFM Community Interact, Involve, Relate, Contribute Online Resources EXECUTION PLAN
19. LIFTOFF - 2010.04 MySQL4OracleDBA.com GRADUATION L I F TO F F MySQLCamp for the Oracle DBA
20. LIFTOFF - 2010.04 MySQL4OracleDBA.com MySQL4OracleDBA.com RonaldBradford.com