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

1
vote
0answers
57 views

MySQL Cluster Master Master Replication - broken Leg

I have two MySQL Clusters which normally operate with Master - Master Replication between two of their nodes. Site 1 gets the majority of the write traffic, with Site 2 writing small amounts of ...
1
vote
0answers
367 views

“ORA-00936: missing expression” setting up Oracle Publisher in SQL Server

I'm trying to set up an Oracle publisher in SQL Server so I can perform replication. I've gotten connected to Oracle, the drivers work great (I have other linked servers), I can select an article I ...
1
vote
0answers
187 views

How can I correct MySQL replication while using federated tables?

This is an overview of what I have going I have 2 server A (10.0.4.22) AND B (10.0.4.29) A is a replication of B and B is a replication of A (yes it is a ring replication) ON A I have 2 table uat and ...
1
vote
0answers
58 views

pt-online-schema-change with circular replication

So I have an alter table (adding 4 columns) to do on a fairly large table (74 million rows). The problem is this table has firstly to remain online and writable during the whole operation and ...
1
vote
0answers
80 views

Replicate/Sync Production database with Development database (no Master/Slave)

I currently use ClearDB MySQL DaaS for my production database, and a local MySQL database on my dev server for development. I need to have the production database replicated/copied/synced to the dev ...
1
vote
0answers
134 views

Replica failed with error mongo db

I am running mongo sharded cluster with two replica set as shards. One set is working fine but replica secondary on other replica set is not working. When ever i restart it it gives me this error and ...
1
vote
0answers
510 views

Replication of a remote MySQL database to local MySQL database

I'm the developer of my employers corporate private website, a HTML5/PHP/CSS powered site for company reports etc. The site, hosted on a shared hosting package, connects to a remote read-only MySQL DB ...
1
vote
0answers
221 views

sqlcmd returning NUL instead of NULL for tinyint column

sqlcmd -E -d MyDatabase -Q "sp_helpsubscription" -s "," -o file.csv -W -u Column 23 which is suppose to be a tinyint (subscriber_type) is output as NUL instead of NULL when the value is NULL. I ...
1
vote
0answers
102 views

mongodb replicaset

I am adding a new member in ReplicaSet and it starts initial sync bur after certain point sync break and start resync again.this process continue and never complete its initial sync.so please resolve ...
1
vote
0answers
351 views

Error to connect mongos when trying to create replicated sharded cluster

I'm trying to create an replicated sharded cluster in mongodb. Initially I've created two shards and there are a replica set with three members in each shard. And all the shards and replicasets run in ...
1
vote
0answers
79 views

Sync/Replication of 2 Oracle Databases with NetApp storage

I am working on a high availability setup of Oracle Enterprise Manager. I need the back-end repository replicated (preferably in real time, or something close) to another repository, in which I could ...
1
vote
0answers
141 views

“Replicate” Table structures with sp_addscriptexec

In our customers environment is a massive central server (running SQL Server Enterprise 2008R2) and some distributed PCs (running SQL Server Standard 2008R2). The central server has a replication for ...
1
vote
0answers
121 views

MySQL replication of single DB to same server

I have a DB Server running CentOS 6.4 and MySQL 5.5 from RPMs (not source). I have dozens of databases but one of them is being hit quite hard with large selects which locks out other updates which ...
1
vote
0answers
62 views

replication error involving ignore-db

I have simple master/slave replication set up between two servers. The master has several DB's I wish not to replicate at this time, in fact there is only DB I am trying to replicate. I have several ...
1
vote
0answers
56 views

Sybase Replication rs_subcmp can ignore length?

I want to use rs_subcmp utility to sync one table. I've created a config file but I got the following error: Length mismatch for column #9 between the primary (50) and the replicate (100). ...
1
vote
0answers
160 views

PostgreSQL 9.3 slaves don't recognize hstore as a type

I am using the postgres built in replication with two slave nodes and a single master. On the master node (as well as the slaves) the hstore extension is installed. But whenever a query using hstore ...
1
vote
0answers
185 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. ...
1
vote
0answers
219 views

Master and slave tables with different character sets - will replication break?

We have some huge tables in our MySQL 5.6 database that have latin-1 as their character set, and want to convert them all to UTF-8 (along with converting the database's global character set). The ...
1
vote
0answers
29 views

The @article parameter value must be 'all' for immediate_sync publications

I have a publication of 4 tables and many subscribers (transactional push replication), most of them being interested by one of those 4 tables. Everything is working fine as long as I create the ...
1
vote
0answers
93 views

SQL Server replication - recommendations for stability

We have two SQL Server 2008R2 Standard servers, and we've set up replication of a single database between them. The replication is about as simple as it can get - it's a transactional replication from ...
1
vote
0answers
578 views

Postgres database zero down time production deployment

I need some idea about how I can deploy a financial application in production environment using PostgreSQL DB with zero down time. I have two servers in Master-Slave design. Currently I am giving ...
1
vote
0answers
108 views

Data replication vs parallel shard query

I'm not a DBA, and I'm wondering how a SQL Server database can scale to fit the needs of a social network. I'm not interested in NOSQL, and I understand that caching plays an important role in ...
1
vote
0answers
94 views

Replication topology advice - central subscriber

I'm seeking guidance and advice about how to set up replication in MSSQL to deal with the following criteria. We have a central server hosted at a data center - this is where our web app is located. ...
1
vote
0answers
75 views

Mysql Replication Master/Slave and Master/Master

Looking for some insight and opinions from some DBAs, as I've been tasked to look into using Master/Master replication for a single table in a database. We currently run mysql replication using a ...
1
vote
0answers
36 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
1
vote
0answers
3k views

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master ...
1
vote
0answers
28 views

SQL Replication - Data not showing

Good Morning, I have recently setup SQL replication and changed some data in one of the tables on the primary table. This data however has not been replicated to the subscription server. On the ...
1
vote
0answers
125 views

MySQL SSL Master-Slave replication not syncing

I have originally posted this thread on stackoverflow and after a comment I moved it here. The original post can be found here. I have setup a typical Master-Slave replication scheme for my MySQL ...
1
vote
0answers
478 views

Log file growth due to replication issue

I have one primary database and it's getting replicated to another server. Both servers are SQL Server 2008 R2 with SP1. Replication was running fine till last week. We have transaction log backup ...
1
vote
0answers
196 views

How to upgrade MySQL 5.0 to 5.5 with master-master replication?

I have to update 2 hosts with SUSE Linux Enterprise 11 from SP2 to SP3 which implies an update from MySQL 5.0.94 to 5.5.31. The release notes state: SLE 11 SP3 introduces the upgrade of the MySQL ...
1
vote
0answers
35 views

sp_spaceused and replication question

I have been replicating data from a table to 2 different locations and was just looking at sp_spaceused to see the size of the tables. I have noticed that the replicated tables are smaller than the ...
1
vote
0answers
146 views

Row not being deleted from the publication when it's deleted in a subscription

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
1
vote
0answers
106 views

MySQL Replication fails - commands received in wrong order?

The other day, I had this issue with one of our MySQL 5.1.60 master and 5.1.61 slave setups: Last_Error: Error 'Can't create table 'foobar.#sql-4b87_2' (errno: 150)' on query. Default database: ...
1
vote
0answers
589 views

Transactional Replication Failing Suddenly - Distributor Error

I have two databases (both SQL Server 2008 R2) taking part in transactional replication. This exists to pass data to a customer of ours, so I am troubleshooting from the Publisher side. Replication ...
1
vote
0answers
113 views

MySQL Master-Master Replication Table Row COUNT() Inconsistency

I have two MySQL servers replicating to each other in a Master-Master typology. This has been working fine for several months now. Recently I've noticed some drift in one Master. There is a row ...
1
vote
0answers
597 views

SELECT + INSERT + Query Cache = MySQL lock up

MySQL server seems to constantly lock up and stop responding on certain types of queries and eventually (after couple of minutes of not responding) give up with an error "MySQL server has gone away", ...
1
vote
0answers
521 views

Merge Replication Update Statement Timeout

I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
1
vote
0answers
80 views

Setting up replication alerts

I 'm trying to configure alerts for replication. Currently on my test setup I run everything under user 'sa'. When I try to set up alert for agent failure I get the following error Login failed for ...
1
vote
0answers
37 views

How to use a database across two availability zones

I have servers in the USA and Japan for my website. At the moment they are both connecting to a MySQL server in the USA, which is obviously perfect for my local USA clients but quite slow for my ...
1
vote
0answers
369 views

How to switch Quiescing to Normal Mode in Oracle?

I have two instance database Oracle, they are ORCL11 and ORCL10,.... I've configured them, it looks like correct. Then, I connect to replication user admin ORCL10 conn repadmin/repadmin@orcl10 And ...
1
vote
0answers
141 views

Any solution to fix circular replication fail-over?

I've developed a point-of-sale system for our corporation, which has 25+ branches across the country. Each branch has its own MySQL POS database on a WAMP server. I want every event that occurs in ...
1
vote
0answers
220 views

innobackupex: What causes Slave_open_temp_tables did not become zero after waiting 15 minutes?

As you might know, in order to assure a consistent replication state, the slave should be backup only when there are no open temporary tables: ...
1
vote
0answers
371 views

How to delete orphaned records from sysmergesubscriptions table?

I have some old orphaned records for old subscriptions that I want to delete from the sysmergesubscriptions table. Each time I delete unnecessary records, it show up again after it syncs with any ...
1
vote
0answers
528 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
355 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
172 views

Replication issue - CREATE SELECT alternative?

I've an MySQL 5.1 slave for our BI team. They need to make some CREATE SELECT with big select queries (several million lines). As CREATE SELECT is a DDL, if the replication attempts to update some ...
1
vote
0answers
562 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
92 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
54 views

Merge Replication Finding Session Id

I am using merge replication with SQL 2012. I am writing a custom business logic handler, and would like to know if there is a way to get a session id? For instance if the custom business logic ...
1
vote
0answers
88 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 ...