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
22
votes
7answers
13k views
How do I completely disable MySQL replication
I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?
12
votes
2answers
856 views
What can we do in MySQL 5.0 Replication to address bandwidth concerns?
I am developing an application to run on the client PC (Win) which is configured with a MySQL server 5.1 instance that will act as read-only slave to the remote master. The remote master has dozens of ...
9
votes
5answers
1k views
Is it unwise to run replication on same physical server?
I'm contemplating setting up a Master-Slave replication for my database. The slave server will be used for redundancy and possibly a reports server. However, one of the biggest issues I'm running into ...
9
votes
2answers
109 views
What objective factors indicate it's time to implement SQL Server replication?
I am trying to strike a balance between high performance of our database and ease of maintenance. We are considering using replication to improve performance, by replicating our SSRS reports to a ...
8
votes
1answer
771 views
What is the difference between PostgreSQL 9.0 Replication and Slony-I?
Is there still any use for Slony-I, and if so, what is it? For clarification, from 9.0 Postgresql supports built in streaming replication.
8
votes
3answers
1k views
Snapshot Replication Retention
I've got Snapshot replication set up on my SQL Server 2008 production server, and I just noticed that there are snapshots ranging back to a year ago in the snapshot folder. How can I change the ...
8
votes
3answers
1k views
Does PostgreSQL 9.1 Streaming Replication catch up after a lag without WAL archiving?
Context:
Let's say that, while using Streaming Replication/Hot Standby on a Postgres 9.1 cluster, a standby node goes down. It stays down for an day, during which time a lot of DML occurs on the ...
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 ...
7
votes
3answers
1k views
Is MySQL Replication Affected by a High-Latency Interconnect?
We've got a vanilla master and slave MySQL setup that reside in different data centers, and another slave in the same datacenter as the master.
The bandwidth between the datacenter is pretty high (in ...
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 ...
7
votes
1answer
122 views
SQL Server considerations when backing up / restoring a database that uses replication
In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind?
Do I need to keep backups of both the publisher and the subscriber?
Can I ...
7
votes
3answers
178 views
Using Replication for Scale-Out
Having read Using Replication for Scale-Out, how can I route different queries to different servers, for example, SELECTI want to route to slaves and NON-SELECT to master. I assume as loadbalancer I ...
7
votes
2answers
378 views
Merge replication fails on executing query
My merge replication was working fine this morning. Since an hour or 2 ago, my synchronisation status windows keeps showing this message:
Thread id 3108 will wait for 15 second(s) before retrying the ...
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 ...
7
votes
0answers
524 views
mysql 5.1.66 SSL connection error ERROR 2026 (HY000)
UPDATE2
Using WireShark I found out the problem string (I hope I did):
28 | 9.582638 | 192.168.18.128 | 192.168.18.129 | MySQL Response Error 1043
And the error is (according to docs):
Error: 1043 ...
6
votes
4answers
399 views
How do I sync instance A to instance B without losing any of the data already on instance B?
Like I said in a comment below, I'm no DBA and I'm still in a learning process.
Here's my scenario :
I have an Oracle server running a couple schemas (let' call it Source). What I would like to do ...
6
votes
3answers
155 views
How to handle reporting of an extreme amount of databases in SQL Server 2005?
I'm looking for some advice on how to handle reporting for our environment. We currently have 16 servers with 20 instances of SQL Server 2005. We have over 6,600 databases and growing across these ...
6
votes
2answers
3k views
Replicate RDS-MySQL to a non-amazon host?
I have a fairly large MySQL (5.1) database running in Amazon as an RDS instance. I'm working on migrating it out of Amazon. To do that smoothly I'd like to set up the new hardware as a read-only ...
6
votes
3answers
8k views
How do you re-sync the Master MySQL DB with Slave DB changes if the Master goes offline?
MySQL Server 1 is running as Master.
MySQL Server 2 is running as Slave.
With both DBs online, they are in "perfect sync". If Slave goes offline, there's no problem if Master still online; they will ...
6
votes
1answer
710 views
Upgrade SQL Server 2005 to SQL Server 2012
I have a test environment set up with the following:
Virtual Machine (Hyper-V)
Windows Server 2008 R2 SP1(x64-bit)
Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name)
1 ...
6
votes
1answer
273 views
How long can the log reader agent run for before a restart will do it some good?
As a developer who has for the first time successfully implemented a replication topology for our production database, I'm monitoring it very closely and fretting over potential problems.
I'm pleased ...
6
votes
2answers
1k views
Streaming replication and failover on PostgreSQL
I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...
6
votes
1answer
148 views
Replication problems after server upgrade
In transactional replication - first 8000 rows of snapshot copies to subscriber snapshot then acts like it completed successfully.
Publication table has 21 million rows. Snapshot says completed ...
5
votes
4answers
936 views
Duplicate database and keep it up to date - Replication or SSIS?
I would like to duplicate a database, on the same server, and keep it up to date either by running a scheduled service once a day or having SQL Server 2008 take care of this internally.
We don't need ...
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 ...
5
votes
3answers
485 views
Database replication and consistency check
I got a question about 2 databases (oracle 10g) that I have, let's call them A and B. A have some information(in various tables) and I want B to get a partial copy of some tables from A, and ...
5
votes
4answers
2k views
MySQL Replication - Introduce new Slave to replication
I've recently taken on a sys admin position managing a group of 20 (or so) servers. One thing I haven't dealt with before (apart from in a test situation), is introducing a new slave to the MySQL ...
5
votes
4answers
435 views
Is there a way to measure replication lag in MySQL with a resolution less than 1 second?
Is there a way by which you can measure replication lag in MySQL with a resolution of less than 1 second?
That is, can replication lag be measured on the microsecond or millisecond level?
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 ...
5
votes
3answers
6k views
Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql
I have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log).
I have created master-slave for this DB on server S2 (mysql version 5.1.54-1ubuntu4-log).
The DB on S1 was using one data file ...
5
votes
2answers
871 views
Will transactional replication push a CREATE INDEX immediately? Or do I need a snapshot?
I have transactional replication set up on SQL 2008, and the article in question has "Copy nonclustered Indexes" set to TRUE.
If I add a non-clustered index on the publisher (using CREATE INDEX), ...
5
votes
1answer
345 views
Can I have an InnoDB master and MyISAM slaves with Full-Text for searching?
I'd like to use InnoDB on the master, for its transactional ability, but MyISAM on the slaves for the full-text search ability. Is this possible?
5
votes
1answer
305 views
MySQL replication - replicate to multiple DBs on slave?
I've got a single table in a master DB that I would like to replicate to multiple databases on one slave server. Like this:
masterDB.tableA -> slaveDB1.tableA
masterDB.tableA -> slaveDB2.tableA
...
5
votes
2answers
218 views
Database replication with ability to revert to previous states
I want to setup a development database such that it'll initially be a mirror of the database used in production. At fixed points during the day (maybe midnight or something) and/or manually, I want ...
5
votes
2answers
338 views
Best practices to run time offset delayed replication
I want to setup replication system on postgresql like #1 MASTER SERVER and two replicated servers: #2 SERVER in realtime (for load balancing), #3 SERVER delayed with some time offset (for example 2 ...
5
votes
2answers
284 views
considerations when using triggers on a replicated (target) database
Our SQL Sever 2008 application database is replicated from Server A to Server B (push replication). We use the copy, let's call it database_b, on Server B to create reports and run other queries so ...
5
votes
1answer
407 views
PostgreSQL 9.1 streaming replication problem: replica fails to use an index properly
We use PostgreSQL 9.1.7 on Ubuntu Linux 12.04 on a master server and PostgreSQL 9.1.7 on FreeBSD 9.0-RELEASE on a replica server. The replica and master servers return different results on the same ...
5
votes
1answer
291 views
What are the common reasons for a Subscription to be deactivated in SQL Server 2005?
I am trying to manage database replication in SQL Server 2005. I have set up my publications, distributors and subscriptions and it seems to work properly at the start.
However, after a period of ...
5
votes
3answers
175 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 ...
5
votes
1answer
1k views
PostgreSQL Failover - What tools should I use?
Here is the scenario:
There are two machines running CentOS 6.2 - machine0 and machine1
Both have PostgreSQL 9.1 installed.
One of them should be active, as a master system and through asynchronous ...
5
votes
1answer
301 views
PostgreSQL: Can I do pg_start_backup() on a live, running db under load?
Our established replication has broken ("requested WAL segment has already been removed" during downtime)
We cannot easily stop the master again.
Can we do
pg_start_backup(),
rsync ${PGDATA}/ ...
5
votes
1answer
237 views
Replication of database used by two programs
I have a peer to peer transactional replication set between two identical databases, each one of the databases is being used by a different program on two different servers. Since we implemented the ...
5
votes
1answer
359 views
Global locking for multi-master Oracle GoldenGate replication
This is a very complex scenario, but I figured a state-of-the-art challenge might interest some of the many high-end users of dba.se.
Problem
I'm working on an intercontinental data replication ...
5
votes
1answer
275 views
Transactional Replication not sending all commands
I have a transactional replication topology as follows:
NY Publication Database same server holds distributor
NY - Subscriber
LON - Subscriber
HK - Subscriber
We are using bog standard, one-way ...
5
votes
3answers
3k views
Add article to transactional publication without generating new snapshot
Using SQL 2008 R2 transactional replication with pull subscribers, when we add an article, I'd like to avoid having to create an entire snapshot (the db is ~80 GB, so this takes hours).
From this ...
5
votes
0answers
98 views
9i streams capture doesn't evaluate rules
I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
5
votes
0answers
100 views
Msg 14027, Level 11, State 1, Procedure sp_MSrepl_addarticle [table] does not exist in the current database
Before setting up SQL Server snapshot replication, I backed up the database from ServerA and restored it to ServerB. Both servers are running SQL Server 2008 R2 SP1.
In trying to setup snapshot ...
4
votes
4answers
435 views
Can two servers access the same database files?
I'm designing an application and considering some options regarding the database system since I'm not familiar with Microsoft SQL Server. I would like to know if it's possible to have 2 servers ...
4
votes
1answer
245 views
Is PostgreSQL replication production ready?
How does PostgreSQL native replication compare to MySQL?
I know asynchronous replication has been supported for longer than sync, which is recent. Is synchronous reliable to be used in real projects?
...
4
votes
3answers
3k views
ALTER TABLE on a large table with an indexed column
I have a large table with a VARCHAR(20) column, and I need to modify that to become a VARCHAR(50) column. Typically, performing an ALTER TABLE (adding a TINYINT) on this particular table takes about ...
