MySQL Sunday tracks at Oracle Open World 2010
By Giuseppe Maxia on Jun 21, 2010
Oracle Open World is the conference of everything related to Oracle. This year edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.
Traditionally, on the Sunday preceding the main event, there is a full day technical event, fueled by the user groups, independently from the company. These Sunday events are wildly popular. they are organized by users for users, and these sessions are usually fully attended.
Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle Open World show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.
The official schedule has all the details of every session (search for "stream/track" = "MySQL Sunday"), but doesn't offer a broad view of the event. For your convenience, here's the unofficial schedule with some useful information.
Secure your seat.
MySQL Sunday is open to all Oracle OpenWorld, JavaOne, and Oracle Develop attendees, including those with the value-priced Discover pass ($50 if you register by July 16). You will be asked if you are attending MySQL Sunday during the conference registration process. Register today.
- When: Sunday, September 19
- Where: Oracle OpenWorld, JavaOne, and Oracle Develop
San Francisco Marriott Marquis
(Alphabetically by title)
MySQL replication plays a critical role in most successful deployments of MySQL. Replication is relatively simple to setup, but takes much more mastery to optimize. Harrison will discuss some of the more advanced replication topologies, as well as practical tips and tricks designed to allow you to take your replication solution to the next level.
Databases always grow. With partitions, MySQL 5.1 becomes an efficient and easy to use data warehouse. This session explains with practical examples how to create and use MySQL partitions and how they will increase your application performance. This presentation also covers the recent additions from MySQL 5.5
How do you know if your MySQL application is having performance issues? More importantly, how do you stop these performance issues before the application is put into production? In this session, learn how to use MySQL Enterprise Monitor to detect and notify you of existing performance robbing issues in production and how to use it in development and QA to prevent the problems from happening in the first place. Plus, you'll learn from Clickability, the leading on-demand Web Content Management solution provider, how the MySQL Enterprise Monitor and MySQL Query Analyzer are utilized to identify performance-tuning opportunities and to eliminate bottlenecks in a fraction of the time.
Why are so many DBAs and developers using MySQL Workbench every day? Just ask Sheeri Cabral - Oracle Ace Director and MySQL guru. See how Sheeri designs, develops and administers MySQL databases at PalominoDB using Workbench.
PalominoDB provides remote services for MySQL and Oracle. Sheeri uses MySQL Workbench to manage distributed, replicated MySQL servers around the globe. Learn to leverage Workbench to connect, tunnel, script, control, configure, maintain, and manage your servers.
Sheeri will share her Workbench snippets and show a few in action. Later you can download these snippets to improve your own productivity.
Also on hand, Mike Frank, PM for Workbench will show how to extend Workbench with plug-ins.
Oracle's InnoDB is the most popular, reliable, and proven transactional storage engine for MySQL. InnoDB provides transactions, row-level locking, multi-version concurrency control for superior performance, and referential integrity and all four ANSI SQL transaction isolation levels to ensure the integrity of your database.
In this session, you will learn InnoDB architecture and some innovative technologies in InnoDB for performance and data protection. You will also hear new performance-enhancing features to improve concurrency and scalability in InnoDB.
This talk will cover high availability techniques, sharding fundamentals, third party technologies and how to decrease the likelihood of system outages.
- Hardware specifications to consider
- Functionally Sharding your data
- Why one would use various topologies such as a relay slave,master-master replication or circular replication for High Availability
- Fail over mechanisms you should consider with replication (i.e. keepalived, heartbeat)
- How to safely and reliably replicate over a WAN for disaster recovery
- Mixing up storage engines (e.g., Leveraging the Blackhole engine)
- Third party options for sharding your data
When you're dealing with Petabytes of data, even MySQL starts to struggle. Hadoop can work alongside your current system, allowing you to perform complex analyses of your entire dataset. And with tools such as Sqoop and Hive, you can do all of that in an SQL-like language without needing to learn the complexities of the underlying MapReduce system.
This talk will demonstrate how you can augment your existing MySQL deployments with Hadoop for batch processing of large amounts of data.
In particular, these topics will be discussed:
- Using Sqoop, an open-source tool for importing data from MySQL to Hadoop
- Using Sqoop to export data from Hadoop back to MySQL
- Using Hive, an SQL-like language, for doing reporting or ETL operations in Hadoop
To scale the business, many companies have large data centers with replicated MySQL servers. Some have hundreds or even thousands of MySQL servers that replicate data. In this talk Lars explains how to use MySQL Replication for scalability and high availability and we especially review the new MySQL 5.5 features that has been implemented to support and simplify maintenance of such installations. Features include replication heartbeating, semi-synchronous replication plugin, fsync tuning, and relay log corruption recovery.
MySQL Cluster has proven itself in mission critical telecoms and web services demanding real-time performance and HA in organizations including ALU, Cisco, Juniper, Telenor, UTStarcom & Zillow.com.
This session will introduce the most recent MySQL Cluster 7.1 release including:
- ndbinfo: presents real-time usage statistics, enabling developers and DBAs to monitor performance and optimize applications.
- The MySQL Cluster Connector for Java: an easy-to-use, high performance native Java interface & OpenJPA plug-in that maps Java classes to tables stored in the MySQL Cluster database.
Finally, Andrew and Mat will present some real-world case studies & explain some of the new capabilities that are currently in development.
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.
When you picture a software startup today you no longer think of people in a garage creating a piece of software to be shipped on disks. It's all about data and global connectivity. Dups will lead you through the technical wonders of deciding to create a virtual economy and stock market and the decision to use MySQL. For Empire Avenue, MySQL is the foundation for a scalable, fast, web architecture which has allowed the company to create and deploy an application in record time with minimal cost. In the world of massive data and the web, you want applications that Scale Fast and Fail Fast. Those that scale and grab our imagination present new business opportunities, technical challenges and new economies. Welcome to the world of a Startup with MySQL.
Learn how to do basic tuning of MySQL using only the tools that come with MySQL. See how to tune for connections, select the best storage engines, and learn how to analyze the key statistics of a MySQL server. This is a technical talk, but no MySQL experience is needed.
In this technical, deep-dive talk, Thomas will explain the performance features added to MySQL Server and the InnoDB 1.1 Plugin. Including details on the scalability gains for multicore systems.
This session will cover how to systematically find each query in a system and how to approve or optimize each query using EXPLAIN. Participants do not need to know how to use EXPLAIN or mk-query-digest to attend this session. This methodology can be used to find queries before they become problems; it can also be used in parts for regular query optimization of known bad queries.
What determines whether a MySQL deployment will succeed? Some deployments are great while others are a constant source of trouble. The secret to success is you, not the MySQL RDBMS. Decisions that you make with respect to the database operations, server platform, schema and workload are critical. Mark will provide examples of decisions, both good and bad, that have a significant impact on the health of a MySQL deployment.
DBAs everywhere are being asked to support MySQL as a less costly alternative in Oracle's portfolio. Rest assured, (almost) everything you know about Oracle can be translated and applied to supporting MySQL with some new vocabulary and some smart starting points.
This talk will touch on 5 things that are helpful to get right from the beginning. Through anecdotes, Sarah will spotlight some common pitfalls, share paths to a fix If you've inherited a running system and offer a vocabulary lesson so those who speak Oracle can start understanding MySQL.
She'll be touching on user management and security, backups and replicas, monitoring, storage engine choices, and probably monitoring again (because it is that important).
(Alphabetically by last name)
Thomas is a performance software engineer at MySQL.
Ronald is a RDBMS industry expert with 2 decades experience using MySQL, Oracle and Ingres.
He presently provides MySQL and Drizzle consulting in the US and Europe for companies requiring assistance in performance analysis & tuning, web scalability, higher availability and for database architecture and design. Ronald has presented at many MySQL events including a number of presentations for Oracle resources. More information is available at MySQL for the Oracle DBA resources.
Ronald is co author of the upcoming Wrox Press book ‘Expert PHP and MySQL’
For more information and blog visit www.ronaldbradford.com and on Twitter Ronald writes at @RonaldBradford and @MySQLExpert
Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; has worked with Oracle, Sybase, DB2, Solaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and wrote the MySQL Administrator’s Bible.
Mark leads the MySQL engineering team at Facebook. The team makes MySQL better for a large and critical deployment. The team writes about their work at http://facebook.com/mysqlatfacebook and publishes patches for MySQL at http://launchpad.net/mysqlatfacebook.
He previously lead the MySQL engineering team at Google. The team published a popular patch for MySQL that included semi-sync replication, user and table monitoring via SHOW TABLE_STATISTICS and USER_STATISTICS, SMP and IO performance patches for InnoDB, global transaction IDs for replication, row-change logging, transactional replication and many bug fixes.
Prior to Google Mark worked at Identity Engines, Oracle and Informix on database internals. Mark holds an M.S. degree in Computer Science from the University of Wisconsin-Madison. He occasionally writes about MySQL at http://mysqlha.blogspot.com.
Harrison is part of the MySQL team at Facebook. Prior to working for Facebook, he was employed at MySQL AB (subsequently acquired by Sun and then Oracle) for 8 years as a senior principal MySQL support engineer, trainer, and consultant. He also is the co-author of a book, MySQL Clustering. Harrison holds a B.S. degree in Computer Science from University at Buffalo. His MySQL writings can also be found at http://harrison-fisk.blogspot.com.
Mike Frank is a Senior Product Manager at Oracle focusing on MySQL - specifically Workbench, security, backup/recovery, platforms, and connectors. Prior to joining MySQL, Mike was Director of Technology at Idera. He was a Product Line Manager at PentaSafe Security Technologies which was acquired by NetIQ. His experience includes development and consulting in the fields of IT security, database design and management, e-business and trading systems.
Jeff Freund is the Founder and CEO of Clickability. With over 14 years of experience in the technology industry, Jeff works to expand Clickability’s leadership position in the Web Content Management category. Jeff is instrumental to Clickability’s rapid growth through the expansion of customer and partner initiatives, product innovation, and driving the market shift from traditional, on-premise technology to on-demand, cloud-based software and infrastructure. As Clickability's technical visionary and founding CTO, Jeff designed and deployed the first and only pure-play SaaS platform for the entire Web Content Management lifecycle. Under Jeff’s leadership, Clickability is responsible for the management and global deployment of over 500 websites worldwide for such companies as NetApp, BMC Software, PR Newswire (United Business Media), NBC, Cantor Fitzgerald, Smithsonian, Philly.com, and Eloqua, among others.
Mat is part of the MySQL Cluster product team, responsible for product strategy and community development. In addition to driving adoption of MySQL Cluster into telecoms, web and enterprise industries, Mat is also involved in gathering user feedback and roadmap planning/ implementation with the engineering groups. Based out of the United Kingdom, Mat became part of MySQL in September 2008. Prior to that, Mat held a series of product management and development positions with Sun Microsystems and other vendors.
Mark Matthews is a member of the MySQL and Java communities since 1996, and joined MySQL as a developer in 2002. He is currently an architect for the MySQL Enterprise Monitor team at Oracle. Prior to joining the Enterprise Monitor Team, he was the original developer of MySQL's JDBC driver and still participates in the JDBC Experts Group. Before joining MySQL, Mark worked as a consultant helping deliver applications for the finance, healthcare, retail and cosmetics industries.
Giuseppe Maxia, a.k.a. “The Data Charmer” is the MySQL community team lead at Oracle.
He’s an active member of the MySQL community and long timer open source enthusiast. During the past 23 years he has worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, SQL, Lua, C, Bash, and good speaker of C++, French, Spanish, Java. Works in cyberspace, with a virtual team.
Philip Antoniades has over 10 years of Web and Database development experience, and has been a MySQL Employee since 2003. He currently heads the MySQL Pre-sales Consulting teams for the Americas and Asia at Oracle. Philip lives in New York City.
Andrew is the MySQL Product Manager responsible for High Availability Solutions - in particular MySQL Cluster and replication. He is based in United Kingdom and has worked for MySQL/Sun/Oracle since February 2009. Before joining MySQL he was responsible for delivering High Availability telecoms applications which is where he became exposed to MySQL Cluster - replacing proprietary and 3rd party databases. His primary roles in MySQL are working with engineers to make sure that MySQL Cluster & replication evolve to meet the needs of their users as well as spreading the word on the what people can get from these technologies. Andrew blogs regularly at www.clusterdb.com.
Sarah’s a founding partner of Blue Gecko. She manages and is a senior administrator in the MySQL/ LAMP practice. Her company does remote administration and management of databases around the world.
She additionally runs the Seattle meetups for LinuxChix, MySQL, and one focused on Opensource and general geeky socializing.
Chris is a certified MySQL professional with over 6 years in the MySQL community. He has designed, implemented and maintained small to large-scale MySQL installations. This includes building architectures from the ground up and improving on those that are currently in place while emphasizing scalability, performance and ease of use. A few of the companies he has contributed to are GoDaddy.com, Facebook.com, VMware, Virident, Plaxo.com and Ning.com.
Sarah works for Cloudera, where she provides training on Hadoop, Hive, HBase and more. Prior to Cloudera, she worked for MySQL, teaching people database administration, high availability and performance tuning.
Calvin Sun is the development manager of the InnoDB group at Oracle. Prior to joining Oracle, he was the development manager of storage engines at MySQL. He has over ten years of database internals experience at Pervasive Software, MySQL and now Oracle. He has an M.S. degree in Computer Science from the University of Science and Technology of China.
Dr. Lars Thalmann is the development manager for MySQL replication and backup. He is responsible for the strategy and development of these features and leads the corresponding engineering teams. Thalmann has worked with MySQL development since 2001, when he was a software developer working on MySQL Cluster. More recently, he has driven the creation and development of the MySQL backup feature, has guided the evolution of MySQL replication since 2004, and has been a key player in the development of MySQL Cluster replication. Thalmann holds a doctorate in Computer Science from Uppsala University, Sweden.
Duleepa "Dups" Wijayawardhana is the CEO of the brand new web-based startup Empire Avenue based out of Edmonton Alberta, Canada. Prior to starting Empire Avenue, Dups worked for MySQL AB (later Sun Microsystems) and BioWare Corp. (later a subsidiary of Electronic Arts). At MySQL/Sun, Dups was the Community Relations Manager for North America as well as being on MySQL's Web Team. Dups has spoken at various events, and multiple universities on the topics of scaling and web site performance and is now reliving the front line fun of creating a social network and a virtual economy using MySQL, Memcached and whole host of new and old technology.