The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. With the release of MySQL 8, a notable enhancement was introduced to the auto-increment counter. Compared to MySQL 5.7, this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. In this article, we will look into this enhancement, compare MySQL 5.7 with MySQL 8, and provide practical examples to demonstrate the differences.

Auto-increment in MySQL 5.7

In MySQL 5.7, the auto-increment counter works as follows: when a new row is inserted into a table with an auto-increment column, the counter increments by 1, and the generated value is used for the primary key of the inserted row. This counter value is stored in memory and is not persistent across server restarts. As a result, if the server …

Where can you find MySQL team in September 2023

With the short work week due to the US Labor Day holiday on last Monday, I barely got this week’s OpenLampTech newsletter out. But, here it is in all its glory. Thanks for reading.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #95, there is great content on:

• An OpenLampTech text-based developer interview
• WebAssembly and PHP
• Laravel Transactions …

MySQL 8.2.0 introduces a new authentication plugin: authentication_webauthn. The plugin allows usage of a FIDO U2F/FIDO2 compatible device to achieve Multi-factor Authentication OR Passwordless Authentication with MySQL server. This plugin supersedes existing authentication_fido plugin which is marked as deprecated in 8.2.0. authentication_webauthn supports both FIDO U2F and FIDO2 devices. FIDO2 devices have discoverable credentials support […]

In MySQL server 8.2.0, we have made certain changes to promote usage of secure and robust ciphers in MySQL server. If you are relying on the default cipher settings in MySQL server and client, you can stop here. These changes will not have any impact on your usecase. On the other hand, if you have […]

In recent years, Linux has witnessed an impressive increase in popularity as a robust and reliable operating system that caters to a diverse range of users, from casual enthusiasts to seasoned software developers. As Linux continues to gain ground across various industries, there's a growing need for software tools and applications originally designed for Windows environments to be installed and utilized on the Linux platform.

The post How to Run dbForge Studio for MySQL on Ubuntu With Wine appeared first on Devart Blog.

in this article, You’ll learn How to export data from MySQL to Excel using PHP and phpspreadsheet, I have already shared the article without any third-party libs Exporting Data from MySQL to Excel using PHP. PhpSpreadsheet is a powerful open-source PHP library that allows developers to work with spreadsheet files, particularly Microsoft Excel formats (such […]

The post Export MySQL to Excel with PHP and PhpSpreadsheet appeared first on Phpflow.com.

Oracle CloudWorld 2023 is coming very soon and as usual there are plenty of MySQl related talks. My talk is MySQL High Availability and Disaster Recovery. What specifically will I be talking about? MySQL High Availability & Disaster Recovery @ CloudWorld 2023 MySQL InnoDB Cluster and MySQl InnoDB ClusterSet provide a complete solution for high availability and disaster […]

MySQL High Availability and Disaster Recovery [LRN2386] at CloudWorld 2023

Percona University Online has released a new free course, “MySQL 5.7 End of Life Options – Free Course at Percona University Online,” by Dave Stokes, Technical Evangelist at Percona. 

Dave is the author of MySQL & JSON – A Practical Programming Guide. He started to work with MySQL from the 3.29 version and was a part of the MySQL Community Team for over a decade.

MySQL 5.7 reaches its End of Life in October 2023. The Era of MySQL 5.x will be over, and only MySQL 8.0 will be officially supported. Learn how to keep your database secure and performant after that date and what real options you have if you decide to upgrade or stay on the current version. 

This course consists of eight short videos. Pass a brief quiz on Google Classroom afterward to receive a Certificate of Completion from Percona. The …