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

What's the best setup for a MySQL multi master replication for a POS in a restaurant?

We're in the process of implementing a point of sale (POS) solution where we have heavily modified an existing open source POS. The original POS was never created with replication/synchronization ...
1
vote
2answers
211 views

MySQL / DRBD / Pacemaker on EC2

I am trying to setup DRBD/MySQL/Corosync/Pacemaker on AWS EC2 instances, though I am not sure if it will work since how to integrate VIP is a problem for me. Anyone have any thoughts on what to do ? ...
0
votes
2answers
44 views

Replication : Delete from Master Database

Is it possible to delete certain data from Master Database and retain that data in the slave ? For, example I want to delete data of before 5 years from master. And I'm sure that data is not being ...
0
votes
1answer
199 views

Got fatal error 1236 Slave has more GTIDs than the master has, using the master's SERVER_UUID

We are testing replication using GTID's on two servers running MySQL 5.6. Replication was running fine, but now it is not functioning. When I run show slave status\G on the slave, I get the following ...
2
votes
0answers
19 views

Promote Postgres standby while materialized view updates in primary

I have one primary Postgres server (serverA) and one standby Postgres server (serverB), both running Postgres 9.4 with Streaming Replication enabled. Is it possible to update a materialized view on ...
0
votes
0answers
31 views

Replication not working

I configured master slave replication and it worked fine however it stops working after 5 min or so! Although slave status show that replication is fine, however whatever I insert in master isn't ...
1
vote
1answer
68 views

Masters database not replicating on slave after restarting client

I'm trying to implement master slave replication and It's works fine with no errors, database is replicated on slave, but when I close my servers and open them again and add something in masters ...
3
votes
1answer
831 views

MySQL relay log rotates too soon and too often

I have a simple master/slave setup where the slave is just a backup. Sometimes I notice that the relay log on the slave rotates too often and too soon, when it is still very small: 4:00 PM ...
6
votes
1answer
70 views

How do I replicate a database over 2 geographical sites?

Disclaimer: I have no idea what I'm talking about here, or if what I'm doing is the correct thing to do. Long story short, my superior has asked me if it's possible to replicate our internal database ...
2
votes
1answer
40 views

How to make most of aws?

I'm new to aws (just one day old). I'm impressed with aws free tier and want to utilize to its best. As of now I'm done with installing mongodb on aws micro instances and mongod EC2 instances are ...
6
votes
2answers
181 views

3 Node Replica Set all became SECONDARY

My 3 set replica set all became secondary and I'm not sure why. The logging I got was: db1 2014-12-12T02:43:55.067+0000 [conn1413096] end connection 10.0.64.12:58483 (512 connections now open) ...
2
votes
1answer
509 views

Slave can not handle replication events with the checksum that master is configured to log

My slave is not connecting to the master and is showing the error Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum ...
0
votes
1answer
60 views

mysql replication master-slave with 2 or more users in master

I've just configured mySQL replication master-slave. I have into master instance 3 user: root (with all privileges and grant), admin(with all privileges) and slaveUser(with replication salve ...
1
vote
2answers
33 views

Master Slave database syncronization

Hi I have just started reading about this replication concept and one thing I want to ask is that when we change something in the slave db how is it going to effect the master db? Is there a sync algo ...
1
vote
1answer
49 views

master-master replication or master slave replication?

We have right now one server with a database. A device and a website are accessing that database causing load What I want is to create two servers master-slave where master databases are replicated ...
2
votes
0answers
23 views

a story about a bad replication issue - insight needed MYSQL

A id val B id A_id We are not sure of what happened but it appears that when replication occurred on a series of these two table datasets, that A failed replication, but another insert got the lost ...
0
votes
0answers
26 views

Slony PostgreSQL replication from Chile to US (between datacenters)

We are moving from a datacenter in Chile to one in AWS (in USA). We've already moved most of our servers but the database (PostgreSQL). As the source server is in a VMWARE environment, we took a copy ...
2
votes
3answers
196 views

Snapshot replication - How to detect when a snapshot has arrived on the Subscriber from the Subscriber DB

I have snapshot replication set up on a server which publishes to a second server as part of a scheduled SQL Server Agent job. When the snapshot finishes, I would like to detect when each table has ...
0
votes
0answers
41 views

Mysql Replication Grant Privilages and Different row records

I followed the steps answered in the following question Setting Circular Replication in mysql I applied this steps in only two nods not three nods I was trying to add commend answer ...
1
vote
2answers
51 views

With MySQL 5.6, Is there any way to keep a replication slave X seconds behind_the_master?

It'd be really nice for disaster recovery to be able to set this up. We are doing snapshots, but this seems like it'd be a really nice backup to have. For example, I'd like to always keep a ...
1
vote
2answers
823 views

ERROR Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

We are facing the issue in replication that we are not getting any error in Show slave status\G output rather facing the following issue in Error Log File [ERROR] Error reading packet from server: ...
3
votes
1answer
39 views

Clarification on Database Replication

SQL Server 2008 I have to do database replication which is a new for me. Goal is have mirror database on servers 2 and 3. When we set up database replication in the Server 2, 3 from Server # 1, ...
3
votes
2answers
54 views

Replication DB move

I have 2TB of DB involved in SQL Server transactional replication. I want to move publisher DB files to a newer disk with minimum amount of downtime and without breaking replication. Please let me ...
1
vote
0answers
35 views

After disabling replication, should I disable binary logging?

I have a master-slave setup currently but am going to remove the replication DB server. The DBs are running on MySQL 5.6. I have a couple of questions about removing the replication: 1) I have read ...
1
vote
1answer
15 views

mysql off-site replication ( file only )

