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

0
votes
0answers
170 views

MySQL 5.1 replication broken after crash, duplicate key error, why? No redo log corruption

What do you think is the reason for the duplicated key errors in our MySQL 5.1.61 replication slave, after the slave machine crashed? It's not corrupted redo logs. Details follows: We have ...
0
votes
0answers
24 views

How to Replicate data from read only sql database to Active one

We are applying logs in every 30 min to one SQL db which has to be in Restoration Mode/Read only mode as we are applying logs continuously. Now we have to Set up Replicaion of this Read only Db to ...
1
vote
1answer
27 views

Suggested ways to route traffic between master / slave

I have multiple Postgres servers up, running in master / slave streaming replication mode. I was wondering what the suggested methods of routing write traffic to the master, and the read traffic to ...
1
vote
1answer
35 views

How to resynchronize replication for a single database

I have two MySQL 5.5 servers in a master/slave replication setup. The server hosts about 10,000 databases, but the replication is messed up for only a couple of databases. To fix the replication I ...
0
votes
3answers
146 views

Changing MySQL auto_increment_offset

Sorry for the wall of text, but I don't know what's relevant and what's not. I have MySQL a MySQL database that it is being replicated from our production environment to our development/test ...
0
votes
0answers
39 views

Mysql: Add a slave to an already existing Master-Master setup

We already have a Master-Master MySQL setup running live in the network. Now we are asked to add a slave to the setup. Is it feasible. If yes, what's the steps I need to follow. Also what are the ...
1
vote
0answers
101 views

Master and slave tables with different character sets - will replication break?

We have some huge tables in our MySQL 5.6 database that have latin-1 as their character set, and want to convert them all to UTF-8 (along with converting the database's global character set). The ...
0
votes
0answers
80 views

MYSQL 5.5 SERVER MULTI MASTER REPLICATION

Myself using mysql 5.5 in master side and in slave side(remote connection) It seems the configuration like log_bin,binlog_do_db are correct but it shows Slave_Io_Running : Connecting ...
0
votes
1answer
238 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 ...
1
vote
1answer
241 views

Moving SQL server 2008 to a new Server with all DBs, replication and Jobs

We have to move our Production SQL server 2008 to a new Server (with latest SKU and more RAM). So we need to move all DBs, replications setup (publisher) and all jobs, means everything :). Also we ...
3
votes
2answers
332 views

Replicating some tables from one postgres database to another

I've got the following situation: I have three machines running postgresql databases. One machine holds client account information (call this machine C), the other two machines hold client logging ...
0
votes
1answer
67 views

Single MySQL DB contains both push and pull data. Recommended path to replication?

We have a single deployed (MySQL) database that contains both user tables and product tables (currently in the same DB). The product tables are "pushed to production" data -- they are generated in ...
2
votes
1answer
74 views

Mysql Master-Master with additional slaves

We have two datacenters with a copy of our web app (online training platform) at each. The primary datacenter receives all of the traffic at any given time and the second datacenter serves as a ...
1
vote
1answer
68 views

Is it possible to archive table rows of an RDS read replica?

I would just like to know if I can purge 60 days old rows from a replica. Would the replica just copy the rows again from the master after deleting the rows? Because what I would really like to do is ...
1
vote
1answer
110 views

Native checksum table says there's a difference, pt-table-checksum does not

I was setting up a slave and doing some table checksums to check things were ok before getting them live. I did a native mysql checksum tables on the slaves after syncing slaving to a stopped point ...
0
votes
1answer
64 views

fixing mySQL replication (large DB)

I have a large mySQL database and I am replicating to two slaves. All three servers are windows (i know). One of my slaves seems to have corruption, the other is fine. This is huge DB, a few ...
0
votes
2answers
53 views

To replicate, or not to replicate

1.Intro Hello, I am running web application on 2 separate geographical locations(e.g. Europe, Hong Kong). Let's suppose Hong Kong server is an Amazon EC2 instance(paying for disk space, IO disk ...
1
vote
1answer
41 views

