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…

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.

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…

Many database management tasks become more difficult as you move from hundreds of millions of rows and hundreds of gigabytes to data to billions of rows and terabytes of data. Such tasks include ingesting data quickly while maintaining indexes, changing schemas without downtime, supporting many connections, replication, and backup. For some scaling problems (connections, and…

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…

This is a two-part session that will take place on Monday and Tuesday. You have to set up a MySQL instance for a test or even for production, and you're feverishly looking through the docs, trying to remember exactly what to do. You install the default MySQL version for your distribution, but is it the…

This is a two-part session that will take place on Monday and Tuesday. You have to set up a MySQL instance for a test or even for production, and you're feverishly looking through the docs, trying to remember exactly what to do. You install the default MySQL version for your distribution, but is it the…