Collaborate is April 22-26
at the Mandalay Bay Convention Center
in Las Vegas. Below is a list of the MySQL sessions. And besure to stop by the Demo area to see some new MySQL goodies!
| Date | Session ID | Session Details |
|---|---|---|
| Mon. Apr. 23 9:45 am – 10:45 am | 560 | DBA 101 Boot Camp: DBA 101 – Tools of Trade Oracle Database Server Database |
| As a beginning DBA you may have some experience with databases such as MS-ACCESS or MySQL. After a weeklong Oracle DBA training course you are now thrust into your new role. In this presentation we will try to present some of the tools that you will need to know / have access to / learn about to do your job that were probably not covered in the class. I’ll try to cover basics for Windows, Linux, and Unix. Example tools: Command line (Shell), Text Editor (VI, Notepad, Text Edit), Networking (ping, netstat, ifconfig, ipconfig), Performance (top, taskmanager, ps, iostat) – Gary Gordhamer, OpEx Leader, Global DBA team GE Health Care | ||
| Mon. Apr. 23 9:45 am – 10:45 am | 826 | Virtualization Boot Camp: Virtualizing Oracle On VMware – Quick Tips |
| A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for Virtualizing Oracle/MySQL databases on VMware. — Dan Winsor, Oracle Database Adminisrator Ntirety | ||
| Mon. Apr. 23 12:15 pm – 12:45 pm | 554 | Set Up MySQL In Five Minutes Flat (2-Part Session) |
| 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 latest one? Is it installed correctly? Installing a properly-working MySQL database is actually pretty easy, and it takes only five minutes. I’ll show you how. — Bob Burgess, Lead, Database Engineering Radian6, a Salesforce.com company | ||
|
Mon. Apr. 23 1:15 pm – 2:15 pm | 578 | Shell Scripting for MySQL Administration |
| 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, and illustrates these concepts with plenty of practical examples. (Many concepts presented here are equally applicable to Oracle.) – Bob Burgess, Lead, Database Engineering Radian6, a Salesforce.com company | ||
|
Mon. Apr. 23 2:30 pm – 3:30 pm | 681 | Portable SQL between Oracle and MySQL |
| 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. – Michael McLaughlin, Dr. BYU – Idaho | ||
|
Mon. Apr. 23 3:45 pm – 4:45 pm | 429 | MySQL High Availability Solutions and case studies |
| An overview of High Availability Solutions with MySQL with case studies of customer deployments in the field – Lee Stigile, Sales Engineering Manager, Americas Oracle | ||
|
Mon. Apr. 23 5:00 pm – 6:00 pm | 493 | Administering MySQL for Oracle DBAs |
| 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 viewed from an Oracle DBA perspective. We will cover mandatory changes to vanilla install, explore and differentiate HA solutions, and look at day to day operation requirements. | ||
|
Tue. Apr. 24 8:00 am – 9:00 am | 281 | Database Development Boot Camp: SQL Tips, Techniques and Traps to Avoid |
| This talk will provide tips for using SQL against an Oracle Database. It will discuss how to exploit a selection of lesser known features and also how to avoid traps and pitfalls. Examples of redundant and undocumented functions, such as OVERLAPS, REVERSE and the range of SYS_OP functions will be covered and some of the more esoteric and weird behavior of SQL will be exposed and evaluated.– Carl Dudley, Professor University of Wolverhampton | ||
Tue. Apr. 24 8:00 am – 9:00 am | 729 | Challenges of Big Databases with MySQL |
| 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 replication), MySQL does better than most of the competion. For others, such as indexing, schema changes, and backup, MySQL has typically been harder to use. Fortunately, the tasks MySQL does well are in its core, whereas the tasks that have historically been more difficult can be solved by storage engine plugins. I’ll talk about how MySQL’s storage engines have recently made dramatic progress in large database managability. | ||
|
Tue. Apr. 24 12:00 pm – 12:30 pm | 389 | MySQL for Oracle DBAs or How to Speak MySQL for Beginners (2-Part Session) |
| 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 DBAs in the world of MySQL.– Dave Stokes, MySQL Community Manager Oracle Keith Larson, MySQl Community Manager Oracle | ||
|
Tue. Apr. 24 12:00 pm – 12:30 pm | 1554 | Set Up MySQL In Five Minutes Flat (2-Part Session) |
| 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 latest one? Is it installed correctly? Installing a properly-working MySQL database is actually pretty easy, and it takes only five minutes. I’ll show you how.– Bob Burgess, Lead, Database Engineering Radian6, a Salesforce.com company | ||
|
Tue. Apr. 24 2:00 pm – 3:00 pm | 694 | Security Boot Camp: Avoiding SQL Injection: Don’t Let a Stranger “Shoot You Up” |
| Many of today’s application interfaces are Web-based and dynamic using the power of relational databases like Oracle and MySQL to provide “live” data on demand. This capability has made modern Web-based applications key to many business processes. But BEWARE; unwitting coding practices may lead to something called “SQL Injection” where someone taking advantage of poorly designed web applications causes SQL to do something other than expected. SQL Injection can be a problem in many different programming environments including Java and .NET. This session will discuss the mechanisms used to perpetrate SQL Injection and how simple it is to effectively defend against it. Topics include some built-in Oracle functionality and programming techniques to make sure your SQL is acting only as you want it to. | ||
|
Tue. Apr. 24 4:30 pm – 5:30 pm | 362 | Security Boot Camp: Security Around MySQL |
| 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 ‘Mission Impossible’ movie (even then you have to protect against Tom Cruise), but connected to a vast array of other computers through a complex network and even eventually the world wide Internet. In this talk we will look at the different ways to compromise MySQL security in typical deployment scenarios through vulnerabilities in the underlying hardware, the operating system, applications, and the network. We will not be focusing just on security from hackers, but from internal sources as well who may be intending to compromise data.– Danil Zburivsky, DBA Team Lead Pythian | ||
|
Tue. Apr. 24 4:30 pm – 5:30 pm | 809 | Demystifying MySQL for Oracle DBAs and Developers |
| eorge 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 with the virtualization of MySQL and moving MySQL databases into the Cloud.– George Trujillo, President VMware Inc | ||
|
Wed. Apr. 25 12:15 pm – 12:45 pm | 1389 | MySQL for Oracle DBAs or How to Speak MySQL for Beginners (2-Part Session) |
| 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 DBAs in the world of MySQL.– Dave Stokes, MySQL Community Manager Oracle Keith Larson, MySQl Community Manager Oracle | ||
|
Wed. Apr. 25 12:15 pm – 12:45 pm | 950 | Making Sense of the SSD Jungle for Relational Databases |
| “Most database performance experts have been waiting for solid-state storage to free them up from constantly tuning their raw devices, SAN storage and various file systems. Now we are at tipping point where so many companies are offering solid-state products in different form factors, interface types of custom intelligence in ASIC or FPGA’s.
This presentation will start with a summary of solid-state storage devices in the market today, how these technologies impact three major databases Oracle MS SQL server and MySQL, and outline key questions to ask when selecting solid-state storage for your database applications. | ||
