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

SQL Server Replication - FTP Snapshot: Policy requires SSL

SQL Server 2014 on both Publisher & Subscriber. Publisher & Subscriber are across the internet. Replication is Transactional Replication Error messages: The process could not connect to ...
1
vote
1answer
25 views

Contradictory reports from MySQL that a binlog file exists

Our replication recently stopped working. I submitted a question but was unsuccessful in fixing the problem (Error 1236 - "Could not find first log file name in binary log index file"). ...
1
vote
2answers
106 views

Error 1236 - “Could not find first log file name in binary log index file”

Our setup: Master: MariaDB 10.0.21 Slave: MariaDB 10.0.17 Replication was working fine until recently at which point the slave's DBs had to be restored from a dump. I performed all of the ...
0
votes
2answers
26 views

Chained MySQL replication from Master->Master replicated pair

This is a pictorial view of what I have: Master 1<----->Master 2 | | | | V V Slave 1 Slave 2 The masters are never written ...
3
votes
1answer
20 views

mysql replication and GRANT that doesn't quite grant

I am trying to set up mysql replication. All's well, but I see an error 1045 for the slave: mysql> show slave status\G *************************** 1. row *************************** ...
1
vote
1answer
52 views

SQL Server Transactional Replication and Security Setup

I am new to SQL Server replication. I was able to setup transactional replication successfully, but I feel like I am missing some important concepts regarding security and accounts. I have a few basic ...
4
votes
3answers
739 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 ...
2
votes
2answers
1k views

Secondary and Arbiter stuck in Startup

I'm using MongoDB version 3.0.0. I'm trying to setup mongodb replication on our machine. Replication was initially setup but due to some changes on the VM the entire thing crashed. When I tried to set ...
1
vote
2answers
2k views

Which one to use? InnoDB Replication or MySQL Cluster?

I am building a url shortener and I use InnoDB as the storage engine for link data. I will start with a single VPS containing both application instance and MySQL database instance on the same Virtual ...
0
votes
0answers
31 views

Considerations to take into account for moving a big table into another database

In our application, we a have 67 GB table ( very big compared to the rest of our tables ) and it acts almost as an archive table since its record are not modified and the ratio of read operations is ...
1
vote
1answer
64 views

Composite Primary keys and auto increment?

i'm developing SaaS app with multi-tenancy, and i've decide to use single DB (MySQL Innodb for now) for client's data. I chose to use composite primary keys like PK(client_id, id). I have 2 ways here,...
1
vote
0answers
34 views

How to alter replicated column

I want to change the length of a replicated column. I ran this: exec sp_articlecolumn @publication = N'DIONLINE-SQL2014' , @article = N'Valuation' , @column = N'WallConstruction' , ...
0
votes
0answers
24 views

WSREP: Requesting state transfer failed: -11(Resource temporarily unavailable)

We have a 3 node Galera cluster. Only one node has "valid" data (gal-1). The other nodes need to sync from this node. I delete datadir and start MariaDB. 160527 14:28:20 [Note] WSREP: discarding ...
2
votes
1answer
564 views

MySQL replication error 1146

Any idea why there is '1146 - table doesn't exists' on 'CREATE TABLE IF NOT EXISTS...' statement. It actually happened only on one of the slaves (there are two in total): Last_SQL_Error: Error 'Table ...
1
vote
1answer
38 views

How did you setup MySQL Replication with autofailover that is app transparent?

Recently told MySQL is shelving MySQL Fabric. Interested how others have implemented a MySQL replicated environment that is app transparent. I am considering using HA Proxy to host virtual IP ...
0
votes
1answer
46 views

Would SQL Replication prove to be a FASTER option than downloading compressed DB files every time from servers at different geographic locations?

My requirement of synchronising two DB servers in different geographic locations is as follows synchronise some DBs on 2 servers in regular intervals (manual). One in US is an intermediate release ...
1
vote
1answer
2k views

Duplicate entry in MySQL slave

