Schedule: Security and Database Administration sessions

Location: Ballroom H Level: Intermediate
Sheeri K. Cabral (Mozilla Foundation), Patrick Galbraith (Hewlett Packard)
Average rating: ***..
(3.29, 7 ratings)
You don't have to read source code -- understanding how MySQL works can be achieved through the system data. Learn a wide range of topics in this 3-hour tutorial, and leave armed with tons of knowledge about how MySQL 5.0, 5.1 and 6.0 work. You will take home a healthy understanding of performance tuning, storage engines, replication and many tips and tricks to help you be a better DBA. Read more.
Location: Ballroom D Level: Intermediate
Giuseppe Maxia (Continuent), Andrey Hristov (SUN Microsystems)
Average rating: ****.
(4.00, 1 rating)
One of MySQL 5.1 main features is the event scheduler, a portable way of executing SQL commands at given times or at scheduled intervals. Using the event scheduler you can organize your work regardless of the operating system you work with. This session presents the basics of the event scheduler, common tasks, tips and tricks. Read more.
Location: Ballroom A Level: Intermediate
Sheeri K. Cabral (Mozilla Foundation), Laine Campbell (Fastly)
Average rating: **...
(2.00, 9 ratings)
Working in an Agile environment poses unique challenges for DBAs used to more traditional environments. This session, co-presented by Laine Campbell of Palomino DB, Inc. and Sheeri K. Cabral of The Pythian Group, will explain how to function more effectively as an Agile DBA, giving you tips and tricks to better survive in an Agile development environment. Read more.
Location: Ballroom D Level: Intermediate
Peter Volk (DDEngine)
Average rating: ****.
(4.00, 3 ratings)
With the increase complexity of software architecture and database design the amount of data stored in databases systems grows rapidly. Additionally, data security and international regulatory laws require that data changes are audited and restorable to any point of time. The revision engine implements automated auditing of data transparently as a storage engine. Read more.
Location: Ballroom C Level: Intermediate
Beat Vontobel (MeteoNews AG)
Average rating: ***..
(3.00, 3 ratings)
Experienced SQL developers know how to solve a class of quite different problems efficiently with the help of an auxiliary sequence table: We'll learn from them with easy to understand hands-on examples -- and meet the SeqEngine, a pluggable storage engine for MySQL 5.1 that helps us to apply the expert's tricks even more efficiently. Read more.
Location: Ballroom B Level: Expert
Chuck Bell (Oracle), Mats Kindahl (Oracle)
Average rating: ***..
(3.33, 3 ratings)
Do you like to tinker? Would you like to see how MySQL? If you’d like to get your hands dirty (or watch others work their developer magic), stop by this session and learn how to take a simple desktop system running MySQL into a fully functional time based backup system that you can connect to any server and get up to the minute recovery capability. Read more.
Location: Ballroom C Level: Intermediate
Phil Hildebrand (thePlatform)
Ever get frustrated because you can't enforce foreign key constraints between partitioned tables? Perhaps you'd like the ability to spread innodb partitions across multiple file systems / directories? During this session, we'll be looking at creative ways to use Triggers to get around a few of those annoying limitations, and what kind of impact they might have on your application in production. Read more.
Location: Ballroom A Level: Novice
Bob Burgess (Radian6 Technologies)
Average rating: ****.
(4.00, 6 ratings)
Beginners to MySQL often start monitoring 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, illustrates how it can communicate with MySQL and with the outside world, and gives practical examples of these scripts. Read more.
Location: Ballroom E Level: Novice
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.75, 4 ratings)
This hands-on session will show you how to change your MySQL server to enable SSL. You will see the steps involved to create an SSL certificate and enable users to connect securely. With SSL you can allow a user to connect unsecurely, connect unsecurely or securely, and you can also require a user to only connect securely. Read more.
Location: Ballroom F Level: Intermediate
Domas Mituzas (Facebook)
Average rating: ****.
(4.33, 3 ratings)
An overview how to make MySQL host system more secure, MySQL itself hardened, access control impossible to penetrate and use all possible security features MySQL provides. Additionally, it will cover some of security design flaws, that can be best resolved by hacking MySQL itself. Read more.
Location: Ballroom B Level: Expert
Peter Zaitsev (Percona LLC)
Average rating: ****.
(4.00, 4 ratings)
Have you ever had Innodb database corrupted or have deleted data accidentally and want it back ? This session will go through various approaches you can use to get most of your data back using MySQL build in features as well as third party open source tool. Read more.
Location: Ballroom B Level: Expert
Domas Mituzas (Facebook)
Average rating: ***..
(3.00, 2 ratings)
DTrace is breakthrough tool for on-demand tracing and analysis of any software. As MySQL internals are open, it is possible to extract incredibly valuable information about database work - without performance overhead or even need to restart a server. This talk covers and merges knowledge and practice from both DTrace and MySQL worlds - and explains why D in DTrace means 'dynamic'. Read more.
Location: Ballroom E Level: Novice
Lenz Grimmer (Sun Microsystems), Colin Charles (Percona)
Average rating: ****.
(4.00, 4 ratings)
There should be nothing more important to a database administrator than backups, restoration and disaster recovery planning. Unfortunately it is an often neglected area of database administration. This session will cover the importance of these vital areas and practical information about the ways to perform backups and recovery with currently available technology. Read more.
Location: Ballroom G Level: Intermediate
Lee Stigile (Oracle), John Duncan (Oracle Corp.)
MySQL security best practices often assume restricted access to the physical server and restrictive file system privileges. However, OEM's and ISV's who bundle and distribute their application with MySQL have no control over where the application is installed. This session will provide silent installation instructions, common deployment strategies and recommendations for securing your data. Read more.
Location: Ballroom F Level: Intermediate
Chuck Bell (Oracle), Lars Thalmann (Oracle), Mats Kindahl (Oracle)
Average rating: ****.
(4.00, 3 ratings)
Do you use replication? Would you like to improve your data protection and recovery capabilities? If you do, chances are you would also like to improve your ability to recover from failures faster. In this session, we will show you how you can use backup to enhance your replication capabilities. Read more.
Location: Ballroom A Level: Intermediate
Frank Mashraqi (Opportunities)
Average rating: **...
(2.50, 2 ratings)
memcached usage is growing like wild fire and most major Web 2.0 websites depend heavily on it. In this session, we will explore several advanced memcached and MySQL use cases. Come see how some of the top destinations online are using memcached to scale their applications, offload load from databases and decrease their application response time. Read more.
Location: Ballroom F Level: Intermediate
Baron Schwartz (VividCortex)
Average rating: ****.
(4.80, 5 ratings)
Maatkit is a set of tools that helps MySQL users and administrators fill otherwise unmet needs. The toolkit is absolutely packed with functionality. This session will teach you how to get your daily work done faster, safer and smarter. Read more.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.