17 votes

How to find slave's IP address and user name from Master server?

On the master server: SELECT * FROM information_schema.PROCESSLIST AS p WHERE p.COMMAND = 'Binlog Dump'; This shows all connected slaves, their ipaddresses, user, and even how long they have been ...
CSTobey's user avatar
  • 271
16 votes

Windows Server: Replicate folders without DFS?

DFS is usable but a) cause issues working with open files b) Hyper-V, SQL Server and Exchange has no DFS support c) can't avoid a spit-bran issue. When multiple users works with the same file that ...
Mr. Raspberry's user avatar
14 votes

Windows Server: Replicate folders without DFS?

DFS-R requires active directory, so that option will not be available to you. As yagmoth mentions in his comment, you could use robocopy For example: robocopy /mir /mot:10 would run a mirror every ...
Rex's user avatar
  • 7,895
9 votes

Windows Server: Replicate folders without DFS?

There are two options that I have used and work relatively well. Peersync - http://www.peersoftware.com/products/sync-backup/peersync-for-servers.html Is licensed however works really well, very ...
Anthony Fornito's user avatar
9 votes
Accepted

Data missing after ZFS replication on FreeNAS/TrueNAS

The difference can be related to different pool or dataset configuration (mirror vs raidz, ashift value, recordsize, compression, etc). If you sent data via send/recv, no data should be lost ever. ...
shodanshok's user avatar
  • 50.3k
8 votes

Is DRBD the only viable block replication solution for Linux?

Well, there's also MARS (Light). According to the documentation this widely used at German provider 1&1
uli42's user avatar
  • 325
8 votes
Accepted

How do i measure redis replication delay?

Given results from an INFO replication command like this: slave0:172.16.101.23,6380,online,424821 master_repl_offset:424827 You can tell that slave0 is behind master by 6. This is the difference ...
sysadmin1138's user avatar
  • 134k
7 votes
Accepted

ZFS on Linux (ZoL) and realtime replication

I recommend a clustered dual-node shared SAS setup or continuous asynchronous replication on 15 or 30-second intervals. The latter is good for continuity, while the latter provides a way to obtain ...
ewwhite's user avatar
  • 198k
7 votes

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

This occured because both my master and standby were initialized from a pg_basebackup that was taken on a cluster that indeed had max_connections = 2000. Details of the situation and two remedies are ...
rookie09's user avatar
  • 653
7 votes

SQL Server Failover strategies

In SQL Server 2014 Standard Edition, your only built-in option for automatic failover without shared storage would be database mirroring. If you upgraded versions to SQL Server 2016 Standard Edition,...
Brent Ozar's user avatar
  • 4,425
6 votes
Accepted

What does an infrastructure that hosts an FTP server with HTTP access look like?

Typically the FTP server and Webserver are not running on different computer systems but both services are running on 1 single host. Both the FTP service and web service point at the same directory ...
HBruijn's user avatar
  • 80k
6 votes
Accepted

HyperV 2016 storage redundancy on non-redundant SANs

You can try using StarWind VSAN (Free) to create a highly available (HA) distributed block device between both Hyper-V hosts on top of an existing SANs attached directly to both servers. Since ...
Strepsils's user avatar
  • 5,115
6 votes
Accepted

Failover Cluster Disk Replication

Storage replica supports either Cluster-To-Cluster replication or Stretch Cluster with shared storage. Technically you should be able to configure it, if you have separate shared storage connected to ...
Stuka's user avatar
  • 5,680
6 votes

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

Neither ZFS nor BTRFS are intended to be replicated between instances in real time. You need to look into the specific category of Distribute File Systems. The Wikipedia page Comparison of distributed ...
AlexD's user avatar
  • 9,849
5 votes

Migrate SQL 2008 database to Azure

Since you need to migrate SQL 2008 to a new host, I would suggest you follow the blog post instructions. That works for me.
Mr. Raspberry's user avatar
5 votes

Is ceph replication based on nodes or disks?

Yes You can define the policy to replicate by node, racks, datacenters, etc.
petertc's user avatar
  • 2,650
5 votes
Accepted

Can ZFS using snaphots replace DRBD using sync protocol A?

I asked a somewhat similar (yet different) question lately In short, it all depends on the replication target you want to achieve and if ZoL fits your use case: if point-in-time replication is ...
shodanshok's user avatar
  • 50.3k
5 votes

Design Replication between 2 Always On Groups in SQL Server 2012

As a possible solution, you can look into creating failover cluster instances with SQL configured as the role (inside a failover cluster). Hopefully, this link will be helpful
Strepsils's user avatar
  • 5,115
5 votes

Replicating storage efficiently

On the block level, the synchronization can be done using Starwind that makes a mirrored disk on both ends. It can run over iSCSI LUNs, making active-active storage. No additional hardware required. ...
A.Newgate's user avatar
  • 1,484
4 votes

Redis Multi-Master Replication

I am also looking for a solution to this challenge, so far, I found: https://github.com/Netflix/dynomite/wiki/Architecture And maybe... https://github.com/CodisLabs/codis or https://github.com/...
nadavkav's user avatar
  • 1,529
4 votes

Prevent non-replication writes to MySQL slave?

As of MySQL 5.7.8, there is now a super_read_only option, which prevents even SUPER users from performing client updates. It does not disrupt the replication process. As with other settings, it can be ...
billyw's user avatar
  • 1,612
4 votes

mysql stop slave forever

The procedure is different based on the MySQL server version. For version 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST='' and then RESET SLAVE. In these versions the RESET SLAVE command ...
Marki555's user avatar
  • 1,568
4 votes
Accepted

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

You need to have at least 3 masters to form a redis cluster. If majority of masters die at the same time, cluster becomes unusable. Failover does not happen if majority of masters are not available.
Pankaj Makhija's user avatar
4 votes
Accepted

How to do storage replication on Windows Server 2012 R2 in a lab?

Check out SDS solutions from HP http://www8.hp.com/us/en/products/data-storage/free-vsa.html and StarWind https://www.starwindsoftware.com/starwind-virtual-san-free. They both have free versions, but, ...
batistuta09's user avatar
  • 9,096
4 votes
Accepted

How to lower AD inter-site replication interval below 15 minutes?

It's not posible to set lower limit less then 15 min, but if you have good link you can enable notifications on site link. It will speed up change propagation between linked sites. To do it for link: ...
Slipeer's user avatar
  • 3,305
4 votes
Accepted

Active Directory - Only bridgeheads get the full forest replication

Q: Is the primary domain controller supposed to be the only domain controller in my DefaultFirstSiteName site that receives replications from it's sister site? A: I think what you're really asking ...
joeqwerty's user avatar
  • 111k
4 votes
Accepted

How to Change Replica Set Protocol Version in MongoDB.

You need to restart the mongod service after rs.reconfig(cfg). The reconfig will change the protocol version but it will be active after the restart. First you need to restart the secondary, then do a ...
Andrada's user avatar
  • 56
4 votes

How do you handle IP addressing at a DR Site

The exact scheme varies, but the key is to use separate addresses for management that always stay in place, and client-facing virtual addresses that you move or reroute on failover. Alternatively, you ...
Zac67's user avatar
  • 11.4k
3 votes
Accepted

Need to DUPLICATE HTTP requests to two servers

What we chose eventually was using Gor (now GorReplay) https://github.com/buger/goreplay this solution allows installing a listener on the original host, and what it does is record any incoming HTTP ...
Moshe Eshel's user avatar
3 votes

Create a MySQL slave from another slave, but point it at the master

I did what @RolandoMySQLDBA suggests but also adding a 6' and an 8' steps (this solves what @Hussain Tamboli comments.): Step 1) Setup a New Server (ServerC) Step 2) On ServerC, Install MySQL (same ...
Pere Barceló's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible