Skip to content

Modified script to automate the creation of Zabbix MySQL DB partitions with Zabbix 2.0.x

Notifications You must be signed in to change notification settings

cdand/zabbixdbpartitioning

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

39 Commits
 
 
 
 

Repository files navigation

zabbixdbpartitioning

Modified script to automate the creation of Zabbix MySQL DB partitions with Zabbix 2.0.x

This work is heavily copied from work by jbayer published on linuxnotes.us (http://linuxnotes.us/archives/503).

In turn that article is derived from work by Ricardo Santos published on the zabbixzone.com blog (http://zabbixzone.com/zabbix/partitioning-tables/).

My efforts extend the contributions of the above authors to make the database partitioning compatible with Zabbix 2.0.x which uses foreign keys between certain histortical tables, my solution to this has been to only partition the history and trends tables. This does leave a problem of a solution to perform some kind of 'housekeeping' on tables such as events, alarms and acknowledes etc...

I have also added a few more arguments to the script that allow a non-interactive functionality (e.g. for use with Puppet) and with this modified/added some default values.

About

Modified script to automate the creation of Zabbix MySQL DB partitions with Zabbix 2.0.x

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages