top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Mysql Cluster Sync-UP

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.

posted Apr 9, 2013 by Salil Agrawal

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

2 Answers

0 votes

Do you mean the mysql system database, or a specific database/table that's in the NDB cluster engine? The mysql system database falls outside of the cluster realm, so each server has its own independent copy.

I would say though that for most purposes, you probably don't want to use NDB Cluster. It is suitable for very specific use cases, and is 'abused' in other situations.
These days, there are better solutions for many cases, including Galera cluster which is a synchronous replication mechanism in MariaDB 5.5 (-cluster) and above. It's not available in stock (Oracle) MySQL.

answer Apr 9, 2013 by anonymous
0 votes

What do you mean by running MySQL in cluster mode - MySQL Cluster? If so then the data is stored in the data nodes rather than the MySQL Servers and so if bad data is written to one MySQL Server then that same bad data will be viewed through the other MySQL Server too.

answer Apr 10, 2013 by anonymous
Similar Questions
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.

+1 vote

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?

0 votes

To source sqldump i can use the source command, but if I need to do the same stuff using command line without going to the sqlpromt, can I achieve that.

+1 vote

I am using PHP along with mysql. Mysql default configuration allows to have 100 simultaneous connection which I want to chane to 200. Please help.