ZABBIX Forums  

Go Back   ZABBIX Forums > Zabbix Discussions and Feedback > Zabbix for Large Environments

View Poll Results: Which database engine are you using for Zabbix Server?
MySQL 82 69.49%
Oracle 11 9.32%
PostgreSQL 25 21.19%
Other 0 0%
Voters: 118. You may not vote on this poll

Reply
 
Thread Tools Display Modes
  #1  
Old 29-03-2011, 13:25
xsbr xsbr is offline
Junior Member
Zabbix certified specialist
 
Join Date: Oct 2009
Location: São Paulo, Brazil
Posts: 24
Default Which database engine are you using for Zabbix Server?

Actually we are using MySQL on our Testing Environment (2.5k vps) with this specs:

OS: CentOS 5.5 64bits

Database: MySQL Percona 5.1
  • InnoDB with a file per table
  • Housekeeper disabled
  • Table partition by day on history tables
  • Table partition by month on trend tables
  • Created an index by clock column on some tables

Hardware:
  • Dell R610 Poweredge
  • 2x L5520 CPUs
  • 24GB RAM
  • 4x HDs 500GB SATA 10K (RAID 10)

Now we trying to setup this environment on Oracle Standard 11g
__________________
Ricardo Santos
Developer and SysAdmin

My Blog dedicated to Zabbix Environments
[URL="http://zabbixzone.com"]http://zabbixzone.com[/URL]
Reply With Quote
  #2  
Old 29-03-2011, 17:43
nated nated is offline
Junior Member
 
Join Date: Apr 2009
Posts: 5
Default

DB: MySQL 5.0 (percona), all InnoDB, Master-Master replication running active/passive with manual failover.

Hardware: 2 x Dell 2970, 12 core x 2.8GHz, 32GB, 6 x 15k SAS in RAID10

OS
: Debian 5

We're in the process of migrating from the 2970's to a couple R710's with 128GB RAM Also switching to Percona Server 5.1.

I'm interested in reading about some big installs on PostgreSQL. Anyone doing that?
Reply With Quote
  #3  
Old 29-03-2011, 17:55
untergeek untergeek is offline
Senior Member
Zabbix certified specialist
 
Join Date: Jun 2009
Location: Austin, TX
Posts: 512
Default

Quote:
Originally Posted by xsbr View Post
Now we trying to setup this environment on Oracle Standard 11g
We are presently running 531 hosts, 25409 items, 6491 triggers and 408.98 nvps on RHEL5 with Oracle 11G on the backend. I would be very, very interested in your experience with this. We are slated to grow dramatically with our monitoring soon. The one thing which would dramatically speed up Oracle's performance would be the use of BIND variables. I understand why it's not included in Zabbix's code, but it is a disappointment to our DBAs as every query has to be fully evaluated instead of being able to cache certain elements.

How large is your entire database?
Reply With Quote
  #4  
Old 29-03-2011, 17:58
italux italux is offline
Junior Member
Zabbix certified specialist
 
Join Date: Jul 2010
Posts: 21
Default

How many hosts you have?

Quote:
Originally Posted by nated View Post
DB: MySQL 5.0 (percona), all InnoDB, Master-Master replication running active/passive with manual failover.

Hardware: 2 x Dell 2970, 12 core x 2.8GHz, 32GB, 6 x 15k SAS in RAID10

OS
: Debian 5

We're in the process of migrating from the 2970's to a couple R710's with 128GB RAM Also switching to Percona Server 5.1.

I'm interested in reading about some big installs on PostgreSQL. Anyone doing that?
__________________
At.
Italo Santos
Operating Systems Analyst

[url]http://italosantos.com.br/[/url]
[url]http://github.com/Italux[/url]
Reply With Quote
  #5  
Old 29-03-2011, 18:06
xsbr xsbr is offline
Junior Member
Zabbix certified specialist
 
Join Date: Oct 2009
Location: São Paulo, Brazil
Posts: 24
Default

2.7k hosts - 181k items - 92k triggers - 2471 vps
DB size is about 73GB (2 months trends and 2 days for history)

Quote:
Originally Posted by untergeek View Post
How large is your entire database?
__________________
Ricardo Santos
Developer and SysAdmin

My Blog dedicated to Zabbix Environments
[URL="http://zabbixzone.com"]http://zabbixzone.com[/URL]
Reply With Quote
  #6  
Old 29-03-2011, 19:09
jonh jonh is offline
Junior Member
 
Join Date: Aug 2010
Posts: 8
Default

DB: MySQL 5.1 (stock version), all InnoDB

Hardware: Dell 2970, 8 core x 2.6GHz, 32GB, 2 x 15k SAS in RAID1 (OS, innodb logs) and 4 x 15k SAS in RAID10 (innodb tablespace)

