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
74 views
How can I disable utf8mb4 entirely on MySQL 5.5?
I know you're not supposed to do this, but I have a MySQL 5.5 master and a MySQL 5.1 replication slave. That's supposed to be okay, unless I do something stupid like use utf8mb4 that isn't supported ...
4
votes
1answer
242 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?
...
1
vote
1answer
99 views
Circular Replication, prevent failure
I recently needed to setup MySQL replication across 4 servers, so that each one is a slave of another.
After several hours of tweaking I finally got this working - it was actually quite simple. I am ...
0
votes
0answers
54 views
Oracle: Mirror database changes between two databases
I need to keep two whole databases constantly synchronized.
That includes:
Data (of course)
DDL Changes (also changes to stored procedures and pl/sql packages)
All changes need to be propagated ...
3
votes
0answers
98 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
1
vote
1answer
150 views
Automatic MySQL Sync from master, where Slave was offline for long period of time
Does anyone here know if there are any tools, not using mysql's built in replication that will sync up two databases when the slave has been inaccessible from the internet for extended periods of ...
3
votes
1answer
58 views
Cannot delete publication
When attempting to delete a publication, I am getting the error cannot drop publication 'XX' cannot drop article 'XX'.
The subscription has been deleted at the subscriber. Any ideas on how I can ...
1
vote
0answers
209 views
SQL Server Troubleshooting Replication and Long-Running fn_dblog query
I am trying to get (pull) Transactional Replication working again for a subscriber.
Currently, in Replication Monitor I am seeing messages in the Publisher to Distributor tab and the Distributor to ...
1
vote
1answer
99 views
Master to Slave to Slave Configuration in MySQL
We currently have 3 MySQL Servers running;
the first which contains production data and is due to be retired
mysqld Ver 5.5.28-0ubuntu0.12.04.2 for debian-linux-gnu on x86_64 ((Ubuntu))
mysql> ...
3
votes
1answer
299 views
Best Approach for Mirroring Data from SQL Server to MySQL
I need help in regards to replicating data from a third party point-of-sale system with a SQL Server backend to a MySQL DB.
Specifically, can anyone suggest a best way to mirror data from SQL ...
2
votes
1answer
191 views
Schedule replication of SQL Server views to MySQL remote database
I have a Microsoft SQL Server 2005 Database inhouse I have to publish some information on the internet and I can't (for security policy) query this database from the web server.
So I came up with the ...
1
vote
0answers
127 views
Transactional Replication Over Domain
I am trying to setup transactional replication in SQL Server 2008 R2 on two servers on separate domains. I am able to create the distributor, create the publication, and create the subscription, ...
2
votes
1answer
114 views
How to switch master server and warm standby (with streaming replication) in PostgreSQL?
I would like to know what is the way to switch the role of 2 servers when using warm standby?
I have 2 servers : S_1 and S_2, and at a time T, S_1 is the master server and S_2 is a warm standby with ...
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 ...
2
votes
1answer
48 views
Transaction stays in capture queue
I set up simple bidirectional db replication using Oracle Streams. I used enterprise manager for this. Streams are active and their status is ok. The problem is that the replication is very slow. What ...
4
votes
1answer
71 views
How can I determine the date of a snapshot in SQL Server 2008r2?
I am working on implementing an ETL process to load data into a warehouse.
Part of this process is pulling data from our production server (Server P) to a staging server where the actual load into ...
1
vote
1answer
40 views
How to change the replicate_*_table variable without modifying my.cnf?
what is the syntax of replicate_*_table without having to modify my.cnf file?
and do i need to restart mysqld for changes to be applied
1
vote
2answers
983 views
Error reading MySQL 5.5 binary log using mysqlbinlog
I'm having some trouble with a replication setup I'm using. It has been working fine for months, and then over the weekend, the slave stopped reading updates from the masters binlog with an error Got ...
1
vote
2answers
63 views
Change the Existing Topology of a MySQL Replication Setup
I want to be able to edit the topology of an existing replication, is that possible?
For example if I have a star topology, I want to edit it to make it a ring one.
How can I do that?
I'm thinking ...
1
vote
1answer
117 views
Replication and linked server security
I have three servers: P1, A1, and R1. P1 and A1 are production oltp servers. On each there are two databases that are being replicated down to R1 for olap (mostly SSRS reports). I am working on ...
3
votes
1answer
82 views
Is there a way to start a script on the publisher when synchronization starts?
I am using merge replication with pull subscriptions and Web Sync.
What is the easiest way to start a SQL script on the publication database when a subscriber starts the synchronization process?
...
4
votes
1answer
127 views
The issue of sp_MScheckIsPubOfSub stored procedure
We have SQL Server 2008 R2 Merge replication set up.
We have 20+ push subscriptions.
Once in a while I get the following error message during the sync:
Error messages: The merge process could not ...
1
vote
1answer
36 views
Merge Replicate, reinitialise with a different part of the data
I have a set of database with merge replicate configured between them.
The publisher is an aggregate of three sets of data.
Call them set 0, 1, and 2
There are subscribers that grab one set of the ...
0
votes
1answer
159 views
Does The Stored Procedure sp_removedbreplication Remove Rowguids
In merge replication if I run sp_removedbreplication will that remove rowguids or not?
Will it take into account the preserve_rowguidcol values in the sysmergearticles table?
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 ...
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 ...
1
vote
1answer
232 views
MySQL master/slave replication… structure not being replicated
Edit: I might have answered my own question while going back thru the links for this post. I would still like to get insight from more experienced DBA's and perhaps make the information easier to ...
7
votes
0answers
522 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 ...
2
votes
1answer
77 views
Does sp_droparticle @force_invalidate_snapshot=1 invalidate the entire snapshot?
Forgive this simple SQL Server question, but if I just want to remove a single stored procedure from snapshop replication (2008 SQL Server R2), if I call sp_droparticle, will it invalidate the entire ...
2
votes
1answer
235 views
mysql statement based replication - unsafe statements
I have recently set up statement based replication and my error logs are filling up with this error
121231 21:10:55 [Warning] Unsafe statement written to the binary log
using statement format ...
1
vote
2answers
132 views
mysql replication: replicate all but one table to different database on different server
I got database1 on server1 and database2 on server2.
Now I need to replicate a single table from database1 to database2
Now I thought that this would work:
replicate-ignore-table = %
...
1
vote
1answer
121 views
SQL Server 2005 merge replication failure
We have a customer who, when trying to sync a client (subscriber) to the server (publisher,) receives the following error:
2012-11-30 21:03:33.334 Percent Complete: 18
2012-11-30 21:03:33.334 Data ...
3
votes
1answer
318 views
How does Postgres 9.2's streaming replication handle schema changes, and initial table setup?
I want to set up a backup database on the physical server which sits right under my primary physical database server. I'm using Postgres 9.2, and I want to use synchronous, streaming replication (for ...
0
votes
3answers
432 views
Automatic MySQL Replication Fail-over Strategy
I want to know that if replication is down due to some reason as if master is down then what strategy should be followed so that the replication is up instantly without manually intervening the ...
6
votes
1answer
700 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 ...
1
vote
1answer
416 views
MySQL Replication and High Availability
I know this might not be a very good question to be asked in this site, but I really need some helps/hints to be directed to the right path.
I want to have failover strategy for 2 MySQL servers which ...
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 ...
1
vote
1answer
144 views
Mysql database replication (failover solution)
Is there anyone know how to do "mysql database replication" with appfog ? In simple word, just want to use 2 databases sync (2 locations) and set one as master database, and other one as slave. if ...
3
votes
1answer
183 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 ...
1
vote
2answers
165 views
Mysql replication - Error No. 1146&1062
short version
In master master replication, How to have one master write data with odd IDs and the other one with even IDs? Is it the way to avoid conflict?
detailed version
I wanted to setup a ...
1
vote
2answers
88 views
MySQL replication - some values are not being replicated
MySQL Replication issues
I might sound clue less here as i am :) , I am having problem with mysql replication, i.e. replication seems to be missing in some random occasion.
My structure looks like:
...
2
votes
1answer
137 views
What causes Transactional SQL Server Replication to need to be rebuilt/re-initialised
In a company I've recently joined we have two SQL Server instances, connected via transactional replication. I'm a developer and hadn't really come across SQL replication before so am a complete ...
1
vote
1answer
262 views
How soon after updating expire_logs_days param and restarting sql will old binlogs get deleted?
MySQL 5.1.x | InnoDB | Windows
My mysql data directory is starting to fill up with bin logs.
I currently have the following settings configured in my windows mysql server:
[mysqld]
log-bin
...
1
vote
1answer
150 views
Set up replication and migrate to InnoDB with low downtime
Current situation is this:
I have a large legacy DB using only MyISAM tables, the size of whole
DB is 4GiB, one of the tables contains over 10 million rows, so it is
pretty large.
The database is ...
1
vote
1answer
136 views
Reconfiguring MySQL slave when changing the hostname/IP of master
I have one master and one slave replicating great, but the master is about to have both it's hostname and IP changed. In master.info I see the current hostname for the master, if I shutdown the slave ...
2
votes
1answer
212 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 ...
3
votes
2answers
120 views
IBM DB2 v9.7 HADR TSA failure on the standby server
I have an environment here where I have 2 servers running DB2.
One is the primary and the other one is standby. They replicate with HADR and failover is made automatically by TSA.
What's the default ...
5
votes
1answer
297 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}/ ...
3
votes
2answers
319 views
Two way replication
I have a little problem...
I have this case:
2 server instances
2 Databases
1 Table (5 columns)
From server 1 I created publication to replicate all columns of tables I have in DB1.
From server ...
2
votes
1answer
211 views
Running pg_dump on a hot standby server?
Disclaimer: I admittedly haven't tried this yet, but I'm not sure I would know if it wasn't working correctly, so I wanted to ask.
I would like to run a nightly backup job (via pg_dumpall) from a hot ...
