Personal schedule for Jojo Antonio
Download or
subscribe to Jojo Antonio's
schedule.
Choosing right Hardware components, configuring them properly, and optimizing Linux settings are very important for MySQL and other database server deployments. But they are frequently overlooked. Learning best practices will certainly improve performance and stability. Do you want to learn these best practices? This three-hour tutorial is for you.
Read more.
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory.
Read more.
MySQL Performance Schema is a new performance analyzes tool in MySQL 5.5, learn how to use it for Performance Optimization tasks.
Read more.
Getting sharding right is crucial for achieving high scale with MySQL on commodity hardware like we do at Facebook. We will overview sharding best practices, and show some examples of both successful and unsuccessful methods at sharding MySQL.
Read more.
Production schema changes are painful but unavoidable. This session will tell you how to
minimize (or totally eliminate) downtime during schema changes with master-master setup or by using "shadow" tables.
Session will focus on pros and cons of each approach and describe most common use cases.
Read more.
In this session, I will talk about tough DBA tasks - how to automate failover under non-trivial crash situations (i.e. promoting one of slaves to new master), and about how to eliminate downtime for difficult maintenance tasks (i.e sharding). If you have spent too much time for these tasks, this session will help your DBA life easier.
Read more.
NoSQL
Location: Ballroom E
HBase is an open source column store built on top of Hadoop.
In this 45 minute session you will get a brief introduction into the design of HBase, and the underlying framework along with some usage examples.
Read more.
Are you considering how to use SSD disks with MySQL? Should you even use them? Will they make your database faster? They are still expensive, so how can you get the most out of them? This is the talk for you
Read more.
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
Read more.
Event
Location: Lobby Bar
Join fellow MySQL Conference & Expo participants at this fun and exciting event. Come together, meet each other face to face, and discuss things in real time over a drink at the bar at this year's MySQL CE Meetup.
Read more.
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. MariaDB is now 2 years old, and has made 2 releases in 2010. He’ll also present an overview of the future of this community developed branch of the MySQL database.
Read more.
Elasticity is a key characteristic of public, private and hybrid clouds. Virtual machines can be spun up and spun down at a moment's notice. But how do databases behave in clouds?
Read more.
We will examine the challenges faced by Zynga in running a large scale MySQL plant in EC2. Serving our social games to millions of players around the globe has required significant investment in automation and performance optimization to the thousands of MySQL instances that drive the games. Delivering high performance in the cloud requires a unique approach to support high CPU and I/O demands.
Read more.
Running MySQL at a scale of Facebook leads to many unique problems. We will
discuss some of the performance problems seen in production systems and the tools and
techniques involved in solutions.
Read more.
While MySQL and MongoDB often fight over the same deployment, there are many cases where MySQL and MongoDB should be used in conjunction.
They each excel at different things, so its important to understand when to use one or the other, and how to make them work well together.
Eliot Horowitz is the CTO and Co-Founder of 10gen, the creators of MongoDB
Read more.
This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatkit tools. It includes tools such as an I/O profiler, a bottleneck analysis tool, and tools to quickly summarize a system's configuration and status.
Read more.
Site failures can blow your business out of the water unless you have a disaster recovery site already setup, tested, and ready to go. This talk presents a cookbook approach for setting up and managing MySQL DR. Standard architectures, failover procedures, and failback are covered. Finally, we talk about how to test it all so you know it works.
Read more.
At Twitter, we have gone through many iterations of storage systems as we have coped with tremendous growth. We have been able to solve many general distributed storage problems in a framework named Gizzard. This has allowed us to quickly and safely develop specialized components for the parts of Twitter that can no longer handle the scale at which they are required to operate.
Read more.
Google engineers have built a system that detects MySQL master failure, chooses a new master, promotes it and hooks up slaves with under a minute downtime. This is deployed in an environment where there's zero tolerance for transaction loss of any sort. The original designer and a sysadmin who worked on the deployment will talk about design, implementation and practical lessons learned.
Read more.
This talk shows how to use Percona Server together with XtraBackup to make important operational tasks easy.
Read more.
Sharding is a pain. Anyone who says differently is trying to sell you something. Gwen Shapira will share stories from her 13 years of sharding experience: Learn how you can have less-painful sharded architecture using your favorite relational database.
Read more.
The last few years have brought technological and market shifts that have disrupted open-source databases. These include cloud computing, solid-state storage, non-SQL databases, and MySQL's acquisition. In this keynote presentation, Baron Schwartz will discuss the new reality
that faces open-source database users and developers.
Read more.
The meteoric growth of MySQL through the 1990s and 2000s were marked by some big in the enterprise database market -- a willingness to adopt open source software for critical business applications, and the emergence of a new class of database-backed web applications that needed a simpler, cheaper and more flexible storage model than the established vendors provided.
Read more.
If you missed Ignite MySQLconf on Wednesday evening, come check out the Best of Ignite - several fun, high-energy “speed presentations” given by people like you.
Read more.
InnoDB becomes the default storage engine in MySQL 5.5. At this session, you will learn the current state of InnoDB and the latest enhancements to the InnoDB storage engine in MySQL 5.5; plus how InnoDB works.
Read more.
This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality.
Read more.
MySQL replication has been a critical part of scaling Facebook's storage infrastructure. However, it brings with it the fear of divergent replicas. This session discusses a new tool that detects divergences, identifies inconsistent data, and helps repairs defects.
Read more.
The Facebook database engineering team works with the community and on its own to make MySQL better for data center deployments. This work is visible in the Facebook patch, bugs fixed in official MySQL and features sponsored in other distributions. We will describe work to support a large number of large databases. We focus on backup, replication and quality of service.
Read more.
Learn best practices in Upgrading MySQL from one Major version to another as well as tools helping to implement these best practices
Read more.
Keynote by Jeremy Cole, DBA Team Lead and MySQL Architect, Twitter.
Read more.
Join us in Exhibit Hall A immediately following the general sessions to celebrate four fantastic days of MySQL Conference & Expo. Take the opportunity to network one last time at this closing event, enjoy some ice cream and other tasty refreshments.
Read more.