Tag: standby

nginx four-layer tcp load balancing and active and standby, four-layer udp load balancing and active and standby, 7-layer http load balancing and active and standby configuration (wndows system active and standby, load balancing)

Preparation Prepare two centos7 computers, virtual machines can also be used Use vmware17 to build centos7 mini version server on windows-CSDN Blog Set up a static IP address (because the network load balancing manager on the Windows server does not support dhcp servers) Modify the network card IP address in ky10, centos7 and other linux […]

Oracle active/standby switchover, ogg recovery method (classic mode)

Foreword: This article mainly introduces how to recover the ogg process (classic mode) running in the main database and standby database when the Oracle database physical ADG primary and backup switches (switchover, failover). Test recovery scenario: 1 A switchover occurs between the active and standby devices, and the main database is the ogg source. 2 […]

89. How to ensure that all data in the MySQL main database has been written to the standby database

1. First, when the main library stops writing, the position of the main library binlog pos will no longer change. “root@localhost Fri Nov 3 22:15:53 2023 22:15:53 [test]”>show master status; + —————– + ———- + ————– + —– ————- + ———————————— ——- + | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | + […]

SQLServer export files, separate databases, active and standby and cluster

1. Export 1.1 Use SSMS tool to export database files as SQL scripts Please refer to this website for details: Export SQLserver database tables and data_sqlserver export table data_fyhs’ blog-CSDN blog 1.2 Use SSMS tool to export a single table to an Excel file (1) Right-click the database (2) Select Task->Export Data (3) Select data […]

nebula-br local-store mode, quick practice of building active and standby clusters

Because the online graph database is currently a single cluster, the amount of data is relatively large, and it has the following disadvantages: Single point of risk. Once the cluster crashes or some queries bring down the entire cluster, all graph operations will be affected. Many optimization classes are difficult to perform but will affect […]

RocketMQ active and standby automatic switching mode deployment

RocketMQActive and backup automatic switching mode deployment In this mode, one node will be elected as the Master node, and the remaining nodes will be Slave nodes. Environment preparation Machine Description 192.168.232.138 (Machine A) NameServer, Controller, Broker 192.168.232.139 (Machine B) NameServer, Controller, Broker 192.168.232.140 (Machine C) NameServer , Controller, Broker 192.168.232.141 (machine D) Broker NameServerDeployment […]

centos7 deployment and configuration MySQL8 stand-alone, active and standby

This article is a continuation of my previous article. The preliminary server and virtual machine configuration are in the previous article. This article mainly explains the deployment of mysql8. Previous link: Super super nanny-level teaching–commonly used Linux deployment and operation and maintenance–from deployment to maintenance (you can learn it if you know the words!!!)-CSDN blog […]

RECOVER managed standby database finish ADG stops recovery processing OMF datafile copy Switch to copy

Backup library switching alter database commit to switchover to physical standby with session shutdown; //Switch to standby mode shutdown immediate startup mount select switchover_status from v$database; //Check status alter database recover managed standby database disconnect; //Enable standby application recovery mode select switchover_status from v$database; //Check the status again Switch to main library alter database commit […]

He3DB-deployment cluster (3) standby node deployment

Previous step: He3DB-deployment cluster 2) Master node deployment 1. Deploy He3DB standby node 1 1. Copy the files under pgdata_sp to pgdata_s1 in node1 cp -a /home/postgres/data/pgdata_sp/* /home/postgres/data/pgdata_s1/ cd /home/postgres/data/pgdata_s1/ rm -rf base global postmaster.pid ln -sf /home/postgres/data/pgdata_sp/base base ln -sf /home/postgres/data/pgdata_sp/global global 2. Enter the following command on node1 to configure the conf file […]