I am working with Icinga 2.1.2 and I need to upgrade my MYSQL database to a newer version, I would like to know which versions of MYSQL are compatible with this version of Icinga or which is the major version I can use.
Could you please verify which Icinga 2 version you are using? AFAIK, there was no Icinga 2 release 2.1.2, and even if, it must be ten years old.
Generally speaking, upgrading MySQL to a newer version should work for Icinga 2’s IDO, Icinga DB and Icinga Web 2. Of course, having a backup just in case is always a good idea.