MySQL 5.1 AMI on OpenSolaris 2008.11
|
AMI ID: |
ami-752ccb1c |
|
AMI Menifest: |
sun-osol-2008-11/MySQL_2008.11_32_3.0.img.manifest.xml |
|
License: |
Public |
Description:
This 32bit AMI is based on OpenSolaris 2008.11 AMI. It contains MySQL 5.1 binaries with DTrace probes, 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 /root/ec2sun/README file
You can reset mysql 'root' password by running following command as unix "mysql" user:
# mysqladmin -u root -p password '<MySQL password>'
It is highly recommended to secure your MySQL database by following the guidelines mentioned within MySQL 5.1 database documentation:
http://dev.mysql.com/doc/refman/5.1/en/security-guidelines.html
Administering MySQL
|
Command |
MYSQL |
|
Start Service |
svcadm enable mysql |
|
svcadm disable mysql |
|
|
Restart Service |
svcadm restart mysql |
ZFS + EBS for MYSQL
User can now take advantage of ZFS to manage EBS volumes and can store mysql data on it. It may improve performance for certain workloads and database sizes.
For more information visit
More details including re-bundling instructions can be found in the Getting Started Guide.
For more information on Dtrace and
SysBench, please visit
http://www.sun.com/software/solaris/howtoguides/dtracehowto.jsp
http://sourceforge.net/projects/sysbench
