Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
3
votes
0answers
65 views
Streaming Replication Failover - how to point second slave at new master?
I have a Postgres database HA cluster I've set up in a lab. I'm using PgPool-II to manage fail-over.
For the cluster itself, I have three identical Postgres 9.2 servers set up like so:
Server A - ...
0
votes
1answer
37 views
Replication Monitor reports little to no latency, but my tracer token is taking hours to go from Distributor to Subscriber
I sent a tracer token through a replication job that was reporting about 2 seconds of latency about two and a half hours ago. I sent the token through because I noticed a row that was inserted on a ...
1
vote
1answer
49 views
Get the list of all Tables, Views, Stored procedures that are not added in a publication for replication
How do i get the list of all Tables, Views, Stored procedures that are NOT added in a publication for replication?Can you help me to make the stored Proc for that?I am new to Replication....Thanks
0
votes
0answers
20 views
What is the quickest way to recover from an “Incorrect key file for table” replication error?
I'm trying to figure out the quickest way to recover from a replication error.
The production site replicates to a DR site. There are two databases at each site. So prod_master replicates to ...
0
votes
0answers
27 views
Slave lags ONLY when long running sql runs
I have mysql Master/Slave setup.
Master in 5.0.77 and Slave in 5.5.28.
The Master serves 24/7 with 82.06 inserts/s, 94.39 updates/s, 0.00 deletes/s, 22613.29 reads/s.
They both are in sync every ...
0
votes
0answers
36 views
Huge sizes Replication Tables in Sql Server db, how to deal with?
I've a sql server database that is configured to work with old software, i've no details about the software, but i know that DB uses replication.
the DB size dramatically increases.
When i ...
0
votes
2answers
80 views
Should I disable triggers, timestamps in a slave in mysql?
We're using MySQL. We have a master that eventually will have 2 slaves. There are triggers in the db that execute when data changes in certain tables. I am wondering whether to disable the triggers in ...
1
vote
1answer
29 views
After adding a slave to Master - Master configuration, slave syncs from only one master
Futher to my previous question,
Here is what we have
+<------+
| ^
V |
S1<---M1 M2
| ^
V |
+-------+
what happens is Upon ...
2
votes
1answer
119 views
Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
We have two mysql servers running in master - master configuration.
Now we have to add a slave to the existing configuration.
But upon adding the third DB server and starting slave on it, it throws
...
0
votes
0answers
29 views
Merge Replication is Slow for Uploads
I have implemented merge replication with pull subscriptions in production environment. Initially it was working fine, but now a days, its too slow to upload any changes to publisher , but subscribers ...
0
votes
0answers
22 views
What will happen if i change the compatibility level of Distribution Database [duplicate]
I have implemented merge replication in production environment, initially it was in SQL Server 2005, then it was upgraded in-line to SQL Server 2008 R2. Later on all databases compatibility level was ...
1
vote
0answers
37 views
Write performance of Postgresql 9.1 with read-only slave
I have a Postgresql 9.1 database that is being hosted by Heroku. It currently has a read-only "follower". I need to truncate several large tables (over 100GB) of data and reloads them. Is the ...
0
votes
1answer
45 views
Circular replication with servers in different locations
My service runs on single machine, and database (mysql 5.1.66) is replicated to 2 other identical slaves (with lesser system resources, mysql 5.1.66) via chained replication. Machines are located in ...
0
votes
1answer
27 views
How to have MySQL Slave Replicate From a Master's Master
We are using the Following:
MySQL 5.1.63-community-log MySQL Community Server (GPL)
OS : Red Hat Enterprise Linux Server release 5.4
We have three servers and all servers are enabled with binary ...
2
votes
2answers
106 views
Bandwidth comparison between log shipping and transactional replication
Which technique uses more network bandwidth:
Log shipping
Transactional Replication
Can some one share any benchmarks for the same ?
What would be the Memory and I/O impact on the Primary server ...
4
votes
1answer
71 views
How to reinsert corrected rows from the conflict table?
I have a bidirectional merge replication. I had failure constraints because the primary key was just integer. I change the primary key to the old primary key + a location identifier.The problem is how ...
1
vote
1answer
50 views
Will deleting data in master automatically delete data in slave?
I have data replication setup on MySQL. If I delete data on the master, will replication know data was deleted and automatically delete the same data on slave?
0
votes
2answers
54 views
Can I use replication/mirroring to have a “Current” database and a “Full History” copy?
I have a database that is used for current operations. The amount of data is starting to get a bit to much for the applications using it.
Most of the data is older and is very rarely needed.
I am ...
0
votes
1answer
291 views
MySQL slave stuck in “Reading event from the relay log”?
5.5.28-log MySQL Community Server (GPL) by Remi
binlog-format=MIXED
My problem is similar to this question.
*************************** 2. row ***************************
Id: 973415
User: ...
2
votes
1answer
63 views
Bi-directional replication for the same MySQL table
AppA stores/retrieves data from dbA.tableA
AppB stores/retrieves data from dbB.tableA
tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA ...
2
votes
1answer
90 views
mysql second slave not syncying while first slave works fine
I have a master (m) - slave (s1) setup using mysql 5.1.45
When I try to add a second slave (s2) the slave lags behind and never catches up on the sync.
Even after having synced the s2 with the whole ...
0
votes
1answer
72 views
Advise On SQL Server Data Replication
We have a huge enterprise system, with geographically seperated SQL servers.
We have some requirements related with data replication between these servers.
We have considered the Sync Framework ...
0
votes
1answer
45 views
Do I need client certs for mysql ssl replication?
I'm setting up mysql replication using SSL, and have found two different guides.
The first one creates both client and server certs, while the second one only creates server certs.
I don't know ...
0
votes
1answer
33 views
Is it possible to have extra tables in a Slave with MySQL Replication
As my title mention I have a Master and a Slave database.
Master if for operations data and my slave mainly for reporting stuff.
The issue is that I need to create extra tables on reporting that ...
0
votes
0answers
18 views
Retention policy for tmp files created on Mysql slave
What if suppose load data infile is issued in master and I see that it gets replicated to slave first by IO with the infile SQL_LOAD data files and then it triggers its DMLs using SQL Thread.
My ...
0
votes
0answers
11 views
How to replicate some databases from a slave to another slave?
Right now, we have a MySQL 5.5 master which replicates all 10 of its databases to two slave servers, slave1 and slave2. I want to offload some processing to slave1, so I want to move two databases ...
2
votes
0answers
38 views
Replicating databases for local and cloud instances
Forgive me if this is an inappropriate place for this architectural question but I'm not sure where it best fits in the StackExchange family.
I have been tasked with developing an online/live auction ...
1
vote
0answers
79 views
MySQL 5.1.67 - Replication failure Mysql, Master Log Truncated or corrupted
I have run into some issues with replication
After an in-place upgrade of mySQL from 5.0.77 -> 5.1.67 rel 14.4 Percona
replication between a master and multiple slaves is causing issues. slaves are ...
0
votes
1answer
60 views
MySQL Slave Lagging Almost Daily -Ver 5.5.17 ( Master & Slave )
I am observing this lag in a continuous manner. Investigating in the bin log events, i found
the following information. Slave executing the relay Logs slowly.
1. Changing the Innodb File Format ...
1
vote
1answer
70 views
SQL Server replication conflicts after migration from 2000 to 2008
I got a suggestion over at Stackoverflow to post here....greatful for any and all help.
Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
0
votes
2answers
108 views
Does MySQL Replication hamper the performance of my DB?
I am not exactly a 'Qualified' DBA, but yes i am in charge of my own DB which we use in our social app.
I have recently implemented Master/Slave Replication on my Database for obvious reasons.
What ...
0
votes
0answers
53 views
Streaming replication WAL files pg_xlog
We are using this awesome tool repmgr developed by 2nd Quadrant for streaming replication.
We set 1000 WALs to be archived. What I noticed though is that on master we have about 600 WALs in the ...
0
votes
2answers
97 views
Replication on MySQL server
I had to stop the slave server to test something. After I started the server again there is a problem with replication on MySQL server
On the problematic server
mysql> SHOW SLAVE STATUS\G
...
1
vote
1answer
37 views
MySQL monitor prompt does not return for slave
I'm trying to fix a replication error (or an ongoing failure to replicate) between our master and slave MySQL databases.
The procedure I have asks me to use MySQL Monitor to stop the slave.
stop ...
0
votes
2answers
66 views
How can I replicate some tables without transferring the entire log?
I have a mysql database that contains some tables with private information, and some tables with public information.
I would like to replicate only the tables containing public information from one ...
5
votes
3answers
184 views
What type of SQL Server Replication fits our scenario? Merge or Transactional?
Background
In our current setup, we have a single SQL Server 2005 instance on our remotely hosted web server. We additionally have another (non-MSSQL) database which we use for our POS system, which ...
0
votes
1answer
52 views
MySQL Slaves lag behind master
I have one master and four slaves. Sometimes all my slaves lag behind the master. I have implemented the heartbeat for monitoring replication lag. Now I am trying to find why the slaves are lagging ...
0
votes
1answer
69 views
MySQL replication between VPS and shared host
I have a VPS where I have ssh access and shared host with CPanel. Both have MySQL.
I need to create a master/slave setup among the two server.
As per this tutorial: How To Set Up Database Replication ...
2
votes
2answers
71 views
Slave SQL thread got hanged
We have a master - slave setup with ROW based replication.
We are seeing huge delay's on the salve even though there is no activity running wither on master or slave.
When we looked in, we observed ...
2
votes
1answer
169 views
Best way to perform SQL Server replication over multiple servers?
My current setup requires me to use three separate SQL Server 2012 instances (installed on 3 separate machines, separated geographically) and have the data be replicated across all 3. Any changes made ...
2
votes
0answers
87 views
Conflict handling, SQL Server 2008 R2 Peer to Peer
I have a Peer to Peer replication topology set up between two SQL Server 2008 R2 servers. I was doing some testing on fault tolerance and conflict handling. I have conflict detection enabled, and ...
0
votes
1answer
59 views
Breaking Semisynchronous Replication in MySQL 5.5
I've set up Semisynchronous Replication between two MySQL 5.5 servers running on Windows 7.
My application is running and updating the database of the master server and same is being updated in the ...
2
votes
0answers
53 views
How can we achive the replica of databases for SQL Server?
I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server.
In the ...
2
votes
1answer
93 views
SQL Merge Replication: Cannot resolve conflict
I have a SQL Merge Replication over HTTP (Replisapi.dll). I'm not very familiar with the internas of the replication conflict solving because it was always working so far.
Now I have two conflicts in ...
0
votes
2answers
306 views
How to sync MySQL database between two servers
I need to sync a MySQL database between two servers.
If a new record will be added in server A, then server B fetch new record.
If a new record will be added in server B, then server A fetch new ...
1
vote
1answer
45 views
Permissions for a MySQL user which will monitor replication status?
I'd like to use a script to monitor the replication status of a MySQL database like in this bash script: https://gist.github.com/wesdeboer/1791632
I'd like to create a user which will only be used to ...
2
votes
0answers
157 views
Why do I get “The initial snapshot for publication is not yet available.”?
We are using Transactional Replications with updatable subscriptions. 1 publisher, 1 subscriber.
SQL Replication started encountering a constraint error on 3/6 at 10AM because people at two different ...
1
vote
1answer
75 views
Minimising downtime implementing merge replication on live system
Background
We have three Servers running SQL Server 2008 which all contain a Product database. These are currently kept in sync once per day by sending a copy of the MDF to the two Subscribing ...
0
votes
0answers
39 views
How we can synchronize a MySQL database to an Oracle database?
How we can synchronize a MySQL database to an Oracle database?
The Oracle database is in secure zone that can only be accessed by application servers. We have multiple MySQL databases in different ...
1
vote
2answers
114 views
MySQL Replication without stopping master
I am currently setting up a replication for my database one of the ways i am thinking of synchronizing the master and slave without write locking the master, is by first taking a log position then ...
