Collaborate is a huge show that is the Independent Oracle User Group’s big yearly show and for 2013 it will be in Denver. There are several MySQL sessions of note and I have noted some below. By the way i will have new MySQL stickers available at the MySQL Demo Pod on the show floor but rules say I can not just leave them around — you will have to ask for them.
- Session #464 – Demystifying MySQL for Oracle DBAs and Developers
Mon. Apr. 8 11:00 am – 12:00 pm
Mile High Ballroom 2C
Abstract: 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 for attendees familiar with Oracle to understand.
George Trujillo, Master Big Data Specialist
- #109 – MySQL User Administration Tricks and Tips
Tuesday, April 9 8:00 am – 9:00 am
Mile High Ballroom 2C
Abstract: MySQL user authentication has greatly changed in the past few years. But does the software you use give users the DROP TABLE privilege by default? Could you use proxies or pre-defined roles? How do you audit users to make sure they have the right privs? What new features such as authentication plug-ins are going to change the DBA’s role? Come to this session to get the answers to these questions and more.
Dave Stokes, MySQL Community Manager
- #683 – Hands on Lab – Fine Tune Your SQL Troubleshooting Skills
Tuesday, April 9
7:00 pm – 9:00 pm
Abstract: Normally when looking at SQL behaving badly, you are at your desk with people breathing down your neck to quickly troubleshoot the performance issue. Did you ever have a dream of getting performance tuning tips when not under pressure? This Late Night OTN Lab will provide the perfect environment for that. It is a hands-on experience that will equip you to stand up under the pressure of the next fire drill, and even better it is a learning experience in a relaxed environment with exactly what every DBA needs, refreshments. This is the opportunity to develop a toolkit of queries and techniques to analyze and resolve the most common SQL performance problems. Come enjoy the challenge, networking, and awesome tuning experience one can only have late night with the IOUG and OTN.
Michelle Malcher, Data Services Team Lead
- #619 – Embracing Database Diversity: the New Oracle/MySQL DBA
Wednesday, April 10
8:15 am – 9:15 am
Mile High Ballroom 4B
Abstract: 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 with a MySQL environment, concentrating on the real focus points, and highlighting the similarities of both RDBMS’.
The power of tools is also of great importance to ensure safe housekeeping and Oracle covers it in both worlds for both solutions, and their mission is quite similar: to make it easier for all.
Typical questions arise:
When is it appropriate to use one or the other.
What assumptions do I have to leave behind?
What assumptions is it safe to bring forward with me?
What is a storage engine and why should I care?
What are the equivalent tools MySQL has for monitoring and backup? What are big differences from Oracle equivalents?
What other tools work with MySQL.
What is Carrier Grade Edition and why do you call it that? When would I use it?
What do I need to know about MySQL security?
The aim is to allow an existing Oracle DBA to get to grips with a MySQL environment, concentrating on the real focus points, and highlighting the similarities of both RDBMS’.
And both worlds provide the necessary tools to avoid a sleepless night.
Provide conceptual knowledge necessary to empower Oracle & MySQL DBAs as confident decision makers.
The power of tools is of great importance to ensure safe housekeeping and Oracle covers it in both worlds, for both solutions, and their mission is quite similar: to make it easier for all.
Lynn Ferrante, Principal Sales Consultant