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
57 views

MongoDB : How to estimate max number of connections supported?

We have a sharded cluster with 2 replica sets. Each replica set is a 3 member cluster with one primary and 2 secondaries. Each instance is a r3.large (aws-ec2) instance with 15G ram. mongos's are in ...
0
votes
1answer
97 views

How to improve mysql replication performance reading the relay logs in slave?

I have a mysql 5.5 row-based replication being done. The slave is slowly getting delayed relative to the master. On show slave status I see the distance between Master_Log_File and ...
0
votes
1answer
265 views

no pg_hba.conf entry for replication connection from host

(Also posted to pgsql-general) I have been configuring a slave server that needs to connect to the host. Both the master and the standby servers have a pg_hba.conf that looks like this: # Allow ...
0
votes
0answers
43 views

How do I know Postgres streaming replication is working?

I have set up a standby server to follow a primary Postgres server following [this wiki page][1]. The issue is that I am not sure the primary server is sending anything to the replica because I don't ...
3
votes
2answers
242 views

Copying MySQL Raw Data Files for Master-Slave Replication and GTIDs

I have been developing and running a mysql-based web application (intranet-based) for some time now. I wish to establish a step-by-step sane sequence for creating a slave from the running MySQL ...
1
vote
1answer
91 views

How to avoid MySQL slave to have errors after crash

I have a MySQL master/slave configuration (MariaDB 10.0.17). Sometimes, the slave or the master server crashes. After the crash and restart, I get some errors of duplicated keys on slave. The server ...
0
votes
1answer
67 views

MySQL Crash After Starting Binary Logs

Recently I have added binary logs to mysql to start replication but after that setting, mysql process failed to start and keep crashing constantly. In mysql error logs some messages are there but not ...
8
votes
2answers
2k views

Migrate heroku database to Amazon RDS with minimum downtime

I have a heroku postgres database and want to migrate it to Amazon RDS to save cost. What's a way to do so with minimum downtime? Usually this involves replicating database in real time and then ...
0
votes
1answer
67 views

Size of data in secondary exceeded primary after its initial resync from primary in MongoDB

I step down the primary node, deleted its data and performed the initial resync from new primary. But when i checked the size of data after the completion of initial resync, I found that the size of ...
0
votes
1answer
132 views

Data mismatch on Subscriber Database in SQL server transactional replication

We have Transactional replication set up between an OLTP Database server 'A' and reporting DB server 'B', where the Data from OLTP DB(Size 400 GB) "AR" is getting replicated on the server B as ...
1
vote
0answers
27 views

Replica Set In Mongo Are All Primary

So I saw a thread on here for when all the replica sets are Primary. The fix was to do rs.Add(hostportStr) on the master server before you do rs.initiate() on the server you want to become a ...
0
votes
1answer
201 views

Hi disk I/O and crash when turning on sync_binlog in MySQL

I have a MySQL master server (MariaDB 10.0.17) that have a very odd behavior. It has one slave fetching data from it. When I set global sync_binlog = 1, the server I/O goes very high and after some ...
0
votes
2answers
89 views

MySQL replication - ibdata1 huge

I'm trying to implement MySQL replication in production after I successfully implemented it on my dev environment. Basically, what I did is export the dump using the following : mysqldump ...
1
vote
1answer
56 views

MySQL: Replicate data within 2 same schemas on 1 mysql server

This might sound a bit crazy, please let me explain the reasoning behind this: we plan to use a real master-slave replication for production we want to use something small'n easy for local ...
2
votes
1answer
155 views

postgresql bdr 0.8.x - adding another downstream server only partially works

