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)

2
votes
1answer
11 views

Monitoring streaming replication

We're setting up streaming replication with one master and one (read-only) slave. We're now looking for a way to monitor the replication; mostly to verify that the slave server is still up-to-date. ...
1
vote
1answer
20 views

MySQL error 1593 on replication between 5.5 on WIndows and 5.6 on CentOS 7

I'm setting up replication between the live server (running Windows 2008 R2 and MySQL 5.5.19) and a dedicated replication server (running CentOS 7 and MySQL 5.6.30). The CentOS box does have MySQL not ...
1
vote
0answers
9 views

Too many open connections with MongoDB 2.6 + PyMongo 2.7.2

I was running MongoDB 2.4 with a replica set which contains 1 primary, 1 secondary and an arbiter. We were using PyMongo 2.6 and MongoEngine 0.8.2. Recently, we performed an upgrade to MongoDB 2.6, ...
0
votes
0answers
25 views

Replacement for transactional replication

My colleagues and I have to migrate a database from SQL Server 2008 R2 to SQL Server 2012. Schema, triggers, stored procedures etc. are working fine. But we also have to "migrate" the replication ...
0
votes
1answer
23 views

MySQL Replication Duplicate Entry for Primary Key

160523 13:07:29 [ERROR] Slave SQL: Error 'Duplicate entry '914166' for key 'PRIMARY'' on query. Default database: 'zo_dev_20121216'. Query: 'UPDATE activity SET activity_type_id = 9, ...
1
vote
0answers
25 views

SQL Server Transactional Replication and Security Setup

I am new to SQL Server replication. I was able to setup transactional replication successfully, but I feel like I am missing some important concepts regarding security and accounts. I have a few basic ...
0
votes
1answer
47 views

Error 1236 - “Could not find first log file name in binary log index file”

Our setup: Master: MariaDB 10.0.21 Slave: MariaDB 10.0.17 Replication was working fine until recently at which point the slave's DBs had to be restored from a dump. I performed all of the ...
1
vote
1answer
13 views

Syncing data from primary member to secondary after election

Maybe this is kind a stupid question but, I'm novice in configuring replication and I need to clear something before makeing anything else. Moment ago I configured replica set with 3 members in it. ...
1
vote
0answers
7 views

2 Cluster managers Control same 2 nodes and control OLTP traffic?

can you have two cluster managers controlling the same 2 nodes so that you can achieve real time replication but still direct your oltp traffic to one node and your reports to the other node?
0
votes
1answer
42 views

How to do data migration between different schemas?

My company is in the process of migrating a customer's data from their third party system into our own system. We currently use a java application that we have developed in house that selects data ...
0
votes
1answer
46 views

Corrupt Transaction Log on database

I have reason to believe the transaction log file on my database is corrupt. This database is involved in transaction based replication (both subscription and publishing), and I'm unable to start ...
0
votes
1answer
34 views

DDL doesn't work in MySQL master to master replication while DML can work?

I have two master in replication left master -> 5.5.47-log MySQL Community Server (GPL) rigth master ->5.5.47-log MySQL Community Server (GPL) "left master" mysql> create table test.left ...
1
vote
1answer
53 views

Composite Primary keys and auto increment?

i'm developing SaaS app with multi-tenancy, and i've decide to use single DB (MySQL Innodb for now) for client's data. I chose to use composite primary keys like PK(client_id, id). I have 2 ways ...
0
votes
1answer
25 views

How to force MySQL master to overwrite the slave

We have a LAMP architecture website. Currently we have a production server running on the cloud and each developer has a complete copy of both the code and the database. Code is synced through Git ...
0
votes
0answers
17 views

Two -way replication on the same server

I have an ubuntu server, and I have a mysql with two database. I want to sync these two database (Two way replication) either via php or command line. I have searched a lot, but I cant find something. ...
0
votes
0answers
33 views

(mysql) Database replication between 2 DB while 3rd DB as backup

I am not an advanced DB admin or designer. I am sure there are articles on this kind of scenario, probably too many. So I got confused and not sure which solution is appropriate/best for me. I am ...
1
vote
1answer
40 views

Setup MySQL Master to Master replication/automatic failover when each Master also has a Slave

