Replication question for MySQL

[martial86]

Hi Nagios Team,

We are in our process of rolling out Nagios XI and we would like to use MySQL database replication on a managed host.
Does Nagios XI support MySQLreplication using GTID (Global Transaction IDs)?

Thanks and Best Regards
David

[jdalrymple]

I don't think we document it anywhere, and I love to point things out in documentation so you don't have to just take my word for it. Today I'm afraid you'll have to take my word for it, the answer is no.

[bfkogle]

Is this still the case? We are looking to implement the same replication method in our environment.

[ssax]

Correct, this is still the case, the defaults still use MyISAM for the majority of tables.

When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB.

This restriction is due to the fact that updates to tables that use a nontransactional storage engine mixed with updates to tables that use a transactional storage engine within the same transaction can result in multiple GTIDs being assigned to the same transaction.

Taken from here:

https://dev.mysql.com/doc/refman/5.6/en ... tions.html