lamp架构2

virsh start vm1
virsh start vm2
virsh start vm3

server2
ps ax
/usr/local/tomcat/bin/startup.sh

浏览器 172.25.254.1/test.jsp

server2
当2挂掉之后
/usr/local/tomcat/bin/shutdown.sh

问题：当2挂掉之后，信息会传到3上，session共享
交叉式存储

server2
cd /usr/local/tomat/
ls
cd conf/
vim context.xml

ls
cd ..
cd lib/
ls
rm -f memcached-session-manager-tc6-1.6.3.jar
yum install memcached -y
systemctl start memcached.service
netstat -antlp

srever3
/usr/local/tomcat/bin/shutdown.sh
cd /usr/local/tomat/
ls
cd conf/
vim context.xml

failoverNodes当出现故障了找自己

ls
cd ..
cd lib/
ls
rm -f memcached-session-manager-tc6-1.6.3.jar
yum install memcached -y
systemctl start memcached.service
netstat -antlp

server2
/usr/local/tomcat/bin/startup.sh
cd ..
ls
cat logs/catalina.out

server3
/usr/local/tomcat/bin/startup.sh
cd ..
ls
cat logs/catalina.out

server2
yum install telnet
telnet localhost 11211
get ID
telnet 172.25.254.2 11211
get ID

server3
/usr/local/tomcat/bin/startup.sh

server2
systemctl stop memcached.service

server2
telnet 172.25.254.3 11211
get ID

tomcat只能做临时存储

编译数据库
数据库下载
Mysql官网下载社区版，mysql community server 5.7.35 源代码 generic linux
tar zxf mysql-boost-5.7.31.tar.gz
编译时，磁盘最好有10G以上的空间

cd mysql-boost-5.7.31/
编译时，要求cmake
yum install cmake -y
yum install gcc gcc-c++ -y
less INSTALL
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DSYSCONFDIR=/etc -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=/root/mysql-5.7.31/boost/boost_1_59_0
安装路径 指定数据目录 定义sock路径 支持innodb存储 配置目录 支持innob本地文件导入 支持所有扩展字符集 默认字符集 校验字符集 boost目录

字符集
高可用HA（High Availability）是分布式系统架构设计中必须考虑的因素之一，它通常是指，通过设计减少系统不能提供服务的时间。

yum install bison -y
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DSYSCONFDIR=/etc -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=/root/mysql-5.7.31/boost/boost_1_59_0
make #只要不停下来，报错也不影响
du -sh /
df -h /
make install

如果想从头开始检测

cd mysql-boost-5.7.31/
ls
删除CMakeCache.txt

cd /usr/local/mysql/
ls
id mysql
useradd -s /sbin/nologin -M -d /data/mysql mysql
ls
pwd
ls
cd support-files/
ls
cp mysql.server /etc/init.d/mysqld
ll /etc/init.d/mysqld
ll
mkdir /data/mysql
chown mysql.mysql /data/mysql/
ll -d /data/mysql/
find -name my.cnf
cat ./packaging/rpm-common/my.cnf
vim /etc/my.cnf

cd /usr/local/mysql/
ls
cd bin/
pwd
ls
cd
vim .bash_profile

source .bash_profile
mysqld --initialize --user=mysql
/etc/init.d/mysqld start
ls /data/mysql/
mysql -p
mysql_secure_installation
输入旧密码
输入两次新密码
强壮度检测，大小写字母加数字加特殊符号超过8位。不想那么麻烦就直接直接回车
直接回车
y
y
y
y
mysql -密码
通常数据库是：
mysql -p
密码
show database;

cd /data/mysql/
ls
pwd
ls
cat /data/mysql/
ll -d /dtat/mysql/
ls
cat server1.err
/etc/init.d/mysqld start

问题：将真个lamp架构串联在一起

cd /usr/local
ls
cd nginx/html
ls
pwd
ls

下载phpMyAdimn-5.0.2-all-languages.zip

unzip phpMyAdimn-5.0.2-all-languages.zip
ln -s phpMyAdimn-5.0.2-all-languages myadmin
cd myadmin/
cd 
ls
ps ax
systemctl start php-fpm.service
netstat -antlp
cd /usr/local/nginx/conf
vim nginx.conf

