3. Database Setup

ROGO 7.0.0

Below is a guide on how to install a database for the latest version of Rogō.

If you have a MySQL expert or database administrator you are recommended to contact them for advice first.

MySQL is currently the only supported database. Please let us know if you do successfully run Rogō on a non MySQL database.

See the community release notes for the version of rogo you are installing to see the required MySQL version.

The basic default installation config should work for small instances. The my-large.cnf should be suitable for most large instancees.

Consult your DBA and review the MySQL documentation before making any configuration changes.

Make sure the setting default-storage-engine in my.ini is same as the DB engine for Rogo database. If rogo DB is set to innoDB, change it in my.ini to innoDB.

The following non default settings may needed to fine tune MySQL for Rogō:

Fine tuning

mysqld settings:

ft_min_word_len	3
key_buffer_size	384M
max_allowed_packet	16M
thread_stack	256K
thread_cache_size	8
max_connections	500
query-cache-type	1
query_cache_limit	5M
query_cache_size	500M
max_heap_table_size	536870912
tmp_table_size	536870912
table_open_cache	2500
log-bin	mysql-bin
binlog_format	mixed

innodb settings:

Not convinced these are improvements on the default settings of mysql 5.7+. So I would only change them if you know what you are doing.

innodb_buffer_pool_size	2000M
innodb_additional_mem_pool_size	200M	deprecated
innodb_log_buffer_size	5M
innodb_flush_log_at_trx_commit	1
innodb_lock_wait_timeout	50

On systems with networked file storage (SANS) with slow disk IO times considerer usinginnodb_flush_log_at_trx_commit = 2. See 'adaptive flushing' for a description of the consequence.

mysqldump settings:

quick
max_allowed_packet	24M

ExamSys (Archive)

3. Database Setup

Related articles

Filter by label