Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Replication: Replication is a way of copying and distributing data and database objects from master to slave servers. These databases are synchronized to maintain …
Read More »Best practice to avoid duplicate entry errors on the slave
In a Master/Slave replication data consistency is a biggest concern and is very easy to break your replication with issues such as duplicate keys, missing …
Read More »Setup a simple MySQL Master Slave Replication
– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not …
Read More »Fragmentation on MongoDB databases
Fragmentation on MongoDB databases When we removing a large amount of data from the collection and no plan to replace it, we generate a …
Read More »Sybase Server HealthCheck Commands With Explanation
It will display current running processes: [crayon-684be0b28adbc684435424/] It will display processes which is running by “dbmaint” user id: [crayon-684be0b28adc1292703271/] It will display databases …
Read More »5 Reasons why Couchbase will be your perfect NoSQL solution
It is the era of Data. Nobody would dare to disagree. People may have different opinion about the storage solutions and architecture, but no …
Read More »PostgreSQL pg_rewind
Introduction : – pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters’ timelines have diverged. …
Read More »How to install MySQL using RPM packages on Linux
The following article is about the installation of MySQL Server on Linux Machine(RHEL) using RPM Packages. 1) Login to the OS using the root …
Read More »Change Data directory and index_path to specific directory path if cluster is built using rolling method
Total Time to perform Activity is: 2hr The following are the high level Steps from DB side: Step 1: Disable Auto-Failover Remove node which …
Read More »Sliding Window-Switch Partition-Split Range-Merge Range
Before you read this article, you need to know what the concept of partition is and how can we create partition for a table. …
Read More »