Feature Wiki
Information about planned and released features
Tabs
MariaDB Support
Page Overview
[Hide]1 Requirements
Currently, MariaDB ist not supported and some errors have already occured. Since MariaDB offers many interesting (and possibly performance enhancing) features especially in connection with InnoDB tables, it should be worthwhile supporting it fully.
1.1 Problematic Issues
InnoDB - Too long keys
For example, using MariaDB and InnoDB tables produces database errors during the installtion pof ILIAS, beacuse some keys in some tables (e.g. cmi_gobjective, dav_lock, ...) are too long for the standard row_format "compact" that is used by MDB2 to create tables. "Compact" tables can only handle 767 bytes in a key.
The problem as such occurs with Oracle MySQL 5.x community edition as well, but Oracle MySQL solves this issue by implicitely truncation the keys.
This issue could be solved in different ways:
For example, using MariaDB and InnoDB tables produces database errors during the installtion pof ILIAS, beacuse some keys in some tables (e.g. cmi_gobjective, dav_lock, ...) are too long for the standard row_format "compact" that is used by MDB2 to create tables. "Compact" tables can only handle 767 bytes in a key.
The problem as such occurs with Oracle MySQL 5.x community edition as well, but Oracle MySQL solves this issue by implicitely truncation the keys.
This issue could be solved in different ways:
- use a better database driver that supports more modern InnoDB options, such as the ROW_FORMAT "Compressed" and "Dynamic" (which can handle keys up to 3072 bytes)
- look through ALL ILIAS tables / database setup steps to identify and solve problematic tables / key / alterations
- combination of option 1 + 2 :)
2 Additional Information
- Idea / concept: Marko Glaubitz,marko.glaubitz@rz.uni-freiburg.de
- Interest in funding: at least partially Universität Freiburg
- Maintainer: (will be set by Jour Fixe / maintainer)
- Implementation of the feature is done by (will be set by Jour Fixe / maintainer)
- Testcases by: (please add your name if you want to create the testcases for this feature)
3 Discussion
4 Implementation
{please give a description of the final implementation and add screenshots if possible}
Test Cases
Test cases completed at {date} by {user}
- {Test case number linked to Testrail} : {test case title}
Approval
Approved at {date} by {user}.
Last edited: 20. Aug 2015, 16:53, Glaubitz, Marko [mglaubitz]