I have a MySQL master-slave replication setup. When I checked show slave status, I got the result as Slave_Sql_running:No and last error as Duplicate entry 'x' on query. But when I tried to delete ...
0
votes
1answer
138 views

“Oneway” Replication from Oracle DB to TimesTen

currently I'm really stuck into a problem and I not able to finde a nice way to realize that. I need a suggestion to replicate from oracle db (some tables) to a TimesTen. A connection is only ...
0
votes
0answers
29 views

How to set up repl_distributor for data access

I need to run queries on the distributor server from the publisher during deployment in a transactional replication setup. I see repl_distributor is set up as a linked server, but am having trouble ...
0
votes
0answers
36 views

Postgres archive_command on Ubuntu 16.04

Ubuntu 16.04: Postgres 9.5: When i start psql -c "select pg_stop_backup();" command to execute for hot standby replica. It gives me warning as archive_command as: NOTICE: pg_stop_backup cleanup ...
1
vote
1answer
6k views

MySQL slave stuck at 'System lock' most of the time, high CPU usage

Let me describe what we are facing now: We have a MySQL Master-Slave, Row Based Replication setup and at the moment, the slave is stuck with a perpetual System Lock. The Master is an active server ...
4
votes
1answer
8k views

MySQL Slave replication: Need to determine where replication left off to start slave in correct location

Idiotically I rebooted a machine that is used as a MySQL slave without running STOP SLAVE, FLUSH TABLES first. I had thought MySQL automatically handles all of this during a machine reboot, but ...
1
vote
1answer
27 views

Why does updating a large VARBINARY break replication (MSSQL_REPL21100)?

We have replication set up on a VARBINARY(MAX) column that stores image data (yes, yes, I know - don't blame me, I didn't design it). Recently, we started inserting larger images (around 200kb) and ...
1
vote
0answers
37 views

Is there a cheap way to bulk select/insert data between SQL Server instances?

In my office, our employees use applications that are consistently writing transaction-type data to a number of databases on a SQL Server 2012. The traffic consists mainly of inserts and updates but ...
1
vote
0answers
42 views

Replacement for transactional replication

My colleagues and I have to migrate a database from SQL Server 2008 R2 to SQL Server 2012. Schema, triggers, stored procedures etc. are working fine. But we also have to "migrate" the replication ...
2
votes
1answer
79 views

Monitoring streaming replication

We're setting up streaming replication with one master and one (read-only) slave. We're now looking for a way to monitor the replication; mostly to verify that the slave server is still up-to-date. ...
1
vote
1answer
36 views

MySQL binary log - write operation

Consider a scenario, where you have a MySQL master and slave server in replication. As we know, binary log enabled on the master and the slave reads from the binary log of the master. From MySQL ...
0
votes
1answer
120 views

MySQL table replication on the same server

I have one the same server (Linux) two databases: db1 and db2 and I want to replicate db1.table1 to db2.table1 I added the following lines to my.cnf and restarted mysql service replicate-do-table = ...
0
votes
1answer
50 views

(mysql) Database replication between 2 DB while 3rd DB as backup

I am not an advanced DB admin or designer. I am sure there are articles on this kind of scenario, probably too many. So I got confused and not sure which solution is appropriate/best for me. I am ...
10
votes
6answers
18k views

Add article to transactional publication without generating new snapshot

Using SQL 2008 R2 transactional replication with pull subscribers, when we add an article, I'd like to avoid having to create an entire snapshot (the db is ~80 GB, so this takes hours). From this ...
1
vote
1answer
32 views

MySQL error 1593 on replication between 5.5 on WIndows and 5.6 on CentOS 7

I'm setting up replication between the live server (running Windows 2008 R2 and MySQL 5.5.19) and a dedicated replication server (running CentOS 7 and MySQL 5.6.30). The CentOS box does have MySQL not ...
1
vote
1answer
76 views

Setup MySQL Master to Master replication/automatic failover when each Master also has a Slave

Thanks in advance. I have always worked with SQL Server and never really had any exposure to MySQL. I now have to determine the preferred setup for MySQL when there are four servers involved. Ideally,...
0
votes
1answer
46 views

