Decide on the Database

[glogiotatidis]

Current database on SCL3

• MySQL 5.6.33-log

We should investigate the existence of raw SQL queries in the codebase or in libraries (especially django-tidings) before deciding on the Engine type and version.

[glogiotatidis]

Closest MySQL available in AWS is 5.6.34

[safwanrahman]

@glogiotatidis As far as I know, SUMO uses Mariadb in SCL3. Can you please check again?

[bookshelfdave]

@safwanrahman this is for the migration to AWS, the main project is located here: https://github.com/mozilla/kitsune/projects/2 (which can also bee seen on the right of this Github issue)

[safwanrahman]

@metadave Yes. I have seen. I have just curios about SCL3 that when they have changed the database from MariaDB to MySQL. As far as I remember, it used to be MariaDB, can you check whats in the SCL3?

[bookshelfdave]

Sorry, that's not something I have access to.

[glogiotatidis]

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.6.33                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.6.33-log                   |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | Linux                        |
+-------------------------+------------------------------+

[akatsoulas]

This issue is too old and probably resolved by now. Please open a new issue if this is not the case.