mysql 5.7主从同步简单配置
来源:互联网 发布:斧子主机 知乎 编辑:程序博客网 时间:2024/06/05 07:52
grant replication slave on *.* to 'rpl'@'%' identified by 'asdfasdf';
mysqldump --single-transaction --master-data=1 -A > a.sql
CHANGE MASTER TO
MASTER_HOST='192.168.1.128',MASTER_USER='rpl',
MASTER_PASSWORD='asdfasdf',
MASTER_PORT=3307,
MASTER_LOG_FILE='mysqlbinlog.000006',
MASTER_LOG_POS=476,
MASTER_CONNECT_RETRY=10;
[root@localhost][test]> show processlist;
+----+-----------------+-----------+------+---------+------+--------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+--------------------------------------------------------+------------------+
| 1 | event_scheduler | localhost | NULL | Daemon | 2073 | Waiting on empty queue | NULL |
| 12 | root | localhost | test | Query | 0 | starting | show processlist |
| 31 | system user | | NULL | Connect | 61 | Waiting for master to send event | NULL |
| 32 | system user | | NULL | Connect | 60 | Slave has read all relay log; waiting for more updates | NULL |
| 33 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 34 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 35 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 36 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 37 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 38 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 39 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 40 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 41 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 42 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 43 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 44 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 45 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 46 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 47 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
| 48 | system user | | NULL | Connect | 61 | Waiting for an event from Coordinator | NULL |
+----+-----------------+-----------+------+---------+------+--------------------------------------------------------+---------------
[root@localhost][test]> show variables like '%slave%';
+-------------------------------------------+---------------------------------------------------+
| Variable_name | Value |
+-------------------------------------------+---------------------------------------------------+
| init_slave | |
| log_slave_updates | ON |
| log_slow_slave_statements | ON |
| pseudo_slave_mode | OFF |
| rpl_semi_sync_master_wait_for_slave_count | 1 |
| rpl_semi_sync_master_wait_no_slave | ON |
| rpl_semi_sync_slave_enabled | ON |
| rpl_semi_sync_slave_trace_level | 32 |
| rpl_stop_slave_timeout | 31536000 |
| slave_allow_batching | OFF |
| slave_checkpoint_group | 512 |
| slave_checkpoint_period | 300 |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_max_allowed_packet | 1073741824 |
| slave_net_timeout | 60 |
| slave_parallel_type | LOGICAL_CLOCK |
| slave_parallel_workers | 16 |
| slave_pending_jobs_size_max | 16777216 |
| slave_preserve_commit_order | ON |
| slave_rows_search_algorithms | INDEX_SCAN,HASH_SCAN |
| slave_skip_errors | 1007,1008,1050,1051,1054,1060,1061,1068,1091,1146 |
| slave_sql_verify_checksum | ON |
| slave_transaction_retries | 128 |
| slave_type_conversions | |
| sql_slave_skip_counter | 0 |
+-------------------------------------------+---------------------------------------------------+
- mysql 5.7主从同步简单配置
- mysql 5.7 主从同步配置
- 简单的MySQL数据库主从同步配置
- MYSQL 主从同步配置
- Mysql 主从同步配置
- mysql主从同步配置
- mysql主从同步配置
- mysql主从同步配置
- mysql主从同步配置
- mysql主从同步配置
- Mysql主从同步配置
- MySQL主从同步配置
- mysql主从同步配置
- mysql主从同步配置
- mysql主从同步配置
- mysql 配置主从同步
- mysql 主从同步配置
- MySQL 主从同步配置
- java 中StringBuilder类的常用方法
- 用Nginx实现https转http
- sd卡tf卡进入spi模式
- 创建一个springboot项目
- python suds 出错"No handlers could be found for logger 'suds.client'"
- mysql 5.7主从同步简单配置
- esri geometry-api-java的maven创建
- rem自适应 窗体大小自动 rem设置 改变rem来完成等比例缩放
- Redis简介
- 蓝牙协议栈Bluez的移植
- CentOS设置代理
- 负载均衡百问-还在担心大流量访问吗
- 1001. A+B Format (20)
- iOS 开发小知识点