ODTUG is happy to welcome a MySQL track to the 2010 Kaleidoscope Conference. The MySQL database is the world's most popular open source database used by many popular and successful websites. It's fast, reliable, and easy to use. We have dedicated an entire track to this topic and are excited about getting the details and information out to you.
Join us on Monday, June 28 for a lively open discussion with Oracle MySQL ACE Directors. In addition to a specific session on MySQL, other Sundown Sessions will address: Middle Tier and Client-Side Development, Database Development, Hyperion, Essbase and BI, SOA and BPM, and Application Express. Drinks and snacks will be served during the sessions, followed by a reception for conference attendees and ACE Directors. More information about Sundown Sessions....
In this session learn the skills you need for rapidly designing and developing MySQL databases and applications. Philip Antoniades will teach you how you can streamline your work from initial idea, to design and modeling, scripting, data management, and finally, a running application. Learn how to design and deploy data models, forward and reverse engineer, synchronize databases, automatically generate schema scripts, easily create SQL statements, quickly edit data, leverage code snippets, generate reports, modify server settings, generate DML and DDL, and move SQL into application code.
Tags: data modeling, ER design, schema creation, reverse engineering, GUI
While MySQL is a popular and widely used RDBMS, some default features and settings are very foreign in comparison with other commercial RDBMS products. In this discussion, Ronald Bradford will discuss some of the MySQL defaults including a non-transactional state, silent data truncations, date management, and transaction isolation options. These are all critical for data integrity and consistency. He will cover in-depth topics including SQL_MODE that saves the day. He will also cover character sets and collations and the best practices to ensure your UTF8 is stored and retrieved correctly.
Tags: data integrity, transactions, transaction isolation, SQL_MODE, character sets, collations, UTF8
What sets apart the every day web developer from the knowledgeable and highly desired developer that can provide a better return on investment (ROI) for their business or organization?
This session will provide MySQL development tips, tricks and best practices that elevate your knowledge and use of MySQL from the perspective of a MySQL Expert. In this master class we will touch on many aspects that make an impact for a successful application and minimize additional work or re-work from commonly observed poor development practices. From architectural design, coding, development practices, testability, debugging, security, application instrumentation, optimal deployment and monitoring we will touch much of the software development lifecycle.
This class is all about improving your knowledge and maximizing the strengths of the MySQL product for increasing productivity and increasing ROI the MySQL way.
Back to Top
MySQL Variants, Forks, Patches and Storage Engines (90 mins) TBD
There is a lot more to MySQL than the version you generally find with your normal Linux distribution or download from www.mysql.com. As an open source GPL product, the MySQL ecosystem supports many different versions not supplied by the trademark owner. While you may not need to know about these additional features, it is important to understand that alternatives exist and work, for example, in later integrated into the base product such as MySQL 5.4 and 5.5 and the InnoDB plug-in available in MySQL 5.1. There are also many companion technologies that use the MySQL protocol, from dedicated data warehousing solutions to hardware appliances, and depending on your particular data storage needs, may offer compelling benefits.
This session presents several ways to import and export data from and to different file formats with MySQL. The best way to import and export data with MySQL depends on the use case and volume of data. There will be discussion on exporting to a file to use in an import to a different database system (such as Oracle). We will also go through obtaining DML and DDL from the MySQL binary logs (archived redo logs).
Tags: SELECT INTO OUTFILE, LOAD DATA INFILE, mysqldump, mysql, import, export, batch, binary logs
Back to Top Navigating MySQL Stored Procedures & Functions, Views and Triggers Sheeri K Cabral, The Pythian Group
MySQL stored routines do not use a pl/sql equivalent; it uses an extended SQL syntax that includes cursors, loops, and error handling. All of the constructs and options for MySQL's stored procedures, stored functions, views and triggers will be discussed including the differences and limitations with Oracle syntax. Tips and tricks such as "how to enable check constraints using views" will be revealed.
Every major relational database system implements some, but not all of the SQL standard. And every major relational database system extends the SQL standard to add product specific features. This talk goes through the SQL standard deviations and extensions that MySQL's SQL syntax has. There is an 80-page detailed supplement PDF that will be available for those in attendance for ease of reference.
MySQL's replication implementation has pros and cons that should be discussed in detail compared to other products such as Oracle. Different features includes the pull model, and read/write access to slaves, the asynchronous and semi-synchronous options. In this session we will discuss how replication works, what it is appropriate for and what it is not, statement vs. row based, common topologies, problems and limitations to watch out for, tools to ensure consistency and tips and tricks for working with MySQL Replication.
For website applications, database caching has proven to be a great way to reduce the load on the database. The need for having a reliable, easy to use caching solution that runs on commodity hardware is why memcached was developed. Understanding how you can implement caching into your applications to cache data that you don't have to obtain from the database for every page load is the key to faster applications and less taxed database. This session will cover how memcached works, how you can use memcached with your database-driven applications, as well as discussing other key-value stores that are memcapable, the simple, straightforward memcached client protocol.
InnoDB is the most similar storage engine for an Oracle developer. Understanding specifics such as the clustered primary key, secondary indexes sizes, page fill factor options and TEXT/BLOB management are important design needs developers need to know. Being able to monitor and analyze the available instrumentation and learn specifics for example auto-inc or gap locking contention, thread concurrency management options and data/log I/O options are also key in mastering InnoDB diagnostics.
Misbehaving or poorly written SQL is often a common cause of performance issues in MySQL. The first step in resolving issues is capturing the actual SQL queries that are causing problems. This presentation covers the various tools and techniques available to first capture and filter your SQL. With this knowledge, they will then discuss the practical approaches to improving the performance of your SQL starting with understanding the MySQL QEP usage, different indexing strategies, and how internal temporary tables and sorting impacts performance with the goal to better understand the MySQL parser and optimizer.
In this session, Jay Pipes will discuss optimization of MySQL joins. Key points include set-wise problem solving in SQL, working with N:M or “mapping” tables and dealing with AND/OR conditions, understanding Left-join-fu, combating filesorts, handling adjacency lists and nested sets in hierarchical data, and various reporting techniques in calculating running sums, aggregates, and ranking of results.
Tags: INNER JOIN, LEFT JOIN, OUTER JOIN, indexes, using filesort, temporary tables
This presentation discusses what MySQL meta data is available including the 'mysql' meta schema, the INFORMATION_SCHEMA (I_S) tables first introduced in MySQL 5.0 and extended in MySQL 5.1, storage engine specific INFORMATION_SCHEMA tables, as well as techniques for writing your own INFORMATION_SCHEMA plug-ins. MySQL also provides a number of SHOW commands that provide easily formatted presentation of MySQL meta data. Dossy Shiobara will also discuss some of the limitations and performance implications of the INFORMATION_SCHEMA.
Tags: meta data, INFORMATION_SCHEMA, SHOW commands, mysql schema, plugins
We will use the MySQL Enterprise Monitor to analyze aggregate query information, with both the MySQL Proxy and Connectors (Connector/J and Connector/NET). We'll look across the queries generated by an application (or its ORM) to identify slow performers, highlight opportunities for caching and refactoring, raise the visibility of warnings and find queries that could benefit from index additions. We'll track bad queries back to the line of source that executed them, and get alerted about situations which we can then analyze to identify problems.
In this session we will start with a brief history of the storage engine architecture including the advantages and disadvantages of this unique MySQL approach to data storage. We will discuss the primary built-in engines including MyISAM, InnoDB and NDB/Cluster and talk about the specific purposes of other engines including Memory, Archive and why would I ever use the Blackhole engine? There is also a vibrant community of third party engines that use the pluggable storage engine API, and we will discuss what they offer that can provide unique performance improvements and functionality. Also included is information on resources available to write your own storage engine.
With shrinking budgets, many developers are being forced to wear multiple hats. One of these hats is often to become a part time MySQL DBA. These super developers only become a DBA for five minutes at a time when a crisis arises. During this session, Matt Yonkovit will give these five minute DBAs the tools and skills to start helping to efficiently find bottlenecks and resolve them. This intro into MySQL database troubleshooting and optimization will walk through, at a high-level, various tools and tricks of the trade (top, iostat, sar, cacti, explain, maatkit, etc), and give examples on how they can be used when it really hits the fan.
The Sundown Sessions are your opportunity to interact with Oracle's best and brightest technical minds in an informal setting, and are open to all MySQL developers in the Washington, D.C. area. You do not have to be registered for the conference to attend.
Immediately following the Sundown Sessions, participants can continue their discussions and meet other Oracle ACE Directors and ACEs during a short reception. Light refreshments will be served.
About the Oracle ACE Program
The Oracle ACE Program serves to highlight member excellence that exists within the global Oracle community. In this program, members of the Oracle technology and applications communities, who willingly share their technical knowledge and experiences, are recognized and rewarded for their contributions.
We have more than sixty Oracle ACEs and ACE Directors speaking at Kaleidoscope 2010. Look for the (signifies ACE) and (signifies ACE Director) around ODTUG Kaleidoscope. It signifies "ACE-dom" for the designated name.
(signifies ACE) and 
(signifies ACE Director) around ODTUG Kaleidoscope. It signifies "ACE-dom" for the designated name.