中间件oneproxy安装部署及实现分表

最新推荐文章于 2024-06-27 17:41:01 发布

无知的蜗牛

最新推荐文章于 2024-06-27 17:41:01 发布

阅读量2.3k

点赞数 1

本文链接：https://blog.csdn.net/weixin_37998647/article/details/78750033

版权

准备：
中间件：192.168.1.98 ——->oneproxy
mysql主：192.168.1.51 ——->master
mysql从：192.168.1.121 ——->slave
为方便实验，三台机都关闭防火墙和selinux
开始之前，需要将master和slave之间主从配置好，这不是本文的重点，下面会有简单的操作，，如要详细的过程，可移步至：http://blog.csdn.net/weixin_37998647/article/details/76599255

一、主从复制搭建与检查：

配置master：

[root@localhost ~]# vim /etc/my.cnf
 19 # read_rnd_buffer_size = 2M
 20 datadir=/var/lib/mysql
 21 socket=/var/lib/mysql/mysql.sock
 22 server-id=1
 23 log-bin=mysql-bin
 24
 25 # Disabling symbolic-links is recommended to prevent assorted security ri
    sks
 26 symbolic-links=0
 27
 28 log-error=/var/log/mysqld.log
 29 pid-file=/var/run/mysqld/mysqld.pid
 [root@localhost ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]

配置slave：

[root@localhost ~]# vim /etc/my.cnf
 19 # read_rnd_buffer_size = 2M
 20 datadir=/var/lib/mysql
 21 socket=/var/lib/mysql/mysql.sock
 22 server-id=2
 23 log-bin=mysql-bin
 24
 25 # Disabling symbolic-links is recommended to prevent assorted security ri
    sks
 26 symbolic-links=0
 27
 28 log-error=/var/log/mysqld.log
 29 pid-file=/var/run/mysqld/mysqld.pid
 [root@localhost ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]

配置文件修改了之后要重启或者重新加载服务，这是常识。

在master上授权：

[root@localhost ~]# mysql -uroot -p

mysql> grant all privileges on *.* to 'root'@'%' identified by 'abc123';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.06 sec)

mysql> set global validate_password_length=6;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'%' identified by 'abc123';
Query OK, 0 rows affected, 1 warning (0.10 sec)
mysql> show master status ;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 |      434 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

在slave上指定master：

[root@localhost ~]# mysql -u root -p

mysql> change master to master_host='192.168.1.51',master_user='root',master_ppassword='abc123',master_log_file='mysql-bin.000001',master_log_pos=434;
Query OK, 0 rows affected, 2 warnings (0.07 sec)
mysql> start slave ;
Query OK, 0 rows affected (0.02 sec)

mysql> show slave status \G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.1.51
                  Master_User: root
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 434
               Relay_Log_File: localhost-relay-bin.000002
                Relay_Log_Pos: 320
        Relay_Master_Log_File: mysql-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes