How to install MariaDB on CentOS 5.5

First thing I want to try on CentOS 5.5 is mariadb. Fortunately mariadb available in binary for CentOS and don’t force me to install from source like I do with FreeBSD since its not available yet on FreeBSD ports.

I’m going to install mariadb 5.23 and make it as learning media πŸ™‚

Here the steps :

Download mariadb rpm file

Get all rpm file (client and server) from osuosl mirror.

# ls

MariaDB-client-5.2.3-87.el5.i386.rpm  MariaDB-server-5.2.3-87.el5.i386.rpm

Install the files

# rpm -i MariaDB-*

error: Failed dependencies:
libmysqlclient.so.16 is needed by MariaDB-client-5.2.3-87.el5.i386
libmysqlclient.so.16(libmysqlclient_16) is needed by MariaDB-client-5.2.3-87.el5.i386
libmysqlclient_r.so.16 is needed by MariaDB-client-5.2.3-87.el5.i386
libmysqlclient_r.so.16(libmysqlclient_16) is needed by MariaDB-client-5.2.3-87.el5.i386
libmysqlclient.so.16 is needed by MariaDB-server-5.2.3-87.el5.i386
libmysqlclient.so.16(libmysqlclient_16) is needed by MariaDB-server-5.2.3-87.el5.i386
libmysqlclient_r.so.16 is needed by MariaDB-server-5.2.3-87.el5.i386
libmysqlclient_r.so.16(libmysqlclient_16) is needed by MariaDB-server-5.2.3-87.el5.i386
#

read more »

Step by step guide install CentOS 5.5 with network install

New class has started and I try to give my student new experince. During my search I found new thing that I think they like to try. Network installation would be good for next lesson. I ever try it few years ago with Linux Mandrake. Create diskette boot and perform installation from network server where all required files has already copied.

Nowadays, its rare to see computer with floppy disk as slowly replaced by usb flash disk. Ok, I decide to try install CentOS 5.5 with network install mode.

Here the steps :

Download CentOS 5.5  iso file

Get from nearest mirror by visit this link.

Pick one mirror and you should see the list.

read more »

How to upgrade mariadb 5.1.50 to mariadb 5.2.3

New mariadb 5.2.3 version already out. I just curious on how to upgrade mariadb since I just installed it 3 days ago πŸ™‚

From montyprogram :

MariaDB 5.2.3 is a Stable release. In general this means there are no known serious bugs and we believe the code is ready for general usage.

Here’s upgrade process of mariadb from 5.1.50 to 5.2.3 on freebsd 8.1 stable :

Backup first

#cd /usr/local

#tar cvzf var.tar.gz var

#mv var.tar.gz /home/alamsyah

read more »

How to install mariadb on FreeBSD

Recent discussion around mysql license and its future lead me to mariadb.

From Wikipedia

MariaDB is a community-developed branch of the MySQL database, the impetus being the community maintenance of its free status under GPL, as opposed to any uncertainty of MySQL license status under its current ownership by Oracle.

The intent also being to maintain high fidelity with MySQL, ensuring a “drop-in” replacement capability with library binary equivalency and exacting matching with MySQL APIs and commands. It includes the XtraDB storage engine as a replacement for InnoDB.

Its lead developer is Monty Widenius, the founder of MySQL and Monty Program AB.”

dba by night, ninja by nightBeing curious I decide to install mariadb on my Freebsd 8.1 stable . My first option for install is via ports but at time writing I don’t find the mariadb port πŸ™

After search and dig google I came up with solution on how to install mariadb from source.

Here the steps :

read more »

How to install postgresql 8.1.22 and php 5.2.14 on FreeBSD 8.1 stable

Recent change in mysql make my friend contact me. He want to learn and practice about postgresql before use it on real cpanel host that support postgresql . I agree to set new server for him to play around. The  server itself basically consists of apache, php, postgresql and phppgadmin on FreeBSD 8.1 stable.

Here the steps :

Which Version of Postgresql

I also have same hosting account that my friend use. I log in to cpanel then click phppgadmin to see postgresql version.

Ok. I can see that Postgresql 8.1.22 installed on that host.

read more »