Monitoring MySQL effectively does not have to be difficult. There are many Nagios plugins written for MySQL, but Sheeri Cabral has written a set of scripts that optimizes statistics gathering so that adding additional variable checks does not add a linear amount of database stress. This session will walk you through how to use and…

We depend on MySQL replication to scale out easily. However, MySQL replication does not guarantee data consistency between the master and slave. Luckily there are free third-party tools to check and fix data consistency. This session will explain how to use those tools, and lead folks through the theory and practice of setting up continual…

The vision for Accounts Payable is to be perceived as a business partner that adds value efficiently and cost effectively by providing accurate, timely and actionable financial data that positively impacts the bottom line. Learn how Oracle Enterprise Content Management Partner DTI provides a streamlined approach to automating the paper-intensive AP process by integrating Oracle…

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.

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…

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…

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…

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…

Beginners to MySQL often start monitoring and administering their systems manually but quickly realize the need to automate. When the new MySQL DBA is also new to shell scripting, the task of automating becomes even more daunting. This presentation introduces the Bash shell, shows how it can communicate with MySQL and with the outside world,…