Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
It is the era of Data. Nobody would dare to disagree. People may have different opinion about the storage solutions and architecture, but no matter what, they will agree …
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. A typical scenario is to …
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 credentials for smoother installation The …
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 doesn’t contain Index . Rebalance …
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. You may want to read …
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 and key pair, that Cloudera …
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 replication section. Note :- Version …
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 be helpful. With this method, …
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-5f6f1b8793189663297532/] 2:- Add OS user [crayon-5f6f1b879318e001734161/] 3:- Go to MySQL installation path …
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 as a bug on the …
Read More »