Database Management Archives - Page 5 of 6

How to Optimize Paging in MySQL? 3 Best Ways

August 14, 2023 / BY Nolan Granger

Paging or pagination is a common requirement for almost all web applications where all the documents are divided into discrete pages. This is the easiest way to select only what …

Easy MySQL Replication With Hotbackups

August 14, 2023 / BY Nolan Granger

Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, …

Top MySQL DBA Interview Questions (Part 1)

August 14, 2023 / BY Nolan Granger

MySQL DBAs are in greater demand now than they’ve ever been. While some firms are losing the fight for talent, promising startups with a progressive bent are getting first dibs with …

WILL SQL JUST DIE ALREADY?

August 12, 2023 / BY Nolan Granger

With tons of new No-SQL database offerings every day, developers & architects have a lot of options. Cassandra, Mongodb, Couchdb, Dynamodb & Firebase to name a few. What’s more in …