Software update: MySQL 8.0

Apr

21

2018

MySQL is a powerful open source database server that is especially popular as a website and forum database. Tweakers.net also uses MySQL to store user data, statistics and various review, news and news articles. The developers have released version of the 8.0. For more information about the improvements in the 8.0 release, please refer to this page . Oracle has included the following announcement:

Announcing General Availability of MySQL 8.0
MySQL adds NoSQL and many new enhancements to the world’s most popular open source database:
NoSQL Document Store gives developers the flexibility of developing traditional SQL relational applications and NoSQL, schema-free document database applications. This eliminates the need for a separate NoSQL document database.
SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms.
JSON Extended syntax, new functions, improved sorting, and partial updates. With JSON table you can use the SQL machinery for JSON data.
GIS Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial data types, spatial indexes, and spatial functions.
Reliability DDL statements have become atomic and crash safe, meta-data is stored in a single, transactional data dictionary
Observability Performance Scheme, Information Schedule, Invisible Indexes, Error Logging.
Manageability Persistent Configuration Variables, Undo tablespace management, Restart command, and New DDL.
High Availability InnoDB Cluster provides an integrated, native, HA solution for your databases.
Security OpenSSL improvements, new default authentication, SQL Roles, breaking up the super privilege, password strength, authorization.
Performance Up to 2x faster than MySQL 5.7.
MySQL logo (620 pix)

Version number 8.0
Release status Final
Operating systems Windows 7, Linux, BSD, macOS, Solaris, Windows Vista, Windows Server 2008, Windows Server 2012, Windows 8, Windows 10
Website
Oracle
Download
https://dev.mysql.com/downloads/mysql/8.0.html
License type GPL

In: Technology & Gadgets Asked By: [18476 Red Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »


Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]