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
0answers
25 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
10 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
42 views
+100

MySQL replication/cluster of multiple databases

I 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
7 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
17 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
39 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
14 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
20 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
30 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
25 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
34 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
19 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
62 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
44 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
14 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
90 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
12 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
30 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
15 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
23 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
21 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
27 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
19 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
36 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
53 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 ...
0
votes
1answer
21 views

Testing postgresql 9.4 streaming replication

I have setup the replication as per https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps. And I see the slave is in streaming ...
0
votes
0answers
10 views

HA_ERR_FOUND_DUPP_KEY error after pt-OST optimize

I run a simple alter to optimize a table that had a lot of stale data using the pt-online-schema tool (wrapped for readability): pt-online-schema-change --alter='ENGINE=InnoDB;' --no-drop-old-table ...
0
votes
2answers
49 views

How to replicate MySQL table in different servers?

I am searching for some solution for the following problem: I have two MySQL Database servers in different locations. I need copy a specific table from Server A into the same table of the Server B ...
3
votes
1answer
32 views

How to migrate from a MySQL master-slave setup to a master-master setup without downtime

We have an existing master-slave MySQL replication setup where we would like to promote the second slave to a master in order to achieve a master-master setup with no or only minimal downtime. Is it ...
0
votes
0answers
65 views

is it possible to alter the primary key of a table (from non clustered to clustered) in the subscriber only and not break the replication?

I have a table that has an clustered unique index and a non clustered primary key with the same structure as the index. IF OBJECT_ID('[dbo].[tblBAccountHolder]') IS NOT NULL DROP TABLE ...
0
votes
0answers
10 views

Delivering replicated transactions in SQL Server transactional replication

I had seen this message in no. of replication cases but never got to know what is the exact cause behind this message and what troubleshooting to be done to know what is going on. What I want to know ...
1
vote
0answers
41 views

postgres wal sender replication timeout during pg_basebackup

Let me start with the caveat that I am still green with Postgres. I am working on a postgres 9.2 Active/Standby cluster on Debian wheezy for an application, based off of the ClusterLabs pgsql cluster ...
2
votes
1answer
29 views

MySQL replication stopped for over 10 days, will replication work correctly when expire_logs_days=10?

I'm foggy on exactly how replication works. Here's my scenario. Today (April 6th) I realized that our replication slave had an error caused by a failed "CREATE USER" command on March 20. Since ...
0
votes
1answer
49 views

Database design for a lot of rows with data archive

i'm new to database design on larger scale. I have some knowledge and experience with MySQL but now i have some performance issues. Currently i'm using MySQL with 3 databases: History Snapshot ...
1
vote
1answer
33 views

How to copy a Postgres database within the same DB cluster?

I want to replicate a Postgres database without dumping data using pg_dump. Both source and target database are on the same machine (Test and Production server). I would like to create a ...
0
votes
1answer
24 views

Performance in replicating table between servers

I'm using SQL Server 2014 and I have two databases, in different region of the world. One in Brazil and the another in China. The databases are exactly the same, except by the ID column, with they ...
1
vote
2answers
46 views

Replicate only specific records of a table

I have setup a merge replication and have got a new requirement: The records of a table should not be replicated until the [state] column is changed from 0 to 1. I have created a filter for the ...
1
vote
2answers
25 views

Microsoft SQL Replication

Good day, I know very little about this topic and need some advice on where to start. I have two Microsoft SQL production databases that I would like to replicate so that I can run my reporting on ...
0
votes
0answers
29 views

template1 database being accessed - PostgreSQL 9.2

I'm currently using postgres 9.2 and as you can see below, the "template1" database was being accessed: The server is a 4-day-old backup DB - does a gzip of pg_dump, excluding some tables; also ...
1
vote
2answers
29 views

MySQL Replication issues on server placed in different continents

I am running 2 cpanel servers with MySQL Replication set on them, one in france the other in US. Running a database hungary site. Replication was setup to load balance as well as for failover reason ...
1
vote
1answer
25 views

Does a read-only MySQL slave need log-bin in addition to relay-bin logs?

I'm running out of disk space on a newly initiated MySQL slave server. The bulk of disk space is in /var/log/mysql where I see both mysql-bin.000XXX and mysql-relay-bin.000XXX logs, each 1.1G. Does a ...
3
votes
1answer
39 views

backup/replication over inconsistent network

I need to setup a MySQL database server for a small number of local (write) users (~6) in a remote area with somewhat irregular internet access via WiMAX. Outages are not at predictable times or of ...
1
vote
0answers
34 views

Merge replication: some subscribers initializing by downloading changes multiple times

I have a database in merge replication with about 25 subscribers, all accessing the publisher/distributor over a satellite connection (high latency, low bandwidth). Recently, as part of a planned ...
0
votes
2answers
45 views

MySQL row-based replication - Delete Fails

We have a Master - Master replication setup, MySQL 5.6. Only one Master is used, the other is for backup and failover (we'll call that the slave). The binlog_format is set to ROW, autoincrement ...
2
votes
1answer
19 views

Removing the uses of MySQL temporary tables

We have a very huge PHP/MySQL application with a lot of legacy code, this application utilized MySQL for most of it's work. It does most of the processing on the database side using temporary tables, ...
1
vote
0answers
29 views

What is stable history in a database?

I am reading the paper Making geo-replication fast as possible, consistent when necessary by Li et al. in which they propose a geo-replication system called "RedBlue Consistency". They have a table ...
0
votes
0answers
31 views

MongoDB replication seems to be abnormal

I have a three-member replica set with 1 primary and 2 secondaries: A - Primary B - Secondary C - Secondary Initially I had only one Member A and all CRUD operations were performed on it only. ...
0
votes
1answer
48 views

Will auto_increment always grow in master-master setup?

Let's suppose I have mysql master-master replication setup with only one server active at a time (i.e. all writes going to one server), and I have ability to manually switch to another master. Next, ...