Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-714

need scalable alternative for the history and items tables

    XMLWordPrintable

    Details

    • Type: Change Request
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.8.2
    • Fix Version/s: None
    • Component/s: Server (S)
    • Environment:
      Linux, Postgresql

      Description

      We have hundreds of monitored servers with thousands of checks in total. The size of the items and various history tables in the Zabbix database is a major scalability problem for us – we've got it running on a very fast RAID array with 10+ disks, but a postgres autovacuum of the items table makes the server almost unusable.

      Long-term the amount of data we can store in those tables will limit whether we can continue to use Zabbix. Has any thought been given to a more scalable storage mechanism? Some ideas:

      • partition the tables in SQL (we'd be OK with switching to mySQL if needed, but some official support for table partitioning could help)
      • support storing the huge data in BerkeleyDB, Cassandra, Hadoop, or some other more scalable storage mechanism

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alexei Alexei Vladishev
              Reporter:
              harpo Will Lowe
              Votes:
              66 Vote for this issue
              Watchers:
              62 Start watching this issue

                Dates

                Created:
                Updated: