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 you need from the database. However, optimizing paging operations is crucial to ensure efficient and fast retrieval of data in MySQL. So how do you…
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, we must start with a snapshot of all the data from the master database. MySQLdump is the tried-and-true method of doing this, however it requires…
This article is from 2006. MySQL has come a long way since then. MySQL 5.5 is very robust and feature-rich, matching Oracle in many different areas including datatypes, stored procedures and functions, high availability solutions, ACID compliance and MVCC, hot backups, cold backups and dumps, full text, and other index options, materialized views and much more. Here’s a high-level…
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 the best applicants. Whatever the case, interviewing for a MySQL DBA is a skill in itself so I thought I’d share a guide of top…
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 the data warehouse space, you have Hadoop, which can churn through terabytes of data and get you results back before lunchtime! So, when I stumbled…