Some key differences for DBAs between Oracle and MySQL database servers include: Oracle architecture is process based, MySQL architecture is thread based. Different tools used for backup and recovery. Database specific SQL syntax. Database specific SQL functions. Different syntax for stored routines. MySQL has no packages. MySQL routines are not compiled and run in each session thread and not in global memory. MySQL only supports row-level triggers. Different tools used to manage and monitor database servers. Different startup and shutdown processes. Oracle RAC is a shared disk solution while MySQL Cluster is a shared nothing solution. The default configuration for MySQL is very lenient in terms of data integrity. A MySQL DBA must tighten down data integrity for it to work like traditional databases. With Oracle, the CREATE DATABASE command is used to create the physical storage for...
Practical tips for smarter database work