IDO master - set prefered host

MarcusCaepio · October 9, 2020, 12:11pm

Hi all,
my both master server have a local DB, where the DBs are in a mariaDB master-master replication.
I want, that the IDO connection is built on my first master node and only on the second, if the first is down. Unfortunately (doesn’t matter, what I try) the IDO connection is always built up from the second master. Is there any way to set a prefered master for the IDO connection?

Cheers,
Marcus

Al2Klimov · October 12, 2020, 10:27am

Hello @MarcusCaepio!

Have you tried to rename the IdoMysqlConnection object in /etc/icinga2/features-available/ido-mysql.conf from ido-mysql to something else?

Attention: They shall be named equally on both masters.

Best,
AK

MarcusCaepio · October 14, 2020, 8:19am

How should renaming help to set a preferred server for the IDO conenction?

Al2Klimov · October 14, 2020, 9:29am

github.com

Icinga/icinga2/blob/876fa8ba97a5c621b5e778649cc669f1611fdc3b/lib/remote/apilistener-authority.cpp#L71



		for (const ConfigObject::Ptr& object : dtype->GetObjects()) {
			if (!object->IsActive() || object->GetHAMode() != HARunOnce)
				continue;

			bool authority;

			if (!my_zone)
				authority = true;
			else
				authority = endpoints[Utility::SDBM(object->GetName()) % endpoints.size()] == my_endpoint;

#ifdef I2_DEBUG
// 			//Enable on demand, causes heavy logging on each run.
//			Log(LogDebug, "ApiListener")
//				<< "Setting authority '" << Convert::ToString(authority) << "' for object '" << object->GetName() << "' of type '" << object->GetReflectionType()->GetName() << "'.";
#endif /* I2_DEBUG */

			object->SetAuthority(authority);
		}
	}

martin · October 14, 2020, 9:56am

Hello,

This topic might help.
I created it before seeing this thread.

MarcusCaepio · October 14, 2020, 10:08am

Well ok, the order was correct, but indeed, changing the name of the ido connection did the trick… never thought about this, thanks all