linux学习笔记12-lap+mysql主从+proxy

安装apache（lap:192.168.176.122）

cd /sur/src

wget https://mirrors.tuna.tsinghua.edu.cn/apache//httpd/httpd-2.4.34.tar.bz2

wget https://mirrors.tuna.tsinghua.edu.cn/apache//apr/apr-1.6.3.tar.bz2

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

/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 statusG;

 

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

 主从配置成功

proxy安装配置

cd /usr/src

wget http://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-Proxy/mysql-proxy-0.8.4-linux-el6-x86-64bit.tar.gz

useradd  -r  mysql-prox

tar zxf mysql-proxy-0.8.4-linux-el6-x86-64bit.tar.gz 

mv mysql-proxy-0.8.4-linux-el6-x86-64bit /usr/local/mysql-proxy

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"

查看

yum install mysql -y

尝试登录以4041端口mysql-proxy管理平台

状态为unknow,为不正常链接。

 systemctl stop firewalld

setenforce 0

关闭防火墙使用下列命令刷新一下

主从创建test1库和t1表(需要主从库上授权mysql-proxy 远程登录mysql）

mysql -h192.168.176.124 -umysql-proxy -p123456 -P4040 -e "select * from test1.t1;"

搭建discuz论坛

OK搭建成功。