Page 1 of 1
Replication question for MySQL
Posted: Thu Jun 11, 2015 7:19 am
by 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
Re: Replication question for MySQL
Posted: Thu Jun 11, 2015 10:13 am
by 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.
Re: Replication question for MySQL
Posted: Wed Mar 08, 2017 3:04 pm
by bfkogle
Is this still the case? We are looking to implement the same replication method in our environment.
Re: Replication question for MySQL
Posted: Wed Mar 08, 2017 3:49 pm
by 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