MySQL for Oracle DBAs and Developers

Source: www.mysql.com
Topic: Oracle Programming

Short Desciption:
Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page: 4 MySQL for Oracle Dudes Outline  DBA Tips, Tricks, Gotchas & Tools  Key Differences for Developers  Migrating from Oracle to MySQL  ...

 

Content Inside:
MySQL for Oracle DBAs and Developers Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   2 MySQL for Oracle Dudes How can you tell an Oracle DBA has touched your MySQL Installation? Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   3 MySQL for Oracle Dudes MYSQL_HOME=/home/ oracle /products/mysql-version mysqld_safe -user= oracle & Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   4 MySQL for Oracle Dudes Outline  DBA Tips, Tricks, Gotchas & Tools  Key Differences for Developers  Migrating from Oracle to MySQL  Questions & Answers Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   5 MySQL for Oracle Dudes My Background  18 years in Database Technologies (1989)  10 years Oracle Experience (1996)  8 years MySQL Experience (1999)  Active in  MySQL, Java, XP User Groups  Joined MySQL Professional Services (2006) Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   6 MySQL for Oracle Dudes DBA Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   7 MySQL for Oracle Dudes  Terminology  Installation  Directories  Log Files  Processes  Ports & Sockets  MySQL Data Dictionary  Backup  Tools  Inherited LAMP Stack Important DBA Stuff Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   8 MySQL for Oracle Dudes Terminology Database (files) -->Database Server Instance Database Instance (memory) -->Database Server Instance Schema User --> Database User --> User Table Space -->Table Space --> Storage Engine Ronald Bradford, MySQL Inc MySQL Conference & Expo 2007 Page:   9 MySQL for Oracle Dudes MySQL Installation  OS packages place files in many areas and varies - e.g. /usr/lib,  /var/lib, & ...