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)

0
votes
1answer
58 views

Is it ok to use 4 application server against one database server?

Initially I have two database server (Master Master Replication config with Haproxy load balancing) A and B. And two application server say P and Q. Both P and Q is pointed towards A will move to B ...
2
votes
1answer
135 views

MySQL slave server getting stopped after each replication request from Master

Basic master-slave MySQL configuration has been done on Windows machine. Master and slave servers are running on localhost with different ports. Now when executing update or insert in master server, ...
1
vote
1answer
97 views

Diffrences between master and slave replication in mysql?

In a database named asterisk, there is a table named cdr which was partitioned on the time field. mysql> show create table cdr; Create Table: CREATE TABLE `cdr` ( `gid` bigint(20) NOT NULL ...
1
vote
0answers
121 views

mysql master/master replication problem

I am having a problem with one of my MySQL servers running CentOS 7. I have it almost setup with a master master replication status. But I keep getting this: MariaDB [(none)]> show slave status\G ...
2
votes
1answer
71 views

Any risks in updating the system time on a mysql 5.5 server?

We just discovered one of our mysql systems has not been running ntp, with the result that the time has drifted a bit. If I enable ntp, and synchronize the time while the system is running are ...
1
vote
1answer
42 views

enable log_bin_use_v1_row_events in mysql 5.6

I have a MYSQL master with two slaves also running MYSQL 5.6. I want to create another slave and that needs to be MYSQL 5.5. I was wondering if replication will work smoothly. I have ...
2
votes
1answer
76 views

Remote MySQL host - is connecting to remote port 3306 vulnerable?

Hello experienced colleagues, I have a web application built on a MySQL database. I need to run another copy in a remote location, and refresh the data weekly. The size of the refresh is about 500k ...
0
votes
1answer
98 views

MySQL Circular Replication

I have this scenario where I have 4 MySQL servers (A,B,C,D), as this: Server (A) is always online, and serves as the main website. Servers (B,C and D) are online on random periods of the day, and ...
1
vote
0answers
129 views

MySQL Master-Master Crash-Safe Replication: Slow UPDATE times

Environment 2 MySQL version 5.6.26 Dedicated MySQL Servers connected on a LAN. Servers Have 16 Cores with 32 GB RAM each and are really fast. Master-Master Crash Safe Replication is setup on both ...
3
votes
0answers
103 views

How to set ALL the replication to DEADLOCK_PRIORITY LOW?

I have just got this email here: Then looking at the sql server log I find this deadlock was caused by one of our procedures (that was the victim) against the replication. O.K. in this case in ...
0
votes
1answer
44 views

Can mongoDB split read and write, with primary on HDD, replica sets on SSD?

I have three machines, each machine both has SSH and HDD, I want to save SSD space, and in my env: less write, lots read. So does mongoDB support splitting read and write, with primary on HDD, replica ...
2
votes
1answer
59 views

Switching replication master in cascading replication scenario

Imagine I have 3 PostgreSQL 9.3 databases (A, B, and C) set up in a cascading, streaming replication scenario (i.e. am NOT manually shipping WAL files, am having Postgres ship them over TCP ...
0
votes
0answers
44 views

MySQL - replication. Do slave DB schema need to resemble master

I want to do wildcard replication in mysql. I want to replicate only one table (say T1). The database in master and slave are different. Only the T1 is common between the two database. can this be ...
1
vote
0answers
92 views

SymmetricDS scheduled sync

I am trying to configure SymmetricDS to run a scheduled replication from one postgres database to another. I've seen people suggesting doing that by setting these fields in node config: ...
0
votes
2answers
42 views

MySQL - replicate some tables between transaction and report database

I have two different database (on two different hosts). One database is transactional and another database is reporting. Let us say, it stores information about departments and their employees. ...
2
votes
3answers
54 views

Mysql privileges and replication

I want to recreate the whole privilege system in my database, and that includes the slave user on the master. It means i have to stop the slave, run a set master command again and than start it. My ...
1
vote
2answers
37 views

Why is replication stopped?

Got the following nagios alert this morning for our MySQL replica: 14:49 PROBLEM: mysql2/MySQL replication check is CRITICAL, 10.1.0.133 is 72870 seconds behind, Aug 09, 21:49 UTC When I look at ...
1
vote
2answers
211 views

Backup a large postgres database for PITR

I have one postgres 9.1 master and 2 slaves setup with streaming replication with WAL archive. Now, I am trying to set up for PITR for at least a window of 1 week. This is to cover for any ...
1
vote
1answer
31 views

How to detect MySQL slave writes?

In a MySQL master-slave replication architecture, how do you detect if there have been (erroneously, since this should never happen!) direct writes on the slave? For now, I'm running this command on ...
0
votes
1answer
62 views

MySQL transaction and replication between two datacenters

I'm using a master MySQL in an east coast data center and want to setup a replication server on a west coast data center. The app server on the west coast may at times need to write to the master. ...
3
votes
1answer
113 views

Why is SAN Replication is Causing Random Database Corruption?

Having a strange issue with a disaster recovery technology we're trying to implement. The environment in both datacenters is the same having VMWare and Dell Equallogic SANs, which are the same ...
1
vote
1answer
209 views

MySQL Replication: How to restore master FROM slave?

TL;DR: given a master/slave setup between two MySQL databases, where the connection from the master to the slave is read only, how can you restore the master from the slave in the event of a failure ...
0
votes
1answer
75 views

Best approch to replicate data from one db to other db on same server

I am facing issue of time out and slow data response so I did search on Google and found that I could create a server which replicates main database data to secondary database and both on same server ...
2
votes
0answers
148 views

Replication stops with GTID_NEXT error after creation/drop of memory table in mysql5.6

We have recently upgraded to mysql5.6.25 from mysql5.5.x/mysql5.1.x on our mysql-cluster. Below is a brief snapshot of our architecture. Since we have upgraded and enabled gtid-mode we have been ...
1
vote
1answer
68 views

Replication with fail over cluster in SQL Server 2014

Presently I am Using Replication Feature in SQL Server 2012 .I want to migrate to SQL server 2014 .I want to use fail over cluster feature .Does it effect the replication feature which we are using ...
0
votes
0answers
37 views

MySQL - Seconds shown for query run time is incorrect

I came into work this morning, and first thing I noticed is that one of my Slave databases was running behind. I took a look at the processlist and could see that I had the following running. SELECT ...
2
votes
1answer
36 views

Postgres streaming replication between hosts with different timezone

I am running Postgres 9.1 on Windows 2012 servers. I am using postgres's streaming replication to replicate data between 2 servers. It has so happened that the time zone of the slave has not been set ...
0
votes
2answers
56 views

What is happening when Seconds_Behind_Master oscillates between two very different sets ov values?

I have a Percona 5.6 slave, newly set up, that is replicating from a server that is itself a slave to a third. The middle server (dbS2, the master for dbS3) is currently ~260000 seconds behind the ...
0
votes
1answer
345 views

sql server replication - how to find and drop subscriptions?

I had 2 subscriptions to a publication, but they were from the same subscriber server and writing to the same subscriber database, just one was bad and one was running fine. I could not find a ...
2
votes
2answers
611 views

Secondary and Arbiter stuck in Startup

I'm using MongoDB version 3.0.0. I'm trying to setup mongodb replication on our machine. Replication was initially setup but due to some changes on the VM the entire thing crashed. When I tried to set ...
1
vote
0answers
161 views

MariaDB multi-master replication (star topology) - Bizarre out-of-sync behavior

This may look familiar, I've been learning about this stuff for a few days - but this is a new question. I have a setup like this: Every node is a master, and I have them all replicating to each ...
2
votes
0answers
63 views

Options for copying data out of continuously updating tables

I work with a pretty large (O(10^1) TB) DB2 (LUW, v. 9.7) database. It's got data coming in on a continuous basis via Golden Gate replication from another DB2 database. It's used for business ...
1
vote
1answer
29 views

sql server replication - how to get combination of values from a binary(8) field?

I am using the table sysschemaarticles to collect information in my transactional replication. It is used for a variety of things including adding new articles and finding out who are the subscriber ...
1
vote
0answers
64 views

Demoting a MySQL Master to Slave [closed]

I recently had to fail my master over and promote a slave due to a network outage. All of that worked fine. Now that the network is back, I'd like to add my old master as a slave of the new master. ...
2
votes
1answer
118 views

How to have remote standby PostgreSQL server in different location (AWS)?

We have a primary PostgreSQL 9.4 server running multiple instances in our DC. It is using Continuous Archiving via WAL-E out to AWS S3. I would like to have a hot/warm standby server in our VPC within ...
1
vote
2answers
148 views

MySQL / DRBD / Pacemaker on EC2

I am trying to setup DRBD/MySQL/Corosync/Pacemaker on AWS EC2 instances, though I am not sure if it will work since how to integrate VIP is a problem for me. Anyone have any thoughts on what to do ? ...
3
votes
2answers
191 views

MySQL Multi-Master Replication Topology

Disclaimer: I've never worked with replication before, but I'm doing all my research. Not really having a bunch of in-depth knowledge about MySQL makes a lot of the documentation hard to understand. ...
3
votes
1answer
129 views

Data synchronization across multiple databases

I have a Django application which uses PostgreSQL as a database. The application stores hierarchical data. It is like a warehouse management system with multiple branches and hierarchy. The current ...
0
votes
1answer
42 views

Replicate update statement as Insert in Mysql 5.6

I want to replicate all update statement from Master as a Insert at Slave end. Is it possible like in SQL Server? If so, how? I want to do it because, if any record on Master is updating and if same ...
1
vote
1answer
56 views

Manual sql failover machine with replication

I hope this is the correct place to ask this question. We recently experienced one of our virtual machines being offline for 3 days due to issues in the data center hosting it. This quickly brought us ...
3
votes
1answer
68 views

Bidirectional Replication Push and Pull with SQL Server

Please bear with me, I'm a developer working with a client without access to a strong DBA. I have a question about bi-directional replication with the following setup and requirements: MSSQL Server ...
1
vote
0answers
122 views

Master/Slave and Master/Master replication - MySQL

What is the difference between having a master-slave replication and having a master-master( where in the second master acting as hot-standby - active-passive) replication? Also, what are the issues ...
0
votes
1answer
51 views

Why does adding a transactional replication publication change all the tables and columns to “not for replication”?

I'm trying to get replication set up - this is my first time ever doing it, so I'm probably making some rookie mistake here. Right now I'm just working in the dev environment. I've been following the ...
0
votes
0answers
46 views

MYSQL 5.6 replication occasional Lag

We use Mixed replication in RDS mysql 5.6 and we are noticing replication lag every few minutes or so, the lag appears momentarily and then disappears. On slaves when we do show processlist we saw ...
1
vote
0answers
27 views

MongoDB user account required for arbiter?

I have a test environment with two mongo v2.6.5 instances (#1, #2) and an arbiter instance in a replica set. I have a a common key file configured for all three instances. I have created an admin ...
3
votes
0answers
50 views

PostgreSQL Streaming Replication Tools - Windows

Is there any clusterware available for PostgreSQL clusters running on Windows OS? I'm specifically interested in automatic failover and STONITH functionality. I've done a fairly extensive Google ...
0
votes
1answer
126 views

MySQL - Enabling Scheduled Event on Master and Slave Simultaneously

This may seem a bit strange, but I am trying to get a Scheduled Event to execute on both Master and Slave. I have two databases set up in a Master (A) to Master (B) replication environment. Master A ...
1
vote
0answers
62 views

DatabaseRestart

I have strange problem, we are using circulation replication, between 2 different network with 5.6.25 and 5.6.22 version of MySQL and RAM is 64GB with 45GB innodb_buffer_pool Master Server is running ...
0
votes
0answers
38 views

What options exist for replicating SQL Server over the public internet

Specifically, I'd like to set up a reporting copy of a SQL Server 2012 transactional database. This primary runs in a managed services provider, and I want a copy in an AWS EC2 SQL Server instance. ...
1
vote
0answers
75 views

Setting up mysql replication (Master->Slave one direction)

I am struggling with the setup of a one way replication for a single mysql table. What I have done so far: Master: Added this into my my.cnf: server-id=5668439 log-bin=mysql-bin ...