Dealing with databases means very often dealing with at least two or more copies of one database. The one in production is good when everything is working smoothly. But such a condition is ephemeral. You need to extend and modify your applications, and your database must evolve, and for this you will need a test database. Or two. As in the case when you need to test or benchmark several scenarios.
You have the choice of using virtual machines, but depending of what you need, this is an expensive and slow solution.
Enter the sandboxing technology. Instead of isolating a database inside a walled operating system, you can fiddle with the database settings to create the illusion of a virtual machine, but with the potential of easy maintenance and minimal commitment of hardware resources.
For MySQL, there is a tool that takes the sandboxing principles to its extreme, and gives you a sandboxed system in seconds. But your systems could be more demanding than this. Using the same principles, this session will explain how to design and build a sandboxed system with several complex database scenarios.
Attendees of this session will walk away with several techniques:
Giuseppe Maxia, a.k.a. “The Data Charmer” works as QA Director at Continuent.
He’s an active member of the MySQL community and long timer open source enthusiast.
During the past decades he has worked in various IT related fields, with focus on databases, object oriented programming, system administration.
Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C++, French, Spanish, Java.
Works in cyberspace, with a virtual team.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts