High availability with shared MySQL


(Oscar) #1

Hi,

I’d like to configure a high availability opennebula platform.

I have read the official document: https://docs.opennebula.org/5.6/advanced_components/ha/frontend_ha_setup.html

In my environment I have an external cluster for mysql.

In the official document looks system manages mysql synchronization that makes non sense in my scenario.

Anyone can give an approach about how to configure the ha cluster when database is shared?

Thanks a lot in advance


(Redouane Bouzeghoub) #2

Hi,

You can change This file below.

Configuring OpenNebula

Before you run OpenNebula for the first time, you need to set in oned.conf the connection details, and the database you have granted privileges on.

Sample configuration for MySQL DB = [ backend = “mysql”, server = “localhost”, port = 0, user = “oneadmin”, passwd = “<thepassword>”, db_name = “opennebula” ]

Fields:

  • server : URL of the machine running the MySQL server.
  • port : port for the connection to the server. If set to 0, the default port is used.
  • user : MySQL user-name.
  • passwd : MySQL password.
  • db_name : Name of the MySQL database OpenNebula will use.

Best regards


(Oscar) #3

Hi, thanks a lot for your answer.

I’d like to know if it is supported having many opennebula servers and schedulers working against the same database.

Thanks a lot in advance


(Redouane Bouzeghoub) #4

Hi,
Yes, you can but you should do sizing.
Best regards.


(Oscar) #5

Thanks a lot!


(Oscar) #6

There is another post where it looks it is not a good idea to have 2 oned daemons.

Anybody has tested this configuration?

Thanks a lot