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
63 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
50 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
54 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
35 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 ...
1
vote
2answers
30 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
35 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
45 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
38 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
3answers
71 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
28 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
34 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, ...
0
votes
0answers
12 views

How to create mail alerts in mysql replication environment?

if suppose In mysql replication environment Masterserver : @@readonlyflag has should be zero only,if it is changed as 1 means without notice.we need to set email alerts for that? is it possible to ...
1
vote
0answers
38 views

Real-time Synchronization [duplicate]

I have created an application in .Net with Microsoft SQL Server for desktop with a local database and an online application with an online database. Data entry will be done on both platforms in real-...
1
vote
0answers
57 views

How to identify file for “The system cannot find the file specified.” during a pg_ctl -D start?

I'm getting one message during pg_ctl -D start of the standby server. Perhaps more of a general troubleshooting question. This is what I'm seeing when I do a pg_ctl -D start: D:\>pg_ctl -D d:\...
1
vote
1answer
63 views

MongoDB Connection Issues

We have a MEAN application with a 3-member MongoDB replica set. Somehow the total connection count keeps increasing until the primary is not able to take any new connections and goes down, making the ...
1
vote
1answer
73 views

How to verify galera is synced

I have been using mysql master:master replication and was always able to check the status of replication using this command: mysql > show slave status\G I was able to see this in the show slave ...
0
votes
0answers
34 views

Slave SQL thread : Time

First of all, My SHOW SLAVE STATUS shows Seconds_Behind_Master: 0 I can compare my slave with master, n see that replication is perfectly synchronized. Now here comes the issue, When I run SHOW ...
0
votes
2answers
24 views

Source of network_name for distributor

So, I have a really weird case. Was doing a migration from sql server 2005 to 2012. Built the server, and at the last minute we found that the server was called abc/xyz. We just wanted abc, so the DBA ...
1
vote
0answers
29 views

Postgresql 9.4 replication not working

I have setup my replication as per https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps. When I start my slave and check for ...
0
votes
1answer
42 views

Galera Replication error: log block numbers mismatch

I am attempting to get Galera replication working between two nodes. I am finding these errors in my innobackup.backup.log file: xtrabackup: error: log block numbers mismatch: xtrabackup: ...
1
vote
0answers
61 views

“The schema script could not be propagated to the subscriber” error has SQL code instead of file name

This type of error is unfortunately not uncommon. One report of many is this one on Stack Overflow: http://stackoverflow.com/questions/11360331/sql-server-merge-replication-error-the-schema-script-xxx-...
0
votes
1answer
21 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?
3
votes
0answers
47 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
27 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
95 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
61 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 ...
0
votes
2answers
61 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
256 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 ...
3
votes
1answer
49 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 ...
1
vote
1answer
96 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
92 views

MySQL Error wth Relay logs - Could not open relay logs file for logging

We are receiving the following error. 2016-03-08 15:32:09 1184 [ERROR] MYSQL_BIN_LOG::move_crash_safe_index_file_to_index_file failed to move crash_safe_index_file to index file. 2016-03-08 15:32:09 ...
0
votes
0answers
40 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 ...
0
votes
1answer
122 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
11 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 ...
4
votes
1answer
91 views

How does SQL Server Merge Replication maintain referential integrity?

Note: This is a curiosity question about SQL Server. I've been reading about SQL Server's Merge Replication feature, and there's one thing I just don't understand about it: How does Replication ...
2
votes
1answer
81 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
1answer
21 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 ...
2
votes
1answer
60 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 ...
1
vote
0answers
38 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 ...
1
vote
1answer
30 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
1answer
69 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 ...
3
votes
1answer
77 views

Merge Replication Validation Failure

We are getting a bizarre error with some of our users while syncing with SQL Server 2008 R2 Service Pack 3. Validation fails even though the row count and expected row count actually match! Error ...
0
votes
1answer
25 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
32 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
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 ...
0
votes
1answer
33 views

Multiple Replication Type Publications on Single DB

I have 2x critical DB's which until recently; I was reporting on as well as using in production. DB1 is a Vendor DB and DB2 an in-house DB used in conjunction with DB1 for custom tables and views (as ...