1. Quick Comparison While SQL databases are insanely useful tools, their monopoly in the last decades is coming to an end. And it’s just time: I can’t even count the things that were forced into relational databases, but never really fitted them. (That being said, relational databases will always be the best for the stuff…
In a MySQL Replication based system, How to migrate a master database to another server/host? Scenario in short goes: dump out master databases, import data on the new master server and point slave to the new master server. If you follow this simple steps, master migration should proceed without problems. Export databases from the master server Stop replication…
When you are using MySQL, you will (likely) have tables that can be fragmented. Fragmented tables in mysql needs to be optimized. You could simply OPTIMIZE every table in every database, but during an OPTIMIZE, the tables are locked, so writing is not possible. To minimize the time that MySQL will be locked (and results…
The 2 major types of table storage engines for MySQL databases are InnoDB and MyISAM. To summarize the differences of features and performance: InnoDB is newer while MyISAM is older. InnoDB is more complex while MyISAM issimpler. InnoDB is more strict in data integrity while MyISAM is loose. InnoDB implements row-level lock for inserting and updating while MyISAM implements table-level lock. InnoDB has transactions while…
Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets. This article shows how to install Redis to work with Linux-based PHP development environment. Installation and Configuration Download and install Redis [root@signals phpredis-master]# wget…
This excellent article talks about database performance on very big system at Twitter and Paypal. The article is originated from iTnews.com.au Driving big performance using MySQL Engineers at Twitter, Paypal have joined Facebook in offering a look under the hood of the massive MySQL deployments that drive their web services. Database and application engineers at both…
This article mentions common problems when performing pagination on a big data set and solutions to overcome them. Scenario When querying with a large dataset, we often use SELCT …. ORDER BY a,b,c LIMIT M, N , but do we know how does this query perform? Let’s look at the explain query: mysql> EXPLAIN SELECT…
This post explains how to add a new slave to the existing MySQL replication. New slave server can be added to the MySQL replication without stopping master or shutting down existing slave server. You will have to temporarily stop replication on the slave server in order to take the current data snapshot. On the other…
This tutorial describes how to setup MySQL replication. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync….
There is no excerpt because this is a protected post.