Here comes another MySQL release, and together with it, a set of new replication features. As usual, we would like to summarize them. And, also as usual, follow up blogs will provide further details.
… Tweet Share
Dear MySQL users,
MySQL Shell 8.0.19 is a maintenance release of MySQL Shell 8.0 Series (a
component of the MySQL Server). The MySQL Shell is provided under
Oracle’s dual-license.
MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and
5.7. Please upgrade to MySQL Shell 8.0.19.
MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server. It provides APIs implemented in JavaScript and Python that
…
The MySQL Development team is proud to announce version 8.0.19 of the MySQL Shell, with the following features:
MySQL InnoDB ReplicaSet
Similar to MySQL InnoDB Cluster (based on Group Replication), this release of the Shell introduces the MySQL InnoDB Replicaset which provides an easy to use management solution for MySQL Replication.…
Facebook Twitter LinkedIn
Dear MySQL users,
The MySQL developer tools team announces 8.0.19 as our General
Availability
(GA) for MySQL Workbench 8.0.
For the full list of changes in this revision, visit
https://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152
The release is now available in source and binary form for a
number of
platforms from our download pages at:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!
A few days ago I wrote about how grossly outdated statistics returned through MySQL’s Information_Schema can be. In that post, Øystein Grøvlen suggested taking a look at mysql.innodb_table_stats and mysql.innodb_index_stats as a better source of information. Let’s do just that!
Let’s start with the good news. Unlike MySQL Data Dictionary Tables (mysql.table_stats, etc), mysql.innodb_table_stats and mysql.innodb_index_stats can be queried by the user. They also contain a lot of interesting statistics. Before we get to that though, let’s examine where those tables come from in more detail.
As the manual tells us, these tables are storing …
[Read more]
Dear MySQL users,
MySQL Connector/NET 8.0.19 is the latest General Availability
release of
the MySQL Connector/NET 8.0 series. This version supports .NET
Core 3.0
and the X DevAPI, which enables application developers to write
code
that combines the strengths of the relational and document models
using
a modern, NoSQL-like syntax that does not assume previous
experience
writing traditional SQL.
To learn more about how to write applications using the X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/index.html.
For more
information about how the X DevAPI is implemented in
Connector/NET, see
http://dev.mysql.com/doc/dev/connector-net.
NuGet packages provide functionality at a project …
The MySQL Development Team is thrilled to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.19!
This release sets the bar higher, by introducing a new integrated solution based on a very well known Replication technology – MySQL InnoDB ReplicaSet!…
Facebook Twitter LinkedIn
During this webinar, we will review the MySQL 8.0 upgrade process. In this deep dive session, we will review the latest version of MySQL 8.0, discuss upgrade challenges, bugs, gotchas and how to successfully upgrade to MySQL 8.0. Please join Percona Senior Technical Manager Alkin Tezuysal on Thursday, January 16th at 9 am EST for his webinar “How to Upgrade to MySQL 8 Like a Boss”.
If you can’t attend, sign up anyway and we’ll send you the slides and recording afterward.
Following MySQL InnoDB Cluster as our first, fully integrated MySQL High Availability solution based on Group Replication, MySQL Shell 8.0.19 includes MySQL InnoDB ReplicaSet which delivers another complete solution, this time based on MySQL Replication.
The basic idea for InnoDB ReplicaSet is to do the same for classic MySQL Replication as InnoDB Cluster did for Group Replication.…
Facebook Twitter LinkedIn
In this blog post series, we will discuss an overview of Vitess technology. Vitess is a database clustering solution for horizontal scaling of data sets currently suitable to 250Gb – 300Gb in sizes*. It’s a proven technology used by several web-scale companies including YouTube. PlanetScale is the company behind developing and supporting this open-sourced project.
Introduction to Vitess
Here’s high-level Vitess architecture visually explained.
Ref: Sugu Sougoumarane presents an overview of Vitess at Highload in Moscow.
Basic Vitess Components
There are two main components of Vitess. One of them is vtgate which works as a query router where vttablet is a proxy to MySQL to serve the data.