PHP Developer News

Choose a category: Blogs CMS Database Frameworks Web View All

Database News

Debezium MySQL Snapshot For AWS RDS Aurora From Backup Snaphot

Debezium MySQL Snapshot For AWS RDS Aurora From Backup Snaphot

2nd January, 2020 by in Database

I have published enough Debezium MySQL connector tutorials for taking snapshots from Read Replica. To continue my research I wanted to do something...

Q & A on Webinar “Top 3 Features of MySQL”

Q & A on Webinar “Top 3 Features of MySQL”

3rd January, 2020 by in Database

First I want to thank everyone who attended my December 19, 2019 webinar “Top 3 Features of MySQL“. Recording and slides are available on...

How to Create Your Own Repositories for Packages

How to Create Your Own Repositories for Packages

3rd January, 2020 by in Database

For Linux, the most common way to distribute software is binary packages in the rpm or deb format. Most packages are included in the official...

Using pt-heartbeat with ProxySQL

Using pt-heartbeat with ProxySQL

3rd January, 2020 by in Database

ProxySQL and Orchestrator are usually installed to achieve high availability when using MySQL replication. On a failover (or graceful takeover)...

Automating the SQL Database Mirroring setup

Automating the SQL Database Mirroring setup

31st December, 2019 in Database

Database mirroring setup without any DBA effort - on every new Database creation.

MySQL Commercial Yum Repo Extended

MySQL Commercial Yum Repo Extended

31st December, 2019 by in Database

Many things in the MySQL 8.0 Series has evolved. I’ve discussed many of those things in prior blogs such as items like the MySQL-Router w/InnoDB...

Debezium MySQL Snapshot From Read Replica And Resume From Master

Debezium MySQL Snapshot From Read Replica And Resume From Master

31st December, 2019 by in Database

In my previous post, I have shown you how to take the snapshot from Read Replica with GTID for Debezium MySQL connector. GTID concept is awesome,...

Rank Data with SQL

Rank Data with SQL

30th December, 2019 in Database

In this puzzle, we’re going to work through a problem to identify the top and bottom 25 percent to rank student scores. Solving puzzles is...

Return the first rows from your result.

Return the first rows from your result.

30th December, 2019 in Database

In this video we’ll walk you though how to select top rows within a query.   We’ll show you how to retrieve the top or bottom rows...