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)

1
vote
0answers
6 views

Is there a way to synchronize mysql databases that are missing a few days worth of data

I have a primary-primary MySQL server setup that is connected to a load balancer. At one point, a failure occurred to where the replication wasn't happening and data was being written to one server ...
0
votes
0answers
8 views

SQL Server Replication with AWS EC2 and On Premise [on hold]

Is this going to be seamless as if not using AWS? Main concern: 1) Different domain. 2) Usage of Instance name. I know we can do it even on RDS using this 3rd party tool, https://aws.amazon.com/...
0
votes
0answers
12 views

View-Specific MySQL Replication

I'm trying to replicate only a portion of a table on Computer A (running an instance of MySQL) to a MySQL instance on Computer B, something that could easily be represented by a view. I know it is not ...
0
votes
1answer
9 views

Why do cross-database statements break replication when using filters?

For example, say you you have table A and table B on the master and on the slave you've set up replicate-do-db = A. Now if I do something like this: USE B; DROP TABLE A.sometable; Why should this ...
0
votes
0answers
11 views

MongoDB HA by reading from Last Secondary not working

Our topology is (1 MongoDB server at each location) Primary Datacenter (main server, priority 10 ) DR datacenter (active standby, priority 5) On-Prem datacenter ( When shiz hits the fan, priority .5)...
1
vote
1answer
30 views

Replication from Enterprise to Standard edition

