MySQL scalability with zabbix

[Javier]

Hi,

i am using Zabbix Server 1.8 for monitored 20000 host's and i hace high mysql load!!
My system isn't scalable and i need more scalability.
I have a mysql-cluster for improve my performace, but sql table of zabbix don't work with NDBCLUSTER.

Any people make similar instalation? How you make data base scalability?

Thanks in advance.
Javier.

[nelsonab]

Are you tied to MySQL? It may be sacrilegious to some people but have you considered Oracle?

[Javier]

Hi,

if i can use Oracla DB with Zabbix-Server the scalability problema don't exists. I think that Oracla is scalable and with performance is true.

In the proyect i want use mysql in first time, but i don't know how to increment the performance and scalability of MySQL and it's very important.

I can see others MySQL solutions (cluster, proxy, etc) and if any solution work's, i write here.

Thanks in advance.
Javier.

[exkg]

Hi,

We have used Oracle for a large enviorement (3k hosts) and performance was worst than MySQL.

I think a good idea is use table partitions in a good storage system.

In most cases the main problem is related to IO (writes / reads). How it is in your enviroment ?

[Javier]

Hi,

the initial idea is to use zabix for monitoring 20k hosts. We know than partition tables is basic, but how to apply this to MySQL server while we think that this system has to be scalable?
The horizontal scalabity is very important because the host is a number continuously growing.

How i can to use table partitions in mysql? Some link?

Thanks.
Javier.

[nelsonab]

MySQL clustering isn't going to be of use to you at all. MySQL clustring is best for databases with more reads than writes, Zabbix is HEAVY on the writes...

This is pretty much the order for MySQL performance you'll want to think about. This assumes you're starting with a decent machine to begin with.

- Tune MySQL (lots of posts/discussions about this and some consultants available)
- Spread out your IO load. If you can get your history tables to be on one lun/device and your trends another and the remainder on another lun/device do that. I haven't needed to dig that deep into the internals of MySQL so I don't know if it's possible to move tables to specific partitions.
- Good disk controllers. Since you cannot cluster MySQL (for write performance) you'll need to make sure your IO into your MySQL database is good
- Memory, MySQL loves to eat RAM... :-D Feed it...
- Start looking at your IO paths in your system, are there motherboard bottlenecks such as the Northbridge bus. If so consider different architecture/mobo
- Better processor/faster RAM
- Faster processor

[Firm]

Javier,

You may also have a look to distributed monitoring feature in Zabbix.