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

learn more… | top users | synonyms

2
votes
1answer
276 views

oracle streams apply: how to get a reason why LCR message was not applied

I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't. ...
1
vote
1answer
853 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
167 views

SQL Server replication conflicts after migration from 2000 to 2008

I got a suggestion over at Stackoverflow to post here....greatful for any and all help. Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
1
vote
1answer
67 views

Snapshotting Database Tables

I have a reporting database (in SQL Server) that takes nightly snapshots of the production data (Oracle) for users to query against for the next day, but now the requirement is getting to be that they ...
1
vote
1answer
59 views
+50

Replication from EC2 Master to RDS Slave - Connecting to master

I am migrating my company's database from an EC2 instance to an RDS instance. I have already migrated a snapshot of data and am now trying to set up replication to get the data that has been added ...
1
vote
3answers
41 views

How to remove master role from MySQL server

I have 2 MySQL servers, one is the master and other one is slave, that's all good. The problem I have is that the slave is also set up as a master. I would like to disable or remove the master role ...
1
vote
2answers
21 views

Mysql Master Offline

In a unidirectional Master-Slave setup, should the slave be manually stopped in cases where the Master is offline due to Maintenance, Crash etc. ? Or should one just leave it so that it keeps trying ...
0
votes
2answers
966 views

Replication on MySQL server

I had to stop the slave server to test something. After I started the server again there is a problem with replication on MySQL server On the problematic server mysql> SHOW SLAVE STATUS\G ...
0
votes
4answers
492 views

How can I replicate some tables without transferring the entire log?

I have a mysql database that contains some tables with private information, and some tables with public information. I would like to replicate only the tables containing public information from one ...
1
vote
1answer
24 views

Fan-In replication 4 Master -> 1 slave

I am trying to merge 4 source db's (one for each region) into a global db. We use ID ranges as primary key on the tables in each region and so the merge should happen nicely. I have a fairly high ...
0
votes
1answer
22 views

Impact of replication compression & encryption on performance, traffic?

What is the impact of MySQL compressed-slave-protocol on replication traffic? According to High performance MySQL it can lower the traffic to a third of the same replication without the compression. ...
0
votes
0answers
24 views

How to use Select query just right after Insert on master in a query.?

I have a question on mysql replication. As usual, I deployed my db structure like the Update on master db, the select on slave. My questions. If I use SELECT query just right after INSERT in a query, ...
0
votes
1answer
106 views

MySQL replication using a lot of IO

