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
7
votes
0answers
531 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 ...
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
101 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
0answers
56 views
“Arithmetic overflow” when initializing SQL Server 2012 replication from backup
I'm initializing SQL Server replication from a backup, by following instructions from here:
http://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/
...
4
votes
0answers
290 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, ...
4
votes
0answers
154 views
Initializing Transactional Replication From Backup
There is an option when setting up a publication for replication to Allow Initialization From Backup. We have been creating replicated databases for several years now and have always initialized from ...
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 - ...
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 ...
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, ...
3
votes
0answers
60 views
How Much Overhead Does Web Sync Add?
I am running merge replication in SQL2012 using web sync.
Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection?
...
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 ...
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 ...
2
votes
0answers
52 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
0answers
154 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 ...
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.
...
2
votes
0answers
129 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
0answers
134 views
SQL Server Replication :: Dedicated Distributor Hardware Requirements
Does anyone know any rules of thumb (or better) with regards to hardware requirements for a dedicated distributor server? i.e. Based on estimate metrics (e.g. number of subscribers, publishers, ...
2
votes
0answers
87 views
How unsafe is it to change the data source of repl_distributor on a publisher
I have a long story that I will condense to a few bullet points that leads up to my question
Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
...
2
votes
0answers
204 views
SQL Server 2008 replication scenario
First of all sorry about my english, and most importantly, my database ignorance, I'll do my best ;)
Until now, the scenario that I have is as follows:
In a server under our LAN, we have a database ...
2
votes
0answers
188 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
0answers
217 views
What is causing all of the msrepl_tran_version columns to become out-of-sync between locations in transactional replication setup?
I have been having a recurring issue with transactional replication setups at the firm I work for. We use SQL 2008 R2. Seemingly without warning or any replication errors, all of the ...
2
votes
0answers
483 views
Oracle GoldenGate replication is stuck
I deployed Oracle GoldenGate to integrate many-to-one databases. After initial loading everything works fine. Until recently, some of the replicat seem to stuck and do not proceed to change ...
1
vote
0answers
26 views
How to sync mysql remote database daily ?
I have a database that contains orders , products ..etc. I have another system that generates reports based on this database. Due to heavy load i want to separate those systems Where i have the master ...
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 ...
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 ...
1
vote
0answers
211 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
0answers
129 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, ...
1
vote
0answers
49 views
pt-table-checksum generates no output
I've been using pt-table-checksum on our staging server successfully, but when I run
./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod
It just sits there. No ...
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
145 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 ...
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
0answers
140 views
Finding differences between a master and slave when pt-table-sync fails
I have a table that's showing some differences on a master and slave according to pt-table-checksum (PTC). I've found some verifying differences beyond that.
Certain tables in the mix have composite ...
1
vote
0answers
70 views
Bucardo stops sync when node is offline
I'm using Bucardo 4.4.8 to replicate two PG DBs to one central master. My problem is the same as was posted back in 2011 here
...
1
vote
0answers
51 views
How to Remove Articles Based on User
I am using merge replication on SQL 2012. I have a very large database with a large number of tables. The subscribers are using netbooks.
I have a filtering scheme that controls which tables end up ...
1
vote
0answers
120 views
Upgrading Remote Distributor in SQL Server Replication
I'm upgrading my remote distributor from 2005 to 2008r2, it is performing transactional replication only. this is a prerequisite to completing an upgrade of the Publisher to 2008r2.
Script ...
1
vote
0answers
47 views
Replication Fails due to Warning
I'm getting the following warning when executing usp_ReplicationMonitor within a job:
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153)
A ...
0
votes
0answers
29 views
Oracle to SQL Server DDL replication
We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
0
votes
0answers
31 views
MM Replication and Zabbix in slave, Error code 1032
I have multi-master replication and using Zabbix for server monitoring. Since the replication is row based, I get this error in slave everytime which also breaks my replication. The error I get is:
...
0
votes
0answers
50 views
PostgreSQL: Slave doesn't replicate the Master's data
I'm using PostgreSQL 9.2.3 on both computers, both of which run Win2008R2. I've setup streaming replication by following this guide: ...
0
votes
0answers
18 views
Can i use XAMMP mysql server with Percona Xtradb cluster?
I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster.
Can I just change the my.cnf config file on XAMPP with the ...
0
votes
0answers
22 views
Oracle Downstream Log transfers
I am attempting to create a downstream capture process for two Oracle 11 databases running on Linux servers. The replication will be one-way and asynchronous using archive logs as the transfer ...
0
votes
0answers
29 views
MySQL replication is not happening when piping sql into mysql client
Today I noticed a very strange issue where if I cat a SQL file and then pipe it to MySQL client, replication doesn't happen. These MySQL statements aren't also written to the binlog. But replication ...
0
votes
0answers
28 views
How to get replication from a SQL Server mirroring setup 2008 R2
I have a mirroring setup in the UK (principal, mirror,witness) which hosts a number of databases. failover is automatic for individual databases and local client connections are managed using dynamic ...
0
votes
0answers
39 views
MySQL failover - Master to Master Replication
My company is trying to implement a MySQL failover mechanism, to achieve higher availability in our webservices tier - we commercialize a SaaS solution. To that end we have some low-end VMs scattered ...
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
0answers
28 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
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 ...
