This is a discussion on MySQL Sunday tracks at Oracle Open World 2010 - Solaris Rss ; 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 ...
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.
Golden Gate B
Golden Gate C1
Golden Gate C2
Golden Gate C3
12.30 - 1.00
1.05 - 1.45
Chris Schneider, Ning, MySQL High Availability
Sarah Sproehnle, Cloudera, Leveraging Hadoop to augment MySQL deployments
Calvin Sun, Oracle, InnoDB Enhancements and Roadmap
Lars Thalmann, Oracle, MySQL 5.5 replication enhancements
1.50 - 2.30
Brian Miezejewski, Oracle, MySQL performance tuning best practices
Thomas Anderson, Oracle,Performance and Scalability Enhancements in MySQL 5.5
Ronald Bradford, 42SQL, MySQL Idiosyncrasies That Bite
Sheeri Cabral, Pythian - Mike Frank, Oracle, For best results ? Use daily: MySQL Workbench - Design, Develop, and Admin
2.30 - 2.45
2.45 - 3.25
Sarah Novotny, BlueGecko, You know databases, how hard can MySQL be?
Giuseppe Maxia, Oracle, Boosting MySQL performance with partitioning
Harrison Fisk, Facebook, Advanced MySQL replication techniques
Jeff Freund, Clickability - Mark Matthews, Oracle, Efficient performance analysis and tuning with MySQL Enterprise Monitor
3.30 - 4.10
Mark Callaghan, Facebook, Success with MySQL
Duleepa "Dups" Wijayawardhana,Empire Avenue, Insert MySQL INTO Startup
Sheeri Cabral, Pythian, Proactively optimizating queries with EXPLAIN and mk-query-digest
Andrew Morgan, Oracle - Mat Keep, Oracle, MySQL Cluster: The Leading Open Source, HA Database for Real-Time Services
4.15 - 5.00
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)
Advanced MySQL Replication techniques
MySQL replication plays a critical role in most successful deploymentsof MySQL. Replication is relatively simple to setup, but takes muchmore mastery to optimize. Harrison will discuss some of the more advancedreplication topologies, as well as practical tips and tricks designedto allow you to take your replication solution to the next level.
Boosting MySQL performance with partitioning
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
Efficient performance analysis and tuning with MySQL Enterprise Monitor
Jeff Freund - Mark Matthews
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.
For best results ? Use daily: MySQL Workbench - Design, Develop, and Admin
Sheeri Cabral - Mike Frank
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 Pythian using Workbench.
Pythian provides hundreds of clients remote services for MySQL and Oracle. They frequently use 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.
InnoDB Enhancements and Roadmap
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.
MySQL High Availability
This talk will cover high availability techniques, sharding fundamentals, third party technologies and how to decrease the likelihood of system outages.
Leveraging Hadoop to augment MySQL deployments
- 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 tostruggle. Hadoop can work alongside your current system, allowing youto perform complex analyses of your entire dataset. And with toolssuch as Sqoop and Hive, you can do all of that in an SQL-like languagewithout needing to learn the complexities of the underlying MapReducesystem.
This talk will demonstrate how you can augment your existing MySQLdeployments with Hadoop for batch processing of large amounts of data.
In particular, these topics will be discussed:
MySQL 5.5 replication enhancements
- 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 centerswith replicated MySQL servers. Some have hundreds or eventhousands of MySQL servers that replicate data. In this talk Larsexplains how to use MySQL Replication for scalability and highavailability and we especially review the new MySQL 5.5 featuresthat has been implemented to support and simplify maintenance ofsuch installations. Features include replication heartbeating,semi-synchronous replication plugin, fsync tuning, and relay logcorruption recovery.
MySQL Cluster: The Leading Open Source, HA Database for Real-Time Services
Andrew Morgan - Mat Keep
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:
Finally, Andrew and Mat will present some real-world case studies & explain some of the new capabilities that are currently in development.
- 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.
MySQL Idiosyncrasies That Bite
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.
Insert MySQL INTO Startup
Duleepa "Dups" Wijayawardhana
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.
MySQL performance tuning best practices
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.
Performance and Scalability Enhancements in MySQL 5.5
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.
Proactively optimizating queries with EXPLAIN and mk-query-digest
This session will cover how to systematically find each query in asystem and how to approve or optimize each query using EXPLAIN.Participants do not need to know how to use EXPLAIN or mk-query-digestto attend this session. This methodology can be used to find queriesbefore they become problems; it can also be used in parts for regularquery optimization of known bad queries.
Success with MySQL
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.
You know databases, how hard can MySQL be?
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.
Brian is a manager in MySQL professional services that still finds time to deliver services to MySQL clients. He currently leads the MySQL PS storage engine and migration practices. He has over 25 years of experience in database design, engineering and usage.
His experience includes:
While he claims to be mainly a C++/OO architect and developer he has also found time to build several data warehouses up to 12TB in size, design large scale Java/XML based web systems, and work with many of MySQL?s largest users. He has designed, built, and managed database systems on MySQL, Oracle, MS SQL, Informix, and a few other databases nobody remembers anymore. Brian?s hobby is ping pong and trying to grok why Object Relational Databases were never successful.
- lead architect for the ZFour database system,
- Senior Principal Architect for the American Airlines enterprise data warehouse,
- and Director of database systems for Travelweb.com.
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 andperformance 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
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.
Read More about [MySQL Sunday tracks at Oracle Open World 2010...