1

I have the next question that I don't know how to solve.

I currently have a server running mariadb version 10.1 on a Debian 9.8. This server is for test environments so it is not a real production environment.

Now I need to create a cluster using a gallery to have two nodes. I already have the second server mounted, but I don't know what are the steps to configure the Galera cluster of a node with databases already created and with information and with another node completely from scratch. What would be the steps and what should be done?

Jagadesh
  • 2,104
  • 1
  • 16
  • 28
admatlantis
  • 45
  • 2
  • 4
  • 1
    The minimum are 3 Nodes to create a Galera Cluster. – Bernd Buffen Feb 10 '20 at 10:13
  • Here is the Doku https://mariadb.com/kb/en/getting-started-with-mariadb-galera-cluster/ – Bernd Buffen Feb 10 '20 at 10:15
  • Thank you very much for the answers. But this documentation does not solve anything. I have already been able to configure a galley cluster from scratch. But now the situation that is proposed to me is having a mysql database server in standalone mode, with databases created and with information already within those databases, I don't know what is the procedure to form a galley cluster and that all the server information that is already configured to the cluster is replicated. – admatlantis Feb 11 '20 at 08:23
  • I suggest you consider upgrading to 10.3 _first_, since it will be easier to do it on a single node than a complete cluster. – Rick James Feb 16 '20 at 01:52
  • s/galley/Galera/ and s/gallery/Galera/ – Rick James Feb 16 '20 at 01:52
  • You need to _configure_ the second node, but not load the data. The bootstrap will take care of copying (via "SST") the data from your first node to the second. – Rick James Feb 16 '20 at 01:54

0 Answers0