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 🙂
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: dbforbix, linkedin, Mastering Zabbix, MySQLBix, orabbix, oracle, postgresql, zabbix
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.com, amazon.co.uk, amazon.it, amazon.de, Barnes&Nobles, O’Reilly and Safari Books Online!
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.it, amazon.de, Barnes&Nobles and soon at O’Reilly and Safari Books Online!
It seem that svn on sourceforge had an issue, and all my project are reverted to an older snapshot, a quite old snapshot to be honest…
Anyway to enable everyone to easily download the source code I have added a link on the download page.
This should respond to all the source code request that I received lately.
