lap 加MySQL主从复制_linux学习笔记12-lap+mysql主从+proxy

weixin_39573822

于 2021-02-07 10:25:25 发布

阅读量286

点赞数

文章标签： lap 加MySQL主从复制

本文链接：https://blog.csdn.net/weixin_39573822/article/details/113908915

版权

安装apache(lap:192.168.176.122)

cd /sur/src

wget http://mirrors.shu.edu.cn/apache//apr/apr-util-1.6.1.tar.gz

yum install gcc-c++ apr-util-devel pcre* -y

tar jxf httpd-2.4.34.tar.bz2

tar jxf apr-1.6.3.tar.bz2

tar zxf apr-util-1.6.1.tar.gz

mv apr-1.6.3/ /usr/src/httpd-2.4.34/srclib/apr

mv apr-util-1.6.1/ /usr/src/httpd-2.4.34/srclib/apr-util

cd httpd-2.4.34/

./configure --prefix=/usr/local/apache --with-included-apr --with-included-apr-util --with-mpm=worker --enable-rewrite --enable-so

报错：解决方法安装PCRE库

yum install pcre* -y

！conf

上图所示表示预编译成功。

make -j4 && make -j4 install

echo "ServerName localhost:80">> /usr/local/apache/conf/httpd.conf

/usr/local/apache/bin/apachectl start

安装php考虑兼容性建议使用php5.6.37

wget http://cn.php.net/distributions/php-5.6.37.tar.bz2

tar jxf php-5.6.37.tar.bz2

yum install libxml2 lib

./configure --prefix=/usr/local/php5 --with-config-file-path=/usr/local/php5/etc --with-mysql=mysqlnd --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd --with-apxs2=/usr/local/apache/bin/apxs

make -j4&&make -j4 install

#vim /usr/local/apache/conf/httpd.conf

添加如下内容

AddType application/x-httpd-php .php

DirectoryIndex index.php index.html index.htm

#/usr/local/apache/bin/apachectl restart

安装mysql主从(主192.168.176.121，从192.168.176.123)

cd /usr/src

#wget http://down1.chinaunix.net/distfiles/mysql-5.5.20.tar.gz

# tar –zxf mysql-5.5.20

#cd mysql-5.5.20

#yum install -y gcc c ncurses-devel cmake libaio bison gcc-c++ git cmake ncurses-devel ncurses

#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql55/ \

-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \

-DMYSQL_DATADIR=/data/mysql \

-DSYSCONFDIR=/etc \

-DMYSQL_USER=mysql \

-DMYSQL_TCP_PORT=3306 \

-DWITH_XTRADB_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_EXTRA_CHARSETS=1 \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DEXTRA_CHARSETS=all \

-DWITH_BIG_TABLES=1 \

-DWITH_DEBUG=0

#make &&make install

#\cp /usr/local/mysql55/support/my-large.cnf /etc/my.cnf

#\cp /usr/loca;/mysql55/support/mysql.server /etc/init.d/mysqld

#chkconfig --add mysqld

#chkconfig --level 35 mysqld on

#mkdir -p /data/mysql

#useradd mysql

#/usr/local/mysql55/scripts/mysql_install_db --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql55

#ln -s /usr/local/mysql55/bin/* /usr/bin/

#chown -R mysql /data/mysql/

#service mysqld start

配置主mysql

vim /etc/my.cnf

添加如下两行并重启mysql

server-id=1

log-bin=mysql-bin

授权

mysql>grant replication slave on *.* to tongbu121@'%' identified by "123456";

mysql>show master status;

记住bin-log文件名和pos点

配置从库

vim /etc/my.cnf

添加如下一行并重启mysql

server-id=2

mysql>change master to master_host='192.168.176.121',master_user='tongbu121',master_password='123456',master_log_file='mysql-bin000003',master_log_pos=390;

mysql>start slave;

mysql>show slave status\G;

双yes即只从建立成功，测试一下

主从配置成功

proxy安装配置

cd /usr/src

useradd -r mysql-prox

echo "export PATH=$PATH:/usr/local/mysql-proxy/bin/">> /etc/profile

source /etc/profile

启动proxy

mysql-proxy --daemon --log-level=debug --user=mysql-proxy --keepalive --log-file=/var/log/mysql-proxy.log --plugins="proxy" --proxy-backend-addresses="192.168.176.121:3306" --proxy-read-only-backend-addresses="192.168.176.123:3306" --proxy-lua-script="/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua" --plugins=admin --admin-username="admin" --admin-password="admin" --admin-lua-script="/usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua"

查看