MySQL Replication

What we provide

Xtivia’s MySQL Engineers will provide recommendations and strategies to set up MySQL replication to meet your organizational objectives. Xtivia also provides the Virtual-DBA service that monitors your replication server activities. Our services include:

• Initial assessments and review requirements
• Replication system design
• Approach and plan definition
• Schedule and cost estimations
• Installation
• Testing and validation
• Training to administer replication server
• Replication server monitoring using Virtual-DBA when requested

We understand these new and existing functionalities and can help you implement and maintain the solution that works best for your company.

What is MySQL Replication?

Replication is the copying of data from one place to another. Data can be extracted by programs, transported to some other location, and then loaded at the receiving location. A more efficient alternative is to extract only the changes since the last processing cycle and transport/apply those to the receiving location. Data may be filtered and transformed during replication. There may be other requirements for replication, such as time constraints. In most cases, replication must not interfere with existing applications and have minimal impact on production systems. The replication processes need to be managed and monitored.

How soon does the data move?

The data moves asynchronously. The time it takes to move from master to slave server depends on the size of your transaction, level of activity in that particular database (a database as in MySQL systems), the length of the chain (one or more replication servers that the transaction has to pass through to reach the destination), the thickness of pipe (network), how busy your system is etc. For small transactions on a LAN this usually takes about a second.

Who uses MySQL replication and why?

A business organization that wants to build distributed system

Data distribution is a tool that helps companies put necessary data in the hands of local decision makers yet maintain firm central control over the data. With MySQL's replication, data can be shared and replicated between databases, allowing system designers to put the data where it's needed.

A business organization that wants to have additional backup strategy

In conjunction with backup, replication strategies complement traditional approaches by providing alternative levels of data protection and integrity while minimizing user disruptions. Replication creates a point-in-time copy of the data to be used as the backup source.

A business organization that wants to set up a failover system

Replication Server maintains a near real-time slave database to which applications can switch with virtually no downtime if the primary site fails. You can manage planned downtime such as routine maintenance and software upgrades. It protects during unplanned downtime due to machine/network outage, for example. It also provides disaster recovery. Any system providing HA services should provide continuous availability of data in any scenario.