You may already know that when the mysqldump client utility performs logical backups, it produces a set of SQL statements that you can execute to reproduce the original database object definitions and table data. Although it dumps one or more MySQL databases for backup or transfer to another SQL server, there are 5 things that…
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…
