PHP Developer News
Most Popular in Database
MySQL Shell Dump how to deal with array arguments in non-interactive mode
How to copy a Schema using MySQL Shell Dump & Load Utility ?
Database News
How to optimize slow INSERT queries in MySQL
At some points, many of our customers need to handle insertions of large data sets and run into slow insert statements. This article will try...
InnoDB Data Locking – Part 4 “Scheduling”
In this blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are...
How to copy a Schema using MySQL Shell Dump & Load Utility ?
Another common question I receive about MySQL Shell Dump & Load Utility is how to dump a schema and load it with another name. Make a copy...
How to Replicate Securely and in Real-Time From MySQL to Amazon Redshift
Amazon Redshift has been providing scalable, quick-to-access analytics platforms for many years, but the question remains: how do you get the...
MySQL Shell Dump how to deal with array arguments in non-interactive mode
As you know, the best way to perform logical dump for MySQL is to use MySQL Shell Dump & Load utilities. This is the most powerful option...
Online DDL with Group Replication In Percona Server for MySQL 8.0.22 (and...
While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL is executed...
Percona Distribution for MySQL: High Availability with Group Replication...
This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on...
Medium Cross Post – Write Code to Write About Code
Any of you who read my blog posts here regularly know I am passionate about SQL, PHP, and Back-end Development. I consider writing an integral...
Percona Distribution for MySQL: High Availability with Group Replication...
This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on...