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

0
votes
1answer
199 views

How to real-time sync local Postgres instance to Cloud Postgres

I have a local postgres database (9.2) running on Ubuntu that is constantly being written to by an application capturing sub-second data. (99.9% of the transactions are inserts). I also have a ...
1
vote
1answer
82 views

Replication randomly started failing

I have replication set up between two servers. This morning I came in and it was failing. I was getting these errors: Error messages: The process could not execute 'sp_replcmds' on ...
2
votes
1answer
123 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 ...
1
vote
0answers
33 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
2answers
185 views

multi master replication [duplicate]

Let us say I have a master(m) slave(s) replication. Now, in the scheme of things, I introduce another database/schema(foo) not associated with the master in any way and I want this schema to be ...
0
votes
3answers
5k views

Broken mysql replication on slave server (error 1236)

My question is: how to fix broken mysql replication on slave server (error 1236)? server 1 (192.168.1.105) server 2 (192.168.1.106) I ran these steps to re-sync: At the master - server 1 ...
2
votes
1answer
283 views

MySQL replication between datacenters

I am trying to figure out the best MySQL replication topology, but I am not sure the best way to lay it out. datacenter A | datacenter B ____ | ____ | | | | | | AA | ...
4
votes
2answers
1k views

How to determine master in mysql master-slave

I am setting up MySQL Master-slave replication and I am trying to figure out how to handle the failover situation where I promote the slave to master (in the event that the master goes down). My ...
-1
votes
1answer
147 views

MySQL 5.6 Delayed Replication - cancel delay questions

I'm using the MySQL 5.6 Master/Slave replication, with Delay set for 2 hours. My questions are : Q1. What is the proper way to cancel the Delay at the slave - i.e. "roll forward" all the changes ...
2
votes
1answer
790 views

Invalid object name 'master.dbo.MSreplication_options' when restoring DB

I've tried Googling for an answer to this but have got nowhere. I have one SQL Server instance whose replication is set up to be a publisher and a distributor of FooDatabase. I have a second ...
0
votes
0answers
188 views

setup mysql row-based-replication without downtime?

Is it possible to use setup rbr on a mysql server (current version happens to be 5.5.31) to a slave without incurring downtime? (and if "yes", how?) My thought is first to configure the master and ...
1
vote
0answers
185 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
1answer
730 views

pt-table-checksum - Diffs cannot be detected because no slaves were found (1)

I'm new to Percona tools. I am trying to use pt-table-checksum as follows: pt-table-checksum h=localhost -u root -p xyz--replicate=percona.checksums --create-replicate-table --databases=mysql But ...
2
votes
1answer
38 views

Removing superfluous tables with a synchronization?

I'm using SQL Server 2008 r2's replication functionality to update my subscriber database through a transactional pull subscription. When I mark it for reinitialization, it does fix the schema and ...
-5
votes
0answers
60 views

Website is working very slowly [closed]

We have replication from Oracle to MySQL via Oracle Golden Gate. Yesterday because of some issues we have rebuilt the replication from Oracle to MySQL (this is called opal replication). Now our ...
1
vote
2answers
166 views

MySQL Replicate Databases without Tables or Content

I would like to replicate all the databases from a MySQL master to a slave used for archiving data older than 30 days. It isn't common for this data to be accessed so I would like it removed from the ...
4
votes
2answers
4k views

What max_allowed_packet is big enough, and why do I need to change it?

I have MySQL (5.5) in master-slave setup and created another slave server. I stopped the original slave, dumped the data, copied and reimported and it worked fine. I noted the master_log pos of the ...
1
vote
0answers
106 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 ...
3
votes
1answer
146 views

Transactional Replication - Snapshot metrics

I have an application that is using Transactional Replication. We are using snapshots to initialize the subscriptions. All publishers and subscribers are using SQL Server 2008. Due to the way our ...
1
vote
2answers
3k views

MySQL replication: 'Duplicated entry for PRIMARY key'

Could you please help me to understand why I'm receiving 'Duplicated entry for PRIMARY key' on a slave server after a full re-sync. Basically 'mysqldump' was running almost whole night and then the ...
2
votes
2answers
207 views

MySQL Master-Slave setup: master is not indexed and slave is indexed

Is it possible to have a MySQL master-slave setup where the master has no indexes (for faster insertion) and the slave will be indexed? Thanks in advance!
1
vote
0answers
129 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
1answer
243 views

monitoring mongodb and mysql replications using nagios

I have set replication for mongoDB and mySQL. Now I have to manage them using nagios. I have to write some php-script that will read server status. I am good with nagios setup. Now I want to know ...
1
vote
1answer
168 views

How to edit publication's generation_leveling_threshold configuration value

I dont know where I put this code: update sysmergepublications set [generation_leveling_threshold] = 0 I only need do it. But I need edited any funcion of agent.
0
votes
1answer
214 views

Compatibility level for published database and transactional replication

I am running a database on compatibility level 80 because the application using it does not yet support a higher level. It is my understanding that transactional replication on SQL Server 2005 and ...
0
votes
1answer
710 views

SQL replication Agent permission

Error messages: The schema script 'teste2_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) The process could not read file ...
0
votes
1answer
200 views

