Setting up MySQL


#1

How to setup MySQL with Razuna

In this guide, we assume that you got a working MySQL Server up and running or just installed one. If not, then please consult your administrator or download and install the MySQL Server.

Important: Make sure you create a database called “razuna” with a correct user and password that allows access to the database. Furthermore, tables need to be configured to use the high-performance InnoDB storage system!

Create the Razuna database with the following command:

create database razuna character set utf8;

For MySQL versions 5.6 and above the following global parameters also need to be set:

SET GLOBAL innodb_large_prefix = 1;
SET GLOBAL innodb_file_format = barracuda;
SET GLOBAL innodb_file_per_table = true;
SET GLOBAL innodb_large_prefix = ON;

:information_source: MySQL Versions
Razuna has been tested with MySQL 4.x and 5.x. WE HAVE NOT tested Razuna with version 8.x or above.

Razuna will setup all the required tables for a successful Razuna deployment within the “Razuna” database. Furthermore, tables need to be configured to use the high-performance InnoDB storage system. Please consult the page Recommended MySQL settings for the recommended MySQL setup for Razuna.

We still recommend that you take a look at our Recommended MySQL settings.


New Install using MYSQL setup wizard failure
Change DB from H2 (default) to MySQL
Need quick help with database server selection ... MySQL 5.6? 5.7?