It is a great today for whole MySQL community: MySQL 8.0 was just released as GA!
Geir Høydalsvik has a great summary in his “What’s New in MySQL 8.0” blog post. You can find additional information about MySQL 8.0 Replication and MySQL 8.0 Document Store that is also worth reading.
If you can’t wait to upgrade to MySQL 8.0, please make sure to read the Upgrading to MySQL 8.0 section in the manual, and pay particular attention to changes to Connection Authentication. It requires special handling for most applications.
Also keep in mind that while MySQL 8.0 passed through an extensive QA process, this is the first GA release. It is not yet as mature and polished as MySQL 5.7. If you’re just now starting application development, however, you should definitely start with MySQL 8.0 — by the time you launch your application, 8.0 will be good.
All of us at Percona – and me personally – are very excited about this release. You can learn more details about what we expect from it in our Why We’re Excited about MySQL 8.0 webinar recording.
We also wrote extensively about MySQL 8.0 on our blog. Below are some posts on various features, as well as thoughts on the various RCs, that you might want to review:
- One Million Tables in MySQL 8.0: Creates one million tables in MySQL 8.0 and tests the performance
- MySQL 8.0 RESOURCE_GROUP Overview: Provides an overview of the new MySQL 8.0 RESOURCE_GROUP feature
- MySQL 8.0 Window Functions: A Quick Taste: Briefly looks at window functions in MySQL 8.0
- New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go: A look at the MySQL 8.0 innodb_dedicated_server variable
- MySQL 8.0.4 RC: auth_socket Users Beware: Dangers lie in wait for users of the auth_socket plugin.
- MySQL 8.0: Descending Indexes Can Speed Up Your Queries: Discusses descending indexes in MySQL 8.0
- MySQL 8.0 General Tablespaces: File per Database (and no FRM files): Looks at MySQL 8.0 general tablespaces
- MySQL 8.0: The end of MyISAM: Discusses the gradual end of MyISAM in MySQL
- Thoughts on MySQL 8.0.3 RC – The First MySQL 8.0 Release Candidate
- 7 Fresh Bugs in MySQL 8.0
- MySQL 8.0
The best way to learn about MySQL 8.0, though, is to attend the Percona Live Open Source Database Conference 2018, taking place in Santa Clara, CA next week. We have an outstanding selection of MySQL 8.0 focused talks both from the MySQL Engineering team and the community at large (myself included):
- MySQL InnoDB Cluster in a Nutshell: The Saga Continues with 8.0 – Frédéric Descamps (Oracle)
- InnoDB Tutorial for MySQL 8.0 – Peter Zaitsev (Percona)
- MySQL Performance Schema in Action – Sveta Smirnova (Percona), Alexander Rubin (Percona)
- The Full MySQL (5.6, 5.7 and 8.0) and MariaDB (10.0 and 10.1) Parallel Replication Tutorial – Jean-François Gagné (Booking.com)
- State of the Dolphin 8.0 – Tomas Ulin (Oracle)
- What Are the Main New Key Features in MySQL 8.0? – Geir Høydalsvik (Oracle)
- MySQL Replication: What’s new in MySQL 5.7 and MySQL 8 – Luis Soares (Oracle)
- MySQL 8.0 Performance: Scalability and Benchmarks – Dimitri Kravtchuk (MySQL/Oracle)
- MySQL 8.0: What’s New in InnoDB? – Sunny Bains (Oracle)
- MySQL 8.0: What is New in Optimizer and Executor? – Manyi Lu (Oracle)
- MySQL 8.0: a Document Store with all the benefits of a transactional RDBMS – Frédéric Descamps (Oracle), Dave Stokes (Oracle)
- MySQL Group Replication – Ready For Production? – Kenny Gryp (Percona)
You can still get tickets to the conference. Come by and learn about MySQL 8.0. If you can’t make it, please check back later for slides.
Done reading? Go ahead go download MySQL 8.0 and check it out!