Latin1 to UTF8 on large MySQL database, minimal downtime

Let me lay out the basic scenario for the problem I'm up against. I'm running MySQL 5.1 and have a single database with 2 large MyISAM tables (9M and 20M rows respectively). Each of these tables has ...
0
votes
1answer
379 views

Insert missing rows to subscriber of Transactional Replication

I have established SQL Server Replication between SQL Server 2005 and 2008 R2. SQL Server 2005 is the publisher while SQL Server 2008 R2 is the subscriber. The replicated database is about 40GB. ...
4
votes
1answer
230 views

Why aren't my Postgres WAL segments (up to the point of turning on archiving) being archived?

The pg_xlog directory for my master cluster looks like this: -rw------- 1 postgres postgres 16M Jun 21 21:42 000000010000000000000001 -rw------- 1 postgres postgres 16M Jun 21 22:42 ...
1
vote
1answer
359 views

Mitigating MySQL replication delay in single master/multiple slave setup

For a particular web application that requires high availability I am thinking of scaling out by setting-up MySQL replication with one "write" master and multiple "read" slaves (as explained here ...
1
vote
1answer
600 views

mongodb replication node stuck at “STARTUP2” with optimeDate as 1970

i have just setup replica sets with three nodes . the third node is stuck at stateStr STARTUP2 with "optimeDate" : ISODate("1970-01-01T00:00:00Z"). However its showing no error message. Is this ...
0
votes
3answers
340 views

Replication Options with data subsets

We have an application that makes of of a SQL Server 2012 (ServerA) database. Some data that we need to display, though, comes from another database, but it's SQL Server 2008 (ServerSOURCE). The ...
0
votes
1answer
59 views

MySql Replication in two directions

I am successfully able to set up master-slave replication of database with MySQL. So, whenever I am updating my database on master, It will automatically replicated on the slave. Now, I have situation ...
2
votes
1answer
636 views

MySQL, optimize and replication

I have two MySQL (MariaDB actually) servers, a master and a slave with standard replication. Two times already in less than a month I've had my slave become unusable. This is what I experienced: ...
0
votes
1answer
43 views

Mview replication

We are setting up a large scale replicated environment and would like to know if there is a way to skip certain dml for eg. deletes during data trasfer with simple mview replication. Also, is it ...
1
vote
0answers
189 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
2answers
1k views

How to properly clean Merge Replication Setup

What is the proper way to completely clean Merge Replication setup ? I have tried to delete the subscriptions, then delete the publication then "Disable Publishing & Distribution" & delete ...
1
vote
1answer
127 views

Should my Postgres backup server be as beefy (IO, processor, RAM) as my master?

I've set up a Postgres database on a server with 2 CPU cores, 4GB of RAM and an SSD volume (on top of RAID 10 of course). This is our (sort-of) "beefy" production database server (I can easily add ...
5
votes
2answers
471 views

SQL Server Replication Alternative Software

We have used SQL Server Replication for a long time and had some issues with it that sometimes we needed to reinitialize subscriptions to fix some issues & other times we needed to destroy the ...
2
votes
1answer
94 views

PostgreSQL: How can I setup Master-Slave replication with DML changes in Slave

I have a master database (PostgreSQL 9.0) and I need to setup a streaming replication on a slave. Slave db can read/write and make schema level changes too which shouldn't write back to master. Can ...
0
votes
1answer
284 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
0answers
32 views

PostgresPlus advanced server replication testing issue

I made the replication on my Windows Server 2003 system as master DB and another XP system for slave DB. I just made the configuration, but I don't know how to check the replication of database. I ...
0
votes
2answers
366 views

Need a log based replication / CDC solution to publish postgres to oracle subscribers

We have a moderately large postgres 9.1 db that is currently 3TB and will likely grow much larger over the next couple of years. we need a reliable and fast solution for moving this data into either ...
2
votes
2answers
792 views

Percona XtraDB Cluster and MySQL Replication

I've setup a 3-node multi master replication with percona xtradb cluster, it works perfectly. Now I've tried to add some read-only slaves setting up replication as usual but it seems the binlog ...
3
votes
2answers
323 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 ...
1
vote
1answer
665 views

mysql replication goes out of sync for some tables

We are running mysql 5.1.61 on redhat systems and have the following setup One master and four slaves replicating from the master, we recently added a new slave for replication and over a few days we ...
3
votes
1answer
840 views

SQL Server Many-to-One replication

I have 8 individual SQL Server 2008 R2 machines, each hosting 1 database. Each database has an identical table structure and schema, and entirely unique data. I would like to establish a reporting ...
0
votes
1answer
322 views

Database replication using wamp?

I have created a POS system for our corporation, in the HQ we have a wamp server with the main database, we also have more than 25 branches across the country. I will setup a wamp server on each ...
7
votes
2answers
605 views

Is a geographically distributed application with SQL Server replication a good idea?

We are currently thinking about a target architecture for a geographically distributed application. This application tracks and schedules the movements of all material units across various production ...
0
votes
0answers
62 views

Replicate database without Internet connection

I'm working on a company where I have a central DB and several agency databases. See the diagram at here. All the databases are identical, just the data can change and in some cases. I've no internet ...