Cluster Control don't import mysql replication

Follow

christoforos demetriou

• November 26, 2018 14:02

0 down vote favorite

 

I tried to import four mysql node on Cluster Control.

My structure is like this :

A <-> B -> C -> D

mysql version : 5.7.23 Linux version : Ubuntu 18.04 LTS Cluster Control: Controller: 1.7.0.2825, Frontend: 1.7.0.5259

I get this error:

Adding existing cluster has failed.
Found more than one writable node. Exactly one node must have 'read_only=OFF'. Correct the read_only settings and restart the job. Aborting.

Do you know how I can resolve this?

0

• 

  Ashraf Sharif

  • November 27, 2018 04:10

  Hi Christoforos,

  As stated in the error, ClusterControl allows only one node to accept write (read_only=OFF) in one given cluster during the import process for accurate topology detection. In your setup, it seems like A and B are writable. Simply set B to read_only=ON before the import process. You can change it back to read_only=OFF once the import process completes.

   

  Regards,
  Ashraf

  0

  Comment actions Permalink
• 

  Ashraf Sharif

  • November 27, 2018 06:21

  Hi Christoforos,

  I'd like to emphasize here that despite supported by ClusterControl, if you are running with more than one writable master in a replication setup, you are exposed to a certain risks e.g, cluster recovery won't work accurately and load balancer integration for read/write splitting will also be a problem. 

  Regards,
  Ashraf

  0

  Comment actions Permalink
• 

  christoforos demetriou

  • November 27, 2018 09:57

  Hello Ashraf,

  Thanks for the replay :)

  Load balancer integration from the Cluster Control ?

   

  Best regards, :) :P

  0

  Comment actions Permalink

Please sign in to leave a comment.