Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Yesterday in one of our mongodb databases developer asked for unshard a sharded collection. Yes it is possible to unshard a sharded collection but …
Read More »MongoDB
Restore a Sharded Cluster with Database Dumps in MongoDB
Before restoring database dumps to new servers we need to install MongoDB on each system. Step 1: Installation: [crayon-67427b7f20734121522258/] inside it: [crayon-67427b7f20738340559747/] [crayon-67427b7f2073a193431685/] …
Read More »Automatizing backup process on sharded clusters
In sharded replicas before backup process you need to disable balancer and when backup finishes you need to enable the balancer. This process doesn’t …
Read More »Back Up a Sharded Cluster with File System Snapshots
In MongoDB we can take backups with database dumps or filesystem snapshots. In large databases it is recommended to use file system snapshots rather …
Read More »Replica set health
Replication lag Typically, in our replica sets, we monitoring the replication lag, that is a measure of who far a secondary is behind the primary: …
Read More »