PHP Developer News

Choose a category: Blogs CMS Database Frameworks Web View All

Database News

How to optimize slow INSERT queries in MySQL

How to optimize slow INSERT queries in MySQL

18th April, 2021 by in Database

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”

InnoDB Data Locking – Part 4 “Scheduling”

16th April, 2021 by in Database

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 ?

How to copy a Schema using MySQL Shell Dump & Load Utility ?

16th April, 2021 by in Database

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

How to Replicate Securely and in Real-Time From MySQL to Amazon Redshift

15th April, 2021 by in Database

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

MySQL Shell Dump how to deal with array arguments in non-interactive mode

15th April, 2021 by in Database

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 MySQL 8.0.23)

Online DDL with Group Replication In Percona Server for MySQL 8.0.22 (and...

16th April, 2021 by in Database

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 solution

Percona Distribution for MySQL: High Availability with Group Replication...

14th April, 2021 by in Database

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

Medium Cross Post – Write Code to Write About Code

14th April, 2021 by in Database

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 Solution

Percona Distribution for MySQL: High Availability with Group Replication...

14th April, 2021 by in Database

This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on...

1 2 3 4 5 Last