Tuesday Apr 14, 2009

MySQL AMI Now Available on Amazon EC2 in Europe!

MySQL AMI Now Available on Amazon EC2 in Europe! 

We are very happy to broaden the availability of the latest MySQL AMI on Amazon EC2 in the European Region. This AMI is based on the OpenSolaris 2008.11 base AMI and does not need registration.

Following are the details of this new AMI:

MySQL 32-bit AMI:

ami-e8ffd79c aki-661c3412 / ari-601c3414

Manifest: sun-osol-2008-11-eu/MySQL_2008.11_32_3.0.img.manifest.xml

To run this AMI in Europe, change the following environment variables before launching the AMI:

EC2_URL="https://eu-west-1.ec2.amazonaws.com"
LOCATION="EU"

The other env variables remain the same.

NOTE:  a unique <your-keypair-name> must be generated for each region before launching an AMI.(Use ec2-add-keypair <name> > keypairfile after setting the above env variables).


Monday Mar 16, 2009

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


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