请输入您要查询的百科知识:

 

词条 WebScaleSQL
释义

  1. Overview

  2. Features

  3. Availability

  4. End of Contributions

  5. See also

  6. References

  7. External links

{{Use mdy dates|date=August 2014}}{{Infobox software
| name = WebScaleSQL
| title = WebScaleSQL
| logo = WebScaleSQL logo.png
| logo caption =
| logo size = 240px
| logo alt = WebScaleSQL logo
| screenshot =
| caption =
| screenshot size =
| screenshot alt =
| collapsible =
| author =
| developer = Facebook, Google, LinkedIn, Twitter and Alibaba Group
| released =
| discontinued =
| latest release version =
| latest release date =
| latest preview version =
| latest preview date =
| frequently updated =
| status = Abandoned (last commit {{date|2015-12-28|mdy}})[1]
| programming language = C, C++, Perl and Bash
| operating system = Linux
| platform = x86-64
| size =
| language = English
| language count =
| language footnote =
| genre = RDBMS
| license = GNU GPL version 2
| alexa =
| website = {{URL|http://webscalesql.org/}}
| standard =
}}WebScaleSQL was an open-source relational database management system (RDBMS) created as a software branch of the production-ready community releases of MySQL. By joining efforts of a few companies and incorporating various changes and new features into MySQL, WebScaleSQL aimed toward fulfilling various needs arising from the deployment of MySQL in large-scale environments, which involve large amounts of data and numerous database servers.[2][3]

The source code of WebScaleSQL is hosted on GitHub and licensed under the terms of version 2 of the GNU General Public License.[4][5]

The project website announced in December 2016 that the companies involved would no longer contribute to the project.[6]

Overview

Running MySQL on numerous servers with large amounts of data, at the scale of terabytes and petabytes of data, creates a set of difficulties that in many cases arise the need for implementing specific customized MySQL features, or the need for introducing functional changes to MySQL. More than a few companies have faced the same (or very similar) set of difficulties in their production environments, which used to result in the availability of multiple solutions for similar challenges.[4][7][8]

WebScaleSQL was announced on March 27, 2014 as a joint effort of Facebook, Google, LinkedIn and Twitter (with Alibaba Group joining in January 2015[9]), aiming to provide a centralized development structure for extending MySQL with new features specific to its large-scale deployments, such as building large replicated databases running on server farms. As a result, WebScaleSQL attempted to open a path toward deduplicating the efforts each founding company had been putting into maintaining its own branch of MySQL, and toward bringing together more developers.[2][5][10]

WebScaleSQL was created as a branch of the MySQL's latest production-ready community release, which was version 5.6 {{As of|2013|3|lc=yes}}. As the project aimed to tightly follow new MySQL community releases, a branching path was selected instead of becoming a software fork of MySQL. The selection of MySQL production-ready community releases for the WebScaleSQL's upstream, instead of selecting some of the available MySQL forks such as MariaDB[11] or Percona Server,[12] was the result of a consensus between the four founding companies, which concluded that the features already existing in MySQL 5.6 are suitable for large-scale deployments, while additional features of the same kind are planned for MySQL 5.7.[2][4][5]

Features

The initial changes and feature additions that WebScaleSQL introduced to the MySQL 5.6 codebase came from the engineers employed by the four founding companies; however, the project was open to peer-reviewed community contributions.[13] {{As of|2014|9|15|df=US}}, available new features and changes included the following:[5][10][14][15][16]

  • A software framework that provides automated testing of all proposed changes
  • A customized suite of database performance tests
  • Various changes to the automated tests provided by the MySQL community releases
  • Performance improvements in various areas, including buffer pool flushing, execution of certain types of SQL queries, and support for NUMA architectures
  • Changes related to large-scale deployments, such as the ability to specify sub-second client timeouts
  • Performance and reliability improvements to the global transaction identifier (GTID)[17] feature of MySQL 5.6
  • So-called super_read_only[18] operation mode for the MySQL server, which disables data modification operations even for privileged database accounts
{{As of|2014|3|28|df=US}}, planned new features and changes included the following:[2][10]
  • New asynchronous MySQL client that will eliminate the client-side waiting while establishing database connections, sending queries, and receiving their results
  • Availability of various table, user and compression statistics
  • Changes to the internal compression mechanisms
  • Addition of a logical read-ahead mechanism that will bring significant performance improvements for full table scans

Availability

WebScaleSQL is distributed in a source-code-only form, with no official binaries available. {{As of|2014|3|27|df=US}}, compiling the source code and running WebScaleSQL is supported only on x86-64 Linux hosts, requiring at the same time a toolchain that supports C99 and C++11 language standards.[5]

The source code is hosted on GitHub and available under version 2 of the GNU General Public License (GPL v2).[4][5]

End of Contributions

In December 2016, the WebScaleSQL website announced the companies originally involved in collaborating on the project (Facebook, Google, LinkedIn, Twitter, and Alibaba) would no longer contribute to the project. The announcement blamed differences among the needs of the various companies for the end of the collaboration.

See also

{{Portal|Free and open-source software}}
  • Comparison of relational database management systems

References

1. ^{{Cite web | url = https://github.com/webscalesql/webscalesql-5.6/commits/webscalesql-5.6.27 | title = WebScaleSQL commits history | date = {{date|2016-01-22|mdy}} | accessdate = {{date|2016-12-12|mdy}}}}
2. ^{{Cite web | url = http://www.zdnet.com/webscalesql-mysql-for-facebook-sized-databases-7000027814/ | title = WebScaleSQL: MySQL for Facebook-sized databases | date = {{date|2013-03-28|mdy}} | accessdate = {{date|2014-04-01|mdy}} | author = Steven J. Vaughan-Nichols | publisher = ZDNet}}
3. ^{{Cite web | url = https://www.wired.com/2014/03/webscalesql/ | title = Google and Facebook Team Up to Modernize Old-School Databases | date = {{date|2013-03-27|mdy}} | accessdate = {{date|2014-04-01|mdy}} | author = Klint Finley | publisher = Wired}}
4. ^{{Cite web | url = https://www.theregister.co.uk/2014/03/27/webscalesql_launch/ | title = Forkin' 'L! Facebook, Google and friends create WebScaleSQL from MySQL 5.6 | date = {{date|2013-03-27|mdy}} | accessdate = {{date|2014-04-01|mdy}} | author = Jack Clark | publisher = The Register}}
5. ^{{Cite web | url = http://webscalesql.org/faq.html | title = Frequently Asked Questions | date = {{date|2014-03-27|mdy}} | accessdate = {{date|2014-04-01|mdy}} | website = webscalesql.org}}
6. ^{{Cite web | url = http://webscalesql.org/blog/2016/12/02/Moving-Forward.html | title = WebScaleSQL Moving Forward | date = {{date|2016-12-29|mdy}} | accessdate = {{date|2016-12-29|mdy}}}}
7. ^{{Cite web | url = http://code.google.com/p/google-mysql-tools/wiki/Mysql5Patches | title = Patches for MySQL 5 – MySQL tools released by Google | date = {{date|2011-06-24|mdy}} | accessdate = {{date|2014-04-01|mdy}} | website = code.google.com}}
8. ^{{Cite web | url = https://github.com/facebook/mysql-5.1 | title = facebook/mysql-5.1 | date = June 2013 | accessdate = {{date|2014-04-01|mdy}} | website = github.com}}
9. ^{{Cite web | url = http://webscalesql.org/blog/2015/01/15/Welcome-Alibaba.html | title = Please welcome Alibaba to WebScaleSQL! | date = {{date|2015-01-15|mdy}} | accessdate = {{date|2015-08-15|mdy}} | website = webscalesql.org}}
10. ^{{Cite web | url = http://www.informationweek.com/big-data/software-platforms/facebook-debuts-web-scale-variant-of-mysql-/d/d-id/1141521 | title = Facebook Debuts Web-Scale Variant of MySQL | date = {{date|2014-03-27|mdy}} | accessdate = {{date|2015-08-15|mdy}} | author = Doug Henschen | website = informationweek.com}}
11. ^{{Cite web | url = https://blog.mariadb.org/mariadb-and-webscalesql/ | title = MariaDB and WebScaleSQL | date = {{date|2014-03-29|mdy}} | accessdate = {{date|2015-08-15|mdy}} | author = Rasmus Johansson | website = mariadb.org}}
12. ^{{Cite web | url = https://www.percona.com/blog/2014/05/22/comparing-webscalesql-percona-server/ | title = A technical WebScaleSQL review and comparison with Percona Server | date = {{date|2014-05-22|mdy}} | accessdate = {{date|2015-08-15|mdy}} | author = Laurynas Biveinis | website = percona.com}}
13. ^{{Cite web | url = http://webscalesql.org/contributing.html | title = Is Your Change Appropriate? | date = {{date|2014-03-27|mdy}} | accessdate = {{date|2014-04-01|mdy}} | website = webscalesql.org}}
14. ^{{Cite web | url = https://www.phoronix.com/scan.php?page=news_item&px=MTY0NjA | title = Facebook & Others Announce WebScaleSQL | date = {{date|2014-03-28|mdy}} | accessdate = {{date|2014-04-01|mdy}} | author = Michael Larabel | publisher = Phoronix}}
15. ^{{Cite web | url = https://code.facebook.com/posts/1474977139392436/webscalesql-a-collaboration-to-build-upon-the-mysql-upstream/ | title = WebScaleSQL: A collaboration to build upon the MySQL upstream | date = {{date|2014-03-27|mdy}} | accessdate = {{date|2015-08-16|mdy}} | author = Steaphan Greene | website = code.facebook.com}}
16. ^{{Cite web | url = http://www.informationweek.com/big-data/big-data-analytics/facebook-announces-webscalesql-upgrade-for-mysql/d/d-id/1315741 | title = Facebook Announces WebScaleSQL Upgrade For MySQL | date = {{date|2014-09-15|mdy}} | accessdate = {{date|2015-08-16|mdy}} | author = Doug Henschen | website = informationweek.com}}
17. ^{{Cite web | url = https://dev.mysql.com/doc/refman/5.6/en/replication-gtids.html | title = MySQL 5.6 Reference Manual, Section 17.1.3 Replication with Global Transaction Identifiers | accessdate = {{date|2015-08-16|mdy}} | website = dev.mysql.com}}
18. ^{{Cite web | url = https://www.percona.com/doc/percona-server/5.6/management/super_read_only.html | title = Percona Server 5.6: super_read_only option | accessdate = {{date|2015-08-16|mdy}} | website = percona.com}}

External links

  • {{Official website|http://webscalesql.org/}}
  • {{Github|webscalesql/webscalesql-5.6|WebScaleSQL 5.6 source code}}
{{MySQL}}{{Database}}

6 : 2014 software|Client-server database management systems|Free database management systems|Linux-only software|MySQL|RDBMS software for Linux

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/10 16:18:53