Is it possible to have mysql treat row based updates as “upserts”?

When processing row based replication events, mysql replication will break if it's unable to find a row matching the "before image". Is there any setting to tell mysql, if you don't find that row, ...
1
vote
2answers
211 views

Upgrading to MySQL 5.6, benefits to switching to GTID replication?

We have the most basic of MySQL replication setups, a single Master doing statement-based replication to a single Slave, a 90/10 mix of innodb/myisam tables. Both run Percona MySQL 5.5 at the moment ...
0
votes
0answers
54 views

SQL Server 2008 replication and large data updates

We have an environment setup where we're replicating a single SQL database to 14 subscribers across relatively slow WAN links. The data at the distributor is refreshed once a day - where the tables ...
3
votes
2answers
130 views

How can streaming replication be kept lagged by a certain 'delay' time?

Postgres has had streaming replication since 9.0 and since 9.1 it is possible to pause and resume the application of the streamed WAL records using pg_xlog_replay_pause() and pg_xlog_replay_resume(). ...
0
votes
0answers
13 views

DB2 bidirectional replication of federated object?

Bidirectional replication of a federated object - is this possible on DB2? Example: replication of a table on the DB2 and another table on MySQL as federated object inside of DB2. Anyone ...
1
vote
2answers
150 views

Multi-master + slaves replication in MySQL

I've been playing around with MySQL and tried to create replication topology according to the following picture. Slaves are used as read servers and Masters are used as both read and write servers. ...
0
votes
0answers
53 views

DB2 manual asynchrounous real-time replication to NON-DB2 database

I have been given a Proof-of-Concept task to find out whether it is possible to set up manual (=no 3rd party tools allowed) asynchrounous real-time replication in DB2 that replicates all data changes ...
0
votes
0answers
36 views

MySQL manual asynchrounous real-time replication to NON-MySQL database

I have been given a Proof-of-Concept task to find out whether it is possible to set up manual (No 3rd party tools allowed) asynchronous real-time replication in MySQL that replicates all data changes ...
1
vote
1answer
109 views

Heartbeat Options with MySQL and Possibilities

I would like to understand if the following scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup ...
1
vote
1answer
90 views

Export synonyms content to tables

I have a distant database to replicate having huge data but I have access only to synonyms and I would like to use Oracle export/import tool to import these data into tables of local database. What ...
1
vote
1answer
509 views

How do I (safely) kill long running operations in MongoDB?

Occasionally operations get out of control in MongoDB and might end up running for hundreds of seconds, and impact performance until they are killed or completed. When that happens, I know I have ...
0
votes
1answer
338 views

MySQL row-based-replication HA_ERR_KEY_NOT_FOUND… which record is it?

I have a mysql slave (5.1) using row-based replication. The slave has stopped with the error HA_ERR_KEY_NOT_FOUND. OK fine, it's trying to update a record that doesn't exist for some reason. Using the ...
2
votes
2answers
426 views

Streaming Replication Log is puzzling me

I have a streaming replication hot-standby setup, which seems to be running all good. I can login, execute selects and the result seems to be up-to-date with the master. However in the log of the ...
2
votes
2answers
61 views

Replication between SQL Server 2005 - 2005

I'm hoping to get some help with a SQL Server 2005 replication issue. In short, in replication monitor, (On the Publisher), on the 'Distributor to Subscriber History' tab, I see two lines under ...
1
vote
0answers
25 views

The @article parameter value must be 'all' for immediate_sync publications

I have a publication of 4 tables and many subscribers (transactional push replication), most of them being interested by one of those 4 tables. Everything is working fine as long as I create the ...
0
votes
0answers
165 views

Mysql replication broke after mysql upgrade on master

I've seen this question, but I am not sure if the solution is right for my particular error (replication breaks after upgrading master) I upgrade my master server's mysql from 5.5.34 to 5.5.35. After ...
0
votes
1answer
326 views

Streaming replication between postgresql 9.2 and 9.3

