文档章节

master-info-repository=TABLE && relay-log-info-repository=TABLE 后的一些对应参照

xxj123gogo
 xxj123gogo
发布于 2017/04/27 19:55
字数 669
阅读 154
收藏 0

对应关系

文件
master.info mysql.slave_master_info
relay-log.info mysql.slave_relay_log_info

下面是从官方文档整理出来的 master.info 文件和 mysql.slave_master_info 表和 show slave status 命令的输出中的各字段对应关系:

Line in master.info File slave_master_info Table Column SHOW SLAVE STATUS Column Description
1 Number_of_lines [None] Number of lines in the file, or columns in the table
2 Master_log_name Master_Log_File The name of the master binary log currently being read from the master
3 Master_log_pos Read_Master_Log_Pos The current position within the master binary log that have been read from the master
4 Host Master_Host The host name of the master
5 User_name Master_User The user name used to connect to the master
6 User_password Password (not shown by SHOW SLAVE STATUS) The password used to connect to the master
7 Port Master_Port The network port used to connect to the master
8 Connect_retry Connect_Retry The period (in seconds) that the slave will wait before trying to reconnect to the master
9 Enabled_ssl Master_SSL_Allowed Indicates whether the server supports SSL connections
10 Ssl_ca Master_SSL_CA_File The file used for the Certificate Authority (CA) certificate
11 Ssl_capath Master_SSL_CA_Path The path to the Certificate Authority (CA) certificates
12 Ssl_cert Master_SSL_Cert The name of the SSL certificate file
13 Ssl_cipher Master_SSL_Cipher The list of possible ciphers used in the handshake for the SSL connection
14 Ssl_key Master_SSL_Key The name of the SSL key file
15 Ssl_verify_server_cert Master_SSL_Verify_Server_Cert Whether to verify the server certificate
16 Heartbeat [None] Interval between replication heartbeats, in seconds
17 Bind Master_Bind Which of the slave's network interfaces should be used for connecting to the master
18 Ignored_server_ids Replicate_Ignore_Server_Ids The list of server IDs to be ignored. Note that for Ignored_server_ids the list of server IDs is preceded by the total number of server IDs to ignore.
19 Uuid Master_UUID The master's unique ID
20 Retry_count Master_Retry_Count Maximum number of reconnection attempts permitted
21 Ssl_crl [None] Path to an ssl certificate revocation list file
22 Ssl_crl_path [None] Path to a directory containing ssl certificate revocation list files
23 Enabled_auto_position Auto_position If autopositioning is in use or not
24 Channel_name Channel_name The name of the replication channel

 

下面是从官方文档整理出来的 relay-log.info 文件和 mysql.slave_relay_log_info 表和 show slave status 命令的输出中的各字段对应关系:

Line in relay-log.info slave_relay_log_info Table Column SHOW SLAVE STATUS Column Description
1 Number_of_lines [None] Number of lines in the file or columns in the table
2 Relay_log_name Relay_Log_File The name of the current relay log file
3 Relay_log_pos Relay_Log_Pos The current position within the relay log file; events up to this position have been executed on the slave database
4 Master_log_name Relay_Master_Log_File The name of the master binary log file from which the events in the relay log file were read
5 Master_log_pos Exec_Master_Log_Pos The equivalent position within the master's binary log file of events that have already been executed
6 Sql_delay SQL_Delay The number of seconds that the slave must lag the master
7 Number_of_workers [None] The number of slave worker threads for executing replication events (transactions) in parallel
8 Id [None] ID used for internal purposes; currently this is always 1
9 Channel_name Channel_name The name of the replication channel

在旧版本(MySQL 5.6之前), relay-log.info 信息如下,并且系统不存在 slave_relog_log_info表

Line Status Column Description
1 Relay_Log_File The name of the current relay log file
2 Relay_Log_Pos The current position within the relay log file; events up to this position have been executed on the slave database
3 Relay_Master_Log_File The name of the master binary log file from which the events in the relay log file were read
4 Exec_Master_Log_Pos The equivalent position within the master's binary log file of events that have already been executed

© 著作权归作者所有

xxj123gogo
粉丝 0
博文 62
码字总数 83973
作品 0
其它
程序员
私信 提问
使用mysqldump 备份 恢复从库报错解决方案(ERROR 1872)

版本:MySQL5.7.22 一、报错现象 dba:(none)> start slave; ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository 这个时候查看error.log: 2018-0......

crazy_charles
2018/08/07
0
0
MariaDB基于GTID的复制

1、配置主从节点的服务配置文件 1.1、配置master节点: #binlog_format=mixed binlog-format=ROW # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set......

孤鸿子
2017/05/12
0
0
Mysql 5.6 GTID-主从搭建

GTID作为mysql5.6带来的新特性,在搭建replicate过程中,可以更快速方便,感觉上更加‘自动化’。 一、修改配置文件 1.修改主服务器配置文件my.cnf,添加下面的几行: 2.修改从服务器配置文件...

韩呵呵哒
2016/03/29
232
0
innodb还有没有数据丢失的情况了

:innodb还有没有数据丢失的情况了?? 设置 innodbflushlogattrxcommit = 1 以及 syncbinlog = 1,在master端就不会出现InnoDB丢数据的情况了。 如果同时还想保证slave端能和master保持一致性...

kisshua
2015/11/09
26
0
修改hostname导致mysql重启slave失败的修复方法

修改hostname导致mysql重启slave失败的修复方法 (只针对于把slave的信息存在文件里面会出现这种情况,如果存在表里就不会有这种问题发生): 有时候我们很早之前修改完主机名后,跑了好几个...

余二五
2017/11/15
0
0

没有更多内容

加载失败,请刷新页面

加载更多

java通过ServerSocket与Socket实现通信

首先说一下ServerSocket与Socket. 1.ServerSocket ServerSocket是用来监听客户端Socket连接的类,如果没有连接会一直处于等待状态. ServetSocket有三个构造方法: (1) ServerSocket(int port);...

Blueeeeeee
今天
6
0
用 Sphinx 搭建博客时,如何自定义插件?

之前有不少同学看过我的个人博客(http://python-online.cn),也根据我写的教程完成了自己个人站点的搭建。 点此:使用 Python 30分钟 教你快速搭建一个博客 为防有的同学不清楚 Sphinx ,这...

王炳明
昨天
5
0
黑客之道-40本书籍助你快速入门黑客技术免费下载

场景 黑客是一个中文词语,皆源自英文hacker,随着灰鸽子的出现,灰鸽子成为了很多假借黑客名义控制他人电脑的黑客技术,于是出现了“骇客”与"黑客"分家。2012年电影频道节目中心出品的电影...

badaoliumang
昨天
16
0
很遗憾,没有一篇文章能讲清楚线程的生命周期!

(手机横屏看源码更方便) 注:java源码分析部分如无特殊说明均基于 java8 版本。 简介 大家都知道线程是有生命周期,但是彤哥可以认真负责地告诉你网上几乎没有一篇文章讲得是完全正确的。 ...

彤哥读源码
昨天
18
0
jquery--DOM操作基础

本文转载于:专业的前端网站➭jquery--DOM操作基础 元素的访问 元素属性操作 获取:attr(name);$("#my").attr("src"); 设置:attr(name,value);$("#myImg").attr("src","images/1.jpg"); ......

前端老手
昨天
7
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部