Questions tagged [replication]

Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.

Filter by
Sorted by
Tagged with
4 votes
2 answers
275 views

MySQL Clustering and replication

I want to setup a MySQL cluster setup of two servers (M1-M2). I also want to setup MySQL replication between two servers (M1-M3). Is it possible to setup both clustering and replication as above. Is ...
Santhosh S's user avatar
3 votes
3 answers
1k views

failsafe RAM drive solution [closed]

I'm looking for a production solution to create a RAM drive that will be safely synchronized with HDD. I have a piece of custom software with heavy I/O load (this is some kind of proprietary document-...
user1450663's user avatar
3 votes
3 answers
9k views

What can I really do with percona toolkit's pt-table-sync?

I have been looking for a tool to synchronize tables from 2 different databases and found pt-table-sync. I read the documentation and got confused: they mostly use examples referring to a replicated ...
Max's user avatar
  • 3,563
3 votes
3 answers
6k views

AD Replication Monitor

Is there something like Replication Monitor (in Windows 2000) available in Windows 2008 R2? What tool do you use to check replication health?
Iškuda's user avatar
  • 225
3 votes
1 answer
3k views

Can an orphaned Domain Controller be rescued?

When an Active Directory domain controller becomes orphaned from a domain, is it possible to configure it to continue operating as a healthy DC without going through the process of forcefully demoting ...
Nic's user avatar
  • 13.5k
3 votes
5 answers
972 views

Master - Slave MySQL setup on a VMWare Cloud -- Is it needed?

We currently are in the research phase of building a "Master" database for our e-commerce business that will centralize all data, including product information, vendor information, Magento information,...
Zak's user avatar
  • 356
3 votes
2 answers
2k views

What is the best way to check the status of a MySQL slave that is replicating from a master?

Specifically I have a set of InnoDB tables and we are backing these up into MyISAM tables to provide full text search. The slave DB routinely falls behind the Master. I am looking for advice on ...
IanMulvany's user avatar
3 votes
2 answers
603 views

ZFS: Handling massive no. of concurrent RW operations and failover

I have a single ZFS/Linux instance with a file that can grow to those crazy sizes supported by ZFS. A large number of concurrent users need to read/write from/to this file over the public inter net. ...
Harry's user avatar
  • 443
3 votes
1 answer
8k views

PostgreSQL hot standby cannot start because max_connections is a lower setting than on the master

I have a PostgreSQL 9.6 master and standby server each. Both this line in their respective postgresql.conf: max_connections = 100 The standby's recovery.conf looks as follows (actuals host, user, ...
rookie09's user avatar
  • 653
3 votes
2 answers
4k views

Why does MySQL Galera not replicate the user table?

I am running a 3 node MySQL 5.6 Galera Cluster. Everything is in sync and looks fine, but as I just found out the user table was not in sync. One particular user was not present on the other nodes ...
merlin's user avatar
  • 2,172
3 votes
3 answers
321 views

What backup method should I choose to backup database on high-load server

I have a mysql (MyISAM) database with size around 30Gb. It has single large table (and some smaller ones but it makes no difference). It performs around 2000 selects (single row by primary key)/second,...
Poma's user avatar
  • 1,309
3 votes
5 answers
3k views

Using MySQL replication to enable a read-only copy of a database in a DMZ

I need to set up a MySQL database instance in a DMZ that is a read-only copy of the live master inside a secure network. MySQL replication seems ideal for this, except that it works by the slave "...
mrowe's user avatar
  • 133
3 votes
1 answer
4k views

SQL Server Replication only for Enterprise Edition? Does it require Enterprise on both sides? Other solution?

My situation: I've been looking for an option of data replication for my SQL Server (I'm not expert on it, I should say it - neither on English Language). I've seen a few options, like Log Shipping ...
Carlos Parisotto's user avatar
3 votes
1 answer
4k views

pg_basebackup: could not get WAL end position from server

I want to create a Base Backup with the pg_basebackup tool of postgres 9.1. After some seconds I receive: ``pg_basebackup: could not get WAL end position from server` What can be the reason for this ...
markus's user avatar
  • 1,110
3 votes
3 answers
1k views

BestReplicated File System - Small, Static Files

As part of our development workflow, we would like to have our build server publish our compiled binaries and other build artifacts to some LAN-based, replicated file system. Ideally, we'd just have ...
Jonathan Oliver's user avatar
3 votes
4 answers
7k views

mysql stop slave forever

I used replication to migrate all data to a new server, and then I commented out master_host,master_port etc(basically all lines related to master) in my.cnf, I issued stop slave. However I after ...
user12145's user avatar
  • 1,125
3 votes
3 answers
6k views

Subversion cluster / replication / HA

What's a good way of making SVN highly available? We take backups of our Subversion server, but this is not enough, as svn is very important. We would like to implement some HA mechanmism for ...
PieterB's user avatar
  • 91
3 votes
3 answers
331 views

MSSQL Two Database Servers 1 Database

We have two servers. They are both HP DL 380 G6 servers with the same hardware and specs running Windows Server 2008. Currently the second server is a warm standby for the first with an automatic fail ...
Campo's user avatar
  • 1,609
3 votes
4 answers
2k views

How can I create a slave replica of a MySQL server without stopping the master?

To ensure the data on the slave and master are in the same place for replication, the new master should be stopped and data transferred to the new slave before starting the master again, at least this ...
davidmytton's user avatar
3 votes
2 answers
4k views

Why Redis slaves don't take over the master after master fail in Redis Cluster?

I have a Redis Cluster with 2 masters and 4 slaves (2 slaves for each master). After I manually crash a master (i.e. redis-cli -p 6379 debug segfault) slaves doesn't do anything. They detects that ...
Oleksandr's user avatar
  • 763
3 votes
2 answers
2k views

MySql server master-master seconds_behind_master jumps

I'm running a 4 servers master-master cluster of MySql. (2 servers version 5.1, and 2 version 5.5) While checking the slave status, i see the seconds_behind_master at 0, and half a second after i see ...
shaharmor's user avatar
  • 337
3 votes
1 answer
1k views

Rails/Mongo across multiple different geo-regions

I have a system that by necessity requires physical presence in three or more different locations and I need advice on structuring in such a way that my database stays replicated in a timely manner ...
wmarbut's user avatar
  • 301
3 votes
2 answers
620 views

Too many data replication technologies in environment

It is possible to configure remote data replication at many layers of the storage stack. Some examples to explain what I mean by layers: Physical Volume Layer (TruCopy, SRDF/MirrorView, SnapMirror) ...
Tom Shaw's user avatar
  • 3,762
3 votes
3 answers
202 views

Best way to duplicate a server?

We currently have a dedicated server with one company that utilizes cPanel/WHM and are moving to a new dedicated server also with Cpanel/WHM. I can get it so cpanel is installed then migrates the ...
mahle's user avatar
  • 255
3 votes
1 answer
719 views

How do you handle IP addressing at a DR Site

I've found various tools that handle replicating virtual machines from one physical location to another for disaster recovery purposes. The part that I am struggling to understand is how these tools ...
Brad's user avatar
  • 619
3 votes
1 answer
280 views

Active Directory - Only bridgeheads get the full forest replication

In my Active Directory, we have two sites. One site has a single domain controller. The other site, DefaultFirstSiteName, has two domain controllers. When I view the replication status from the non-...
gnu_byte's user avatar
3 votes
1 answer
2k views

Changing tablespace on table with streaming replication

I've been searching for answers for a while know but can't find any reliable source. We have 2 postgres servers that replicates using streaming replication. I now need to move some tables to a ...
jishi's user avatar
  • 878
3 votes
2 answers
657 views

What type of AD replication is needed for a non-mesh Hub and Spoke network?

I'm having AD replication issues (OUs not replicating, FRS, etc) and suspect the issue is that the network admins have modified AD Sites And Services in ways that disabled the ISTG and other aspects. ...
makerofthings7's user avatar
3 votes
2 answers
862 views

Static master in Redis replication

I'm running replicated Redis that includes a master and just one slave. My goal is to implement a replication (using Redis sentinels) in which the slave becomes master when the master goes down, but ...
empe's user avatar
  • 33
3 votes
3 answers
2k views

<suffix> invalid DN 21 (Invalid syntax) on Converting slapd.conf OpenLdap

Actually i want to configure ldap as master-slave replication using syncrepl method, On any reference which i found,I'm running on Centos 6 machine and openldap v2.4.23. I following step by step on ...
Pirates's user avatar
  • 31
3 votes
1 answer
4k views

Quickly change Active Directory Replication Schedule for all Sites & Sitelinks

My company has more than 80 sites, and my predecessor for reasons unknown to me put in a large chunk of time preventing replication between the HQ's DC and the branches' RODC. I need to reset their ...
pepoluan's user avatar
  • 5,108
3 votes
2 answers
1k views

Checksumming mysql replicas over ssl

After hours of struggling to understand the way percona toolkits (2.1) pt-table-checksum works, I try to try you. Situation Running MySQL replication (Master-active:Master:passive) Slave user is ...
Ruben's user avatar
  • 31
3 votes
1 answer
2k views

What are possible results/side effects if replication between DC's in a Windows domain is unable to occur?

There's plenty of administration literature out there how to properly manage Windows servers. But in dealing with real life, things don't always occur like you want them to. In Microsoft's Windows ...
Chad Harrison's user avatar
3 votes
1 answer
5k views

Backing up live iSCSI LUNs

Is there anyway to replicate a live (running) iSCSI LUN from one NAS to another using QNAP?
Aaron's user avatar
  • 83
3 votes
2 answers
3k views

Restoring a slave MySQL database from raw backups of master gives InnoDB tablespace errors

I have a master/slave replication setup where I use InnoDB and MyISAM tables in over 7000 databases that I want to copy from my master to the slave to restore replication. Both servers were running ...
Edward van Kuik's user avatar
3 votes
4 answers
12k views

Replicating/Synchronizng multiple tables across different Databases on the same instance

I have few tables that needed to be replicated/synchronized across several databases in our SQL Server 2008 cluster. I know it's possible to replicate between multiple instances, but I'm looking for ...
Idan's user avatar
  • 319
3 votes
1 answer
568 views

Current replication techniques in PostgreSQL

I'm planning to migrate from MySQL to PostgreSQL, but worried about the apparent luck of replications solutions there. Are there any current replication techniques that can be used out of box? ...
SyRenity's user avatar
  • 3,189
3 votes
1 answer
475 views

Exchange Local Continuous Replication - Seeding Fails

When setting up Local Continous Replication on an Exchange 2007 server's larger database, the wizard consistently fails with a message along the lines of: The log file xxxx for SERVERNAME\Your ...
Katherine Villyard's user avatar
3 votes
2 answers
4k views

pg_archivecleanup not found Postgres 9.1, even though it is installed?

I have streaming replication setup on 2 Postgres 9.1 servers. Everything is ok apart from the archivecleanup. In the logs it says: sh: 1: pg_archivecleanup: not found 2013-11-19 09:17:37 GMT WARNING: ...
user199835's user avatar
3 votes
1 answer
6k views

how to install pg_archivecleanup for postgresql 9.3 on Ubuntu

I am trying to get streaming replication working with postgresql 9.3 on Ubuntu 13.04 (Raring Ringtail). I installed postgresql on master and slave by doing: apt-get install postgresql I believe I ...
colour me brad's user avatar
3 votes
2 answers
12k views

"Could not create IPv6 socket" postgresql standby error

I'm trying to create Postgresql 9.1 hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
Alex's user avatar
  • 131
3 votes
1 answer
1k views

mongod: automatically initiate replica-set

Currently I manually execute the rs.initiate() in the shell after starting a mongo primary or secondary machine to join the replica-set "farm". Doesn't the /etc/mongodb.conf allow me to define the ...
ledy's user avatar
  • 565
3 votes
1 answer
2k views

HAproxy with MySQL Master-Master Replication incredibly slow

I have two MySQL servers in multi-master mode, with an HAproxy machine for simple load balancing/redundancy. When I am connected to one of the servers directly and try to update about 100,000 entries, ...
Joe Gibson's user avatar
3 votes
1 answer
803 views

MongoDB -what's the safest and most efficient way to change from Master-Slave to ReplicaSet?

I now have two mongo servers with a Master-Slave configuration (all read-writes are done with the Master, the Slave is just a cold backup) serving a pretty demanding web app. I want to switch to ...
SecondThought's user avatar
3 votes
1 answer
301 views

What is the safest way to change MongoDB server structure?

I currently have a MongoDB replica set configured as such: { "_id" : "ahspy_mongo_set", "version" : 13, "members" : [ { "_id" : 0, "...
Pierre's user avatar
  • 241
3 votes
1 answer
2k views

One way replication from MSSQL2005 to MYSQL 5.x

I have a mysql database acting as our websever backend. We have our production mssql server that we would like data pushed from, to our mysql server. I have successfully made the mysql server an ...
RateControl's user avatar
  • 1,207
3 votes
2 answers
2k views

multi-master file replication

I have a load balancer and several servers behind it. I'm looking for a multi master file replication tool that would allow me to write on any of the machines and replicate the content on all the ...
evilpenguin's user avatar
3 votes
3 answers
795 views

What is the least expensive version of Microsoft SQL Server 2008 that supports replication?

We need to purchase two licenses for Microsoft SQL Server 2008 to upgrade Microsoft SQL Express 2008 so that we can mirror the two databases in two geographically dispersed locations. What is the ...
Nick Bolton's user avatar
  • 5,146
3 votes
1 answer
5k views

Apache Derby master/slave replication and clustering

I'm interested in the possibilities of master/slave replication for Derby in client/server mode (if at all possible). However, I'm unable to find any material that either explains it in a decent ...
3 votes
2 answers
20k views

Will the DNS Forward Lookup Zone recreate itself if I delete it?

Here is my situation: I have inherited a Windows 2003 domain with only 1 domain controller, we'll call it DC1. DC1 is also the DNS, DHCP and Exchange server for this organization. DC1 was ...
Kyle Noland's user avatar
  • 1,039

1 2 3
4
5
21