PHP Developer News

Choose a category: Blogs CMS Database Frameworks Web View All

Database News

MySQL Shell 8.0.23 – What’s New?

MySQL Shell 8.0.23 – What’s New?

28th January, 2021 by in Database

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

Load Balancing ProxySQL in AWS

29th January, 2021 by in Database

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

MySQL Join Tutorial

27th January, 2021 by in Database

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

Import CSV file with MySQL Workbench

27th January, 2021 by in Database

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

5.6 Goes Deep-Six

28th January, 2021 by in Database

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 Enables –lock-ddl by Default

28th January, 2021 by in Database

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

Announcing Vitess 9

26th January, 2021 by in Database

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

A 250x improvement to tablespace truncation in MySQL Server 8.0.23

26th January, 2021 by in Database

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

Replicate from MySQL 5.7 to MySQL Database Service

26th January, 2021 by in Database

MySQL Replication is a very common topology, widely used in various architecture. People use it, among others, for High Availability, Read Scalability...