MySQL Shell 8.0 – What’s New?

MySQL Document Store

In MySQL 8.0 a new stack of components is introduced, turning MySQL to a competitive Document Store solution.

The MySQL Document Store takes advantage of existing capabilities including:

  • Efficient and safe data management from the InnoDB storage engine
  • ACID compliance and Transactional Operations
  • High Availability with Group Replication and InnoDB cluster

One of the most attractive components introduced in MySQL 8.0 is a development API (DevAPI) that enables you to create JSON document based applications through a fluent API.…

Axis Order in Spatial Reference Systems

MySQL 8.0 has many new GIS features, including a catalog of spatial reference systems (SRSs) and support for geographic (latitude-longitude) computations.

In a Cartesian SRS, it doesn’t really matter which coordinate is on which axis. The axes are orthogonal and the units are the same on both axes, so if a user consistently puts the X value in the Y coordinate and the Y value in the X coordinate, it doesn’t affect computations (in the functions MySQL currently supports).…

MySQL InnoDB Cluster 8.0 – A Hands-on Tutorial

MySQL InnoDB Cluster has proven with the first GA release its potential as the native out-of-the-box HA solution for MySQL. With the second GA release, usability, stability and flexibility were greatly improved as described in the previous blog post.

This tutorial aims to show how does a typical InnoDB cluster setup look like and how that setup even became simpler and more effective as before.…

MySQL InnoDB Cluster 8.0 GA is Available Now!

The MySQL Development Team is proud and happy to announce the General Availability release of InnoDB Cluster 8.0! This is an extremely exciting release of our integrated, native, full stack High Availability (HA) solution for MySQL.

InnoDB Cluster provides an out-of-the-box and easy to use built-in HA and Scaling solution for MySQL by tightly integrating the following GA components:

  • MySQL 8.0.11+ Servers with Group Replication, to provide the data replication mechanism within InnoDB clusters, ensuring fault tolerance, automated failover, and elasticity.

MySQL 8.0 – Announcing GA of the MySQL Document Store

In this blog I’ll explain the big wins that come with the MySQL Document Store in the MySQL 8.0 GA.

Basically

SQL + NOSQL
= Winning Combination
= Relational + Document Store + Hybrid
= Big Win For Devs
= Big Win for DBAs
= Big Win for Data Analysts
= Big Win for LOB owners

First, let’s start by considering some modern software facts

  • Move faster, change rapidly
  • Time to market is critical
  • Rapid prototyping, iterate fast and frequently
  • Relational Models ask for schema up front
  • Potentially saving time later
  • Less variation, less code for edge cases
  • Easy to run in-depth analytics
  • Document Models do not ask for a schema
  • Saves time up front
  • Often adds operational costs in the long term
  • Getting Analytics from the data can be way more work
  • Most popular NoSQL database use similar data structures to relational databases (B+TREE)
  • No inherent scalability advantages
    Yet behind on key functionality
  • Standing up multiple database technologies adds complexity for operations teams

Customers continually tell us they want to simplify their data infrastructure.…