How to configure MySQL in Azure for your GpsGate installation

This article describes how to set up a MySQL database under Microsoft Azure to be used in a GpsGate installation.

This article does NOT describe how to install GpsGate on Azure.

1. Follow Create MySQL Server database instructions from Microsoft. Make sure that on your installation, you select MySQL 8.

2. Once your MySQL resource is created, go to it.

3. On the Server parameters properties, select optimizer_switch > BLOCK_NESTED_LOOP=ON

5. On Server parameters > sql_mode, unselect ONLY_FULL_GROUP_BY

4. Finally, click on Save.

Now your MySQL server resource is configured to be used in a GpsGate installation.