Data Management

Oracle Gives You Better Database Performance with MySQL 5.7

MySQL TCO Savings Calculator.

MySQL has always been known for its high performance, ready scalability and high reliability.  So, it is really no surprise that the open source database is the most popular in the world.

Oracle, however, has been able to improve on an already good thing.

On March 31, 2014, Oracle announced that they have just made Development Milestone Release for MySQL 5.7 available.  Oracle said that the new release is aimed at meeting the heavy demands of cloud, embedded and Web applications.  The software giant also indicated that the new release would make MySQL even more reliable, even more high performing and even more scalable than ever before.  Further, management functions were also improved.

MySQL 5.7 is faster and more scalable

The new release comes with throughput and performance enhancements for SSDs or solid state disks and better InnoDB metadata locking and buffer pool.  Semi-synchronous replication has also been improved.  How much faster is the current release?  Tests show that the new release is twice as fast as MySQL 5.6 and thrice as fast as MySQL 5.5.

MySQL 5.7 is more manageable

The new release includes some enhancements to the optimizer so you have better and more accurate cost computations, while the performance schema now has additional instrumentations and other improvements.  The new release also has better security with new options to manage your passwords and the inclusion of AES (advanced encryption standard) 256-bit encoding.

Improved availability

MySQL Fabric, one of MySQL Utilities in the latest release, gives you high availability by giving you a way to automatically detect failures, as well as giving you a way to shard data that you can use to scale out.  You could also get MySQL Workbench 6.1 that allows you to use tools to assess performance and optimize queries.

Other improvements in MySQL 5.7

Moreover, Oracle announced that they have also released other MySQL related tools and features, adhering to their philosophy of releasing enhancements and improvements early and often.

If you are using Microsoft SQL Server now, you can use MySQL Workbench to make your migration to MySQL a painless and easy process.

Also, take advantage of other MySQL 5.7 features such as GIS improvements, and better multi-source replication.  You could further expect faster node restarts with the MySQL Cluster 7.4 performance improvements.

It is very clear that Oracle is committed to innovating and developing MySQL by steadily providing releases that enhance MySQL’s scalability, performance and reliability, as well as manageability.

Ready to try it out?  Download it from here: //dev.mysql.com/downloads/mysql/5.7.html

If you have questions about MySQL or if you are having doubts about migrating to MySQL, check out the range of Oracle consulting services that Four Cornerstone offers.  We can also train your MySQL administrator with all the finer points of administering your MySQL systems.  All it takes is just one call to us and we can provide you with the best solutions you would find anywhere.

Contact us now and maximize your IT and Oracle investments!

Photo by MySQL.

Uncategorized

Performance Boost in MySQL 8.0.35…

Oracle has recently published interesting performance numbers that show MySQL 8.0.35 Enterprise Edition about 25%, or higher, faster than MySQL Community Edition.   A great...

Keep Reading

Uncategorized

Security Trends For 2024: SBOMs

A recent article on Forbes, linked below, lists five security trends that are likely to be important in 2024. Of course, AI-related security topics top...

Keep Reading

Uncategorized

Getting started with your first…

Anyone looking at writing their first Generative AI application should read this to save time. In June 2023, Google Cloud published a useful blog post,...

Keep Reading

Uncategorized

Read-Write and Read-Only query splitting…

Optimize the usage of the standby (secondary) read-only MySQL InnoDB Cluster servers by automatically and transparently distributing read-queries to them. A great feature in MySQL...

Keep Reading

Uncategorized

Considering Cloud Diversification?

Moving an enterprise to a Public Cloud can quickly feel like moving into a locked-in relationship with the Cloud vendor. One solution to diminish this...

Keep Reading

Uncategorized

Gartner: Global cloud consumption will…

Gartner forecasts that 2024 will see a 20% global cloud consumption increase from 2023 to $679B, while 2023 has seen an 18% increase from 2022...

Keep Reading

Uncategorized

ByteDance: Use AI for tuning…

ZDNet is reporting that a ByteDance (the maker of TikTok) Linux kernel developer has proposed to implement AI to tune the performance of Linux systems...

Keep Reading

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Live Chat | Emergency