27八/090
玩玩 MySQL 更新 Memcached (2) MySQL 服务器
现在配置 MySQL 数据库服务器 和 MySQL 的 Memcached 扩展.
下载最新版的 mysql 5.1 二进制包. 这里使用 mysql-5.1.37-linux-i686-icc-glibc23.tar.gz
tar zxf mysql-5.1.37-linux-i686-icc-glibc23.tar.gz sudo mv mysql-5.1.37-linux-i686-icc-glibc23 /usr/local/mysql sudo groupadd mysql sudo useradd -g mysql mysql cd /usr/local/mysql sudo chown -R mysql . sudo chgrp -R mysql . sudo scripts/mysql_install_db --user=mysql sudo chown -R root . sudo chown -R mysql data sudo cp support-files/my-medium.cnf /etc/my.cnf sudo support-files/mysql.server start sudo bin/mysqladmin -u root password 'rootpwd' sudo bin/mysql -u root -p
创建两个供外网测试帐号:
GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'localhost' IDENTIFIED BY 'dbpasswd' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'%' IDENTIFIED BY 'dbpasswd' WITH GRANT OPTION;
数据库初步安装OK, 下面配置 Memcached 扩展.
wget http://www.monkey.org/~provos/libevent-1.4.12-stable.tar.gz tar zxf libevent-1.4.12-stable.tar.gz ./configure --prefix=/usr make sudo make install cd .. wget http://memcached.googlecode.com/files/memcached-1.4.0.tar.gz tar zxf memcached-1.4.0.tar.gz ./configure --prefix=/usr make sudo make install cd .. wget http://download.tangent.org/libmemcached-0.31.tar.gz cd libmemcached-0.31/ ./configure --prefix=/usr make sudo make install cd .. wget http://download.tangent.org/memcached_functions_mysql-0.9.tar.gz ./configure --with-mysql=/usr/local/mysql/bin/mysql_config --libdir=/usr/local/mysql/lib/plugin make sudo make install
给 MySQL 添加 UDF 函数, 修改 memcached_functions_mysql_0.9 下的 sql 目录中的 install_functions.sql 文件, 去掉 memc_servers_version 这行. 保存, 导入到 mysql 中.
/usr/local/mysql/bin/mysql -u root -p < sql/install_functions.sql
数据库配置到此OK, 下面进行数据库的主从配置.
