MySQL Terminology Updates

栏目: IT技术 · 发布时间: 5年前

内容简介:It’s been 20 years since MySQL Replication was introduced in MySQL 3.23.15 (Released in May 2000). Since then, virtually every MySQL Database deployment in production has been using Replication in order to achieve high availability, disaster recovery, read

It’s been 20 years since MySQL Replication was introduced in MySQL 3.23.15 (Released in May 2000). Since then, virtually every MySQL Database deployment in production has been using Replication in order to achieve high availability, disaster recovery, read scale out and various other purposes.

Anyone using MySQL Replication is familiar with the terms: “master” and “slave”. The origins of these words are negative. That is clear.  At MySQL, we made the decision to change this terminology.  Already, many of us have changed how we refer to these roles in blogposts and presentations — usually using terms like “primary”, “secondary”, “source”, and “replica”.  We have now started the process of changing the MySQL syntax in our source code and documentation to match this.

Our latest products already rely on the use of Primary/Secondary to define different roles servers can have in the database architecture:

  • MySQL Group Replication
  • MySQL InnoDB Cluster
  • MySQL InnoDB ReplicaSet

The following terminology changes will be implemented in all MySQL products in upcoming releases:

Old New
master source
slave replica
blacklist blocklist
whitelist allowlist

Why was “source” chosen? MySQL Asynchronous Replication is a change stream. Each replication configuration has a source and does not imply what role a server should have in the overall database architecture. Therefore, the use of e.g. “primary” does not fit, especially when replication is used to build database architectures topologies including bidirectional replication, multi-tiered replication, or even circular replication.

It will take some time to make these changes. One quick way to remove some of the syntax would be to add aliases for the existing commands, e.g. SHOW SLAVE STATUS becoming SHOW REPLICA STATUS . That is not enough, many of these commands return results with column names that include the text “master” and “slave”.

Completely removing the use of these legacy terminologies is a huge undertaking.

To retain backwards compatibility, some of these terminologies need to be deprecated first and then later removed. It is important that we make the new syntax eg. SHOW REPLICA STATUS the recommended syntax and not merely an ‘alternative’ syntax.

It is impossible to remove all references in one release. There are millions of deployments of MySQL we have to keep on supporting. It will take several iterations to deprecate and/or remove these terminologies from our syntax, protocol, error messages, source code…

Earlier this week, the documentation team published the first phase of terminology changes in the MySQL 8.0 documentation.

Training & Certification and forthcoming MySQL product releases will incorporate gradual changes to the terminology as well.

— The Oracle MySQL Team

1,505 total views,  1,505 views today


以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

产品经理修炼之道

产品经理修炼之道

费杰 / 机械工业出版社华章公司 / 2012-7-30 / 59.00元

本书由资深产品经理、中国最大的产品经理沙龙Pmcaff创始人费杰亲自执笔,微软、腾讯、百度、新浪、搜狐、奇虎、阿里云、Evernote等国内外20余家大型互联网企业资深产品经理和技术专家联袂推荐。用系统化的方法论和丰富的实战案例解读了优秀产品经理所必须修炼的产品规划能力、产品设计能力、产品执行能力,以及思考、分析和解决问题的能力和方法,旨在为互联网产品经理打造核心竞争力提供实践指导。 全书一......一起来看看 《产品经理修炼之道》 这本书的介绍吧!

Markdown 在线编辑器
Markdown 在线编辑器

Markdown 在线编辑器

正则表达式在线测试
正则表达式在线测试

正则表达式在线测试

RGB CMYK 转换工具
RGB CMYK 转换工具

RGB CMYK 互转工具