admin on February 4th, 2014

Readers would be pleased to know that I have teamed up with Packt Publishing to organize a Giveaway of the Mastering Zabbix

And three lucky winners stand a chance to win ecopy of their new book. Keep reading to find out how you can be one of the Lucky Winners.
Overview:

3491OS_Mastering%20Zabbix[2]

•Integrate Zabbix in your large or complex environment
• Establish a distributed monitoring solution
• Set up Zabbix and its database in a High Availability configuration
• Collect data from a variety of monitoring objects
• Organize your data into graphs, charts, and maps
• Build intelligent triggers and alarms to monitor you network
• Write scripts to create custom monitoring probes
• Understand Zabbix’s database scheme and harvest data from it
• Automate procedures using Zabbix’s API

 

How to Enter?

All you need to do is head on over to the book page (Mastering Zabbix) and look through the product description of the book and drop a line via the comments below this post to let us know what interests you the most about this book. It’s that simple.

Deadline

The contest will close on Feb 15th 2014. Winners will be contacted by email, so be sure to use your real email address when you comment!

 

admin on January 19th, 2014

I am still getting many and many question about which database you should choose.

Well I don’t think is really needed do comparison of all the features they have side-by-side as the web is already full of this kind of comparison.

What I think is that most people are comparing MySQL with PostgreSQL but they are indeed very different.

Comparing apple with pear

You can find a lot of comparison between those two DBMS engine… but I think is like compare apples with pears : they are completely different!

The main difference is that PostgreSQL is fully ACID compliant and MySQL no. I already know that now many and many follower will think that it is not true as InnoDB made MySQL fully ACID compliant, and well it is true, but…. you have a great fully ACID compliant Engine that you can’t hot backup… 

Some years ago I had an interesting and large Zabbix installation on MySQL.

I still have a screen shot that report the following data:

Number of hosts (monitored) 1662
Number of items (monitored) 82532
Number of triggers (enabled) 14118

as you can see it can’t of course considered a small installation!

Well now all is fine until you don’t face an issue, and it is very important have a hot backup utility in place.
Then I managed to migrate the database on InnoDB (as they want to keep the database on MySQL) and they bought InnoHotBackup for something like 800 USD. As far I know that database still up and running and they managed to do a couple or restore due some issues.

Now without that utility InnoDB can’t be hot backed up!!! In the meaning InnoBase (the vendor of that great utility) has been bought by Oracle and… you need to buy a licence from Oracle to have the same kind of functionality and… I can say that an Oracle One Edition cost more or less like a MySQL license… for this reason now MySQL is no more used on my setup.

Performance performance performance….

Now many people want to know which database is better.

Well all my setup are running on PostgreSQL and I can say that they run without any kind of issue, with a good backup policy and restore tested at scheduled period on a spare server.

PostgreSQL need to be tuned to run faster than MySQL but of course nobody that read my website is here looking for a Next-> Next ->Next ->Finish setup :)

If you are interested to see some perf chart there is a very well done presentation at this address.

The conclusion of their test reflect exactly my thoughts and then:

  • PostgreSQL and MySQL is almost same performance when used as Zabbix DB ( I would say that PostgreSQL is a bit better as it run with less IO waits)
  • MySQL consume less CPU (but the partitioning don’t support foreign keys and is less sophisticated than PostgreSQL)
  • PostgreSQL is more stable in Heavy I/O Situation
  • PostgreSQL offer a hot backup and point in time restore
  • PostgreSQL is fully ACID

Now if you are curious go to check the presentation :)

 

 

 

admin on January 12th, 2014

I am very happy as I am getting a lot of positive feedback about the “Mastering Zabbix” book.

I would like to share with my followers some of them. They are coming from the Zabbix group on Linkedin in this thread.

Bought and I’ve found many useful information and tips.
Good work, a must have for sysadmin and Certified Specialist.

Very good book on mastering Zabbix, nice chapters on DB partitioning, proxies and H/A. Must be hold by all Zabbix Admin.

Just purchased the e-book: lots of useful information about advanced Zabbix configurations and scenarios, mostly not covered by official documentation. Great work!

Many positive feedback are also coming by e-mail and this website.

Tags: , , , , , , ,

admin on December 27th, 2013

I am pleased to announce that my new book “Mastering Zabbix” book is now published and available from all the major distributors.

You can find the book on Packt Publishing web site, amazon.comamazon.co.ukamazon.itamazon.deBarnes&Nobles,  O’Reilly and Safari Books Online!

admin on November 30th, 2013

It’s time to unveil the cover of an in interesting upcoming book.

I am pleased to announce that a new Zabbix mastering book is available in preorder from all the major distributors.
I wrote this book together with Stefano Kewan Lee. This is just an heads up more details will follow!

The book is available for preorder on Packt Publishing web site, amazon.com, amazon.co.uk, amazon.itamazon.deBarnes&Nobles and soon at O’Reilly and Safari Books Online!

Tags: , ,