Questions tagged [Replication] (72)

1
answer

Replication from MySQL to SQL Server. If you want to use?

The last few years to replicate live data use Oracle Golden Gate, maybe there are some simpler alternatives.
Gage67 asked April 19th 20 at 12:41
1
answer

99%, automatic replication PostgreSQL/MySQL?

Saw that there are 2 types of replication: Master-Master and Master-Slave. Here and there I had a permanent human presence. For example. In Master-Slave went to the Master and Slave becomes Master, but he himself does not realize that it's time to become Master? And when the old Master will arise, he will not realize that h...
consuelo.Prohaska asked April 19th 20 at 11:53
0
answer

How to switch mysql slave master replication multiple databases?

Good day, dear All. The task is to transfer more of the loaded websites to another server with minimal downtime. As the database uses Mysql (Percona 8.0). Established replication between the old and new server using the GTID, database synchronized. I want to, alternately, translating the database from slave to master, mov...
whitney_MacGyver0 asked April 18th 20 at 12:34
1
answer

Why Active Directory has not replicated all the division between the domain controllers?

Good afternoon. Noticed that on domain controllers vary the number of divisions, although replication shows that there are no errors. On the PDC, where all five FSMO roles most units. The same units on another domain controller. The other two domain controllers have fewer units and they are for example no OU Microsoft Exch...
furman asked April 8th 20 at 02:03
1
answer

How to change the path to the postgresql log for a working replica?

Hello! Test the possibility of replication on postgresql. Has created a replica, everything is replicated. But it does not have postgresql.conf, there is only postgresql.auto.conf, in which it is undesirable to make changes manually. But I wanted to change the target file to output a log file, not pg_log/postgresql-%a.log...
gennaro.Corwin70 asked April 4th 20 at 14:12
1
answer

How to organize the database replication with one and the same name in Postgres?

Hello, you have multiple servers with the same name databases on Postgres, is it possible to have replication of these databases on a single server and a slave will not be any conflict in connection with the same database name?
tanya18 asked April 4th 20 at 13:56
1
answer

Proper configuration of MySQL replication master+master + slave?

There are two Mysql server configured at each other in Master-Master replication. Need to connect another slave to one of the servers in read-only mode. How to do it correctly, nothing is broken. Replication master master, master slave set up the idea
Jazmyn_Hand26 asked April 3rd 20 at 17:47
1
answer

How to set maxscale for multi-master cluster?

Good afternoon. Need help. There is a cluster mysql percona master-master (3 replicas). Need it set a maxscale. Maxscale config:[maxscale] threads=auto [db1] type=server address=172.31.6.70 port=3306 protocol=MariaDBBackend [db2] type=server address=172.31.6.252 port=3306 protocol=MariaDBBackend [db3] type=server addres...
Darryl_Kunde asked March 31st 20 at 21:53
1
answer

How to organize synchronous replication PostgreSQL database on geographically remote servers?

Good day! Immediately say, that in PostgreSQL I was a newbie. There are 2 remote server with PostgreSQL on Board. Different local addresses (192.168.1.x and 192.168.100.y), but can see each other through the l2tp tunnel + IPsec. You need to make it so that when you write to one DB, the same record is replicated to another ...
deshaun_Harris16 asked March 29th 20 at 20:43
1
answer

How to make PostgreSQL replication and load balancing workloads write and not read?

Hi all. It is necessary to raise the base on k8s (but not important), which is a record. In the near, near future it's planned 16K records per second and 1K readings per minute. Schemes of load distribution record is not found, except as a Warm Standby, which will save the situation in case of breakup, but found the unloa...
jerald93 asked March 27th 20 at 12:37