由于用到centos 5.11,而yum mysql的版本是5.09 要想实现主从复制,就得升级到5.5以上。
yum 升级比较方便。操作如下:
系统环境:centos5.5
centos5.5的源mysql目前还停留在5.0.19上,要做数据库主从的时候,必须升级到5.1以上。
索性,直接到5.5吧
1、安装MySQL 5.5.x的yum源:
rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm
2、安装MySQL客户端的支持包:
yum install libmysqlclient15 --enablerepo=webtatic
3、卸载MySQL老版本的软件包:
yum remove mysql mysql-*
4、安装MySQL 5.5的客户端和服务端:
yum install mysql55 mysql55-server --enablerepo=webtatic
5、启动MySQL系统服务,更新数据库:
/etc/init.d/mysqld restart
mysql_upgrade
升级完毕
- /etc/init.d/mysqld restart
- 停止 mysqld: [确定]
- 初始化 MySQL 数据库: Installing MySQL system tables...
- OK
- Filling help tables...
- OK
- To start mysqld at boot time you have to copy
- support-files/mysql.server to the right place for your system
- PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
- To do so, start the server, then issue the following commands:
- /usr/bin/mysqladmin -u root password 'new-password'
- /usr/bin/mysqladmin -u root -h client4.360zan.cn password 'new-password'
- Alternatively you can run:
- /usr/bin/mysql_secure_installation
- which will also give you the option of removing the test
- databases and anonymous user created by default. This is
- strongly recommended for production servers.
- See the manual for more instructions.
- You can start the MySQL daemon with:
- cd /usr ; /usr/bin/mysqld_safe &
- You can test the MySQL daemon with mysql-test-run.pl
- cd /usr/mysql-test ; perl mysql-test-run.pl
- Please report any problems with the /usr/bin/mysqlbug script!
- [确定]
- 启动 mysqld: [确定]
源是国外的,贼慢贼慢。
文件我下载到csdn了,有兴趣,到csdn http://download.csdn.net/detail/mush_me/4499521