top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Your offline data will synchronize with the MySQL cluster on your web host?

+1 vote
770 views

if you set up your LAN MySQL server in to cluster, will it make the new data's entered on a laptop MySQL database that is not connected on the LAN synchronize with the cluster, once that laptop got connected with the LAN again? Is it also possible to set up a cluster on a web host MySQL, so that when you log in on the online database, your offline data will synchronize with the MySQL cluster on your web host?

posted May 15, 2014 by Deepak Chitragar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

You need to do something more like replication and not clustering - Suggested Link is here.

Clustering is used for high availability / high usage. You would need multiple independent servers attached with a minimum 10/1000 ethernet connection. Clustering requires using the NDB storage engine where the entire database is held in memory. It's a very complicated and expensive setup, and would not work if the servers aren't directly connected and always on.

Replication also does not work well unless the servers are always connected. It generally ends in a data mismatch and then the servers stop replicating.

answer May 16, 2014 by Aastha Joshi
Similar Questions
0 votes

I am running My-SQL in cluster mode with two machine. Want to know if mysql database get corrupted on one of the machine will it force the corruption on the other machine too or in this case sync between two mysql instances will stop after the corruption.

0 votes

My site is using mysql and PHP, now for the scale purpose want to introduce mysql-cluster. Few questions are -
1. Do I need to change any code which is written in PHP.
2. What are the steps to convert mysql to mysql-cluster.

Appreciate the help.

0 votes

I have a database on local computer and same on remote, I want to sync both server any suggestion on how to proceed?

...