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
0answers
34 views

Replication Strategy for Multi-Office Database

I'm considering options for setting up a repository of large spatial datasets that can be used by employees across our company. We have offices scattered around the US. Our employees utilize ...
0
votes
0answers
26 views

What exactly should I backup in MongoDB when using replica sets?

I have several instances of MongoDB replica set servers with a primary and a failover machine for each replica set. The primary machine makes daily backups by creating an LVM snapshot and copying all ...
0
votes
0answers
12 views

MySQL replication error when an event is expired and dropped automatically

I have an event that ends at 2014-01-21 10:00:00, and a replication error was caused by drop event *** statement, coz the slave complains that the event does not exist at all. A little bit more ...
0
votes
0answers
32 views

Mongodb replication behind a gateway

I have a replicaset with 3 servers and I need to move two if them behind a gateway. The final setup would look something like this, Server 1 (PRIMARY) ________ | S | _____________ | _ _ _ _ _ _ _ ...
0
votes
0answers
39 views

Saving replication latency for monitoring purposes

I have SQL Server 2012 Enterprise edition, transactional replication. many servers, many DBs. This morning I come to the office and been told the latency on some databases was about 30 min behind. I ...
0
votes
0answers
62 views

Replication monitoring refresher for distribution job affecting performance

I have a performance problem due to a sql agent job executing dbo.sp_replmonitorrefreshjob. The environment is a 2 node Cluster with SQL Server 2005 SP2 and with transaction replication. The OS ...
0
votes
0answers
25 views

Error “Slony-I creation script not avilable ; only joining possible” in SlonyI replication using pgadmin3

I am facing the above issue while Creating a base replication objects like database etc.. As a workaround i have done the changes like editing the options of Binary Paths in Pgadmin Console but no use ...
0
votes
0answers
36 views

What should be the ideal network configuration for a Postgresql Streanming Replication and PgPool HA setup

I have the following configuration using Pgpool, Postgresql with streaming replication. Pgpool is used for load balancing and automatic failover. .-----. .--------. | | ...
0
votes
0answers
23 views

Mysql Master - Master Replication

i have established a master A and master B replication between two servers.Both are getting replicated.But it is limited with only one database. My questions 1.How to create a new database in ...
0
votes
0answers
22 views

MySQL multi masters with replicas

Currently I have a Master-Master setup, however there is a need to create replicas servers in geographical areas. I am trying to figure out the best method to handle this. The kicker is not all ...
0
votes
0answers
39 views

mysqldbcompare showing AUTO_INCREMENT differences but there are no missing records

I am encountering a strange issue when using mysqldbcompare to compare two MySQL DBs(one is a master, the other its slave). I noticed that the tool notes that the AUTO_INCREMENT values of this ...
0
votes
0answers
190 views

How to solve MySql Slave Error 1452 Foreign key constraint fails?

I am site administrator. We use to have a mysql 5.5.40 master(db01) - slave(db02) setup. One day our master server (db01) got down due to hardware failure. So we switched our site to slave (db02) ...
0
votes
0answers
19 views

Replication lag is causing issue on one shard

I am running a mongo db sharded cluster with two shards. Each shard has one primary, one arbiter and one secondary. On one shard I am facing an issue with replication as it is showing this result ...
0
votes
0answers
33 views

Mysql Multi master replication - auto_increment for tables with natural primary key?

I am thinking about using Master-Master replication using Mysql 5.6.19 with InnoDB as the engine. From what I have been reading, looks like I should be using auto_increment_offset and ...
0
votes
0answers
21 views

Sudden (and drastic) decrease in commands/second on replicated slave

On a slave that uses statement-based replication from a failover of master (all running mysql 5.6), the number of queries executed per minute has suddenly decreased from ~20k during peak traffic to ...
0
votes
0answers
20 views

MySQL Remote Database Failover: Need Advice

I run a network of sites all on 1 server. To improve performance, I'm (finally) moving the MySQL database to a remote machine. I'd love anyone's advice on how to appropriately approach failover. ...
0
votes
0answers
48 views

