PostgreSQL has few feature for standby technology. I generally use streaming replication. This is very easy and confident. Streaming replication use a replication user for replication operations.Streaming replication allows a standby server to stay more up-to-date than is possible with file-based log shipping. The standby connects to the primary, which streams WAL records to the…
Search Results for: ssh-keygen
Oracle 19c R3 Active Data Guard Installation on Oracle Linux 7.7
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
Oracle 12c R2 (12.2.0.1) Real Time Apply Data Guard Installation on Oracle Linux 7.3
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
PostgreSQL Hot Standby (Streaming Replication) Database Installation and Failover Operations
PostgreSQL has few feature for standby technology. I generally use streaming replication. This is very easy and confident. Streaming replication use a replication user for replication operations.Streaming replication allows a standby server to stay more up-to-date than is possible with file-based log shipping. The standby connects to the primary, which streams WAL records to the…
Oracle 12c R2 (12.2.0.1) RAC Installation Steps on Oracle Linux 7.3
Oracle Real Application Clusters (Oracle RAC) is a clustered database infrastructure of Oracle Database based on a comprehensive high-availability stack that can be used as the foundation of a database cloud system as well as a shared infrastructure, ensuring high availability, scalability, and agility for any application. Oracle Real Application Cluster has been using with…
SSH Connectivity Configuration For Cluster Nodes on Oracle Linux
SSH connectivity configuration provides connection among nodes without using password. If you configure ssh, nodes can connect with ssh without password. SSH configuration parameters are in path which is /home/username/.ssh/ . You have to make SSH configuration in connection user’s home directory. For example if you use oracle user for ssh connection, you have to…