emGee Software Solutions Custom Database Applications

Share this

MySQL Server Blog

News from the MySQL Server Team
Updated: 37 min 13 sec ago

Geographic Spatial Reference Systems in MySQL 8.0

17 hours 50 min ago

MySQL 8.0.11 comes with a catalog of 5108 spatial reference system (SRS) definitions, and 479 of these are geographic. We usually just refer to them by SRID, but in this blog post we’ll dive into the details and try to understand the definition itself.…

Categories: Web Technologies

MySQL 8.0: MVCC of Large Objects in InnoDB

Tue, 05/22/2018 - 02:58

In this article, I’ll explain about the multi version concurrency control (MVCC) of large objects (LOBs) design in the MySQL InnoDB storage engine.  MySQL 8.0 has a new feature that allows users to partially update large objects, including the JSON documents.  …

Categories: Web Technologies

Changes in MySQL 8.0.11 (General Availability)

Thu, 05/17/2018 - 23:59

The MySQL Development team announced the General Availability of MySQL 8.0 on April 19th, 2018. Here we follow up with references to worklogs that were added in 8.0.11. Note the jump in version number from 8.0.4 (RC2) to 8.0.11 (GA) explained here.…

Categories: Web Technologies

MySQL 8.0: InnoDB Introduces LOB Index For Faster Updates

Tue, 05/15/2018 - 04:49

To support the new feature Partial Update of JSON documents, InnoDB changed the way it stored the large objects (LOBs) in MySQL 8.0. This is because InnoDB does not have a separate JSON data type and stores JSON documents as large objects.…

Categories: Web Technologies

MySQL 8.0: InnoDB now supports Instant ADD COLUMN

Wed, 05/09/2018 - 07:17

Instant DDL has been one of the most requested InnoDB features for a very long time. With ever larger and rapidly growing datasets the ability to do DDL instantly is a must have feature in any web scale database.  Developers constantly need to add new columns to meet the constantly changing business requirements.  …

Categories: Web Technologies

MySQL InnoDB Cluster Tutorial Videos

Mon, 05/07/2018 - 12:06

We just published a series of 4 video tutorials about our native, full-stack, out-of-the-box and easy to use High Availability and Scaling solution for MySQL: InnoDB Cluster!

If you want to see the new MySQL Shell 8.0 in action to create a MySQL InnoDB Cluster and try it out yourself, just take a look!…

Categories: Web Technologies

Geographic Indexes in InnoDB

Fri, 05/04/2018 - 00:07

One of the big features of MySQL 8.0 is geography support. MySQL now has a catalog of spatial reference systems (SRSs), of which almost 500 are geographic. Most functions also support geographic computations. What about indexes?

MySQL 8.0 comes with InnoDB spatial indexes for geographic data.…

Categories: Web Technologies

MySQL Shell 8.0 – What’s New?

Thu, 05/03/2018 - 09:53
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.…

Categories: Web Technologies

Axis Order in Spatial Reference Systems

Thu, 05/03/2018 - 02:53

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

Categories: Web Technologies

Geography in MySQL 8.0

Wed, 05/02/2018 - 01:18

MySQL 8.0.11 comes with a catalog of 5108 spatial reference systems (SRSs): 4628 projections (flat maps), 479 geographic (ellipsoidal) representations of Earth, and one Cartesian all-purpose abstract plane (SRID 0).


Projected SRSs are Cartesian planes, just like SRID 0.…

Categories: Web Technologies

Spatial Reference Systems in MySQL 8.0

Mon, 04/30/2018 - 05:08

MySQL 8.0 brings a lot of new spatial features. The main feature is the support for multiple spatial reference systems (SRSs).

Spatial reference systems is not a new concept in MySQL, but 8.0 is the first version where it affects computations, and it’s the first version where users actually have to think about it.…

Categories: Web Technologies

New JSON functions in MySQL 5.7.22

Thu, 04/26/2018 - 11:21

A number of new JSON functions have been added to MySQL 8.0. Since we appreciate that not everyone will be ready to upgrade to MySQL 8.0 the minute it is released, we have backported many of the new functions to MySQL 5.7 so that they are available starting with version 5.7.22.…

Categories: Web Technologies

MySQL InnoDB Cluster 8.0 – A Hands-on Tutorial

Tue, 04/24/2018 - 02:27

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

Categories: Web Technologies

Upgrading to MySQL 8.0 : Default Authentication Plugin Considerations

Mon, 04/23/2018 - 11:03

If you are upgrading your server to MySQL 8.0 and observe that your application is experiencing error related caching_sha2_password plugin, it is likely because your clients/connectors does not (yet) support caching_sha2_password plugin. To resolve this issue, you may consider using mysql_native_password as default authentication for MySQL 8.0 server.…

Categories: Web Technologies

MySQL InnoDB Cluster – What’s new in the 8.0 GA Release

Mon, 04/23/2018 - 02:50

The MySQL Development Team is proud to announce the second GA release of InnoDB cluster!

We listened carefully to the feedback we got from the previous major release (1.0 GA) and the last release candidate (8.0.4 RC) and incorporated many of the suggested changes.…

Categories: Web Technologies

MySQL InnoDB Cluster 8.0 GA is Available Now!

Mon, 04/23/2018 - 02:49

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.
Categories: Web Technologies

MySQL 8.0 – Announcing GA of the MySQL Document Store

Thu, 04/19/2018 - 06:23

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


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

Categories: Web Technologies

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

Thu, 04/19/2018 - 06:00

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.
Categories: Web Technologies

MySQL 8.0: From SQL Tables to JSON Documents (and back again)

Tue, 04/17/2018 - 02:01

One of the nice things about MySQL 8.0 is the ability to combine the relational and document models. As a developer, you can choose to work with traditional SQL tables, with schemaless JSON documents, or with both types at the same time.…

Categories: Web Technologies

MySQL 8.0 Regular expressions and character properties

Wed, 04/11/2018 - 04:00

In MySQL 8.0 we have replaced the old regular expression library with the ICU regex library.  See Martin’s blog on the topic. The main goal is to get full Unicode support for regular expressions, but in addition we get a lot of neat features.…

Categories: Web Technologies