In the world of databases, some developers try to build database-independent applications, especially using ORMs (object-relational mappers). On the surface this seems like a great option, build your application to use only standard components and features, and then you can easily move to a different platform when requirements dictate. Unfortunately, things are not quite 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…
Deploying in the Amazon cloud is touted as a great way to achieve high scalability while paying only for the computing power you use. How do you get the best scalability from the technology? In this article, we have explained three ways to boost your cloud scalability. Let’s explore them below. 3 Ways to Boost…
Scalability should be the primary concern in the ever-evolving landscape of technology and business. It helps increase the ability of the system without decreasing the performance. Previously, we have discussed 5 things toxic to scalability. In this article, we will go deeper into five more things that can pose a threat to scalability. Let’s explore…
We already know that the Amazon Elastic Compute Cloud (EC2) is a widely used cloud computing service that offers scalable and flexible virtual server resources. But do you know how to deploy on Amazon EC2 with Vagrant? While deploying on Amazon EC2 traditionally, it requires manual configuration and setup. You can streamline this process by…
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…