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
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.
...
1
vote
2answers
182 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 ...
1
vote
2answers
220 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
1answer
319 views
3 Databases, Best Replication Setup?
We have 3 DB servers, two of them i.e. db1, db2, are located in the same data center. The other one i.e. drdb, is located in a different site. Currently, the replication setup for these servers is of ...
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 ...
1
vote
1answer
163 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 ...
4
votes
2answers
1k views
Scaling Percona datacenters: setup and replication
Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you.
We have already scaled alot of our application stack: we offloaded ...
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 ...
4
votes
2answers
3k views
Easy Postgresql master/slave replication with automatic failover on Linux?
I need a reliable SQL DB for our application and have been looking at Postgresql's streaming replication support. It seems that it's not hard to setup master/slave replication and you can use the ...
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:
...
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
119 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 ...
7
votes
1answer
329 views
Transactional replication from SQL Server 2000 to 2008
I have legacy databases on two SQL Server 2000 servers that I am trying to replicate to a SQL Server 2008 R2 database using transactional replication.
The 2008 server is not in the same LAN, so I am ...
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
779 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
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 ...
4
votes
2answers
2k views
How can you stop MySQL slave from replicating changes to the 'mysql' database?
I have my slave set to not replicate the 'mysql' database as described in this SHOW SLAVE STATUS\G;
Slave_IO_State: Waiting for master to send event
Master_Host: 127.0.0.1
...
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 ...
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, ...
5
votes
4answers
143 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
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 ...
7
votes
1answer
281 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 ...
1
vote
2answers
154 views
Can I replicate views with Slony?
Can I feed some SQL that creates a view to Slony?
I have some SQL that does CREATE OR REPLACE VIEW name_of_view and so on, passes it to slonik_execute_script, and then tries to run slonik_create_set ...
4
votes
0answers
273 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, ...
0
votes
2answers
693 views
Some queries slower in MySQL 5.5 than 5.0?
We have an exceptionally inefficient process (1.3 million selects, 232k updates) that I'm now recoding to be 1 select and 50 updates. In the meantime, though, today's process ran.
We recently updated ...
2
votes
1answer
56 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
2answers
645 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
2answers
6k views
What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?
I am very new to Database Administration.
I face a lot of problems while setting up mysql master-slave replication.
I also face regular mysql replication troubleshooting issues.
Can anybody helps ...
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 ...
2
votes
1answer
312 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 ...
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. ...
4
votes
2answers
436 views
Replicate DB2 table to SQL Server 2008
I need to replicate data from a DB2 database into a SQL Server Database (along the lines of about 80 tables). I can create an SSIS package, to just flat copy the data from one to another pretty easy, ...
1
vote
1answer
205 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
163 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
2answers
582 views
Removing Archive Logs after PostgreSQL PITR online-recovery
I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2.
Replication mode is "on"
Load balance mode is "on" (between primary and standby1)
I followed the official ...
3
votes
2answers
371 views
How to resolve the master server shut down/unavailability in mysql with master - slave replication
Let us suppose that we have a master/slave setup and the application is running fine for the time being. All of a sudden the master server suddenly shuts down due to some problem.
Now how can I ...
4
votes
1answer
371 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 ...
0
votes
0answers
123 views
Oracle Data Guard Fast-Start Failover Questions
Here is the setup in question:
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dbabc
Observer: (none)
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
...
2
votes
1answer
81 views
MySQL : Does 'bytes_sent' and 'bytes_received' include mysqldump data?
I'm trying to estimate my db traffic not including backups (mysql 5.1.41).
I use show global status; to get the parameters bytes_sent and bytes_received.
Questions
Do these numbers include ...
0
votes
2answers
604 views
MySQL replication fails due to duplicate keys after master is restarted
I'm new to MySQL load balancing, I want to try the master-slave concept.
Whenever I setup master-slave for the first time, and both have up-to-date fresh data, that works perfectly fine. However, ...
1
vote
1answer
813 views
PostgreSQL streaming replication broken: invalid magic number, out-of-sequence timeline ID
For some reason, my PostgreSQL slave no longer streaming-replicates changes on the master. It was working before, for a while, but I recently noticed that the slave's database contents is old, and ...
2
votes
2answers
435 views
Streaming Replication in PostgreSQL
I'm trying to set up two PostgreSQL servers on one machine and perform a streaming replication. I have succeeded once, but when i've tried again following exactly the same steps it doesn't work.. ...
1
vote
0answers
72 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 ...
3
votes
2answers
353 views
Rows already DELETEd on MySQL slave; How to DELETE on master?
I have a handful of rows that exist in my MySQL master but not in my slave.
Replication is running ok and these rows are unlikely to ever be referenced as it is a store-and-forget type of table. ...
2
votes
0answers
187 views
Ports necessary for Oracle 11g Replication across a firewall?
We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
2
votes
1answer
83 views
MySQL - Partially restore binary log
I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500.
How can I do that?
