MySQL Sandbox: Easily Using Multiple Database Servers in Isolation

Giuseppe Maxia (Continuent)

Administrators, developers, QA, and support engineers need to install and test several versions of MySQL database server. Performing this task safely, without affecting existing instances on the same host, is not easy. Using MySQL Sandbox, users can:

  • Install a new server in less than 10 seconds, just by pointing to a binary tarball.
  • Install a system of master + slaves in replication in less than 15 seconds.
  • Install 10 independent servers in 1 minute with just one command.
  • Optionally, install the above items with complex options, using one command, without need of editing configuration files.

This presentation explains how to install a server or a replication system with MySQL Sandbox, covering the basics and some advanced options.

It will also show the ease of use through the auto-generated scripts.

Some real world examples follow.

Photo of Giuseppe Maxia

Giuseppe Maxia

Continuent

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.

Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.