MySQL database provides three database types to choose from during the installation process:
Transactional, Non-Transactional or Multifunctional
Which database type would be best for Foglight?
Transactional type will be the most appropriate option. That will configure the database to use the InnoDB storage engine which is what Foglight uses.