There are many reasons why MySQL is still the most used and preferred open source database. We’ll look at why many companies, unicorns, and today's world biggest online companies like Facebook, Twitter, and Booking.com chose to rely on MySQL.
This webinar will go over the top 10 reasons why MySQL remains the number one open source database. It will cover the many business benefits of selecting MySQL for your organization.
MySQL 8.0 has several new features of interest to developers using MySQL as their database. The first is the new data dictionary where all the metadata about the database is store in the database instead of scattered around the filesystem.
- There are Common Table Expressions to ease the burden of writing subqueries, windowing functions for analytics, lateral derived tables to make your SQL more powerful.
- There is better JSON support including a new JSON bulk data loader in the new shell.
- The MySQL Document Store that provides a way for developers to use MySQL without having to set up relations, indexes or tables before storing and retrieving data. Plus an improved optimizer, a contention aware scheduler that provides much better performance when you have hot rows or columns in your data, invisible indexes, optimizer hints, and resource groups to let you manage your queries better.
- And that does not cover the improvements in locking, histograms, or the new default UTF8MB$ character set.