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
1
vote
2answers
78 views
Mix of Cyclic and Chained MySQL replication - What do you do with “log-slave-updates”..?
I have the following MySQL replication topology set up:
Master1 (M1) replicates to Master2 (M2)
Master2 (M2) replicates to Master1 (M1)
Master1 (M1) replicates to Slave1 (S1)
Pictorial View
...
2
votes
1answer
127 views
PostgreSQL asynchronous replication (and possible data loss)
I'm trying to wrap my head around Postgres' asynchronous replication. The way I'm reading the documentation, if the master goes down after data was committed, but before it's shipped to slaves, the ...
2
votes
3answers
325 views
Table with identity column in merge replication
I have a table in SQL Server 2005 and I have an IDENTITY(1,1) property set for an ID column. Records are inserted in a table at a local server as well as a remote server. I am using Merge ...
2
votes
1answer
55 views
mysql read slave to fetch entire database on start
I am building a standart infrastructure, where writes are going to master db, and reads are going to slave dbs. The idea is that when I need more read power - I just spawn more MySQL slave servers.
...
2
votes
1answer
123 views
Post replication powershell script - on subscriber
I need to execute a command before a replication executes on the publisher, and after, on the subscriber.
I seem to have it working on the publisher, by adding another step in the replication agent.
...
3
votes
2answers
142 views
Cleaning up transaction replication del/ins/upd stored procedures?
I'm referring to the ones that start with:
dbo.sp_MSdel...
dbo.sp_MSins...
dbo.sp_MSupd...
I've noticed they are not removed when I run exec sp_dropsubscription on the Publisher then run ...
1
vote
1answer
428 views
Replicating data from Oracle to MySQL
I work with a vendor that does data analytics, and they currently receive a replication stream from some of our databases using a product called Goldengate (which is very expensive). Goldengate has ...
1
vote
1answer
96 views
How Can I Isolate A Merge Replication Timeout
I am using merge replication in SQL 2012 with web sync.
When I create my subscription I am getting a timeout. The error message is not clear about cause of the timeout, but what I do know is if I ...
1
vote
1answer
164 views
Restoring MySQL database with db dump and binlogs
I have a database running on our production web server that I have set up as a master with a single slave in another datacenter. When reading through the MySQL replication setup instructions, they ...
1
vote
2answers
184 views
Oracle symmetrical one-way replication for cheap HA: unfashionable or technically unfeasible?
We have two smallish unrelated databases on two big Oracle Enterprise servers. Instead of buying more licenses and servers for high-availability replicas, can we replicate database B to server A and ...
0
votes
1answer
59 views
Mysql restore all data from Master
MySQl Slave replication server got crashed and I am missing around 60 tables, some table structure and data which present in master and by DB size is more than 25Gb, How I Can restore to resolve ...
0
votes
1answer
146 views
Length of LOB data (%1) to be replicated exceeds configured maximum %2
We recently hit this error shortly after enabling replication on a table.
Length of LOB data (%1) to be replicated exceeds configured maximum %2
I've found solutions to this problem already:
...
3
votes
1answer
117 views
adding another table to existing MySQL replication scenario
I'm running a simple MySQL replication scenario MASTER ➙ BLACKHOLE ➙ SLAVE, replicating only a number of tables via replicate-do-table on BLACKHOLE and SLAVE.
Now I would like to add several more ...
0
votes
1answer
286 views
Resuming Replication w/ Database Mirroring when Principle is unavailable
I'm trying to setup a disaster recovery scenario and I'm stuck at this particular point. Here's what I've done so far:
A) Created principal database on Server A and and mirror on Server B
...
0
votes
0answers
120 views
Real time replication issue - can't use transactional replication
We have an existing Microsoft SQL Server 2008 R2 database that we need to real time replicate to an identical off-site live web database.
Transactional replication and merge replication will not be ...
1
vote
0answers
62 views
Looking for a good 3rd party Microsoft SQL replication app! [closed]
We have an existing Microsoft 2008 SQL R2 database that we need to real time replicate to an identical off-site live web database. Transactional replication and merge replication will not be able to ...
2
votes
1answer
103 views
How can I modify a trigger at subscribers SQL Server 2005?
I have a SQL Server 2005 publisher with SQL Server 2005 subscribers and one SQL Server 2000 subscriber running merge replication.
Is there any way to modify triggers at a subscriber with the ...
2
votes
0answers
52 views
Once in a while synchronization of the independently updated mysql databases problem
I have a production database and a test database running on MySQL with MyISAM and InnoDB tables, which are updated independently.
The Production database is updated by system and sometimes by a user.
...
0
votes
1answer
783 views
Pgpool install - libpq is not installed or libpq is old
Based on the documentation here, I want to create a pgpool II with PostgreSQL databases. When I try to install, I encounter this error:
configure: error: libpq is not installed or libpq is old
...
1
vote
0answers
78 views
Pull replication stuck on Microsoft SQL Server 2000. What is the safest way to get it running again?
I believe the steps necessary would be:
Generate scripts to "create or enable" (including replication jobs) by right clicking the subscription in question in "local subscriptions" and saving the ...
1
vote
2answers
221 views
What is the Maximum Merge Articles in Merge Replication [duplicate]
Possible Duplicate:
Hard limitation for merge replication article count?
I am using merge replication in SQL 2012. I am looking here:
Maximum Capacity Specifications for SQL Server (2012)
...
1
vote
2answers
57 views
Will changing server_id on master break replication?
I have few MySql absolutely isolated trees, each one of them has one master and few slaves.
For purposes of automation I need to set the same server_id to all masters (this will simplify the usage ...
1
vote
0answers
144 views
When using a master plus multiple slaves, how do I change over from one server to a brand new one with minimal downtime?
In my particular case, I'm using Heroku Postgres (repackaged Amazon EC2 instances running PostgreSQL), but platform-agnostic answers are also good!
Heroku's instructions
describe the process for ...
2
votes
1answer
697 views
MySql - Changing expire_logs_days without restarting the server
I'm using MySql 5.5.
Is it possible to change expire_logs_days and have the changes take effect without restarting the server?
3
votes
0answers
70 views
Multiple Merge Replications on same SQL Server Database Conflicts
I have 2 separate merge replications on the same database on a server, one named 'POC' with a single subscriber running continuously, and another named 'Clubs' with ~50 subscribers. As of recently, ...
7
votes
3answers
905 views
SQL Server database synchronization
Problem definition
Our users need the ability to query a database that is mostly up to date. The data can be stale up to 24 hours and that is acceptable. What would be the lowest cost approach to ...
1
vote
1answer
127 views
Do I have to filter the percona.checksums table in replication for use with pt-table-checksum?
I've set up MySQL replication, one master and one slave. Now I just starting to check the data for integrity on both sides by using Percona's pt-table-checksum. Wonderful tool to detect any changes or ...
2
votes
2answers
111 views
Teaching Slony replication to select slave nodes
There is a system with up to 256 nodes in db cluster. We need to replicate some data from one of them across to all others. But for every row to replicate there is a list of nodes where it must be ...
3
votes
1answer
113 views
Witnessing standby failure with repmgr
We're setting up a PostgreSQL cluster, and we're looking at using repmgr to handle standby promotion and so on.
Our cluster has one master and a hot standby, and uses the streaming replication ...
7
votes
1answer
282 views
Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
I am looking at snapshot replication between two servers. Here is what I have:
500GB database
~500MB nightly bcp loads
~50MB daily transactions
I was asking other DBAs in the company about which ...
2
votes
1answer
91 views
Can I replicate to a pre-existing database?
I am going to test this out, however I'd like to know what the forum would say.
I have 2 SQL servers with replication setup between them.
I am now adding another new SQL Server and I want this one ...
3
votes
1answer
326 views
How to script out push subscription creation at the subscriber?
I'm trying to set up a push subscription to a SQL Server publication from the subscriber.
I could set up the subscription at the publisher using the Replication Wizard in Management Studio. However, ...
4
votes
0answers
277 views
Impact of changing the DB compatibility level for a Published replicated DB from 90 to 100
I have a SQL Server 2008 R2 server with a bunch of published databases that are currently operating under compatibility level 90 (2005).
The subscription databases are also SQL Server 2008 R2, ...
3
votes
3answers
173 views
How can I replicate MySQL data from many servers to one?
All over the internet I can find manuals on how to replicate databases from master(s) to slaves.
What I need is to continuously keep a copy of table from 5 different servers in sync.
We have one ...
2
votes
1answer
214 views
Do database servers need load balancing?
I am trying to build a 1TB database on MySQL which will need strong read performance. I intend to replicate my database to prevent downtime.
Do my database servers need load balancing to improve ...
2
votes
1answer
57 views
Replicate from master-master setup
I have MySQL Master-Master replication on 2 servers.
I want to replicate to another slave server.
When I configure the slave to replicate from master1, only data added on master1 is replicated. ...
2
votes
0answers
128 views
How to Rename Table or Field With Merge Replication
I am using merge replication with SQL 2012. I am trying to rename a published table, and rename a published field.
These operations are not permitted in merge replication.
However I can think of an ...
3
votes
1answer
184 views
Setting up MySQL circular replication in existing replication topology?
I have the following MySQL replication topology set up for fault tolerance/disaster recovery with master server A and slaves B and C:
A replicates to B
A replicates to C
Both B and C are fully up ...
3
votes
2answers
2k views
MySQL replication - slave is continuously lagging behind master
I am using MySQL-5.1.50 with a Master-slave replication setup.
Most of the time the slave is lagging behind the master.
When I run show processlist;, there is no query that's taking a long time. ...
1
vote
1answer
206 views
MySQL Master-Slave Replication Cross Database
I am setting up Replication for cross Database as i have set 2 variables in Slave' s my.cnf as replicate-do-db=database_name and
Replicate-wild-do-table=database_name.% ,But i am not able to get ...
0
votes
0answers
77 views
How to user the Tablediff Utility with Replication Filters
I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence.
I see a problem with this approach though. This is because I am using parameterised filters to ...
1
vote
1answer
87 views
Is MySQL replication suitable for a Write Mostly application?
I'm considering adding another server to my one-server setup application with 600GB MySQL DB. The db and the apache are both running from the same server. In order to avoid backup downtime and improve ...
0
votes
2answers
164 views
PostgreSQL replication and large import
I am tasked with making large PostgreSQL imports to master instance, and then replicate it across the nodes as read-only data.
Still, the CMS system has to be able to write data and replicate across ...
3
votes
1answer
152 views
What is the difference between 'two way transactional replication' and 'peer to peer replication'?
Can someone explain in detail the exact differences between 2 way transactional replication and peer to peer replication?
2
votes
2answers
647 views
Looking for an efficient way to fix “Could not parse relay log event entry…” error
I have a corrupt relay log in MySQL 5.0 and looking for the steps to fix replication without having to reprocess all the binary logs from the master again.
Here is the full error message if you are ...
5
votes
4answers
144 views
Replicating only changes made by a specific database user
I am performing parallel testing. We have upgraded the legacy batch jobs to a new framework which we need to test against the existing batch jobs.
In the existing setup, I have web application which ...
2
votes
1answer
315 views
Slave I/O thread dies very often
I have MySQL Replication working between two servers in master-master mode.
Replication has been working from day 1.
The IO Thread and the SQL Thread has never died. However, the Slave SQL thread ...
4
votes
1answer
377 views
Replicating multiple databases into one database
I would like to replicate multiple databases on different servers into one master database.
I have 5 different instances on separate servers all running SQL 2008 R2. The schemas and structure are all ...
1
vote
0answers
73 views
MySQL replication backup
How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu.
What happens if,
I issue or schedule ...
1
vote
1answer
1k views
Some MySQL slave errors?
Master version: mysql-server-5.5.14-1.el5.remi
Slave version: Percona-XtraDB-Cluster-server-5.5.24-23.6.340
Binlog format: ROW based
I'm using PRM to setup HA for MySQL.
Sometime, MySQL slave ...
