Stack Overflow
Stack Overflow

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

SQL 2008 R2 p2p replication alternate

The requirement. Establish 3 global data centers (sites) and direct users to their closest site based on a Cisco Global Site Selector. If site 1 goes down all site 1 traffic will be direct to site 2. If a user from site 1 travels to site 2 or 3 they…
gombala
  • 83
  • 1
  • 6
0
votes
1 answer

Replication Mysql 5.5.33 to MariaDB 5.5.33 issue

My configuration: Master (Mysql 5.5.33) Slave (MariaDb 5.5.33) Slave status: Variable Value Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User sn1 Master_Port 12345 Connect_Retry 60 Master_Log_File …
Nicola Marcucci
  • 1
  • 1
0
votes
0 answers

Replicate locally hosted MySQL database to server

I want a local MySQL database to be replicated in a server database which is hosted in the server. I cannot use general master slave replication as the master(local computer) doesn't have a static IP. Is there a methodology that I can use, by…
chandimak
  • 201
  • 3
  • 17
0
votes
1 answer

mysql master master replication out of sync

I have 2 server set on mysql master master replication. we can call it as good server and bad server. Good server has all the latest data. Once of table in the bad server is not in sync and have old data. How can I sync the new data into that table?…
sandy
  • 43
  • 1
  • 1
  • 7
0
votes
2 answers

Snapshot Replication shows error "The step is improperly defined and so could not be run"

I am trying to add a "SQL Server Agent" job to a new database server that has SQL Server 2008 R2 in it. This job does snapshot replication on a "groups" table, and then distributes the snapshot to a subscriber in another server. Unfortunately that…
Jay C
  • 141
  • 1
  • 12
0
votes
1 answer

MYSQL sync/data insert from multiple databases to a single target database

One of our application is installed in 50 odd locations. Each of these has a local database. we need to sync data of one of the table of this database to a centalized location. We want to use a queue mechanism in between the local and the…
user3123372
  • 704
  • 1
  • 10
  • 26
0
votes
1 answer

MySQL 5.6 Data Replication Syncronization Checker Between Servers (Master & Slave)

I have one Master and Slave OS : MySQL5.6 & RHEL 7.0 Replication Status : Running Fine Everything working fine and correctly I want to check that the data is correctly replicated between servers (Master to Slave) and with the help of mysqlrplsync, i…
Mubashar Iftikhar
  • 1
  • 3
0
votes
1 answer

MariaDB replication - slave lag due to gtid statements in relay log

I'm doing a migration work from MySql to MariaDB where replication is involved, everything is working fine and compatibility of master MySql (5.5.59) to slave MariaDB (10.1.26) is good. The problem occur when I enable the replication from MariaDB…
Jacopo
  • 21
  • 5
0
votes
0 answers

Issue Using Percona-Toolkit to Add Index to Table Column

I need to able to add an index to a column in a MySQL table. I am using Mysql Ver 14.12 Distrib 5.0.77 and Percona-Toolkit 2.0.3. I can add the index using the Percona-Toolkit using: pt-online-schema-change --alter "ADD INDEX server (server) USING…
sudodashell
  • 121
  • 4
  • 12
0
votes
0 answers

Why can't I cancel CouchDB 2.1.1 replication?

Just a couple days ago, I migrated from CouchDB 1.6.1 to 2.1.1 in our production environment. The couchup replicate step was taking forever, and then I noticed that most continuous pull replication was running, so I figured that must be slowing it…
Westy
  • 707
  • 2
  • 10
  • 23
0
votes
1 answer

How to replicate huge data table in SQL Server 2012

I have the same database on two servers and I am using merge replication for around 35 tables, and it is working fine. But whenever I add 2-3 more tables with around 1 million records, the replication breaks after some time/days. Can I do 2…
prashant
  • 361
  • 9
  • 26
0
votes
1 answer

SQL Replication not working correctly.

I have a transactional SQL Server replication set up. Currently everything I have review seems to show that the replication is working. I have reviewed the Replication Monitoring and Sync State and both show that transactions are being pushed across…
SQL Shell
  • 1
0
votes
1 answer

reset master in percona xtradb cluster

I have two pxc clusters each consisting of 3 mysql servers. PXC1(node1,node2,node3) has db1 and db2, and PXC2(node4,node5,node6) has db2 and db3. I've setup a gtid based replication between pxc1(node1) and pxc2(node3). Now the replication failed…
Raja kadali
  • 31
  • 3
0
votes
1 answer

Postgresql 10 replication mode error

I'm trying to setup a basic master slave configuration using streaming replication for postgres 10 and docker Since the official docker image provides a docker-entrypoint-initdb.d folder for placing initialization scripts i thought it would be a…
omu_negru
  • 4,642
  • 4
  • 27
  • 38
0
votes
1 answer

Configure MongoDB DB Replica Sets using IP Addresses

Can I configure MongoDB DB replica sets using IP addresses alone instead of host names? Usually an IP address can be used almost everywhere a host name is expected. But our main Mongo DB expert led me to believe that we must use hostnames sharing a…
Agnel Kurian
  • 57,975
  • 43
  • 146
  • 217
1 2 3
…
99 100