Thanks in advance. I have always worked with SQL Server and never really had any exposure to MySQL. I now have to determine the preferred setup for MySQL when there are four servers involved. ...
2
votes
1answer
38 views

How can I detect the use of SQL Server replication on a server (all versions) preferably using PS or CMD

I am trying to find a way to detect if a customer has SQL Server replication on. This helps decide whether they can use Express (as they frequently request) and this is one of the blocking factors. ...
1
vote
2answers
33 views

What type of SQL Server Replication Allows Modifications

I have an application that uses a database for each instance of the application, one instance per client. Each client wants a database for reporting as we do not allow reporting from the production ...
1
vote
0answers
26 views

Why switch? [ReplicationExecutor] another primary seen with election time xxx:1 my election time is yyy:1

On 09-05-16 - 08:41:51 Replica Set elected a new primary. The question why? Here the logs from this time series and without login messages egrep -v 'NETWORK|ACCESS'. On the same OpenStack platform ...
1
vote
1answer
29 views

Offsetting reporting Load from one server to another

I have a SQL Server 2008r2 database ( Let's call it "BIG_DB") at 200GB. This server gets hit hard. It is the back end for an application, BIG_DB is a source of a lot of reporting. There are about ...
0
votes
0answers
41 views

MongoDB replication doesn't work using Java driver

I have a three instance replica set and i am using the following code to insert values in my mongodb database constantly. MongoClient client = new MongoClient(Arrays.asList( new ...
1
vote
0answers
12 views

Download the replication snapshot file using FTPS

I have two databases for two companies. Company A's database contains domain data. The other company is pulling the data using snapshot replication. We have used FTP to communicate: Created FTP ...
0
votes
0answers
31 views

subscriber table needs to be updated - how to use a batch process AND how not to upset the replication while doing it?

I have a table called tblBOrderPaymentGiftVoucher that is replicated to 3 different subscriber servers. this table is part of a publication that contains many tables, some very big. I can't afford to ...
1
vote
1answer
15 views

Cassandra change replication factor hive datastore

I am trying to change replication factor of HiveMetaStore but I receive this message: cassandra@cqlsh:system> alter KEYSPACE HiveMetaStore with replication = {'class': ...
0
votes
0answers
77 views

MySQL replication/cluster of multiple databases

I am looking for a suitable MySQL replication technology. I'll try to explain our use case first. We have several applications: 1 public web application multiple customized enterprise web ...
0
votes
0answers
10 views

MySQL master- master replication

I am in the process of setting up Master - Master replication between 2 servers on a production environment. My settings are as follows, Existing System: Server 1: Status: Master databases: db1, ...
1
vote
1answer
18 views

mysql replication: slave is not getting data from master

here is my problem that all setup is done for mysql replication but the slave is unable to sync the master's data. to understand i am sharing link below please visit. mysql> SHOW SLAVE STATUS \G; ...
1
vote
1answer
40 views

Avoiding a full re-initialization when making changes to transactional replication

When I use the GUI to make any changes to transactional replication on SQL server, I live in fear of the "the changes you have made require a reinitialization of all articles" dialog. I have had ...
0
votes
0answers
15 views

Would snapshot replication avoid the “repl table shuffle” when making schema changes?

I support an application that sits upon a SQL 2008 database and has an admin tool that allows app admins to do some field customization. This issues an ALTER TABLE command when saved, and since the ...
0
votes
1answer
22 views

Make a (copy of a) postgis database available to customer?

Our application uses a PostgreSQL database (with the PostGIS spatial extension). Now one of our customers has requested direct access to the database; because, as they claim, it’s their data. We’d ...
-4
votes
0answers
32 views

what prerequisite are required to become a DBA?not overview but to the depth of course [duplicate]

what prerequisite are required to become a DBA?not overview but to the depth of course if any online link is there to learn or course to become DBA then let me know
0
votes
1answer
30 views

How to set a mongodb node to return as the primary of a replication set?

There is this question here: How to force a mongod to become primary in a replica set? But it was not the answer I was looking for. and there is the question below, which could be related but it is ...
1
vote
1answer
39 views

If replication is 600 seconds behind master will INSERT or UPDATE queries including `NOW()` be 600s different?

If slave is behind master by 600 seconds, will queries including NOW() also be 600s different? Example: master|mysql> INSERT INTO my_table (hash,my_time) VALUES ('foo',NOW()); ### 600s later, ...
1
vote
0answers
20 views

Meta Destination Owner Differs From Actual Owner

How can the replication meta data table differ from the properties of the publication through the interface; for instance ... SELECT destination_owner FROM distribution..MSarticles Yet, when ...
0
votes
0answers
33 views

MySql 5.6: How to create a slave using gtid for an existing database, and fail over?

There seem to be very few guides on setting up mysql replication for failover (and failback) for 5.6 using gtid. The official manual shows how to do it for an existing replicated setup, but not for a ...
2
votes
2answers
82 views

How to fix a messed up replication on MS SQL Server

I restored a database from a backup. The database uses replication to publish to a different server. Assuming the database restore would break the replication, I tried to delete the replication and ...
1
vote
1answer
50 views

How to skip the current 'Relay_Master_Log_File' in AWS MYSQL RDS?

Below is the status of my slave. The master log file is at position "mysql-bin-changelog.278337" but the slave log file is at position "mysql-bin-changelog.278008". How to skip the current executing ...
1
vote
1answer
18 views

Configuring SQL Replication subscriber to a publisher in a different DNS zone

I have a server that I wish to set up a subscriber on, however the publisher lives on a different domain controller and is not in the primary DNS. To access the server, a FQDN needs to be provided. ...
0
votes
1answer
188 views

mongodb could not find host matching read preference { mode: \“primary\” } for set?

I am deploy a monodb sharding, I have deploy a replica set in three machines: dev41:27017,dev42:27017,dev193:27017 and configsvr in three machine: dev41:27019,dev42:27019,dev193:27019 and also a ...
0
votes
0answers
16 views

Amazon Aurora Replication Error

I'm creating a replication between two Amazon Aurora Cluster following this: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Aurora.Replication.html#Aurora.Replication.MySQLReplication.Monitor ...
1
vote
0answers
41 views

Replication of PostgreSQL cluster from Datacenter to Office with write access

Some information about the cluster: Version: postgres 9.5 Size: /postgres/data$ du -hs . 854G OS: Ubuntu 14.04 LTS Storage: Raid10 SSD's I have a master-slave PostgreSQL 9.5 ...
0
votes
1answer
17 views

MongoDB temporary node / mirror

When I have a running MongoDB instance with some data and requests against it, can I start a second instance on another machine, register it as another node in the first instance and all the data is ...
0
votes
0answers
28 views

SAN replication vs AlwaysOn vs something else?

Working on a DR project at the moment, we have our primary location which is all setup. Our secondary location has most of the hardware we need already. We have a Microsoft SQL driven web application. ...
0
votes
0answers
19 views

What is the easiest way to set up automatic replication of tables/schemas on two PostgreSQL servers?

I have two PostgreSQL database servers, one uses SSD, the other HDD. We struggled with the full SSD disc and we didn't need all the data on SSD all the time so we moved the majority of them to the ...
0
votes
1answer
22 views

Replicate View different servers

Using MySQL, and related to this answer open in another thread (How to replicate MySQL table in different servers?), It arises me the idea of replicating only a View in different servers (through ...
0
votes
1answer
32 views

MySQL read-write Master with many read-only Slaves over shared storage?

I've asked the same question on the MySQL forum but have also seen lots of great responses here as well so thought I would try my luck here too. We have a relatively large MySQL environment where we ...
0
votes
0answers
29 views

Replica set with SSL issues

I was able to set up a replica set with self signed certificates on Windows. However, I suspect there are some communication issues between primary and secondary. When I look at the log, I see ...
0
votes
2answers
44 views

Mongo ReplicaSet - arbiter in connection string

I'm using ReplicaSet with Mongo and when i build the connection string i have all servers hosts and ports - comma delimited. My question is, shall i add the arbiter address there as well or just the ...
1
vote
0answers
62 views

mysql replication takes 6 seconds

I am struggling trying to understand why MySQL 5.7.11 semi-sync replication using RBR takes around 6 seconds between 2 VMs on the same physical host. I have verified the network bandwidth b/w the 2 ...