Drizzle: A Database For The Cloud

by
Share this Article: Facebook0Google+0Twitter9LinkedIn3Reddit0StumbleUpon0

Drizzle, a fork of MySQL, is a free, Community driven, Open Source Relational Database Management system. The Drizzle team has removed non-essential code, re-factored the remaining code into a plugin-based architecture and modernized the code base moving to C++. The early work of Drizzle was done by Brian Aker and now the current development is doing by a team of contributors that includes staff members from Canonical Ltd., Google, Six Apart, Sun Microsystems, Rackspace.

Like MySQL and MariaDB, Drizzle has a client/server architecture and uses SQL as its primary command language. Drizzle is written in C++ and distributed under GPL version 2 and 3. As the title says, Drizzle is optimized for web applications and cloud infrastructure. The developers of Drizzle describe it as a “smaller, slimmer and (hopefully) faster version of MySQL. It supports almost all modern Unix/Linux operating systems, Mac OS X, freeBSD and Soalris.

Install On Ubuntu 11.04 or later

Drizzle is available in the official ubuntu repositories. So install it using the following command.

$ sudo apt-get install drizzle

The above command will install both the server and client packages.

Install On RHEL/CentOS 6.x

First you have to add EPEL repository.

Add EPEL Repository on 32-bit Linux 6.X:

# rpm -Uvh http://epel.mirror.net.in/epel/6/i386/epel-release-6-8.noarch.rpm

Add EPEL Repository on 64-bit Linux 6.X:

# rpm -Uvh http://epel.mirror.net.in/epel/6/x86_64/epel-release-6-8.noarch.rpm

Add Drizzle 7 Repository

To add the Drizzle 7 repository to your system, create a /etc/yum.repos.d/drizzle.repo file with the following content:

For Drizzle 7:

[drizzle]
name=drizzle
baseurl=http://rpm.drizzle.org/7-dev/redhat/$releasever/$basearch/
enabled=1
gpgcheck=0

[drizzle-src]
name=drizzle-src
baseurl=http://rpm.drizzle.org/7-dev/redhat/$releasever/source
enabled=1
gpgcheck=0

You can then install Drizzle by running the following command:

# yum install drizzle-server drizzle-client

Add Drizzle 7.1 Repository

To add the Drizzle 7.1 repository to your system, create a /etc/yum.repos.d/drizzle.repo file with the following content:

[drizzle]
name=drizzle
baseurl=http://download.drizzle.org/7.1/redhat/$releasever/$basearch/
enabled=1
gpgcheck=0

[drizzle-src]
name=drizzle-src
baseurl=http://download.drizzle.org/7.1/redhat/$releasever/source
enabled=1
gpgcheck=0

You can then install Drizzle by running the following command:

# yum install drizzle-server drizzle-client

Note: In the Drizzle 7-stable repository, the packages are named drizzle7-server and drizzle7-client.

Start/Stop/Restart Drizzle services

On Ubuntu/Debian:

$ sudo service drizzle start
$ sudo service drizzle stop
$ sudo service drizzle restart

On RHEL/CentOS:

# service drizzle start
# service drizzle stop
# service drizzle restart

You might want to check out the official Drizzle documentation page and detailed installation instructions of Drizzle from source.

You can manage Drizzle database using a GUI database management tool called phpMyAdmin.

For questions please refer to our Q/A forum at : http://ask.unixmen.com/


Share this Article: Facebook0Google+0Twitter9LinkedIn3Reddit0StumbleUpon0