Many people who are charged with running MySQL are not DBA's, rather they are developers, system administrators, network administrators, etc. Typically these people put on a DBA hat only when there is a problem to solve or to deal directly with. I call these people the 5 minute DBA's, dealing with databases issues for only a very short time in any given week. I aim to give these 5minute warriors some very basic tools and skills in order to maximize the time they spend in MySQL.

On the example of this real-life project, we will demonstratehow mature MySQL database software is and what an experiencedOracle DBA can expect in the MySQL land. The project included settingup highly available clustered infrastructure and disaster recoverysite for MySQL. The application was migrated to MySQL from a legacy database platform on OpenVMS.

I have worked with hundreds of MySQL customers over the past 4 years and many of them actually fall into the same bad habits. Whether its over-allocating memory or using GUIDs for primary keys, the results end up being the same...non-optimal database performance. I am going to walk through the most common of these mistakes and tell you why they are bad, and how you can avoid them.

An overview of High Availability Solutions with MySQL with case studies of customer deployments in the field

This is a two-part session that will take place on Tuesday and Wednesday. MySQL is now a proud part of the Oracle Database Family and is used by over 70% of IOUG members. But do you know about 'storage engines' or how MySQL Cluster differs from RAC. This is a session to introduce seasoned Oracle…

Oracle Server, the flagship database, has many features familiar to Oracle DBAs for daily operation of solid production environments. These same DBAs are now expected to manage Oracle's MySQL that is being adopted by many companies. We explore the full life cycle and tools of a robust commercial MySQL environment, from development through production, as…

Presents a comparative view of SQL-dialects available in Oracle and MySQL databases. Examines when to use portable and non-portable SQL statements, and examines the comparative mechanics of managing transactions across the two databases. Compares and contrasts the impacts of web form managed transactions from the perspective of single and multiple table transactions.

George Trujillo continues his popular demystifying series of Demystifying MySQL.     This presentation will use best practices for installing, configuring and tuning a MySQL database server.  This fast paced detailed technical presentation will cover:  MySQL Architecture, Installation, Configuration, Key Features, Security, MySQL Tools, Storage Engines, transactional capabilities and strategic directions.  The presentation will end…