No Image

MySQL 8.0: InnoDB now supports Instant ADD COLUMN

2018-05-09 KENNETH 0

MySQL 8.0: InnoDB now supports Instant ADD COLUMN 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.  … Source: MySQL 8.0: InnoDB now supports Instant ADD COLUMN

No Image

MySQL InnoDB Cluster Tutorial Videos

2018-05-08 KENNETH 0

MySQL InnoDB Cluster Tutorial Videos 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!… Source: MySQL InnoDB Cluster Tutorial Videos

Geographic Indexes in InnoDB

2018-05-04 KENNETH 0

Geographic Indexes in InnoDB 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.… Source: Geographic Indexes in InnoDB

No Image

MySQL Shell 8.0 – What’s New?

2018-05-04 KENNETH 0

MySQL Shell 8.0 – What’s New? 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.… Source: MySQL Shell 8.0 – What’s New?

Axis Order in Spatial Reference Systems

2018-05-03 KENNETH 0

Axis Order in Spatial Reference Systems 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).… Source: Axis Order in Spatial Reference Systems