nginx -s reload
cd /usr/local/php/
ls
cd etc/
ls
vim php.ini

ll /dtata/mysql/mysql.sock
systemctl reload php-fpm

浏览器 172.25.254.1/myadmin/index.php，能进去看见目录就说明lamp架构成功

scp -r /usr/local/mysql server2:/usr/local/
cd /etc/
scp my.cnf server2:/etc/
scp /etc/init.d/mysqld server2:/etc/init.d/

server2
useradd -s /sbin/nologin -M -d /data/mysql mysql
id mysql
mkdir -p /data/mysql/
chown mysql.mysql /data/mysql/
vim .bash_profile

source .bash_profile
mysqld --verbose --help
mysqld --verbose --help|grep init
mysqld --initialize --user=mysql
/etc/init.d/mysqld start
mysql_secure_installation
步骤与之前同样
mysql -p

server1
vim /etc/my.cnf
/etc/init.d/mysqld restart

mysql -pwestos
show master status
cd /data/mysql/
ls
ll mysql-bin.000001
file mysql-bin.000001
mysqlbinlog mysql-bin.000001
ls
mysql -p
CREATE USER 'repl'@'%' IDENTIFIED BY 'westos'; #创建用户
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%'   #授权主从复制
show master status

server2
vim /etc/my.cnf
/etc/init.d/mysqld restart

mysql -pwestos
CHANG MASTER TO MASTER_HOST='172.25.254.1',MASTER_USER='repl',MASTER_PASSWORD='westos',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=595;
start slave;
show slave status;
show slave status\G;
#只要看到两个yes就表示成功了。

server1
show database;
create database westos;
use westos
show tables;
create table users (
username varchar(20) not null,
passwored varchar(25) not null);
show tables;
desc users;
insert into users values ('user1','123');
insert into users values ('user2','456');
select * from users;

mysql必知必会
server-id=0,0表示禁止所有

Mysql的组成工作原理
slave_IO_running :NO一般情况下可能是因为网络，还有master端的用户创建有问题。
slave_SQL_running :NO一般情况下，主从数据不对称，
mysql复制不是同步，它是把数据文件里面的内容复制过来，这样前提条件是base是一样的。当底层base不一样，就会报错。
一主多从比较适合读多写少的场景，A->B->C

server1
cd 
scp -r /usr/local/mysql server3:/usr/local/
scp /etc/my.cnf server3:/etc/
scp /etc/init.d/mysqld server3:/etc/init.d/

server3
useradd -s /sbin/nologin -M -d /data/mysql mysql
mkdir -p /data/mysql
chown mysql.mysql /data/mysql/
vim .bash_profile

source .bash_profile
vim /etc/my.cnf

mysqld --initialize --user=mysql
/etc/init.d/mysqld restart
mysql_secure_installation
与之前操作一样

主从复制一定是服从二进制制

server2
vim /etc/my.cnf

/etc/init.d/mysqld restart
ls
mysqlbinlog mysql-bin.000001

server1
mysql -pwestos
use westos
insert into users values ('user3','456');

server2
mysqlbinlog mysql-bin.000001 -v
cat server2-relay-bin.index
cat ./server2-relay-bin.000004
mysqlbinlog mysql-bin.000004 -v
mysql -pwestos
show master status;

server1
mysqldump -pwestos westos < dump.sql 

server3
vim dump.sql
mysql pwestos
show tables;
show databases;
create database westos;

mysql -pwestos westos < dump.sql
mysql -pwestos
use westos
select * from users;
MASTER_HOST='172.25.254.2',MASTER_USER='repl',MASTER_PASSWORD='westos',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=1022;
start slave;
show slave status\G;

server2在2中创建repl
mysql -pwestos
use mysql
select * from users;
grant replication slave on *.* to repl@'%' identified by 'westos';
flush privileges
show master status;

server1
mysql -pwestos
use westos
insert into users values ('user4','456')
insert into users values ('user5','456')

server3
use westos
select * from user3;