I'm having big troubles on a database pool I've setup recently. There is a master, and 4 slaves replicating one DB. All using MyISAM engine. Thing is, during the replication period (when the slave ...
0
votes
2answers
31 views

MySQL Slave not updated

This might be a duplicate of questions on the same problem asked before. But all the suggestions to the previous questions do not seem to work in my case. I have set up Replication using SSH Tunnel. ...
3
votes
1answer
90 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 ...
0
votes
1answer
14 views

SQL Server distrb.exe & Logread.exe using huge SQL.txt file in C:\Users\sqlsrvacct\AppData\Local\Temp folder

I have the following situation: SQL server 2008 R2 SP2 I have both the Distribution and Subscription database in this server. LogReader agent and Distribution agent are running in continuous mode the ...
11
votes
0answers
2k 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: ...
0
votes
2answers
1k views

Distributed Database Architecture Using MySQL Replication

I've been task to move our web servers to the cloud for all countries that use our services for localization. The issue is, they must share the same data and therefore I need to set up some database ...
1
vote
1answer
35 views

Determining replication traffic

is there any way to determine from server statistics* running MySQL, how much traffic(bits per second) WOULD replication consume between 2 servers, without setting-up the actual replication between ...
0
votes
2answers
43 views

To replicate, or not to replicate

1.Intro Hello, I am running web application on 2 separate geographical locations(e.g. Europe, Hong Kong). Let's suppose Hong Kong server is an Amazon EC2 instance(paying for disk space, IO disk ...
2
votes
1answer
109 views

Updateable Subscriptions: Rows do not match between Publisher and Subscriber

I have transactional replication with updatable subscribers set up in SQL Server 2008. It has 3 subscribers and 1 publisher. I had to setup replication again due to some errors related to the database ...
0
votes
1answer
30 views

CRC checkup in MongoDB

I am newbie to MongoDB and currently working on a project. I read tutorials about mongoDB but unable to find any information about Cyclic Redundancy Check (CRC) check in mongoDB. My question is that ...
1
vote
1answer
80 views

Upgrading to MySQL 5.6, benefits to switching to GTID replication?

We have the most basic of MySQL replication setups, a single Master doing statement-based replication to a single Slave, a 90/10 mix of innodb/myisam tables. Both run Percona MySQL 5.5 at the moment ...
1
vote
1answer
100 views

MySQL - Best long read query solution within a replication based system

I'm working on a project where work in a queue requires a database read against heterogeneous table schemas (InnoDB/MyISAM). The queries constructed during the "read" process can result in 10-15 ...
0
votes
0answers
21 views

SQL Server DTC: is it possible to automatically replicate data that is created on Oracle DB?

I have a SQL server with a table that is spec'd exactly like a table in an Oracle database. What I would like to do is automatically copy the data from the Oracle table to the SQL server table... Is ...
0
votes
1answer
175 views

Syncronize mysql databases between local and hosted servers automatically

We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
0
votes
1answer
81 views

How to remove orphaned Log Reader Agents from Replication Monitor?

How do I remove the two Log Reader Agents with errors from the Replication Monitor? As you can see, the job does not exist (Error message produced by right click > Properties on errored Log Agent ...
1
vote
1answer
39 views

MySQL master master replication, safe to delete rows on both masters?

We have a MySQL (v5.1.61) cluster with two masters (and two slaves). We have a table logs with a primary key column logID. This log table grows rather huge, and we'd like to delete data from it. So ...
3
votes
2answers
53 views

Postgres Streaming Replication lagging, using lots of CPU and little I/O

We have 2 dedicated DB Servers. One is master and other is its streaming slave. Postgres version 9.0.17. We have similar hardware on both servers and using 15krpm SAS drive in Raid 10 for Database ...
1
vote
0answers
19 views

Data Corruption on base backups created with wal-e?

I have streaming replication setup on Postgresql 9.1 with two machines on AWS EC2. The master has a cron job that does a daily base backup using the wal-e tool and uploading it to Amazon's S3 storage. ...
0
votes
2answers
31 views

Query to check if all replication articles are created at Subscriber SQL Server 2012

I am creating an automated build and test tool for our databases. In general there are two stages: - install databases in version A, install transactional replication - drop replication, update ...
5
votes
2answers
349 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/ ...
0
votes
0answers
14 views

Performance : MySQL replication or only one big server?

I'm searching about the best choice. We have to host a website with 10.000 - 20.000 visitors per day actually, growing. At the beginning, which would be the best : Having 2 MySQL servers (12 GB ...
0
votes
1answer
81 views

MySQL: records, inserted via phpMyAdmin, do not replicate

As it says on the topic, for some reason records inserted/ modified via PMA do not get replicated to the slave, If I do exactly the same insert/modification on master via mysql command line, or ...
3
votes
1answer
195 views

Log Reader Agent is not running - The job failed

I created a transactional replication on PRE-PROD (via TSQL) and everything works as expected. On PROD platform replication is not working. While inspecting Replication monitor, I get this error ...
0
votes
0answers
24 views

SQL Server Replication Monitor Throwing “Specified cast is not valid. (ReplicationMonitor)” Error

The publisher is running SQL Server 2008 R2 on a Server 2008 R2 box. The subscriber is running SQL Server 2012 on a Server 2012 box. I have tried launching the replication monitor from both servers ...
2
votes
1answer
353 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
120 views

PostgreSQL Hot Standby

I have two PostgreSQL servers running on my local Ubuntu machine (port 5437 is master, port 5438 is standby). While following the tutorial on http://wiki.postgresql.org/wiki/Hot_Standby I get this ...
1
vote
0answers
7 views

Is it possible for unique key to break master-master replication in mysql?

I have a master-master mysql setup with 2 servers running the exact same application making writes to such a table: CREATE TABLE `metric` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, ...
0
votes
2answers
86 views

Abnormally high MySQL writes and larger than normal Binary Log files. How can I determine what caused this?

We have a MySQL master database which replicates to a MySQL slave. We were experiencing issues where MySQL was showing a high number of writes (but not an increased number of queries being ran) for a ...
3
votes
2answers
47 views

Replication with FileStream

I need to setup database replication (for high availability) on a database that uses FileStream. This is on SQL Server 2012 Standard Edition, so Always On or Peer-to-Peer replication is not an option. ...
1
vote
1answer
15 views

Postgresql wal saving for standby servers that go offline

I use postgresql 9.1 replication to a lot of workstations that have postgresql on hot standby mode. However sometimes these workstations go offline and disconnect from the master server. If they go ...
2
votes
1answer
203 views

All four data nodes in MySQL Cluster in same node group

I am testing MySQL Cluster 7.2. I have two servers, mysql1 and mysql2. I want the management server and two data nodes to run on mysql1 and two other data nodes to run on mysql2. My config.ini file ...
0
votes
0answers
12 views

Replication failure after old domain controller shut down

We changed domains on our SQL Server 2008 R2 about 6 months ago with no issues while the old domain controller was still up. The old controller was taken down today and our replications started ...
0
votes
1answer
35 views

Export synonyms content to tables

I have a distant database to replicate having huge data but I have access only to synonyms and I would like to use Oracle export/import tool to import these data into tables of local database. What ...
3
votes
1answer
128 views

PostgreSQL replication for archiving

I've looked around a bit and haven't found a very clear strategy or method for what I'm trying to do, which is surprising because I would think it would be a fairly common practice. I currently use ...
3
votes
2answers
241 views

Data sharing between client and server two ways

One of my Silverlight applications is running. This Application is using one central database (SQL Server 2008) and three other client databases (SQL Server 2008) in server other locations. Our ...
0
votes
0answers
47 views

MongoDB Sharding and Replica Set Allocation

I am going to setup MongoDB cluster: 3 config servers, 3 routing servers, 2 shards (replica set per shard). A replica set is just simply 1 primary, 1 secondary and 1 arbiter. Therefore, in my ...
6
votes
1answer
856 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? ...
2
votes
1answer
137 views

Bi-directional replication for the same MySQL table

AppA stores/retrieves data from dbA.tableA AppB stores/retrieves data from dbB.tableA tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA ...