(一)安装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=