I am new to mysql, I have extensive experience with MS Access and some with Tivoli. I have tried to search the net for my solution but there is such a massive quantity of results I can't find a ...
1
vote
2answers
38 views

Database mirroring with fixed set of tables without sql server replication

We have requirement of mirroring the database with some fixed set of tables. We do not want to use sql server replication for that purpose. Do we have any solution for that or any software for this ...
1
vote
0answers
21 views

Replication of Database in PostgreSQL

I want to Replicate my PostgreSQL, in the website there far too many options, I want to know which one to choose. I have a main server which the database is stored at. Inserting, editing and deleting ...
3
votes
1answer
390 views

MySQL master slave replication not working

I had MySQL master slave running and working fine but suddenly it stopped. I don't know which commands have been executed but now replication is not working. I am very new to MySQL can anyone help me? ...
1
vote
3answers
457 views

postgreSQL hot_standby pg_dump on slave

I have master-slave (hot_standby) pgsql configuration and I want to make backups from one of my slaves. I don't want PITR, just good old database dump. I switched to postgres from MySQL. With MySQL ...
0
votes
0answers
37 views

Merge Replication with Static Filters - Does not Delete from the subscriber database?

I have a merge replication setup, I have applied static filters so as to send only specific rows to the subscribers from a publisher (table) say 'X' the filter is " where Name Starts with 'T' ". Now ...
0
votes
1answer
19 views

Automatically purging binlogs after successful replication

I have a dedicated server hosting a MySQL database, and want to use replication to have an always up-to-date backup somewhere. I chose to use Amazon RDS as my replica, and I'm following this guide: ...
0
votes
2answers
33 views

mysql replication master - slave

I have a setup of two databases, master - slave. Slave was stooped for about two weeks and old binlogs binlogs purged from master but copied on another fs before purging. Slave can't catch up the ...
0
votes
0answers
21 views

Problem with MySQL Delayed Replication

I am testing out MySQL Delayed Replication. But it's not working. I have a Master DB (5.5) and a Slave DB (5.6) both set up as a normal master/slave setup with statement based replication. On the ...
0
votes
1answer
23 views

mysql ssl replication - fails while attempting to connect to master

I'm trying to troubleshoot why my slave cannot connect to the master. This is what I see in the output from the command "show slave status \G" mysql> show slave status \G; ...
0
votes
2answers
72 views

Mysql sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 with replication

I'm looking into sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 to improve write performance. There is this question, but it doesn't address the specific problems with replication. I have an ...
1
vote
3answers
207 views

Replication taking too much time between requests

We are using transactional replication in SQL Server 2014 with one master (publisher), 1 distributor (dedicated server), and 3 slaves (subscribers). All writes are made to master and reading is done ...
1
vote
0answers
58 views

Query slow on subscriber but fast on publisher (Merge Replication)

As the title suggests, I am having issues with performance with my subscriber. I run the exact same query (it's a recursive query with a few joins but nothing too serious). I can run this query on my ...
1
vote
2answers
83 views

Merge Replication - Deleting from the subscriber database?

I have 2 SQL Server instances where I use merge replication on a database. A developer accidentally inserted data to both the subscriber and publisher at the same time. Now I have data in both ...
0
votes
0answers
83 views

Bucardo Postgresql replication master-master windows

Is it possible to use Bucardo installed on linux PC to replicate master-master postgresql 9.4 for two windows servers.
2
votes
1answer
65 views

Cannot drop distribution database in SQL Server 2012

I am trying to drop distribution database but cannot as I am getting this error: The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset ...
0
votes
0answers
28 views

Postgresql hot standby what happens when Master is down

Beginner question. When Master is down hot-standby become automatic master? When old master is up what happened to hot-standby and meanwhile data insert in hot-standby how is transfer to the ...
2
votes
1answer
62 views

Can I add an Arbiter node in the same server of my Config-Server?

I'm using MongoDB and I want to know if I can add an Arbiter node in the same server that I'm hosting my Config-Server. Is it possible? Let's say that I have 3 sharded clusters with 6 servers (2 per ...
3
votes
1answer
4k views

MySQL: What happens to the row when skip-errors=1062 is set

I found out that I can set skip-errors=1062 in the my.cnf but I need to know what happens to the row when the error happens. Does it get silently dropped? Or is that config option the equivalent to ...
1
vote
2answers
37 views

In mongodb 3.0 replication, how elections happen when a secondary goes down

Situation: I have a MongoDB replication set over two computers. One computer is a server that holds the primary node and the arbiter. This server is a live server and is always on. It's local IP ...
1
vote
1answer
38 views

MySQL replication seems to work but no data is transferred [closed]

I'm trying to set up a one way MySQL replication. All sources I looked for errors seemed fine but no data is transferred. The following sites couldn't help me: ...
2
votes
0answers
64 views

How to setup SQL Server 2014 replication for a demo site

Background: We have been looking at replication of our SQL Server 2014 databases for a couple of scenarios.One which just works and its hunky dory and the other which just doesn't seem to work, ...
0
votes
1answer
95 views

Size of Binary log file in Mysql Replication

I have a master - server replication setup in Linux servers. Master Configuration details : MySQL version is 5.1 and replication mode is MIXED type. Slave Configuration details : MySQL version ...
0
votes
1answer
57 views

SQL Server distributor server move

I need to move my distributor server to a brand new server without resnapshotting it. The scenario I have is similar to the one defined in below link. ...
1
vote
1answer
179 views

Replicate only some tables of MariaDB database

I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. However I now have the need to create a new similar structure but with one ...
0
votes
0answers
77 views

Simple/Easy PostgreSQL HA multi-master for high latency / unreliable network

I have an environment consisting of two servers running JBOSS and PostgreSQL. Each server writes to its own database and programmaticly synchronises some data to the other database. This causes ...