MySQL Replication Duplicate Entry for Primary Key

160523 13:07:29 [ERROR] Slave SQL: Error 'Duplicate entry '914166' for key 'PRIMARY'' on query. Default database: 'zo_dev_20121216'. Query: 'UPDATE activity SET activity_type_id = 9, ...
1
vote
0answers
55 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
45 views

DDL doesn't work in MySQL master to master replication while DML can work?

I have two master in replication left master -> 5.5.47-log MySQL Community Server (GPL) rigth master ->5.5.47-log MySQL Community Server (GPL) "left master" mysql> create table test.left ...
0
votes
1answer
61 views

How to do data migration between different schemas?

My company is in the process of migrating a customer's data from their third party system into our own system. We currently use a java application that we have developed in house that selects data ...
1
vote
1answer
29 views

Syncing data from primary member to secondary after election

Maybe this is kind a stupid question but, I'm novice in configuring replication and I need to clear something before makeing anything else. Moment ago I configured replica set with 3 members in it. ...
1
vote
0answers
7 views

2 Cluster managers Control same 2 nodes and control OLTP traffic?

can you have two cluster managers controlling the same 2 nodes so that you can achieve real time replication but still direct your oltp traffic to one node and your reports to the other node?
0
votes
1answer
49 views

Corrupt Transaction Log on database

I have reason to believe the transaction log file on my database is corrupt. This database is involved in transaction based replication (both subscription and publishing), and I'm unable to start ...
0
votes
1answer
44 views

How to force MySQL master to overwrite the slave

We have a LAMP architecture website. Currently we have a production server running on the cloud and each developer has a complete copy of both the code and the database. Code is synced through Git ...
3
votes
1answer
7k views

Mysql replication is enabled but stuck at “waiting for binlog to be updated”

I have set up replication between an existing database (server-id=23), and a new one (server-id=51). I have followed the steps in this stackoverflow question, but replication is not happening. On ...
7
votes
3answers
839 views

Why Do Replication Deletes Require sysadmin Access

I am running merge replication with SQL 2012. There seems to be a nasty consequence of the delete triggers added for replication in SQL 2012. Inside the delete triggers are this, select @xe_message ...
0
votes
2answers
1k views

How to remove orphaned Log Reader Agents from Replication Monitor?

How do I remove the two Log Reader Agents with errors from the Replication Monitor? As you can see, the job does not exist (Error message produced by right click > Properties on errored Log Agent ...
0
votes
0answers
27 views

Two -way replication on the same server

I have an ubuntu server, and I have a mysql with two database. I want to sync these two database (Two way replication) either via php or command line. I have searched a lot, but I cant find something. ...
2
votes
2answers
10k views

Some MySQL slave errors?

Master version: mysql-server-5.5.14-1.el5.remi Slave version: Percona-XtraDB-Cluster-server-5.5.24-23.6.340 Binlog format: ROW based I'm using PRM to setup HA for MySQL. Sometime, MySQL slave ...
2
votes
1answer
45 views

How can I detect the use of SQL Server replication on a server (all versions) preferably using PS or CMD

I am trying to find a way to detect if a customer has SQL Server replication on. This helps decide whether they can use Express (as they frequently request) and this is one of the blocking factors. ...
0
votes
0answers
79 views

MySQL replication/cluster of multiple databases

I am 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 ...
1
vote
2answers
34 views

What type of SQL Server Replication Allows Modifications

I have an application that uses a database for each instance of the application, one instance per client. Each client wants a database for reporting as we do not allow reporting from the production ...
1
vote
0answers
54 views

Why switch? [ReplicationExecutor] another primary seen with election time xxx:1 my election time is yyy:1

On 09-05-16 - 08:41:51 Replica Set elected a new primary. The question why? Here the logs from this time series and without login messages egrep -v 'NETWORK|ACCESS'. On the same OpenStack platform ...
1
vote
1answer
123 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 ...