Slide 1

Slide 1 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com IGNITION Ronald Bradford - Instructor http://ronaldbradford.com Class of 2010.04 MySQLCamp for the Oracle DBA

Slide 2

Slide 2 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Translation Installation Protection Detail The Dashboard Mechanics Redundancy Checklists OPERATING PLAN

Slide 3

Slide 3 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com TRANSLATION Don’t Assume

Slide 4

Slide 4 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com READ_COMMITTED != READ_COMMITTED TRANSLATION

Slide 5

Slide 5 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com NUMBER != NUMERIC/DECIMAL TRANSLATION

Slide 6

Slide 6 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com START; SQL ... ; COMMIT; != Successful Transaction TRANSLATION

Slide 7

Slide 7 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com TRANSLATION Don’t Assume MySQL is not Oracle What you won’t find What you will find Terminology

Slide 8

Slide 8 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Operating Systems Products Versions Package Types OS Distributions Release Cycles INSTALLATION

Slide 9

Slide 9 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Filesystem Locations Multiple Instances Upgrade Procedure Downgrade Procedure INSTALLATION

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Default Minimal Recommended PROTECTION DETAIL

Slide 12

Slide 12 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Users Privileges PROTECTION DETAIL

Slide 13

Slide 13 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com SQL_MODE PROTECTION DETAIL

Slide 14

Slide 14 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Operating System MySQL Logs MySQL Instance INFORMATION_SCHEMA (I_S) THE DASHBOARD

Slide 15

Slide 15 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Transactions Locking Storage Engines Communication Protocol MECHANICS

Slide 16

Slide 16 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Replication Asynchronous Master/Slave(s) Hybrid Topologies The Weakest Link REDUNDANCY

Slide 17

Slide 17 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com Installation Security Instance Application CHECKLISTS

Slide 18

Slide 18 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com MySQL Software MySQL Sandbox RTFM Community Interact, Involve, Relate, Contribute Online Resources EXECUTION PLAN

Slide 19

Slide 19 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com GRADUATION L I F TO F F MySQLCamp for the Oracle DBA

Slide 20

Slide 20 text

LIFTOFF - 2010.04 MySQL4OracleDBA.com MySQL4OracleDBA.com RonaldBradford.com