MySQL continues to be the world’s most popular database management system for the Internet. This session provides a fast-paced introduction to the MySQL architecture, core features, best practices, and core performance areas. A MySQL version of OFA will be shown as a best practice. MySQL features will be taught from a perspective that is easy…

Classic Oracle DBAs are somewhat starved for the "big overview" knowledge that will make them better decision makers and less hesitant to use MySQL. Oracle covers wide ranges of solutions and doubts appear concerning the 2 most popular databases on the market. The aim is to allow an existing Oracle DBA to get to grips…

Classic Oracle DBAs are somewhat starved for the "big overview" knowledge that will make them better decision makers and less hesitant to use MySQL. Oracle covers wide ranges of solutions and doubts appear concerning the 2 most popular databases on the market. The aim is to allow an existing Oracle DBA to get to grips…

Classic Oracle DBAs are somewhat starved for the "big overview" knowledge that will make them better decision makers and less hesitant to use MySQL. Oracle covers wide ranges of solutions and doubts appear concerning the 2 most popular databases on the market. The aim is to allow an existing Oracle DBA to get to grips…

When you ask a MySQL DBA about security, they will usually tell you one or more of these three things: 1) strong MySQL passwords; 2) proper user@host grants and 3) SSL connectivity. However in reality MySQL is not deployed in an isolated secure room with no network access like the CIA computer room in the…

When you ask a MySQL DBA about security, they will usually tell you one or more of these three things: 1) strong MySQL passwords; 2) proper user@host grants and 3) SSL connectivity. However in reality MySQL is not deployed in an isolated secure room with no network access like the CIA computer room in the…

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…

I have worked with hundreds of MySQL customers over the past 4 years and manyof them actually fall into the same bad habits. Whether its over-allocatingmemory 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 ofthese mistakes and tell you…

Many people who are charged with running MySQL are not DBA's, rather they aredevelopers, system administrators, network administrators, etc. Typically thesepeople put on a DBA hat only when there is a problem to solve or to dealdirectly with. I call these people the 5 minute DBA's, dealing with databasesissues for only a very short time…