OpenSolaris Based MySQL AMI
By Prateek Parekh on Aug 29, 2008
Following the launch of the Ruby on Rails 2 AMI, we are pleased to announce the launch of our "MySQL 5 with Dtrace probes" AMI.
This 32-bit AMI is based on the OpenSolaris 2008.05 AMI with updated software revisions to build 91. It contains MySQL 5.1.25 binaries, and SysBench. SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load. There are also sample Dtrace scripts which utilize the probes in MySQL to collect information about SQL calls. Users should check /export/home/mysql README files for directions.The MySQL and SysBench binaries are located in the /usr/local/mysql and /sysbench directories. An existing user 'mysql' is authorized to start the MySQL server and run tests.
Note: default mysql root user password can be obtained from /export/home/mysql README
The OpenSolaris distribution is based on the OpenSolaris project, and features functionality such as ZFS, DTrace, and a new packaging system, the Image Packaging System(IPS). IPS is a network based package management system that allows for users to install applications from online repositories using the "pkg" command. Developers can install additional software on this AMI from the repository using the pkg command. The root file system is ZFS in this AMI.
Also, just like in the RoR AMI, the "pkg image-update" command updates the kernel and ramdisk which is not allowed in EC2. Therefore, in order to prevent your instances from becoming non-compatible with the Amazon EC2 environment, we have disabled this command. More details including re-bundling instructions can be found in the Getting Started Guide.
More details can be found at:
For more information on Dtrace and
SysBench, please visit