Reset relay files on lagging slave after MySQL crash signal 11?

MySQL crashed on this slave server with signal 11: Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) Slave I/O: Replication event checksum ...
0
votes
0answers
65 views

MySQL Master-Master-Slave failover

I have setup a Master-Master configuration in MySQL with one additional slave, like this: Master1 <-> Master2 <- Slave Master1 is the write master used by my application, Master2 is used ...
0
votes
0answers
45 views

SQL Server 2008 R2 - Replication - Multiple Publications on a single database

I have hit a problem and I need an idea of where to look or how to resolve. I have setup a publication and 2 subscriptions to it, 1 running on a schedule and the other running continuously. I need ...
0
votes
0answers
24 views

Checking for replication options

I have a master/master setup with one DB in each. DB name and tables in one server are different from the other, and few 'user' tables are being replicated with the option replicate-do-table. (It's ...
0
votes
0answers
38 views

Data on the slave becomes inconsistent after couple of days

We are planning on upgrading our production MySQL server from MySQL 5.0.77 to Percona 5.6.19-67.0. Since our downtime window is small, we setup a slave of the production master on a new host and ...
0
votes
0answers
40 views

Differing AUTO_INCREMENT values between 5.1 vs 5.6 slaves

I have a MySQL 5.6.21 slave and a MySQL 5.1.73 slave that are both replicating from the same MySQL 5.1.73 master. I noticed that for several of the tables ( I said several because when I try to rerun ...
0
votes
0answers
51 views

sql server snapshot replication compatibility issue

I have 2 SQL Server 2008 R2 and I am trying to set up Snapshot Replication over the Internet. I have successfully managed to get the subscriber to connect, but now as the Job executes on the ...
0
votes
0answers
63 views

Amazon RDS replication with external slave

I've recently configured a replication with an external MySQL master and RDS as slave but now I need to reverse that config and use RDS as master and the other instance as slave. Actually I use a vpn ...
0
votes
0answers
37 views

Last synchronization time between master and slave (replication)

During replication process where a Master is connected with slave. Some times connection between these two goes down. Any options to get the details of the last synchronization time?
0
votes
0answers
64 views

Creating SSL certificates for a MongoDB replication set

So I figured out my issues regarding connecting a node to a node or a client to a node in my replication set and now I'm trying to figure out how to bring this together so that all of my nodes can ...
0
votes
0answers
5 views

MySQL Master Slave replication seems to affect whole solution

We are running 2 master slave pairs on a web application MySQL 5.1. The concept is to keep all data in sync so that we can via a config file point all customers at one master slave pair to do ...
0
votes
0answers
107 views

Bucardo doesn't do fullsync

I have a 2 computers, one of them called master, and the other called slave both using PostgreSQL 9.3.5, but has different OS (32-bit and 64-bit) I have installed and setup the bucardo on the server ...
0
votes
0answers
115 views

MySQL Binlog Dump process stops after net_write_timeout

We have 2 MySQL 5.6.19-1 servers with master-master replication that were working fine (DB01 and DB02). One of them was rebooted unexpectedly (DB01) and seemed to be working fine, but we saw that the ...
0
votes
0answers
17 views

mysql replication error 1236 need to restart replication process

I'm using mysql replication and the slave/master crashed in the process and then I got: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in ...
0
votes
0answers
338 views

MySQL 5.6: explicit_defaults_for_timestamp

I have the following replication topology: DB1 (MySQL 5.5) -> DB2 (MySQL 5.6, explicit_defaults_for_timestamp = 1) -> DB3 (MySQL 5.6, explicit_defaults_for_timestamp = 1) - "date" field: ...
0
votes
0answers
20 views

MariaDB replicate views

I have a database in MariaDB from which I wan't to provide information from some of it's tables (for example, from the users table I don't wan't to showpassword, and also skip some users, like admin) ...
0
votes
0answers
261 views

How to split task (read and write) between two mysql server via HAproxy load balancing?

I have done some test and setup two (A and B) different database server from the following link - https://www.digitalocean.com/community/tutorials/how-to-use-haproxy-to-set-up-mysql-load-balancing--3 ...
0
votes
0answers
23 views

MySQL Replication problem with VIEWS and “Sub-Databases”

I've got three servers that should do a master-master replication. On server 1 i got "01_maindb" which holds the master tables. I replicate this table to the two other servers without problems. ...
0
votes
0answers
22 views

why is latency growing

I have a 4.4TB database that I've been transactionally replicating to 2 different subscribers just fine. Yesterday I added a 3rd subscriber that is all flash drives to test how much better it will be ...
0
votes
0answers
46 views

Best upgrade path for MySql 4.1 to 5.5?

Background Our production environment runs on a system that nobody wanted to update for a long period of time. With a new sherrif in town, we're going to update it. Production is MySql 4.1 with ...
0
votes
0answers
22 views

Bidirectional transactional replication for failover system: Managing sql server jobs

I have set up Bidirectional transactional replication for failover system. I have taken care of Identity columns (have reseeded their values from a higher value) and all other things. But how can I ...
0
votes
0answers
36 views

How to do multi master replication on Database with Triggers in Oracle

I need advise on how to go about multi master replication on Database with Triggers in Oracle. i have "Database A" with Triggers on every transaction. need to have 2 more db's as hot standby,problem ...
0
votes
0answers
50 views

How many Slaves Can I to replicate with one Master Server with MySQL?

How many Slaves Can I to replicate with one Master Server with MySQL?, because I have a inconvenient, I have three servers that replicate a MySQL database. I've maked all the configurations and the ...
0
votes
0answers
49 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 ...
0
votes
0answers
31 views

MySQL master/slave replication - replicate all tables

I am doing a master/slave replication, but getting errors about my tables does not exist. Is there not a way where i can make the whole table structure replicate aswell? Thought it did on default tbh. ...
0
votes
0answers
32 views

Replication overview

My boss wants me to elaborate a comprehensive report about synchronisation/replication. I know that replication can be done with the DBMS (we are using SQL Server 2012), but he wants something manual ...
0
votes
0answers
32 views

Which primary keys must be specified when using slony PostgreSQL replication?

I'm extremely green when it comes to databases, so forgive my ignorance. I've been researching ways to replicate our production Postgres DB, and I've decided to try out Slony. Since the server is ...
0
votes
0answers
68 views

Understanding correct procedure to recover master in master-slave replication in PostgreSQL

For learning, I have setup master-slave streaming synchronous replication. Pg-pool 3.3.3 is installed in one VM and it connect to 4 VMs which runs PostgreSQL 9.3, one master and 3 slaves. Replication ...
0
votes
0answers
158 views

Subscription fails with Incorrect syntax near '9'

In my Distributor To Subscriber History I get the following error: Command attempted: 9 (Transaction sequence number: 0x0018E94F0000207A006200000000, Command ID: 59) Error messages: ...
0
votes
0answers
46 views

Bucardo status does not feel if the slave is down

I am using bucardo as third party to postgresql replication between two sites. everything ok except buacrdo status <sync_name>. I have a Master-slave sync on master server. when I poweroff the ...
0
votes
0answers
156 views

Replication saying my snapshot Publication Does Not Exist. But it does exist

enter code hereI used the SQL Server (2008) wizard to create a new snapshot publication on my sever called "BlinkViewsOnly" in the BlinkDataMaster database. Publication was created successfully. I ...
0
votes
0answers
319 views

SQL server replication error - the row was not found at the Subscriber

I am doing transactional replication on specific tables. I am getting an error: The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: ...
0
votes
0answers
89 views

Database design for large incoming data

I've been tasked to design a database to handle a large volume of incoming traffic from sensor readings, possibly 1,000s an hour when it's at full strength. Each reading will be relatively short - ...
0
votes
0answers
42 views

Is there a MySQL setup for my use case?

I have multiple nodes that are mostly independent of each other, meaning 99% of traffic is reads to data contained inside themselves, plus some writes that need to be instantly available for the node ...