emGee Software Solutions Custom Database Applications

Share this

MySQL Server Blog

News from the MySQL Server Team
Updated: 1 day 1 hour ago

The MySQL 8.0.12 Maintenance Release is Generally Available

Fri, 07/27/2018 - 11:10

The MySQL Development team is very happy to announce that MySQL 8.0.12, the first 8.0 Maintenance Release, is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release, most notably the InnoDB instant add column feature. …

Categories: Web Technologies

MySQL Shell 8.0.12 – storing MySQL passwords securely

Fri, 07/27/2018 - 05:00

MySQL Shell 8.0.12 introduces a new feature which allows users to store and automatically retrieve their MySQL account credentials. This enables them to seamlessly work with various servers without explicitly providing the password for each new connection and create secure unattended scripts which do not need to include plain text passwords.…

Categories: Web Technologies

MySQL Guide to Ports

Mon, 07/09/2018 - 12:44

There could be from one to over ten ports used within your MySQL ecosystem.  It really depends on what you have enabled, which components you are using, how your applications connect, and other characteristics of your environment.

From a security point, these ports need to be opened just wide enough to allow the various components  that should communicate to talk while blocking out anything else trying to hack its way in – the goal being to enforce the security principle of “least privilege”. …

Categories: Web Technologies

MySQL 8.0: Support for BLOBs in TempTable engine

Thu, 07/05/2018 - 20:27

In some cases, the server creates internal temporary tables while processing statements. These tables could be stored in memory or on disk – the first option is preferred but there exist some limitations. One of such restrictions was presence of TEXT or BLOB columns in the table; as in-memory storage engines (MEMORY and TempTable) did not supported these types server had to use the on-disk engine (InnoDB or MyISAM).…

Categories: Web Technologies

Audit Log’s JSON format logging

Thu, 07/05/2018 - 00:08

Blood, sweat, tears and the JSON format logging is finally supported by the Audit Log plugin. This comes in pair with the feature that allows to read log events, which could be useful for rapid analysis of the audit log trail without the need of accessing the files directly.…

Categories: Web Technologies

Upgrading to MySQL 8.0 with Spatial Data

Mon, 07/02/2018 - 02:54

The big change from MySQL 5.7 to 8.0 when it comes to spatial data, is the support for multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs are ignored, and all computations are Cartesian.…

Categories: Web Technologies

Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0

Thu, 06/28/2018 - 10:01

There are many changes to spatial functions in MySQL 8.0:

The first two are failing cases.…

Categories: Web Technologies

Upgrading to MySQL 8.0? Here is what you need to know…

Mon, 06/25/2018 - 07:16

In my previous blog post, I had described the steps to perform an in-place upgrade for upgrading from MySQL 5.7 to MySQL 8.0. In this blog post, I will discuss about the considerations that needs to be taken into account while upgrading to MySQL 8.0

The general in-place upgrade requirement is that MySQL 8.0 will understand the disk image produced by MySQL 5.7. …

Categories: Web Technologies

The connection_control plugin : Keeping brute force attack in check

Wed, 06/20/2018 - 06:31

To quote book of all knowledge:

In cryptography, a brute-force attack consists of an attacker trying many passwords or passphrases with the hope of eventually guessing correctly. The attacker systematically checks all possible passwords and passphrases until the correct one is found.…
Categories: Web Technologies

MySQL 8.0: New Lock free, scalable WAL design

Mon, 06/18/2018 - 00:40

The Write Ahead Log (WAL) is one of the most important components of a database. All the changes to data files are logged in the WAL (called the redo log in InnoDB). This allows to postpone the moment when the modified pages are flushed to disk, still protecting from data losses.…

Categories: Web Technologies

MySQL 8.0: Optimizing Small Partial Update of LOB in InnoDB

Tue, 06/12/2018 - 08:39

In this article I will explain the partial update optimizations for smaller (LOBs) in InnoDB. Small here qualifies the size of the modification and not the size of the LOB.  For some background information about the partial update feature, kindly go through our previous posts on this (here, here and here).…

Categories: Web Technologies

INPLACE upgrade from MySQL 5.7 to MySQL 8.0

Fri, 06/08/2018 - 04:33

MySQL 8.0 General Availability was announced in April and it comes with a host of new features. The overview about the new features and improvements made in MySQL 8.0 can be found in the following blog.

The server can be upgraded by performing either an INPLACE upgrade or LOGICAL upgrade. …

Categories: Web Technologies

Creating Your Own Spatial Reference Systems in MySQL 8.0

Fri, 06/01/2018 - 04:21

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). And if for some reason that isn’t enough, we can create our own.…

Categories: Web Technologies

Upgrading Spatial Indexes to MySQL 8.0

Wed, 05/30/2018 - 09:34

MySQL has had spatial indexes for many years, but they have all been Cartesian (X and Y coordinates) indexes. MySQL 8.0 adds support for geographic (latitude-longitude) indexes. In an earlier blog post, I described how the feature works. In this post, we’ll go into the details of how to upgrade from 5.7 to 8.0 if you have spatial indexes.…

Categories: Web Technologies

Projected Spatial Reference Systems in MySQL 8.0

Mon, 05/28/2018 - 02:40

MySQL 8.0.11 comes with a catalog of 5108 spatial reference system (SRS) definitions. In a previous post, we covered the definitions of geographic SRSs. In this post we’ll go into the details of projected SRSs. (If you haven’t done so already, I suggest you read the previous post first.)

Projected SRSs are flat, Cartesian coordinate systems created by projecting points on (an oblate spheroidal model of) Earth onto a flat surface.…

Categories: Web Technologies

Geographic Spatial Reference Systems in MySQL 8.0

Fri, 05/25/2018 - 01:37

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