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
1answer
226 views

Postgresql - Minor version upgrade 9.3.5 to 9.3.6 on Ubuntu

I am two servers: A & B. My master database is running on A and the version is 9.3.5. It's replica is running on B and the version is 9.3.6. I am trying to use B as UPSTREAM slave, and trying to ...
0
votes
1answer
150 views

Replication Configuration

I had a SQL Server 2008 Express edition as a Default instance and I am having SQL Server 2012 Evolution and SQL Server 2014 Evolution are my named instances. When I was trying to configure ...
1
vote
1answer
115 views

Indexed view doesn't exist on the subscriber

I am configuring transactional replication in SQL Server. The subscription is configured as push from 2008R2 publisher (distributor is the same server) to 2012 subscriber. The object I want to ...
2
votes
1answer
2k views

mongodb replication node stuck at “STARTUP2” with optimeDate as 1970

i have just setup replica sets with three nodes . the third node is stuck at stateStr STARTUP2 with "optimeDate" : ISODate("1970-01-01T00:00:00Z"). However its showing no error message. Is this ...
2
votes
1answer
16 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, ...
0
votes
1answer
108 views

Consistent backup of large DB --single-transaction

I need to mysqldump a large DB (330 GB) in order to set up a slave for replication. Does --single-transaction allow me to dump the entire DB without shutting mysql down and keeping it down for the ...
0
votes
1answer
101 views

Mysql 1 way replication master lost data replication still has

Had a master mysql on (windows) improper shutdown. Many records could not be recovered and investigation found slave had records master did not have. Did not restore over master - left as was. As if ...
4
votes
1answer
154 views

missing indexes on distributor database

Looking for missing indexes on my distributor databases, I surprisingly find too many. the tables that need to be indexed are generally 3: MSrepl_commands MSlogreader_history ...
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 ...
2
votes
1answer
481 views

How to switch Quiescing to Normal Mode in Oracle?

I have two instance database Oracle, they are ORCL11 and ORCL10,.... I've configured them, it looks like correct. Then, I connect to replication user admin ORCL10 conn repadmin/repadmin@orcl10 And ...
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 ...
1
vote
0answers
33 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 ...
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 ...
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 ...
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
28 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 ...
4
votes
3answers
718 views

Finding differences between a master and slave when pt-table-sync fails

I have a table that's showing some differences on a master and slave according to pt-table-checksum (PTC). I've found some verifying differences beyond that. Certain tables in the mix have composite ...
3
votes
1answer
214 views

Relaying changes to a slave from another master with Tungsten on MySQL

I am trying to setup a multi-master type of replication with each master having an additional slave using Tungsten. As an example, lets say I have 4 hosts (A,B,C,D) and hosts A and C are the masters, ...
1
vote
0answers
28 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 ...
1
vote
5answers
308 views

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : ...
0
votes
0answers
53 views

Is it a good idea to disable lock escalation while adding new calculated columns to a table?

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column Is it a good idea to disable lock escalation ...
1
vote
1answer
771 views

MySQL - How to see the queries executing by slave io thread

We have a strange problem with MySQL replication. We have observed huge load and IO wait on server while replication is in progress. We can have information of the queries from bin-log by using ...
1
vote
2answers
45 views

Synchronous SQL Server Replication only for specified subscribers

I would like to create database replication between multiple localisation. There will be one publisher and multiple subscribers. Is it possible to define that synchronisation is synchronous only for ...
2
votes
0answers
88 views

How Much Overhead Does Web Sync Add?

I am running merge replication in SQL2012 using web sync. Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection? ...
2
votes
1answer
491 views

Problem when using gtid with MySQL replication

I am faced with this problem when using gtid in MySQL replication: When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please ...
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
7 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
1answer
118 views

Can scheduled and continous replication configurations exist side-by-side on the same master/slave servers?

Environment We have a core sql server cluster. This cluster contains some databases that get replicated to a load-balanced sql cluster of currently 3 servers. These databases are replicated each 12 ...
0
votes
0answers
23 views

Attach replicated .MDF file with/without log after OS reinstalled

I have SQL Server 2014 DataCenter RTM Version on Windows 2012 Standard Edition for about 2 months and had migrated a database from SQL Server 2008 R2. The database had transactional replication was ...
0
votes
1answer
149 views

New Master-Master replication has stopped working

We're building a new MySQL server pair for high availability, and of course it's not like managing a single server. We're working with Ubuntu 14.04 LTS and MySQL 5.5.43 I had master-master ...
1
vote
0answers
40 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 ...
1
vote
0answers
38 views

Real-time Synchronization

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 ...
0
votes
2answers
23 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
270 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. I have a MySQL 5.6 server (community edition) on another Linux server which is slave. I have installed various ...
0
votes
1answer
74 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 ...
3
votes
1answer
68 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 ...
1
vote
1answer
46 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
49 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
1answer
24 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
19 views

Replicating data from SQL Server 2014 to SQL Server 2005 - temporary solution

I will be installing a new SQL Server 2014 database system, which is based on our current SQL Server 2005 database system. The new system will be on a completely new infrastructure when we go live, ...
0
votes
0answers
27 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 ...
4
votes
1answer
85 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 ...
1
vote
0answers
26 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 ...
3
votes
1answer
1k views

Replicating Triggers

I am doing some analysis on merge replication and triggers for a project. I have two tables, Product and Audit that I am replicating. I have an update trigger on the Product table which is ...
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
67 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
55 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 ...