Synopsis of Mydbops 19th edition of MyWebinar

Thank you to everyone who joined us for the 19th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community in the coming days by presenting more LIVE events.

Recently, Mydbops conducted a webinar on the top 10 features of MySQL 8. MySQL is one of the most popular and widely used open-source relational database management systems. With every new version, MySQL brings new features and enhancements that make it more reliable, secure, and efficient. In this blog, we will wrap up the top 10 features of MySQL 8 discussed in the webinar by Mydbops.

Vinoth Kanna, co-Founder from Mydbops was successful in making this event more interactive, engaging, and, most importantly, productive for the audience. Thank you for your continuous contribution to the opensource community.

Topic: Top 10 features in MySQL 8.0

Date: February 11th, 2023

Time: 11 AM IST

The most important key takeaways are:

Atomic DDL, transaction data dictionary in MySQL 8:

Atomic DDL and transactional Data Dictionary are two features in MySQL 8 that enhance the reliability and manageability of the database system. Atomic DDL ensures that DDL statements are executed as a single, atomic operation, which helps to prevent data inconsistencies if an error occurs during a DDL operation. The transactional Data Dictionary ensures that changes to the Data Dictionary are executed as a single transaction, which makes it easier to manage and maintain the Data Dictionary.

Improving performance of InnoDB components ensuring ACID:

Improving InnoDB performance while maintaining the ACID properties in MySQL 8 requires a combination of best practices, including using the latest version of MySQL, optimising the buffer pool size, enabling the Adaptive Hash Index, using compression, enabling multi-threaded compaction, and monitoring performance metrics. By following these best practices, database administrators can optimise InnoDB’s performance and ensure reliable and consistent data processing.

Redolog enhancements

Undolog enhancements

Doublewrite buffer enhancements

Improving Security

Controllable and complete encryption

Clone plugins

DDL Improvements:

Instant DDL (Data Definition Language) allows performing certain DDL operations without locking the table. It enables schema changes without disrupting the application’s availability.

Query performance enhancements and so much more!!

After which the speakers had a detailed demo and a quick Q&A session.

In case you were unable to attend, or would like to re-watch the webinar at your leisure, Please follow the link below: