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.
1,044
questions
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 ...
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-...
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 ...
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?
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 ...
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,...
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 ...
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. ...
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, ...
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 ...
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,...
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 "...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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)
...
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 ...
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 ...
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-...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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?
...
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 ...
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: ...
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 ...
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 ...
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 ...
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, ...
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 ...
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,
"...
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 ...
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 ...
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 ...
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 ...