MySQL :: Developer Zone

:

: 2

MySQL 8.0: Optimizing Small Partial Update of LOB in InnoDB
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...

INPLACE upgrade from MySQL 5.7 to MySQL 8.0
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. …

Where you can find MySQL in June
As follow up to the previous message posted on June 4, 2018 please find below the shows where you can find MySQL during June this year: DataOps in June 21-22, 2018 in Barcelona, Spain ​MySQL is a Community sponsor of this event where our colleague Fred Descamps, the MySQL Community...

Using –login-path with MySQL Cluster Manager
Protective convenience Recent versions of MySQL has an added security feature, the –login-path option. This feature puts your username and password in an encrypted file, and you refer clients to this file instead of typing plain text passwords on the console, or putting them in...

Busy week for MySQL - where you can find us!
This week is going to be a bit busy for MySQL team. We are going to be present at four conferences in Europe and two in the US. Please find them below: ​International PHP Conference, Berlin Germany, June 4-8, 2018 This time we are going to have a booth on the Bronze level in the expo...

Getting started with MySQL Cluster 7.6 using MySQL Cluster Manager 1.4.6
MySQL Cluster 7.6 is GA! If you’re eager to give the recently announced MySQL Cluster 7.6 GA a spin, I’ll walk you through a quick and simple way to get started using MySQL Cluster Manager 1.4.6. Bootstrap and go! Download and install MCM and MySQL Cluster Bootstrap a cluster with...

MySQL Cluster 7.6 is now Generally Available
Bernd Ocklin | MySQL Cluster Engineering Director It gives us great pleasure to announce that the 7.6 release of MySQL Cluster is GA and now ready for prime time.  MySQL Cluster is a distributed database combining linear scalability and high availability. An...

Creating Your Own Spatial Reference Systems in MySQL 8.0
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.…