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

Allow plugins to dictate their preferrred engine and character set #5934

Open
TheWitness opened this issue Nov 29, 2024 · 1 comment
Open
Labels
database Database and database support issues enhancement General tag for an enhancement plugins Plugin related issue

Comments

@TheWitness
Copy link
Member

Feature Request

Is your feature request related to a problem? Please describe

There are several plugin that desire to have either a character set or table engine other than InnoDB or utf8mb4 due to either performance or space requirements. One good example is the flowview plugin which want's it's analytic tables in 'Aria' or 'MyISAM' and would prefer latin1 as there is no internationalization in those tables. Both changes improve performance of the plugin.

However, Cacti provides no way for Cacti's table conversion functions to regulate that.

Describe the solution you'd like

Provide a callback that allows the plugins to validate the desired engine of their tables.

Describe alternatives you've considered

For the near term, we have modified Cacti starting in 1.2.29 to only convert base tables and not plugin table.

Additional context

There is no real good answer here.

@TheWitness TheWitness added the enhancement General tag for an enhancement label Nov 29, 2024
@TheWitness
Copy link
Member Author

Note, this will likely only impact older Cacti installs where we used MyISAM for just about everything early on.

@TheWitness TheWitness added plugins Plugin related issue database Database and database support issues labels Nov 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
database Database and database support issues enhancement General tag for an enhancement plugins Plugin related issue
Projects
None yet
Development

No branches or pull requests

1 participant