Nov 18, 2009

Percona MySQL Install on Ubuntu 8.0.4 LTS

I was looking for a install guide / walk through so I could install the Percona Builds of MYSQL on Ubuntu 8.0.4.

In the end I did the following:

Edited sources as per: http://www.percona.com/docs/wiki/release:start

apt-get install build-essential

Then I got the deb packages directly, I wanted to be sure of the version.
wget http://www.percona.com/mysql/5.0.87-b20/deb/5.0.2/x86_64/libmysqlclient15-dev_5.0.87-percona-b20_amd64.deb
wget http://www.percona.com/mysql/5.0.87-b20/deb/5.0.2/x86_64/mysql-client-5.0_5.0.87-percona-b20_amd64.deb
wget http://www.percona.com/mysql/5.0.87-b20/deb/5.0.2/x86_64/mysql-common_5.0.87-percona-b20_all.deb
wget http://www.percona.com/mysql/5.0.87-b20/deb/5.0.2/x86_64/mysql-server-5.0_5.0.87-percona-b20_amd64.deb

dpkg -i mysql-common_5.0.87-percona-b20_all.deb
dpkg -i libmysqlclient15-dev_5.0.87-percona-b20_amd64.deb

This threw a dependency error for me.
apt-get -f install

apt-get install libdbi-perl
apt-get install libdbd-mysql-perl

dpkg -i mysql-client-5.0_5.0.87-percona-b20_amd64.deb
dpkg -i mysql-server-5.0_5.0.87-percona-b20_amd64.deb


mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.0.87-b20 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit
Bye

Nov 7, 2009

Breaking the chain

I've just come across something that has actually made me think, yes I'll give that a go. The concept is "don't break the chain". It's aim is to get you in the habit of doing something constructive for you and your skills each day.

I read about it here: http://bit.ly/djKD

So I'm a software engineer, working with Ruby based frameworks and a climber. What can I do that's positive and not breaking the chain?

Climb and develop code is the obvious answer. But in the real world I'll be able to achieve one of those goals each night at best.

I'm going to begin with some realistic aims, the aim is to improve skills. I've spent the last hour looking at Sinatra and implmenting Susy, SASS and HAML. I'll write it up in my next post and this is the first chain crossed out.