MySQL Sessions at Collaborate


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.

Gurinder Brar
STEC

About these ads

Leave a comment

Filed under Collaborate, MySQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s