商城网站如何做,广西八桂职教网官网,定制网站开发报价单,凡科小程序登录入口1、从MYSQL官方下载MYSQL的源码版本【一定要是源码版本】2、按以下代码键入LINUX命令行[注] 添加mysql组和用户#groupadd mysql#useradd -g mysql mysql[注] 解包到/usr/local# tar -xzf mysql-standard-4.1.9-pc-linux-gnu-i686.tar.gz -C /usr/local[注] 建立软链接#xff…1、从MYSQL官方下载MYSQL的源码版本【一定要是源码版本】2、按以下代码键入LINUX命令行[注] 添加mysql组和用户#groupadd mysql#useradd -g mysql mysql[注] 解包到/usr/local# tar -xzf mysql-standard-4.1.9-pc-linux-gnu-i686.tar.gz -C /usr/local[注] 建立软链接方便操作(此处给此连接命名为mysql001也可为其它的名字)#cd /usr/local#ln -s mysql-standard-5.0.15-linux-i686-glibc23 mysql001#cd mysql001#scripts/mysql_install_db#chown -R root .#chown -R mysql data#chgrp -R mysql .[注] 复制data以供单版本多实例分配#cp -a data data_1#cp -a data data_2[注] 添加多实例配置文件#cd /usr/local/mysql001/bin#cat my_multi.cnf[注] 以下是my_multi.cnf的配置信息可依此复制[mysqld_multi]mysqld /usr/local/mysql001/bin/mysqld_safemysqladmin /usr/local/mysql001/bin/mysqladminuser rootpassword root[mysqld1]socket /tmp/mysql_001.sockport 3301pid-file /usr/local/mysql001/data_1/hostname.piddatadir /usr/local/mysql001/data_1log /usr/local/mysql001/data_1/hostname.loguser mysql# slave settingserver-id 2master-host 192.168.1.85master-port 3306master-user backupmaster-password 123456replicate-do-db gs_databasereplicate-do-db gs_logmaster-connect-retry30[mysqld2]socket /tmp/mysql_5_2.sockport 3302pid-file /usr/local/mysql001/data_2/hostname.piddatadir /usr/local/mysql001/data_2log /usr/local/mysql001/data_2/hostname.loguser mysql# slave settingserver-id 3master-host 192.168.1.69master-port 3306master-user backupmaster-password 123replicate-do-db gs_databaesreplicate-do-db gs_logmaster-connect-retry30CTRLD退出。#vi /etc/profile # 添加系统环境变量。export MYSQL_HOME/usr/local/mysql001/binexport PATH$PATH:$MYSQL_HOME重启系统让环境变量生效。添加至开机自动启动【此处可不添加依个人情况决定是否需要设置开机自动启动】vi /etc/rc.local# 添加mysqld_multi --defaults-extra-file/usr/local/src/mysql_dir/bin/my_multi.cnf start 1,23、其它一些技巧# 访问某个实例mysql -u root -S /tmp/mysql_5_1.sock -p# 设置各个实例密码mysqladmin -u root password root -S /tmp/mysql_5_1.sock# 手动启动各个实例mysqld_multi --defaults-extra-file/usr/local/src/mysql_dir/bin/my_multi.cnf start 1,2# 停止各个实例mysqld_multi --defaults-extra-file/usr/local/src/mysql_dir/bin/my_multi.cnf stop 1,2# 参考文章http://blog.liuts.com/post/13/由于第一次接触LINUX花了三天时间才算有所成就发出来希望可以给大伙带来方便