Can I define transactional replication while the Publisher and Distributor are both Enterprise Edition and the Subscriber is Standard Edition? What do I need to consider in case it is possible (given ...
1
vote
0answers
13 views

Replication prioroty

I have two MongoDB instances running on two servers (instance1 and instance2) and they are configured as a replica set. Instance1 is the primary and instance2 is the secondary. When instance1 was ...
0
votes
1answer
11 views

repmgr 3.0.4 and postgres 9.4 on ubuntu (ERROR: replication slot “repmgr_slot_2” does not exist)

I'm not a DBA but I have been tasked with setting up a database and streaming replication and repmgr is the tool I have decided to use. The master goes on fine and I can see it registered in the ...
0
votes
1answer
15 views

Trying to understand MySQL Replication with SSL

I'm trying to get my head around the use of SSL with MySQL replication. I've spent all day reading blog posts / articles about this, and I'm still no closer to getting an answer to this question: ...
0
votes
1answer
25 views

SQL Replication, transactions Replication

I have configured a SQL transaction replication to create two subscribers and one publisher, the question is that after any deployment and changes that made on the SQL "alter procedures" on the ...
0
votes
0answers
12 views

Galera segments relay node — is there a way to prefer one?

I have geo-distributed cluster with 2 segments. Main segment is in Singapore, secondary -- in Europe. Recently I found out, that one node of main segment has RTT to Eu node about 5 times less, than ...
0
votes
1answer
16 views

Database Replication/Mirroring for Reporting Purposes

I am pretty green to the administration end of databases, but I was hoping you guys could direct me on the right path. I have Server 1, 2, and 3. They both identical versions of SQL Server, with an ...
0
votes
1answer
72 views

How could duplicate entry on unique key happen if only one master is active?

Say, I we have master-master replication with only one master active at a time. We have users table: create table users ( id int auto_increment, email varchar(255), primary key id(id), unique ...
0
votes
0answers
31 views

MySQL replication: Master to Multiple Slaves with table filtering

I have 2 separate web systems (A, B) that will end up using the same 5 tables. I'm using MySQL. System A has only one database (A1). System B has at least 3 databases (B1, B2, B3) on different ...
0
votes
0answers
3 views

Pervasive Replication - DXDeploy Error - Failed to butil-copy file

Pervasive database (v10.21.0025) that replicates between two servers. Recently the replication became corrupted. At the advice of the previous DBA, I attempted a manual clean up of the replication job ...
0
votes
0answers
28 views

Postgresql promoting slave server to master

I am trying to setup Postgresql(9.4) master-slave cluster. I am using the following tutorial: http://linux.xvx.cz/2014/10/loadbalancing-of-postgresql-databases.html The issue I am facing at the ...
0
votes
1answer
18 views

MySQL replication on slave server Broken/Stopped without error

(Hi; sorry for my English) My question is: how can I restart MySQL replication on a slave server. At first sight everything seems to be normal but when I check with SHOW SLAVE STATUS\G besides ...
0
votes
0answers
16 views

Cannot connect to a mongos

I am implementing a sharded cluster in a Windows environment. I first create the config server as follows: C:\MongoDB\bin>mongod –configsvr –bind_ip 192.168.1.4 –port 3000 –dbpath C:\Sharding\...
1
vote
0answers
9 views

Raspberry as data aggregator node, transfer to database if Raspberry is online

I have never used SQL and currently I do read and watch various turorials and the manual of PostgreSQL. I would appreciate if someone could give me a brief overview how an experienced user would set ...
0
votes
0answers
10 views

Using a view in SQL replication for horizontal filtering

I am setting up transactional replication with more than 200 subscribers. I have read that using a view for horizontal filtering of the rows is best practice so that if you need to change the ...
0
votes
0answers
12 views

Add a new column with new values

I need to ADD A NEW COLUMN with VALUES 'ABC00001234' In this case, all values in the column will be 'ABC00001234' Will the SQL statement add these column&value in the actual DBF? or for just ...
0
votes
2answers
39 views

How to improve query count execution with mySql replicate?

For my report I have to use count queries (name 'user_activity' for example) and then group by by another column (user_type) in another table (user table). And its really time consuming when it ...
0
votes
3answers
33 views

Unable to replicate a database

I setup a master slave replication, where the master has the following setup datadir = /mnt/DATADIR/ bind-address = 0.0.0.0 binlog-ignore-db = information_schema,...
0
votes
1answer
36 views

How to stop MySQL from replicating CREATE TABLE… on Slave for ignored databases

Mine is a simple MySQL Master-Slave setup, with --binlog-do-db option as discussed in this article. As per the documentation, logs are written for DDL statements for all databases irrespective of '--...
1
vote
1answer
17 views

Grabbing SQL Dump of Master DB Without Downtime

I'm curious whether downtime will be necessary to grab a SQL dump of my master database. Right now, I'm in the process of rebuilding my one slave. There is actually only one database from master that ...
0
votes
0answers
8 views

Pervasive v10 - DXDeact Error - System DSN found but no longer valid

I've inherited a Pervasive database (v10.21.0025) that replicates between two servers. Recently the replication became corrupted. I attempted to re-sync the two databases but immediately ran into an ...
0
votes
2answers
51 views

How do I script SQL Server 2012 replication to turn it off during a deployment and then turn it back on after the deployment?

The scenario that I'm in is: We have a database that is replicated but its objects (tables, etc.) are updated via Entity Framework. Whenever a schema change is made to the database by the SEs, we ...
0
votes
1answer
10 views

Postgresql: replica and HA

I've postgresql 9.4. I'm aware that there are many answer on DBA and SO, I'm aware of the wiki and the documentation. But anyway, I can't understand in a simple way what's the right way to have a ...
1
vote
1answer
33 views

Why does Publisher need to be able to connect to Remote Distributor?

I have Transactional Replication set up with a Remote Distributor and a Pull Subscription. So as I understand it, at one end I have the Publisher, and at the other end I have the Distributor, Log ...
0
votes
1answer
20 views

Live Database Sync. MySQL - SQL Server

I have a Rarer scenario, Is there any possibility to achieve the target? Here is the Situation: I have Developed a Responsive site using php with foundation framework and the back-end is MySQL for a ...
0
votes
0answers
13 views

Can a MariaDB slave have local databases?

I want to have a MariaDB Master-Slave implemented on two CentOS 7 systems. However, the slave replicates only one DB from Master. I want to use the slave to have a few other local databases too. Is ...
0
votes
1answer
24 views

Doubts on Setting up Master-Master replication (Percona)

I have two 5.6 Percona servers in which I'm planning to setup Active master- Passive master replication. Secondary master will be in read-only mode. Caveat is that the servers in which i'm going to ...
1
vote
1answer
24 views

is shared storage safe in Postgres if all servers are read-only?

Description of shared storage in Postgres: https://wiki.postgresql.org/wiki/Shared_Storage Related question: http://serverfault.com/a/620315/137464 Both of these make it clear that it's not safe to ...
0
votes
1answer
8 views

Percona server Master-Slave version query

I have a master with percona server (5.6.25) running in RHEL host and a slave of the same version. I'm facing some corruption issues in replication slave and I'm thinking of rebuilding the slave from ...
0
votes
2answers
39 views

How to not replicate index creation on ignored tables in MySQL/MariaDB

I have a setup with two MariaDB masters, each being the slave of the other. Some tables are ignored, with the configuration option : replicate-ignore-table = moodle.mdl_temp_% My problem is when a ...
2
votes
0answers
27 views

Link SQL Server Databases

I have 2 MS SQL Server Databases in two different offices (different countries), both working with the same in-house program I developed. I want to share the information in the databases between the ...
0
votes
0answers
21 views

Row replication and statement replication in the same topology?

Is it possible to set one master server replicate to one or more slaves using row-based replication and then one of the previous slaves act as master and replicate to another slave using statement ...
2
votes
1answer
489 views

High Availability SQL Server

We currently have a asp.net application running on a Win 2012 dedicated server, with a local copy of SQL 2014 Express. We are looking to add a second web server and have them in a NLB cluster. But ...
0
votes
1answer
42 views

What exactly happens during Database Mirroring? What about during a fail over?

So I am trying to configure a two server setup, both containing SQL with independent storage. We're using windows server 2012, and I have a question about mirroring. If the server's data bases are in ...
0
votes
0answers
31 views

Replication after Master down in Master-Master schema in MySql

I have set up a Master to Master replication scheme. I have 2 Master server: server A and server B. Server A is configured as follow. my.ini server-id = 1 binlog_do_db = example log-bin=mysql-...
1
vote
0answers
11 views

MySQL replication just hangs, then Database wont shutdown

I have recently set up some new MySQL Databases on a remote site. They are all 5.5.47, running on Debian Servers. They are set up as one Master with multiple slaves. The Master is itself a slave from ...
0
votes
0answers
19 views

Tool like `pt-table-sync` for Amazon RDS

I am looking for a tool / script that does the same functionality as pt-table-sync in the Percona Toolkit, (i.e. sync two tables that are explicitly NOT in a master-slave setup) but is compatible with ...
1
vote
1answer
34 views

Sync two MySQL servers data, while changing the Engine in the slave

I'm running a MySQL server 5.5.44, and I'd need to sync its data to a new server running MySQL 5.7.13 using master-slave. The idea is to bring both DBs synced until we migrate to the second, newer ...
3
votes
0answers
47 views

How to manage primary key value while multiple secondary server sync with primary server?

we have three secondary database server in different cities and one primary server. my question is i want asynchronous transaction commit to all three database but primary key data conflict occur ...
0
votes
0answers
16 views

Retrieve Subscription Data on subscriber

I would like to retrieve the subscription data from a SQL server subscriber. The data that I am looking for is the same data that is displayed under the Local Subscriptions folder under Replication ...
1
vote
1answer
19 views

Data Replication in Oracle

I have a table on master site which only allow insert operation. I want to replicate the rows which are inserted recently so, need something which can track the last record replicated into the local ...
1
vote
0answers
15 views

Mysql multisource replication : on slave map masters dbname to something like mastername-originaldbname

I need to implement a mysql multisource replication using mysql >=5.7.11, there are already a certain number of mysql servers running which will become masters for the single slave which is going to ...
1
vote
0answers
32 views

Error : failed to Retrieve data for this request when expanding subscriptions in SQL Server 2008

We are getting error when expanding subscriptions to delete them, we have already dropped distribution database. The error text is Failed to Retrieve data for this request. Microsoft.SqlServer....
2
votes
2answers
59 views

SQL Server Replication - Publication and Subscriber schema differ, need to sync

I have a SQL Server 2005 database where the publication and subscriber schema are different. This was intentionally done by turning the "Replicate Schema" option to False. However I now need to ...
1
vote
1answer
28 views

How to convert MySQL master-slave to master-master

I've searched around, but can't find the exact details to point me in the proper direction. I currently have 2 MySQL instances under 5.5.41 running as a master-slave setup. I followed these ...