Does anyone know if it's problematic to have a postgresql 9.3 slave setup to do streaming replication from a postgresql 9.2 master?
0
votes
1answer
186 views

pgpool2 not working on my Ubuntu i686 athlon i386 GNU/Linux

I am trying to implement replication and load balancing on my Ubuntu i686 athlon i386 GNU/Linux.for creating database clustures I have installed postgresql contrib 9.1.11 having initially database ...
0
votes
0answers
35 views

Probable database replication issue in LAMP setup with Master/Master MySQL replication

I have been facing issues in my high availability failover (on WAN links) LAMP setup hosting a Drupal CMS based site, approximately after every 2 months both servers suddenly stop responding to http ...
2
votes
1answer
104 views

Is it possible to replicate wide table in MS SQL?

The reason of me using sparse columns is to overcome limit of 1024 columns in a table (I know that generally it's not a good reason and there are downsides, but in my situation it's good option ...
2
votes
1answer
172 views

Postgresql 9.2.6 ignoring archive_command

I'm attempting to set up a 3-server chain by leveraging WAL-E. I've done this in the past with replication/wal segments and I'm attempting the exact same method, just with using WAL-E in between. My ...
0
votes
0answers
64 views

SQL Server 2012 Replication Initialisation Fails — Table keeps being dropped

I have two servers - one located in Australia (Distributor / Publisher), and a second in the UK (Subscriber) both on Amazon's cloud. I have attempted to configure replication as both pull and push ...
0
votes
0answers
301 views

Redis Master/Master or Shared Storage

I'm setting up Active/Passive Redis setup for a client of mine. I have a high performance NFS storage where I'm storing the configs and the data currently. I'm just wondering if it would be best to ...
0
votes
0answers
30 views

On replicating all tables of a given database except for those starting with some pattern

I'd like a slave to replicate all tables of a given database except for those starting with some pattern, eg. those with names starting with 'nc' (non-critical, redundant denormalized tables). So I ...
0
votes
0answers
61 views

Upgrade 2 servers with master-master replication without data loss

We have two MySQL servers running with master-master replication in a Pacemaker cluster. If a database operation should be done, the primary server is asked first to do the job, if it fails, the ...
0
votes
2answers
257 views

Cannot stop MySQL 5.5 replication threads

We have a master-master replication setup using MySQL 5.5. On one of the servers I am trying to stop the slave thread, but without success. To ensure that the replication does not connect to a real ...
0
votes
2answers
107 views

MySQL Master/Slave replication on same VM instance?

I'm fairly new to databases so I hope this isn't a silly question! Is it possible to set up master/slave replication on the SAME server? I understand there are not any advantages to this in terms of ...
1
vote
2answers
110 views

MySQL replication: slave not updated

This has been asked many times over but we really cannot get a simple Master-Slave Mysql (5.5.25) replication to work for our two dbs (FatTree and Torus). And no trace of error in the logs. The ...
3
votes
1answer
245 views

With SQL transactional replication, does changing user permissions to a table trigger a new snapshot?

I was hoping to get some help with a SQL Server 2012 transactional replication scenario - or maybe just my understanding of where permissions are stored in SQL server. If I change a users permissions ...
1
vote
0answers
61 views

SQL Server replication - recommendations for stability

We have two SQL Server 2008R2 Standard servers, and we've set up replication of a single database between them. The replication is about as simple as it can get - it's a transactional replication from ...
0
votes
0answers
111 views

SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber

In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers For 2nd subscriber every table data is updating properly But for 1st ...
2
votes
1answer
175 views

Can I configure MySQL replication to break when I run a “drop database” or “drop table” command on the master?

Basically, what the title says. This would enhance the failover quality of our systems, becuase we have run into issues of people thinking that they were in a test environment running drop statements ...
0
votes
1answer
485 views

Postgres replication: Do I need to rsync pg_xlog files if I have archiving setup in master?

I am trying to replicate a master to slave, without shutting down my master. In the tutorial here: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial, they recommend these steps: ...