PHP Developer News
Database News
MySQL Shell 8.0.23 – What’s New?
The MySQL team is proud to announce the general availability of version 8.0.23 of the MySQL Shell. In addition to a considerable number of bugs...
Load Balancing ProxySQL in AWS
There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual...
MySQL Join Tutorial
Some believe the most important part of SQL is the ability to query data. Queries typically retrieve data by joining many tables together into...
Import CSV file with MySQL Workbench
CSV imports with MySQL Workbench, is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying...
5.6 Goes Deep-Six
When MySQL 5.6 went GA back in 2013, it was a major milestone for MySQL, with a large number of improvements and new features in areas such...
Percona XtraBackup 8 Enables –lock-ddl by Default
Percona XtraBackup 8.0.23 enables the “lock-ddl” option by default to ensure any DDL events do not corrupt the backups. Any DML events continue...
Announcing Vitess 9
On behalf of the Vitess maintainers team, I am pleased to announce the general availability of Vitess 9. Major Themes # In this release, we...
A 250x improvement to tablespace truncation in MySQL Server 8.0.23
In MySQL Server 8.0.23 an improvement was made to InnoDB that allows truncation and deletion of all tablespaces to be faster. In fact, making...
Replicate from MySQL 5.7 to MySQL Database Service
MySQL Replication is a very common topology, widely used in various architecture. People use it, among others, for High Availability, Read Scalability...