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ō:
mysqld settings:
innodb settings:
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:
|