lnmp_数据库主从

最新推荐文章于 2024-06-12 15:28:19 发布

xiao_lu.

最新推荐文章于 2024-06-12 15:28:19 发布

阅读量289

点赞数 2

文章标签：数据库

本文链接：https://blog.csdn.net/xiaolu0129/article/details/138523484

版权

记录

容器内的ip记录

容器	ip	端口
nginx-web	10.31.0.4/16	80->80
nginx-web2	10.31.0.5/16	81->80
php-web	10.31.0.6/16	9001->9000
php-web2	10.31.0.7/16	9002->9000
master	10.31.0.1/16	3307->3306
slave	10.31.0.3/16	3308->3306




CREATE USER 'slave'@'%' IDENTIFIED BY '1';
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave'@'%';



change master to master_host='192.168.1.5', master_user='slave', master_password='1', master_port=3307, master_log_file='com-mysql-bin.000001', master_log_pos=617, master_connect_retry=30;


docker run -d -p 3308:3306 \
--privileged=true \
-v /docker/dbslave/log:/var/log/mysql \
-v /docker/dbslave/data:/var/lib/mysql \
-v /docker/dbslave/conf:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD=admin \
--network lnmp_net \
--ip 10.3.1.10 \
--name dbslave \
mysql:5.7

数据库信息

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| lxj301db           |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use lxj301db
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from t1;
+------+-----------+
| id   | name      |
+------+-----------+
|    1 | liuxijing |
+------+-----------+
1 row in set (0.00 sec)

php配置

<?php
    $db_host="10.31.0.3";
    $db_username="root";
    $db_password="1";
    $db_name="lxj301db";
    $link = @mysqli_connect($db_host,$db_username,$db_password,$db_name);

    if (mysqli_connect_error($link)){
        die("连接mysql失败：".mysqli_connect_error());
    }
    echo "连接成功！";
    $sql = "select * from user";
    if ($result = mysqli_query($link,$sql))
    {
        while ($total = mysqli_fetch_array($result))
            var_dump($total);
    }else{
        die(mysqli_error());
    }


?>

11.13

1.基本搭建成功

需要修改 nginx+php 1 和 2 区别开

挂在不同目录下

2.lvs调度的问题

3.数据库的内部问题 出现在前端的东西不美观

change master to master_host='192.168.1.7', master_user='slave', master_password='1', master_port=3307, master_log_file='com-mysql-bin.000001', master_log_pos=154, master_connect_retry=30;

create database db301;
use db301;
create table db301.user (id int,name varchar(20));
insert into db301.user values(1,'liuxijing');
select * from db301.user;

容器	ip	端口
db-master	10.1.0.1/16	3307->3306
db-slave	10.1.0.3/16	3307->3306
nginx1	10.1.0.6/16	81->80
nginx2	10.1.0.7/16	82->80
php1	10.1.0.4/16	9001->9000
php2	10.1.0.5/16	9002->9000