I have the following postgresql 9.4 bdr setup: upstream server with db called "bdrdemo" running on 10.1.1.1 downstream server(1) with db called bdrdemo running on 10.2.2.2 (replicates with ...
2
votes
3answers
1k views

MySql shell command not replicated to slave

I have a shell script that looks something like that: #!/bin/bash mysql -udb_user -pdb_password -e "LOAD DATA LOCAL INFILE '/srv/some_file.csv' INTO TABLE db_name.db_table FIELDS TERMINATED BY ...
2
votes
1answer
561 views

How to user the Tablediff Utility with Replication Filters

I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence. I see a problem with this approach though. This is because I am using parameterised filters to ...
4
votes
0answers
542 views

SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'

I have just set up very basic transactional replication on SQL Server 2014. The Publisher and Distributor are one and the same. I have configured the Publisher to push to the Subscriber, so any and ...
0
votes
0answers
129 views

Couldn't setup postgresql cluster with heartbeat pgsql ra

I'm trying to install postgresql cluster with the following configuration: 2 virtual hosts with RHEL 6.6 x64: postgresql 9.1 with hot standby replication pacemaker 1.1.12 resource-agents 3.9.6 I ...
2
votes
1answer
112 views

SQL Server 2014: missing replication option

This article details exact steps to set up basic database replication with SQL Server 2014. It starts with this: Right-click the Replication folder, and then click Configure Distribution. ...
0
votes
1answer
77 views

Change MariaDB 10.0.17 (MySQL) master to a slave

I have a MySQL master/slave configuration -------- -------- | master | -> | slave1 | -------- -------- I want to kill my current master, transform slave1 to be the new ...
0
votes
0answers
40 views

Slave executing queries with different charset

I need to change a database charset because of this issue and I solved my issue in staging environment with the SQL command ALTER TABLE `articles` CONVERT TO CHARACTER SET utf8 COLLATE ...
0
votes
1answer
48 views

Can I setup database triggers to run on a defined secondary set of servers only? [closed]

This might sound a bit off, but here's what I have been thinking for a while now: Use Case You want to build an activity log for each user action on your application using database (postgreSQL) ...
1
vote
0answers
16 views

Error on slave2 after promoting slave1 to master in cascaded streaming replication

I've a setup like MASTER -> SLAVE1 -> SLAVE2. MASTER and SLAVE2 are running on different ports on single server. SLAVE1 in on another server. For testing purpose I've powered off my first server ...
0
votes
1answer
25 views

Setting up replication for various mongodb micro instances

We currently have 5 mongodb micro instances on aws, each of them serve different modules and the calls are made through REST services. We are planning to setup replication for these instances and my ...
1
vote
2answers
370 views

Postgresql 9.4 high availability

I currently have a master postgresql 9.4 server containing many databases on Ubuntu 14.04. I tried to use Barman to setup backup, but would like to set up streaming replica so that when the master ...
0
votes
0answers
83 views

MySQL replication: most important config parameters on slave for performance on master server?

This query is almost the same as this question. But in this case, a configuration to make the master perform faster or just the same. Case We have a Master-Slave setup on a Mysql 5.0.77 - MariaDB ...
0
votes
0answers
37 views

Amazon rds read-replica, use as archive database

I have hosted my database (MySql) on Amazon RDS service and also created read-replica in the same availability zone. I have send my read queries on that read-replica. Now a days my database is become ...
1
vote
2answers
44 views

MySQL Replication Lag Check

we are about to replicate our database servers into several slaves in different physical locations. The company which is doing replication for us, has asked to give them a sql select statement on ...
0
votes
1answer
23 views

MySql Replicate different tables to different database

I have Database1 on server1 and Database2,Database3 on server2. Database1 has two tables T1, T2. I want to replicate T1 on Database2 and T2 on Database3. How can I accomplish it? I googled but only ...
0
votes
0answers
22 views

Replicated databases across locations; delay in application

I have a replicated instance of database on different locations different SANs which is utilized for running a vendor supported application. However, I notice that there is a significant delay between ...
0
votes
0answers
48 views

How to sync postgres roles between multiple servers

I am looking for a solution in which I can replicate the details of a role (most notably the password) between various postgres servers. (All running the same version). The idea behind this is that ...
0
votes
1answer
27 views

Delayed transactional replication setup?

I will need to setup transactional replication for a big database. I use backup/restore to initialize the database because it's too big to use snapshot over slow network. So the following steps are ...
1
vote
2answers
5k views

Best Possible Solution for Reporting Mirroring or Replication?

Hi I have SQL SERVER 2008R2 Data Centre Edition and I use SSRS and a Vendor application for reporting. I have a Reporting Server where we backup and restore everyday from Live Server to have Data ...
0
votes
0answers
22 views

Moving Replicated & Partitioned SQL2005 Enterprise to SQL 2008R2 Enterprise

Our SQL2005 Enterprise has 4 databases which are all partitioned, each have 5 files and a handful of tables replicated, compatibility mode is 90. They are on an old Windows Server 2003 32bit machine ...
0
votes
1answer
54 views

Replication Issue - Changing the replication-do-db filter

I have a server that someone has setup which are acting as a master on both database. Since they have been configured as both master on the same database, changes one on end has caused all sorts of ...
0
votes
0answers
25 views

Does MySQL Backup Restore affect Master-Master Replication

Hello I got some problems with a MySQL shemas and it seems that the schemas got deleted for an unknown reason. I try to find in the binlog for more information of this but I didn't find the way to see ...
0
votes
0answers
26 views

MySQL Replication 2003 error connecting (servers behind monowalls)

I'm trying to get MySQL replication, Master-Slave, configuration working. On my slave when I do a SHOW SLAVE STATUS\G; I get a 2003 error: Last_IO_Errno: 2003 Last_IO_Error: error connecting to ...
0
votes
0answers
47 views

Percona Master-Master lag issues

I have 2 servers with master-master replication using Percona MySQL 5.6 and I am having replication lag in the second server: db-02, however db-01 never had a lag situation. What could be causing ...
0
votes
0answers
52 views

MySQL replication error: Table doesn't exist

I just run a MySQL database master-slave replication using these instructions. The process seemed to be ok, but when I run some queries on the slave server I get this message on 3 of my tables. ...
1
vote
1answer
43 views

What User Level is needed for Transactional Replication

I've been setting up Transactional Replication between two database servers I have running. My first experiment with setting it up I simply used SA and local Admin account for all of the agents. ...
0
votes
0answers
23 views

Mongo db replication issue in 3.0.0

I updated my replica set from Mongo 32.6.4 to 3.0.0. After that i saw frequent switch between primary and secondary server. When i check the log i found this in log [ReplicationExecutor] replset: ...
2
votes
0answers
49 views

After restarting Mysql replication, Slave commands are executed

up vote 0 down vote favorite I have a Mysql Master Slave Replication which is working fine. Unfortunately I got some serious problems on my slave and the only chance I saw was to restart the whole ...
0
votes
1answer
23 views

Should I exclude mysql database from multi master replication?

Running mysql in a two master replication setup. There are many databases and they are all replicating correctly including the mysql database itself. Is it safe to replicate mysql or should I exclude ...
1
vote
3answers
40 views

Can I remove the middle slave in a MySQL “master -> slave -> slave” setup?

Let's say I have the following setup: Master -> Slave1 -> Slave2 I would like to remove the middle slave, Slave1, and have the following: Master -> Slave2 My gut is that I can do the following: ...
1
vote
0answers
141 views

Configuring slave from EC2 master to Amazon RDS slave

I am configuring replication from EC2 master to Amazon RDS instance. After starting the slave, I don't see any errors but I see slave_IO _thread is connecting. Master version:5.6.23 Slave ...
0
votes
0answers
44 views

Why are foreign keys ignored on subscribers?

We have a merge replication set up on Sql Server 2008 R2. There are many tables with foreign keys providing a logical dependence on each other. For this question, let's say there are the "User" and ...
4
votes
1answer
173 views

Best database replication technique for a very unstable (power wise) network

I am part of a small network (500 users) who are all connect via WiMax to each other. The people connected to this network live in about a 70 km radius. This network allows for a transfer speed of ...
0
votes
0answers
369 views

Mongo db replication issue with 3.0.0

I updated my mongo instance to 3.0.0. Now i am seeing this error continuously in the replica set log 2015-03-12T15:24:23.141+0530 W NETWORK [ReplExecNetThread-74] Failed to connect to ...
0
votes
1answer
243 views

can we use a mongodb 3.0 and mongodb 2.6 in same replica set?

i know that replicas using different storage engines can coexist in a replica set on MongoDB 3.0 but can we add a MongoDB 3.0 replica to a replica set that consists of MongoDB 2.6 instances ? That ...