Why should choose MySQL 5.7?

Currently, there are many organizations and individuals who choose MySQL 5.7 to deploy their management system and applications. You may also be interested in why they choose MySQL 5.7?
First, let's take a look at the history of development to learn more about MySQL. MySQL is a database management system (DBMS), first published by MySQL AB on May 23, 1995. Over the years of ups and downs with many different owners like MySQL AB (1995 – 2007), Sun MicroSystems (February 2008 – January 2010), and now Oracle (January 27, 2010), MySQL has raised level, improve and release many different versions, many people choose.
MySQL Version
After 20 years of efforts to develop and enter the information technology community, MySQL has now become a popular and popular database management system. MySQL database is the most popular choice for web applications, e-commerce, online transaction processing application (Online Transaction Processing – OLTP). With secure transaction capabilities, full integration of utilities, ease of use, scalability, increased productivity, low cost, etc., MySQL has become the most popular open source database in the world. Many of the most visited websites in the world, such as Facebook, Google, Twitter, Uber, Amazon, Digg and Booking.com, have chosen MySQL for important business applications.
According to Google Trends – 01-2015 to 03-2016
Not stopping there, MySQL continues to produce more and more complete versions. With the introduction of MySQL 5.7 October 2015, MySQL marked the success of MySQL with faster, more secure, more convenient than version 5.6.
MySQL 5.7 is designed for Web, Mobile and Cloud applications with more than 150 new features ( http://www.thecompletelistoffeatures.com ). In it, there are outstanding features:
Performance and scalability (Performance & Scalability)
1. More efficient than MySQL 5.6 to 3 times
According to statistics published on http://dimitrik.free.fr/blog/archives/cat_mysql.html , based on the number of users and Concurrent Users and the number of queries performed on 1 Seconds (Query / sec), we see that the performance of MySQL 5.7 outperforms MySQL 5.6 and earlier versions (with 1024 users, in 1 second, MySQL 5.7 currently has 1,000,000 queries while MySQL 5.6 can only perform about 300,000 queries.
 
2. Improving InnoDB
Faster loading and execution of online tasks, the ability to change the online buffer size, using ALTER TABLE RENAME INDEX not only changes meta data, sets the compressed page size to 32k / 64k, use Using Cache Retention helps 25% of buffers to be stored automatically …
Compared to MySQL 5.6, InnoDB & Memcaches in MySQL 5.7 performs a lot faster (with 1024 connections, in 1 second, MySQL 5.7 can execute up to 1,200,000 queries while MySQL 5.6 can only perform about 200,000 query).
3. MySQL Router is faster, easier and safer for Scale MySQL applications: with connection and transaction routing, easy to expand using plug-in APIs, MySQL support Fabric.
4. Replication improvement (multi-source, multi-threaded) with the implementation of migration of GTIDs (global transaction identifier) ​​online, improvement of Semi-sync performance (synchronous sale), change of set Online filtering, the speed of slave throughput increased more than 8 – 10 times, MySQL group replication helps actively update member management and errors detected …
5. New Model Optimizer Cost : control and manage larger user volume and better access performance with configuration upgrade, support for VIRTUAL and SORTED Virtual Columns, character set GB18030 …
Management (Manageability)
1. Support JSON (JavaScript Object Notation – a fast data-interchange format, independent data exchange similar to XML, based on JavaScript): with built-in functions that allow storing, searching, updating Using and manipulating Document, JSON comparator allows easy integration of Document data in SQL queries …
2. Improved security and security: create, install and configure, and manage more securely with default 256 ARES encoders, password notation policies, and usernames with 32 characters, SSL options, default server initialization SSL keys, MySQL Firewall, LOCK / UNLOCK user accounts, support for Proxy User expansion.
3. Improve My SQL Performance Scheme (a feature to monitor MySQL Server executing at low level): by adding new monitoring capabilities, reducing footprint and overhead, significantly improving usage with SYS Schema.
4. Using MySQL SYS Schema (SYS – system is the system's Schema) is a set of objects that help database administrators and programmers compile the data collected by Performance Shema. The sys scheme objects can be used to navigate and predict the usecases.
And there are many other interesting new features. Why don't you try to install and experience MySQL 5.7 right from today?
ITZone via t3h
Share the news now