Oracle Announces General Availability of MySQL 8.0

Posted by: Admin  :  Category: Mysql

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

MySQL adds NoSQL and many new enhancements to the world’s most popular open source database:

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

  • NoSQL – Document Store gives developers the flexibility of developing traditional SQL relational applications and NoSQL, schema-free document database applications.
  • 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 functions you can use the SQL machinery for JSON data.
  • GIS – Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial datatypes, 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 Schema, Information Schema, Invisible Indexes, Error Logging.
  • Manageability – Persistent Configuration Variables, Undo tablespace management, Restart command, and New DDL.
  • High Availability – InnoDB Cluster delivers 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

Latest News from MySQL

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

Leave a Reply

*