Navigation Menu

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add a config option to set the database engine to InnoDB #7311

Open
NateWr opened this issue Sep 21, 2021 · 1 comment
Open

Add a config option to set the database engine to InnoDB #7311

NateWr opened this issue Sep 21, 2021 · 1 comment
Labels
Enhancement:1:Minor A new feature or improvement that can be implemented in less than 3 days. Housekeeping:1:Todo Any dependency management or refactor that would be nice to have some day.

Comments

@NateWr
Copy link
Member

NateWr commented Sep 21, 2021

Describe the problem you would like to solve
Some hosting environments can not change the default storage engine of the database to InnoDB because they host over software which expects MyISAM. In such scenarios, it is not possible to run recent versions of OJS which create tables using the default storage engine.

Describe the solution you'd like
Add a config option to manually specify the database engine. This config option should be added to the [database] section and commented out by default:

; Database engine
; Override this setting if you operate in a shared hosting environment and are unable to run
; OJS on the server's default database engine. 
; InnoDB is the recommended database engine for MariaDB/MySQL
; engine = InnoDB

Who is asking for this feature?
Users running OJS in a shared hosting environment.

Additional information
See the forum post.

@NateWr NateWr added Enhancement:1:Minor A new feature or improvement that can be implemented in less than 3 days. Housekeeping:1:Todo Any dependency management or refactor that would be nice to have some day. labels Sep 21, 2021
@asmecher
Copy link
Member

It may be possible to set the engine at the connection level, rather than needing to specify it for each table -- see: https://stackoverflow.com/questions/21380754/how-do-you-set-default-engine-for-the-schema-builder

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Enhancement:1:Minor A new feature or improvement that can be implemented in less than 3 days. Housekeeping:1:Todo Any dependency management or refactor that would be nice to have some day.
Projects
None yet
Development

No branches or pull requests

2 participants