Introduction
Now that Galera Cluster 5.7 GA has been released, let’s take a look at some features in MySQL 5.7 that improve Galera performance or allow new workloads and applications to be Galera-enabled.
Spatial indexes come to InnoDB and Galera
Previously, only MyISAM tables could have indexes on spatial columns. Starting with 5.7, it is now possible to use spatial indexes with InnoDB tables as well. This way applications in the areas of GIS, geo-location, mapping, etc. can take advantage of Galera replication for their spatial data.
CREATE TABLE geometry_table (
geometry_column GEOMETRY NOT NULL,
SPATIAL INDEX(geometry_column)
) ENGINE=InnoDB;
It is also possible to migrate existing spatial data stored in MyISAM or replicated using traditional asynchronous replication to InnoDB and Galera.
JSON support
If you have previously considered using another database …
[Read more]