devxlogo

Database Development Zone

Database Performance Tuning (Step-by-Step Guide)

Database Performance Tuning (Step by Step Guide)

Start with a clean model of performance You feel a slowdown, users complain, dashboards spike. Before you touch a single knob, define the goal in plain terms. Database performance tuning

Image

MySQL vs. MariaDB

Many developers have used MySQL, while they have only heard of MariaDB. Let’s explore the differences between these two database management systems. History MySQL and MariaDB share common history. MySQL

Image

Using Python for Big Data Analysis

It’s no surprise that big data?is becoming an integral part of any business conversation. Desktop and mobile search are providing data to marketers and companies around the world on an

Image

Introduction to Facebook GraphQL

GraphQL is a data query language used by Facebook since 2012 that was recently open sourced. It was designed to expose hierarchical data and make it easier for front-end developers

Image

Container Orchestration with Docker Swarm

Containers eat the DevOps world. Docker is leading the pack with the ubiquitous Docker engine runtime and a plethora of related tools. In this article, I provided some basic information

Image

Backup and Restore Using Amazon S3 API

In terms of data security, it is a good practice to backup your server’s files to an external location. At a rate of $3 per 100 GB of storage, Amazon

Image

Working with Triangular Joins

Set-based solutions are always faster than loops in SQL, right? Usually?that is true but not always. A good example would be if you wanted to create a running total of

Image

MySQL Master Slave Replication

In high-traffic Web applications, a master-slave database architecture is used to optimize performance by separating read and write operations and to prevent loss of data in case of a server