RedHat linux 5.6 mysql資料庫主從複制 單機多執行個體

Mysql涓諱粠澶嶅埗

涓€銆佸崟鏈哄瀹炰緥锛屽疄鐜癿ysql 涓諱粠澶嶅埗浣跨敤鐨勬槸5.6绯葷粺婧愮爜鍖呫€

鍑嗗缂栬瘧鐜锛屽畨瑁咃細gcc, gcc-c++ ,autoconf 聽,automake

[root@localhost ~]# ls

anaconda-ks.cfg Desktop 聽install.log 聽install.log.syslog 聽mysql-5.0.18.tar.gz

[root@localhost ~]# tar -zxf mysql-5.0.18.tar.gz 聽 聽 聽 聽 聽 //瑙ｅ帇杞歡鍖

[root@localhost ~]# cd mysql-5.0.18 聽 聽 聽 聽 聽 聽 聽 //杩涘叆瑙ｅ帇鐩綍涓

[root@localhost mysql-5.0.18]# vi 聽INSTALL-SOURCE 聽 聽 //缂栬緫INSTALL-SOURCE鏂囦歡

聽 聽 useradd mysql

聽 聽 ./configure--prefix=/usr/local/mysql --with-charset=gbk

聽 聽 make

聽 聽 make install

聽 聽 cp support-files/my-medium.cnf/etc/my.cnf

聽 聽 cd /usr/local/mysql

聽 聽 bin/mysql_install_db--user=mysql

聽 聽 chown -R root 聽.

聽 聽 chown -R mysql var

聽 聽 chgrp -R mysql .

聽 聽bin/mysqld_safe --user=mysql &

缂栬緫濂戒互鍚庝繚瀛橀€€鍑猴細wq 聽 聽

[root@localhost mysql-5.0.18]# chmod 聽777 聽INSTALL-SOURCE 聽 聽 聽 //缁橧NSTALL-SOURCE 777鏉冮檺

[root@localhost mysql-5.0.18]# ./INSTALL-SOURCE 聽 聽 聽 聽 聽 聽//瀹夎mysql

[root@localhost ~]# /usr/local/mysql/bin/mysql 聽 聽 聽 聽 聽 //鍚姩mysql

[root@localhost ~]# ps -aux | grep mysql 聽 聽 聽 聽 聽 聽 聽 聽//鏌ョ湅mysql杩愯璇︾粏杩涚▼

Warning: bad syntax, perhaps a bogus '-'? See/usr/share/doc/procps-3.2.3/FAQ

mysql 聽 26617 聽0.0 聽3.4 127516 17564 ? 聽 聽 聽Sl 聽18:29 聽 0:01

/usr/libexec/mysqld --defaults-file=/etc/my.cnf--basedir=/usr --datadir=/var/lib/mysql --user=mysql--pid-file=/var/run/mysqld/mysqld.pid --skip-locking--socket=/var/lib/mysql/mysql.sock --server-id=1 --log-bin=/var/mysql/binlog

涓嬮潰鍋氫富mysql 瀹炰緥锛

[root@localhost ~]# mkdir /var/mysql/

[root@localhost ~]# cd /var/mysql/

[root@localhost mysql]# touch binlog

[root@localhost mysql]# chmod 777 /var/mysql/binlog 鈥揜

[root@localhost mysql]# killall mysqld 聽 聽 //鏉€浜嗘墍鏈塵ysql杩涚▼

涓嬮潰鍚姩涓籱ysql瀹炰緥锛

[root@localhost mysql]# /usr/local/mysql/libexec/mysqld--basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql--pid-file=/usr/local/mysql/var/localhost.localdomain.pid --skip-locking--port=3306 --socket=/tmp/mysql.sock --server-id=1 --log-bin=/var/mysql/binlog &

鍚姩浠巑ysql 瀹炰緥锛

[root@localhost~]# mkdir /usr/local/mysql-new

[root@localhost~]# cp -r /usr/local/mysql/* /usr/local/mysql-new

[root@localhost ~]# /usr/local/mysql/libexec/mysqld--basedir=/usr/local/mysql-new --datadir=/usr/local/mysql-new/var --user=root --pid-file=/usr/local/mysql-new/var/localhost.localdomain.pid--skip-locking --port=3307 --socket=/tmp/mysql-new.sock --server-id=2 &

瀹炵幇mysql涓諱粠澶嶅埗锛

[root@localhost ~]# mysql 聽 聽 聽 聽 聽 聽 聽 //杩涘叆涓籱ysql

mysql> show databases;

[root@localhost ~]# mysql -h 127.0.0.1 -P 3307 聽 聽 //杩涘叆浠巑ysql

mysql> change master to master_host='127.0.0.1',master_user='root', master_password='', master_port=3306; 聽 聽 聽 聽 聽//閾炬帴涓籱ysql鏁版嵁搴

mysql> start slave;

涓ゅ彴mysql鏈嶅姟鍣ㄥ疄鐜頒富浠庡鍒

瀹夎閮ㄥ垎鐪佺暐锛侊紒锛侊紒锛侊紒锛侊紒

Mysql涓繪満1 聽 锛欼P锛?92.168.1.100

涓嬮潰鍚姩涓籱ysql锛

[root@localhost mysql]#/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql--datadir=/usr/local/mysql/var --user=mysql--pid-file=/usr/local/mysql/var/localhost.localdomain.pid --skip-locking--port=3306 --socket=/tmp/mysql.sock --server-id=1 --log-bin=/var/mysql/binlog&

Mysql浠庢満2 聽 锛欼P锛?92.168.1.200

[root@localhost mysql]#/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql--datadir=/usr/local/mysql/var --user=mysql--pid-file=/usr/local/mysql/var/localhost.localdomain.pid --skip-locking--port=3306 --socket=/tmp/mysql.sock --server-id=2 &

杩涘叆mysql涓繪満1 聽锛

mysql>grant all on *.* to 鈥榰sername鈥橜鈥?鈥檌dentified by 鈥?23456鈥橕

杩涘叆mysql浠庢満2锛

mysql> change master to master_host='192.168.1.200',master_user='username', master_password='123456';

mysql>start slave;