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.
