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.…

What’s New in MySQL 8.0? (Generally Available)

We proudly announce General Availability of MySQL 8.0. Download now! MySQL 8.0 is an extremely exciting new version of the world’s most popular open source database with improvements across the board. Some key enhancements include:

  1. SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms.

MySQL Shell 8.0.4: Introducing “Upgrade checker” utility

MySQL 8.0 brings a lot of exciting new features and improvements. To make sure that your 5.7 system is ready for an upgrade there are certain steps you should take, described in our documentation: upgrade prerequisites. To make this process as quick and easy as possible we are introducing in MySQL Shell version 8.0.4 new utility called “Upgrade checker” (UC).…