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

Stop Service

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


Comments:

Post a Comment:
Comments are closed for this entry.
About

Information about Solaris and OpenSolaris on Amazon Web Services (AWS) EC2. Look here for the latest information on the program and any late breaking information on (Open)Solaris on EC2.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today