OS
: CentOS 5 64-bit

Hosts/Items: 3277 / 133139

Has anyone tested Zabbix on MySQL 5.5? It's finally in public release, but it's new enough that I don't want to just cut over without lots of testing.

Thanks for the comments about partitioning and added indexes. I have not been using those features yet but we've grown to the point where some queries on history and trends literally never complete. So it may be time for that Would you mind saying what clock indexes you added, and why?
Reply With Quote
  #7  
Old 29-03-2011, 20:50
nated nated is offline
Junior Member
 
Join Date: Apr 2009
Posts: 5
Default

Quote:
Originally Posted by italux View Post
How many hosts you have?
327 hosts, 22k items, 6k triggers, 336 nvps, and db size around 150GB (lots of trend data). Not that big compared to some of the others here but we are looking to grow it quite a bit. We have some other internal tools using the db also, though they are lightweight compared to Zabbix.
Reply With Quote
  #8  
Old 29-03-2011, 22:40
MarkusL MarkusL is offline
Member
 
Join Date: Nov 2008
Posts: 41
Default

Our goal is monitoring small customer networks. We are working with one zabbix-proxy per customer.

At the moment we are migrating with a complete new installation our old 1.6.5-zabbix-server/proxies to a fresh and basic redesigned 1.8.4-zabbix-server/proxy-environtment.

All our proxies connect via outgoing ssh automatically to our zabbix-server.

Some data about our environment:

1x Zabbix-Server:
DELL R2950, 1x XEON Quad E5420 (2,5GHz, 2x6MB), 8GB RAM, 4x 146GB 15k SAS (2x RAID1 for root and swap), 2x 450GB 15k SAS (RAID1 for mysql-innodb),
Ubuntu Server 10.04.1 LTS, 64bit

at the moment 21x Zabbix-Proxy-Server:
BTO-servers, Intel Atom, 1-2GB RAM, 80-160GB S-ATAII,
Ubuntu Server 10.04.1 LTS, 64bit, rollout / cloning via Mondo

Zabbix-Values (when we finished migrating):
~ 600 Hosts, fast growing :-)
~ 16000 Items
~ 20000 Triggers
~ 200vps

Most interesting about the setup is, that the basis of our monitoring is simple "german" T-DSL Business 2000 up to 16000 (upload 40-125kB/s max) with forced reconnect all 24h by provider. We have a "planned downtime" in our trigger-dependency-model for 23.55h-00.05h; in this time we and all our customers Internet go down and up again (router- / firewall-config) + automatically connecting all proxies per autossh to our zabbix-server again. Works with our old system and our new system like a charm for about 2,5 years now!

We really love the model server <-> proxy in zabbix. Btw, all proxies are configured to store config for 48h in case of longer internet-downtimes at us or customer. In this case, proxies store all collected data in local db and deliver at reconnecting. With little tricks in trigger-dep. we only get one alert; no nodata or other things popping up. GREAT!


Kind regards,

Markus.


P.S.: very interesting thread! I´m really interested to hear from other people working with zabbix-proxies.
Reply With Quote
  #9  
Old 30-03-2011, 03:19
xsbr xsbr is offline
Junior Member
Zabbix certified specialist
 
Join Date: Oct 2009
Location: São Paulo, Brazil
Posts: 24
Default

Quote:
Originally Posted by jonh View Post
Hosts/Items: 3277 / 133139
Great numbers! We're in the same game.

Quote:
Originally Posted by jonh View Post
Has anyone tested Zabbix on MySQL 5.5? It's finally in public release, but it's new enough that I don't want to just cut over without lots of testing.
I prefer waiting for percona 5.5 stable version

Quote:
Originally Posted by jonh View Post
So it may be time for that Would you mind saying what clock indexes you added, and why?
On next days I'll write about this with details. Today I've only my own documentation in SQL format.
__________________
Ricardo Santos
Developer and SysAdmin

My Blog dedicated to Zabbix Environments
[URL="http://zabbixzone.com"]http://zabbixzone.com[/URL]
Reply With Quote
  #10  
Old 30-03-2011, 03:43
xsbr xsbr is offline
Junior Member
Zabbix certified specialist
 
Join Date: Oct 2009
Location: São Paulo, Brazil
Posts: 24
Default

Quote:
Originally Posted by jonh View Post
P.S.: very interesting thread! I´m really interested to hear from other people working with zabbix-proxies.
I opened a dedicated thread to talk about proxies:
http://www.zabbix.com/forum/showthread.php?p=82223
__________________
Ricardo Santos
Developer and SysAdmin

My Blog dedicated to Zabbix Environments
[URL="http://zabbixzone.com"]http://zabbixzone.com[/URL]
Reply With Quote
Reply

Tags
mysql oracle database

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 15:33.