Installing MariaDB on openSUSE 11.2

In the first day of this month, the first stable version of MariaDB was released. MariaDB is the OSS relational database forked from MySQL. On this download page, there sources for Linux and Solaris and binary packages for Ubuntu. openSUSE users of course can build from this sources. But if you install from binary RPMs, read the instructions below:

(1) Launch the YaST2 and start "Software Repositories" to add new repository URL.

(2) Add the repository URL including MariaDB.

http://download.opensuse.org/repositories/server:/database:/UNSTABLE/openSUSE_11.2/

Check the repository is added successfully.

(3) Then launch the "Software Management", uninstall mysql RPM packages except libmysqlclient16 and llibmysqlclient_r16

Because these 2 packages are used both from mysql and from MariaDB.

(4) Install MariaDB RPM packages.

Corresponding RPM packages are below:

MySQL	MariaDB
libmysqlclient16
libmysqlclient_r16
mysql	mariadb
mysql-bench	mariadb-bench
mysql-client	mariadb-client
mysql-debug	mariadb-debug
mysql-ndb-extra	mariadb-ndb-extra
mysql-ndb-management	mariadb-ndb-management
mysql-ndb-storage	mariadb-ndb-storage
mysql-ndb-tools	mariadb-ndb-tools
mysql-test	mariadb-test
mysql-tools	mariadb-tools

The biggest merit of installing from YaST2 is that /etc/init.d scripts are also installed.