linux下mysql 有双机_MySQL完整安装和主从双机配置

MySQL完整安装和主从双机配置

示例主机：192.168.0.1  示例备机：192.168.0.2

################### mysql 完整安装 ###################

groupadd  mysql

useradd -g mysql mysql

mv /root/mysql-5.0.51b.tar.gz /usr/local/src

tar -zxvf mysql-5.0.51b.tar.gz

cd mysql-5.0.51b

./configure –with-charset=latin1 –with-extra-charsets=all –enable-assembler –with-mysqld-ldflags=-all-static –with-mysqld-user=mysql –prefix=/usr/local/mysql-5.0.51b –localstatedir=/data/mysql5051_db

make

make install

ln -s /usr/local/mysql-5.0.51b /usr/local/mysql

mkdir -p /data/mysql5051_db/dbdata

mkdir -p /data/mysql5051_db/innodb

mkdir -p /data/mysql5051_db/binlog

chown -R mysql:mysql  /data/mysql5051_db

chmod -R 775 /data/mysql5051_db

cd /usr/local/src/mysql-5.0.51b

vim ./scripts/mysql_install_db中的ldata=/data/mysql5051_db/dbdata

cp ./support-files/my-small.cnf /etc/my.cnf

/usr/local/mysql-5.0.51b/bin/mysql_install_db –basedir=/usr/local/mysql-5.0.51b –ldata=/data/mysql5051_db/dbdata –user=mysql

vim /etc/my.cnf

bind-address    = 192.168.0.8

datadir    = /data/mysql5051_db/dbdata/

pid-file    = /data/mysql5051_db/my.pid

log-slow-queries=/data/mysql5051_db/dbdata/slowquery.sql

log-bin  = /data/mysql5051_db/binlog/sortrepl.log

################innodb####################

# Uncomment the following if you are using InnoDB tables

innodb_data_home_dir = /data/mysql5051_db/innodb/

innodb_data_file_path = ibdata1:1000M;ibdata2:1000M:autoextend:max:800M

innodb_log_group_home_dir = /data/mysql5051_db/innodb/

innodb_log_arch_dir = /data/mysql5051_db/innodb/

# You can set .._buffer_pool_size up to 50 – 80 %

# of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 600M

innodb_additional_mem_pool_size = 20M

# Set .._log_file_size to 25 % of buffer pool size

innodb_log_files_in_group = 4

innodb_log_file_size = 400M

innodb_log_buffer_size = 160M

innodb_flush_log_at_trx_commit = 0

innodb_thread_concurrency = 8

#innodb_flush_method = O_DSYNC

innodb_lock_wait_timeout = 50

################innodb####################

#启动服务

# /usr/local/mysql/bin/mysqld_safe -umysql &

# /usr/local/mysql-5.0.51b/bin/mysql

#关闭服务

# /usr/local/mysql/bin/mysqladmin shutdown

################### mysql 完整安装完成 ###################

推荐阅读：