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

Is reply to client about transaction commit, before binary log or after?

When does MySQL server reply to client that a SQL statement has completed or a transaction has been committed? Before it writes to binary log or after?
1
vote
0answers
13 views
3
votes
0answers
33 views

AS/400 + DB2 to MongoDB?

I'm not seeing a whole lot of info on the subject, so I figured I'd ask people who might know more about it than I do: Is it possible to replicate data from an AS/400 + IBM DB2 instance to MongoDB? If ...
1
vote
0answers
23 views

MySQL master to slave dump fails when done over SSH pipe

When we need to [re]build a MySQL-5.5 slave, our usual approach is this (CHANGE MASTER TO / START SLAVE omitted for clarity): master$ mysqldump -uroot -p --all-databases --master-data > dump.sql ...
0
votes
0answers
68 views

SQL Server could not retrieve the list of publications for 'XYZ'

First of all please note the following carefully: I have a source database named S_DB on one SQL Server hosted on a machine named S_SRV, on a domain named S_DOM. On a different domain named D_DOM, ...
0
votes
1answer
56 views

Does exist some software for transforming data from one DB schema to another?

I need to transform between two different database schemas the same data. For example i have one table in old schema like this: and i need to transform it to new schema like this: So i have few ...
3
votes
1answer
44 views

MySQL replication and master users on slave server

Do the users initiating inserts on the master server also have to be on the slave with at least as many permissions for the replicated queries to be correctly executed? My understanding is that you ...
0
votes
2answers
51 views

MySQL Backup Strategy

We are running the backup from the replication server and it is working good, since we are not facing any other issues, some information for better understanding our strategy: Backup Type: Full ...
1
vote
1answer
71 views

PostgreSQL streaming replication lag for synchronous standbys

We use PostgreSQL 9.5 in a master + synchronous hot-standby setup, i.e., using synchronous_commit = on and using synchronous_standby_names='*'. Consequently, the standby has sync_state = sync in the ...
0
votes
1answer
12 views

What configs influence whether user credentials/grants are written to the binlog in Mysql

I have a fairly trivial master-master setup. When testing this setup I see that mysql users are binlogged and replicated on slaves. However on each of the masters the binlog-do-db* is for a specific ...
0
votes
1answer
87 views

Transactional Replication from SQL Server to Azure SQL

I'm attempting to setup transactional replication between an on-premises SQL Server and an Azure SQL database. Unfortunately, it looks like Azure SQL doesn't support SQL Server Replication, and Azure ...
0
votes
0answers
28 views

MongoDB sharded Replica cluster AWS

I am currently evaluating where to run a sharded&replica MongoDB cluster right now I am looking into: self hosted, or either self made on AWS with a bunch of EC2 instances AWS cloudformation ...
2
votes
1answer
7 views

Is automatic failback on Postgres 8.4 possible via log shipping/PITR?

I have successfully setup continuous archiving and recovery of a master and slave node with PostgreSQL 8.4 via log shipping. I'm using keepalived to monitor both nodes and I can successfully trigger ...
0
votes
0answers
30 views

Mysql hung at 41% CPU Usage

We are using 3 servers. Master Server1 syncs data to Server2 & Server3. Server1 -- Debian -- MySQL 5.5.40 Server2 -- CentOS 6.6 -- MySQL 5.5.45 Server3 -- CentOS 6.6 -- MySQL 5.5.43 All 3 ...
1
vote
1answer
84 views

Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs

How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database? I want to have a replication/slave database to have all the ...
0
votes
1answer
84 views

ReplicaSet MongoDB

I'am trying to create replcaSet in MongoDB and I'am facing a problem. This is what I did step by step: 1- I entered this command to create these repertories: mkdir \data\rs1 \data\rs2 \data\rs3 ...
2
votes
1answer
77 views

Inserting data into table in server B whenever table in server A gets updated

