Questions tagged [database-replication]

Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.

Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending (and potentially re-sending until successfully applied) of subsequent updates.

1836 questions
0
votes
1 answer

Spring+Hibernate: read/write different datasource and thousands mysql databases

I need to use separate reader/writer MySQL servers. One writer and one (or more) read replica. What is the best way to do this? I found a lot of examples: http://www.dragishak.com/?p=307 Use special JDBC driver:…
martin
  • 1,707
  • 6
  • 34
  • 62
0
votes
1 answer

SQL Server Replication with Publication and Subscriptions not working as it requires the actual server name to make a connection

I have a Computer / SQL Server machine that ALL software ( 500 applications) know as TMPSQL2 So on this TMPSQL2 machine I have a Database that I want to setup replication with doing Publication. Problem is that SQL Server is unable to connect…
user6321478
0
votes
1 answer

Stop BDR from replicating DROP TABLE or CREATE TABLE

I have two databases with tables that I want to sync. I don't want to sync any other table. I'm using Postgres-BDR to do that. Those tables are part of replication set common. There are some circumstances where other tables share a name across nodes…
0
votes
0 answers

create a pull subscription to transactional publication that uses FTP snapshot delivery in SQLServer Management Studio

I've created a publisher that uses FTP snapshot delivery method using SSMS. However, when I tried to configure Subscriber, I couldn't find option to use FTP credentials. I read "To create a pull subscription to a snapshot or transactional…
Ash
  • 1,180
  • 3
  • 22
  • 36
0
votes
1 answer

Unable to start mysql after changing replicate do table on master

Master was running with the following: server-id=1 log-bin = /opt/bitnami/mysql/data/mysql_bin.log replicate-wild-do-table=my_database I thought I could just simply change to: log-bin =…
0
votes
0 answers

nodejs driver - reconnect slow when PRIMARY GOES DOWN

I want to know how does nodejs driver behave when PRIMARY GOES DOWN. Issue db.shutdownServer() on Primary "SECONDARY" become Primary right away. But driver takes at least 11 second hanging before issuing another write command again. I test with…
0
votes
0 answers

RDS: Replication Error

Good Day, Today I got this problem on our database replica. Read Replica Replication Error - IOError: 1236, reason: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from position…
Henry
  • 1
  • 1
0
votes
1 answer

MongoDB data sync geographically to different AWS accounts

I am very new to both MongoDB and AWS cloud technologies. I am currently trying to configure MongoDB to allow data replication and sync between instances of two different AWS account. Also, I have been reading some doc from official MongoDB website…
0
votes
1 answer

MariaDB Galera Cluster not replicate data after crash

I setup galera cluster on two different server and sync them as a master-master replication. SERVER CONFIGURATION Debian GNU/Linux 7 500 GB HDD Lets say example i have two servers. Server A and Server B ISSUE Now due to some reason if server A…
H.Patel
  • 1
  • 1
0
votes
1 answer

Synchronization one table from general database to another database on another servers

I need to have one "General login database", with few columns (ID, Pass, User, IP). Users came to site, enter their data (they can chage password\username, and they ip can be changed), all this changes goes to "General Login DB". And i have 2…
Amaroc
  • 179
  • 1
  • 2
  • 9
0
votes
1 answer

Does MongoDB (2.6 or 3.x) lock on updates until all replica set members verify the writes

Given a replica set with 3 data bearing members, and MongoDB 2.6.3 (I'm also interested in the behavior of later versions if they differ) and a default write concern: Does MongoDB (2.6 or 3.x) lock on updates until all replica sets verify the…
Antonius Bloch
  • 2,311
  • 2
  • 14
  • 14
0
votes
1 answer

How can I limit the MySQl replication to 2 slaves out of 3?

I am on Linux platform with MySQL 5.7. I have 3 MySQL Slaves and 1 MySQL Master and replication is working perfectly. I want to do experiments such that in my first experiment, Master only replicate data to 1 slave, in second experiment, Master…
0
votes
1 answer

Table schema affect on transactional replication performance

We've implemented transactional replication (push model) over a WAN and are sometimes seeing slow-downs during bulk updates of a specific table (ie. we are seeing a high number of 'commands not replicated' for that specific table). The table in…
0
votes
0 answers

Replication - Is it possible to publish to different servers?

I use mssqlserver08 with ssms, and want to publish tables to two different servers. One server is used to run my application, the other is used to backup data, and the tables' schema are the same. 1.Is it possible to publish same tables to…
0
votes
1 answer

Read from mongodb secondary node when no connection with primary

We have mongodb replica set with 3 instances, where Primary is in datacenter D1, and secondary nodes on datacenter D2. We dont need any failover option in our setup, and configured it as described at…