Monday, February 9, 2009

OurDelta MySQL on EC2 - install

Summary:

Arjen would give me an earful if I got this wrong or poorly worded.

"OurDelta produces enhanced builds for MySQL, with OurDelta and third-party patches, for common production platforms" from http://ourdelta.org/about

Over the next series of articles I am going to put the many additions to the MySQL 5.0 baseline through their paces on Amazon EC2.

Using a base CentOS 4.4 I had lying around on Amazon S3 I had Ourdelta installed and secure in no time flat.

This is outline for the installing Ourdelta onto CentOS 4

Install:


yum install yum-plugin-protectbase
rpm --import http://mirror.ourdelta.org/deb/ourdelta.gpg
rpm -Uvh http://mirror.ourdelta.org/yum/CentOS/OurDelta-release-0.0.4-1.noarch.rpm
mkdir downloads
cd downloads/
wget http://mirror.ourdelta.org/yum/CentOS/4/i386/RPMS/MySQL-OurDelta-server-5.0.67.d7-44.el4_7.i386.rpm
wget http://mirror.ourdelta.org/yum/CentOS/4/i386/RPMS/MySQL-OurDelta-shared-5.0.67.d7-44.el4_7.i386.rpm
wget http://mirror.ourdelta.org/yum/CentOS/4/i386/RPMS/MySQL-OurDelta-test-5.0.67.d7-44.el4_7.i386.rpm
wget http://mirror.ourdelta.org/yum/CentOS/4/i386/RPMS/MySQL-OurDelta-client-5.0.67.d7-44.el4_7.i386.rpm
wget http://mirror.ourdelta.org/yum/CentOS/4/i386/RPMS/MySQL-OurDelta-devel-5.0.67.d7-44.el4_7.i386.rpm
yum localinstall MySQL-OurDelta-*
/usr/bin/mysql_secure_installation
ps -ef|grep mysql
mysql -u root -p


Comments:

Thats it. Straightforward install.
I am getting lazy in my old age I used a pipe combo to generate the install commands using this:

history |grep -v history|awk '{ print $2" "$3" "$4 }'

The next article will cover the upgrade of any existing MySQL 5.0 release to OurDelta.
I have saved this Ourdelta MySQL install as an AMI.

If people are interested in making this a public AMI please post a comment.

Have Fun

Paul

4 comments:

arjenAU said...

Why not just do "yum install ..." to fetch and install the packages after installing the repo info. No need to wget and localinstall them?

roobaron said...

I was wondering when someone would point that out.

After I published it I realized that yes, yum install MySQL-OurDelta-server would have installed the server.

I will update the post to add that.

OMax said...

Is post updated?
I would prefer to have AMI with this already installed.

roobaron said...

Sorry been busy and this blog doesn't pay any bills.

Thanks for the feedback.

I will see about the AMI.
The only downside with using a OurDelta MySQL AMI is it sets in stone which version you are using.

More later.