lo云中_云中的mysql 8 0-优快云博客

lo云中

万岁！ (Hooray!)

The most popular and widely used open-source database finally saw its arrival on the cloud trinity two days ago when Google Cloud announced that it supports MySQL 8.0 GA on Cloud SQL. The first one to offer upgrades to MySQL 8.0 in the cloud was obviously AWS, then Azure and now Google.

两天前，当Google Cloud宣布它支持Cloud SQL上MySQL 8.0 GA时，最流行和使用最广泛的开源数据库终于在三位一体中崭露头角。第一个在云中提供对MySQL 8.0的升级的人显然是AWS，然后是Azure，现在是Google。

MySQL 8 comes with a fantastic set of features like online DDL, the much awaited window functions, enhanced JSON features, recursive common table expressions (CTEs) for hierarchical querying, default UTF8MB4 collation & encoding, soft deletes, invisible indexes, descending indexes, staged rollouts and more. Cloud SQL does provide the standard security features with an option to encrypt the data with your own keys. Both, encryption in-transit and encryption at rest are supported. You can find the list of features in the following blog post by MySQL Server Team

MySQL 8拥有一系列出色的功能，例如在线DDL，期待已久的窗口功能，增强的JSON功能，用于分层查询的递归公用表表达式(CTE)，默认UTF8MB4排序规则和编码，软删除，不可见索引，降序索引，暂存推出等等。 Cloud SQL确实提供了标准安全功能，并提供了使用您自己的密钥加密数据的选项。同时支持在途加密和静态加密。您可以在以下MySQL服务器团队的博客文章中找到功能列表

To explore the exhaustive list of features of MySQL 8.0, please visit this blogpost by MySQL Server Team.

要探索MySQL 8.0的详尽功能列表，请访问MySQL Server Team的此博客文章。

Other standard features to support BCP, such as High Availability by the way of making the system fault tolerant and having an option to replicate the same data to multiple regions. And then there’s Cloud SQL Proxy —

其他支持BCP的标准功能，例如通过使系统具有容错性并可以选择将同一数据复制到多个区域的方式来实现高可用性。然后是Cloud SQL代理-

The Cloud SQL Proxy allows a user with the appropriate permissions to connect to a Second Generation Cloud SQL database without having to deal with IP whitelisting or SSL certificates manually. It works by opening unix/tcp sockets on the local machine and proxying connections to the associated Cloud SQL instances when the sockets are used.

Cloud SQL代理允许具有适当权限的用户连接到第二代Cloud SQL数据库，而无需手动处理IP白名单或SSL证书。 通过使用本地套接字上的unix / tcp套接字并代理到关联的Cloud SQL实例的连接，它可以工作。

If you haven’t already upgraded your on-prem or cloud MySQL instance to MySQL 8, now is the time. As with every upgrade, there are a number of caveats (nothing limiting) which are well documented in the following blogposts by MySQL & SeveralNines

如果您还没有将本地或云MySQL实例升级到MySQL 8，那么现在该了。与每次升级一样，有一些警告(没有限制)，这些警告在MySQL＆Somenines的以下博客文章中都有详细记录

竞争者 (Competitors)

The closest competitor of MySQL is PostgreSQL. If you try and understand the product roadmaps for both the databases, you’ll find that both of them are aiming to do something what the other does. PostgreSQL is probably trying to implement a layer of storage engines. MySQL, on the other hand, is trying it’s best to have great JSON, array and geospatial support. MySQL finally introduced window functions. PostgreSQL has had them for years.

MySQL最接近的竞争对手是PostgreSQL。如果您尝试了解两个数据库的产品路线图，则会发现它们两个都旨在做其他事情。 PostgreSQL可能正在尝试实现一层存储引擎。另一方面，MySQL正在尝试最好地具有强大的JSON，数组和地理空间支持。 MySQL最终引入了窗口函数。 PostgreSQL已经拥有它们多年了。

There’s a controversial blogpost by Uber’s Engineering team about why they shifted to MySQL from PostgreSQL a couple of years ago. It’s a very interesting read but has had its share of criticism.

Uber工程团队有一篇有争议的博客文章，介绍了为什么几年前他们从PostgreSQL转向MySQL。这是一个非常有趣的读物，但也受到批评。

Google has accelerated it’s cloud expansion in the last couple of years with the support of great open-source tools like Airflow, Kubernetes etc. and exposing Google’s own highly scalable services like BigTable. With acquisitions like Kaggle and Looker, Google’s outlook is looking great in the years to come. All I want to say is — feel safe when you run MySQL 8.0 on Google Cloud Platform.

在过去的几年中，借助Airflow，Kubernetes等出色的开放源代码工具的支持，Google加快了其云计算的扩展，并公开了BigTable等Google自身的高度可扩展服务。通过进行Kaggle和Looker等收购，Google在未来几年的前景看起来不错。我只想说-在Google Cloud Platform上运行MySQL 8.0时要放心。

An introduction to Google Cloud SQL

Google Cloud SQL简介