Drizzle安装

（一）安装drizzle所需的环境：

 

#CentOS-5.2-x86_64-bin-DVD.iso

由于官方推荐drizzle安装在64位操作系统上，所以需要先在宿主机中创建新的虚拟机并且安装64位centos操作系统。

 

（二）drizzle安装

 

http://docs.drizzle.org/installing/redhat.html

方法一：取sourc直接编译安装

#http://docs.drizzle.org/installing/from_source.html#compile-source

./config/autorun.sh   #取个最新版本的Source，然后解压缩，里面应该有autorun.sh文件的。

./configure

make

make install

方法二：利用官方提供的rpm包安装手顺安装（推荐）

#redhat和centos是一样的吧

http://docs.drizzle.org/installing/redhat.html

①Install EPEL Repository on 64-bit Linux 5.X:

sudo rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm

#远程安装不行的话，可以先下载下来在安装\(^o^)/~

 

②To add the Drizzle repository to your system you also need to create a /etc/yum.repos.d/drizzle.repo file with the following content:

RedHat→ 

[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

 $releasever uses RHEL 5 or RHEL 6, and $basearch is the architecture (i386 or x86_64).

因此对于本系统来说，上述/etc/yum.repos.d/drizzle.repo的内容应该是：

 

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

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

 

③You can then install Drizzle by running the following command:

sudo yum install drizzle7-server drizzle7-client

或者

yum install drizzle7-server drizzle7-client

（三）服务器端和客户端启动

参考：

http://wiki.drizzle.org/Starting_drizzled#Starting_drizzled

http://www.lupaworld.com/article-133135-2.html

利用上述方法二安装好drizzle之后，请按照如下手顺启动drizzle服务：

安装完成后，就要为数据库服务器创建一个非特权组和用户，如下：

shell> groupadd drizzle  

shell> useradd -g drizzle drizzle 

另外还要创建一个目录以存放数据库文件，并给予适当的权限，如下：

shell> mkdir /usr/local/drizzle  

shell> mkdir /usr/local/drizzle/data  

shell> cd /usr/local/drizzle  

shell> chown -R drizzle .  

shell> chgrp -R drizzle . 

然后，用以下命令启动Drizzle服务器：

shell> /usr/sbin/drizzled --user=drizzle --basedir=/usr/local/drizzle/ --datadir=/usr/local/drizzle/data/ &  

出现错误如下：Plugin 'md5' init function returned error

解决办法：yum install libgcrypt-devel

然后继续启动：

[root@rdb6 include]# /usr/sbin/drizzled --user=drizzle --basedir=/usr/local/drizzle/ --datadir=/usr/local/drizzle/data/ &

[1] 19209

[root@rdb6 include]# InnoDB: Log scan progressed past the checkpoint lsn 48941

110407 11:36:08  InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

110407 11:36:09  InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percents: 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

InnoDB: Apply batch completed

Listening on /tmp/mysql.socket

然后尝试打开客户端：

[root@rdb6 tmp]# /usr/bin/drizzle

Welcome to the Drizzle client..  Commands end with ; or \g.

Your Drizzle connection id is 2

Connection protocol: mysql

Server version: 2011.03.11 Source distribution (drizzle)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

drizzle>

连接成功了，说明启动成功。

Shutting down drizzle    

/usr/bin/drizzle --shutdown

Shutting down drizzle on certain port    

/usr/bin/drizzle --shutdown --port=<PORT_NUMBER>