Data replication techniques

What is the data replication technique at database level?

It is the replication of log files between two servers made by the database management system (like the SQL Server log).

For an automatic failover, it is mandatory to have synchronous replication otherwise the data of the last validated transactions will not be recovered on the secondary server after a failover.

This data replication technique replicates a database but not the other data of an application. Failover of many applications also requires the replication of other data such as configuration files.

When a server crashes and loses some database files, failback is not automatic. A skilled DBA must restore the database on the failed server.

What is the data replication technique at disk level?

It is the replication of modifications inside disks between two servers (like DRBD).

For an automatic failover, synchronous replication between the disks is mandatory for having 0 data loss.

This data replication technique can replicate databases as well as other files. But, there is a strong impact on the organization of application data. All data must be localized in the relicated disk. This may be impossible if some data to replicate are in the system disk, because this disk must remain specific to each server.

Skills are required to configure a replicated disk with a file system and to configure application data in the replicated disk.

What is the data replication technique at file level?

It is the replication of modifications inside files between two servers (like SafeKit).

For an automatic failover, real-time synchronous replication is required for having 0 data loss.

This data replication technique can replicate databases as well as other files. There is no impact on data organization for an application. For instance, if an application has its data in the system disk, real-time file replication is working.

The solution is very simple to configure as only the paths of directories to replicate are configured.

Comparative tables between data replication techniques

Evidian SafeKit mirror cluster with real-time file replication and failover
3 products in 1 More info >	The SafeKit high availability software saves on Windows and Linux the cost of : external shared or replicated storage, load balancing boxes, enterprise editions of OS and databases SafeKit includes all clustering features: synchronous real-time file replication, monitoring of server / network / software failures, automatic application restart, virtual IP address switched in case of failure to reroute clients
Very simple configuration More info >	The cluster configuration is very simple and made by means of application modules. New services and new replicated directories can be added to an existing application module to complete a high availability solution All the configuration of clusters is made using a simple centralized web administration console There is no domain controller or active directory to configure as with Microsoft cluster
Synchronous replication More info >	The real-time replication is synchronous with no data loss on failure This is not the case with asynchronous replication
Fully automated failback More info >	After a failure when a server reboots, the replication failback procedure is fully automatic and the failed server reintegrates the cluster without stopping the application on the only remaining server This is not the case with most replication solutions particularly with replication at the database level. Manual operations are required for resynchronizing a failed server. The application may even be stopped on the only remaining server during the resynchonization of the failed server
Replication of any type of data More info >	The replication is working for databases but also for any files which shall be replicated This not the case for replication at the database level
File replication vs disk replication More info >	The replication is based on file directories that can be located anywhere (even in the system disk) This is not the case with disk replication where special application configuration must be made to put the application data in a special disk
File replication vs shared disk More info >	The servers can be put in two remote sites This is not the case with shared disk solutions
Remote sites and virtual IP address More info >	All SafeKit clustering features are working for 2 servers in remote sites. Replication requires an extended LAN type network (latency = performance of synchronous replication, bandwidth = performance of resynchronization after failure). If both servers are connected to the same IP network through an extended LAN between two remote sites, the virtual IP address of SafeKit is working with rerouting at level 2 If both servers are connected to two different IP networks between two remote sites, the virtual IP address can be configured at the level of a load balancer with the "healh check" of SafeKit.
Quorum and split brain More info >	The solution works with only 2 servers and for the quorum (network isolation between both sites), a simple split brain checker to a router is offered to support a single execution of the critical application This is not the case for most clustering solutions where a 3^rd server is required for the quorum
Active/active cluster More info >	The secondary server is not dedicated to the restart of the primary server. The cluster can be active-active by running 2 different mirror modules This is not the case with a fault-tolerant system where the secondary is dedicated to the execution of the same application synchronized at the instruction level
Uniform high availability solution More info >	SafeKit implements a mirror cluster with replication and failover. But it imlements also a farm cluster with load balancing and failover. Thus a N-tiers architecture can be made highly available and load balanced with the same solution on Windows and Linux (same installation, configuration, administration with the SafeKit console or with the command line interface). This is unique on the market This is not the case with an architecture mixing different technologies for load balancing, replication and failover
RTO / RPO More info >	SafeKit implements quick application restart in case of failure: around 1 mn or less Quick application restart is not ensured with full virtual machines replication. In case of hypervisor failure, a full VM must be rebooted on a new hypervisor with a recovery time depending on the OS reboot as with VMware HA or Hyper-V cluster

🔍 SafeKit High Availability Navigation Hub

Explore SafeKit: Features, technical videos, documentation, and free trial
Resource Type	Description	Direct Link
Features	Why Choose SafeKit for Simple and Cost-Effective High Availability?	View Features
Partners	SafeKit: The Benchmark in High Availability for Partners	SafeKit for Partners
VM vs App HA	SafeKit: High Availability (HA) and Redundancy Choices	VM/App Choice
Typical Usage	Typical usage with SafeKit and Limitations	Usage and Limitations
Videos	SafeKit: Technical Demonstrations and Tutorials	Watch Videos
Mirror Cluster	How the SafeKit mirror cluster works (real-time file replication and failover)?	Mirror Cluster
Farm Cluster	How the SafeKit farm cluster works (network load balancing and failover)?	Farm Cluster
Differentiators	Comparison of SafeKit with Traditional High Availability (HA) Clusters	View Benefits
Resources	SafeKit High Availability Resources, Downloads, and Documentation	Access Resources
Application Modules	SafeKit Application Module Library: Ready-to-Use Solutions	Browse Modules

Data replication techniques

Evidian SafeKit