I want to synchronize data from table 1 in server A to tables 2 and 3 in server B, whenever table 1 gets updated. Tables from server A are not related to tables from server B, so I'd have to specify ...
0
votes
2answers
307 views

Can we disable binary logging for one specific session or user in AWS RDS

Currently we have a situation to disable binary logging for one set of queries on AWS RDS. We thought to set log-bin=0 for that specific session. As per Amazon, this is not possible. Is there any work ...
1
vote
1answer
53 views

High Availability for MariaDB and Postgres : replication or active-passive (SAN)

During the last weeks I did a lot of research on High Availability for Postgres and MariaDB. Both by my own research and also recommended by vendor's, replications seems to have more advantages. Some ...
0
votes
1answer
18 views

Slave (SQL thread) replicates very slowly

See this video: https://mckay.media/Yxjp2 I have two MySQL replication slaves which are replicating from the same master. Both slaves are running on identical hardware. Each has its data directory ...
0
votes
1answer
30 views

Adding a db for replication into mysql

Currently I have these settings. I am adding a new db called mydb3. How to enable the replication for this new db? Currently I have copied the table schema into both master and slave. What other ...
0
votes
1answer
19 views

Default binary log position for change_master_to in MySQL circular replication?

I have two MySQL servers set up with replication - lets say A and B for ease. Currently B is a slave of A To allow me to switch over to A in event of failure, I want to make this replication ...
0
votes
0answers
40 views

MySQL Bin-Log Courupped

In the recent time we have found that the bin log is getting corrupted, 20% binlog files were having errors, which couldn't even pass the sanity check by mysqlbinlog -u user -p mysql-bin.000021 | head ...
0
votes
0answers
11 views

I can't create a transactional replication

I have two databases identically in two SQL Server 2014 instances. The problem is as follows. I can access from server A to B, I can create the publication in server A and access to that publication ...
2
votes
1answer
44 views

Hybrid Synchronous / Asynchronous Replication?

We have a situation where we would like to have synchronous replication in our main data center, but replicate asynchronously to another region. Our second data center is 3,000 miles away (Site B) and ...
0
votes
1answer
20 views

Multi master single slave replication mysql

I have a scenario in which there are two masters master 1 and master 2 and i want to add slave to master 2 , so when i update in master 1 it will replicate for master 2 so how do i get slave of master ...
1
vote
1answer
50 views

Which error codes are safe for `slave_skip_errors` with MySQL Innodb

Does anyone know which error codes are safe to ignore during replication, meaning the slave will remain consistent with the master? For example [mysqld] ...
1
vote
0answers
21 views

Changing tx_isolation and binlog format on master server - do i also need to adjust slave?

We are running a Drupal Commerce site with MariaDB 10.0 and master/slave replication. Because of the way our application works, we end up running in to a ton of deadlocks under heavy load. Apparently ...
1
vote
0answers
34 views

Merge Replication query causing slow performance

I have three databases (one publisher, two subscribers) running merge replication and this morning noticed very slow performance. They sync on 10 second intervals but this morning it was taking much ...
0
votes
2answers
43 views

what's difference between sql_log_bin and log_bin in MySQL?

can anybody tell me what is the difference between them ?
4
votes
2answers
92 views

Is there a way to create a MySQL/Percona Slave without using a dump?

I haven't been able to find anything so I'm sure the answer is no, what are you, a noob? but I feel the need to ask anyway :) Is there a simple utility that would allow a new slave server to be ...
2
votes
1answer
57 views

Sync two SQL Server database

Currently we have one SQL Server 2008 R2 database server in location X. All application users are in location X. All instances of the application can add data to database table and which may be ...
4
votes
1answer
643 views

SQL Server Replication :: Dedicated Distributor Hardware Requirements

Does anyone know any rules of thumb (or better) with regards to hardware requirements for a dedicated distributor server? i.e. Based on estimate metrics (e.g. number of subscribers, publishers, ...
4
votes
1answer
4k views

MySQL Replication: Seconds Behind Master super high

I've set up a slave db server for my production database, but when I checked the show slave status, I noticed a super big number in seconds behind master. This is the output: ...
0
votes
2answers
45 views

Mysql - How can I replication structure, not data

I have master with 2 slaves (4 but other 2 not relevant). One slave is full replication, ability to switch to be master if needed. Second slave was designed to replicate certain tables and leave out ...
0
votes
0answers
11 views

Replicated data from 2 databases into 1 on a server - Don't know how to revert

I am not SQL certified enginner however company doesn't care when it comes to protect the data. I have a site with two databases: Live Test In the testDB there were several entries created in ...
1
vote
2answers
96 views

For a standby workload of long running analytical queries, is it better to turn on hot_standby_feedback or set max_standby_*_delay settings to -1?

When spinning up a hot standby server specifically for BI/Analytics purposes where long running queries may be common, is it better to turn on hot_standby_feedback or set the max_standby_*_delay ...
1
vote
2answers
70 views

Running pt-table-checksum with replicate-do-db option on

I've read the documentation on percona page, but still a bit confused, especially about the --replicate option. My setting is that the slave is only replicating certain databases from master, say db1 ...
0
votes
0answers
33 views

Replication vs extracting just the data we need?

I recently did a project with a developer who wrote a desktop app. This is used by a few businesses, and each business has their own database installed locally. The app does not use any Internet ...
3
votes
1answer
50 views

Replicating redis foreign table via postgresql synchronous replication

I have synchronous replication between db server, DB1 and DB2. Tested, working. I have a redis server (RD1), integrated with DB1 (master) via redis_fdw, no issues here. I was expecting foreign redis ...
0
votes
2answers
46 views

replication error

I am getting error for connect to master (mysql 5.1) from slave (mysql5.7) Slave I/O for channel '': error connecting to master 'replica@hostname' - retry-time: 60 retries: 6, Error_code: ...
1
vote
1answer
2k views

How to generate replication snapshot without locking tables

When I reinitialize subscription and generate new snapshot it locks all tables and makes the database unusable for a very long time (never waited it out). Is there anyway to do this without locking?
0
votes
1answer
28 views

Replication/log shipping to a standby site [closed]

I need to replicate a SQL Server database on my standby site. Regarding Log Shipping, I have the following concerns: Is there any data type or primary key dependency exists if I use log shipping? ...
1
vote
2answers
60 views

Can MongoDB be configured to sit behind a load balancer?

According to this post: In a single replica set, you cannot distribute writes, they all must go to the primary. You can distribute reads to the secondaries already, via Read Preferences as you ...
1
vote
1answer
24 views

Changing replication snapshot folder, require re-snapshot?

We have SQL Server 2012 SP2 running on Windows Server 2012. We need to change the snapshot folder for all (including default) transaction replication publications. I have read that this means the ...
2
votes
1answer
544 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 ...
7
votes
2answers
647 views

Creating an incremental database copy in PostgreSQL

Virtual machine software like VirtualBox allow one to make incremental VM clones. That is data, once "touched" (opened writable), will be copied and stored in the incremental cache of the new clone. ...
0
votes
0answers
32 views

MySQL Master-Master - different bin logs

We have Master <> Master replication. After some start-stop issues - I found some odds in replication. First - on both boxes we have an error: 160226 10:08:59 [Note] Slave I/O thread: connected ...
1
vote
1answer
38 views

MySQL Replication - 1 Master - 2 Slaves. Inserting works for One, not the other

I am a Python developer, working with 3 databases, configured in Master -> slave,slave style. Each slave has their own application associated with it. I am not too familiar with database ...
2
votes
1answer
77 views

SQL AlwaysOn & System Center Configuration Manager TP 4 1601

Recently Microsoft released Technical Preview 4 for Configuration Manager (1601). Per TechNet, "Configuration Manager now supports using a SQL Server AlwaysOn availability groups to host the site ...