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 »Cloudera manager installation on google cloud
To deploy Cloudera Manager and CDH on an Google Compute VM instance, begin by creating an environment. The environment defines common settings, like region …
Read More »Point in time recovery on Mongodb Standalone server.
1:- Enable oplog using –master option while starting mongod service [Version 3.2]. And later version (3.2 +) need to put replSetName=rs0 into the mongo.conf file in …
Read More »Create Server Login(Do not type a password in web config)
As a high-level security measure in SQL Server, if you do not want application developers to know the application’s user password, this article will …
Read More »How to do MySQL binary installation.
You can download the MySQL binary files from below link. https://downloads.mysql.com/archives/get/file/mysql-5.7.21-el7-x86_64.tar.gz 1:- Add OS group [crayon-67807f9425e37119601411/] 2:- Add OS user [crayon-67807f9425e3b566075614/] 3:- …
Read More »RMAN DBGMISC: ENTERED krmkmrsr
ERROR: In Oracle 11g r2 database rman crashes during exit and gives error like DBGMISC: ENTERED crmkmrsr. REASON: Inconsistency in NLS settings. (This is specified …
Read More »