admin on December 5th, 2016

I’m adding more and more functionality to DBforBIX2, this new version has been re-factored again a bit and between the new feature you find:

  • Improved Connection Pooling with Apache DBCP 2.2.
  • The items that can’t be sent are now stored in an  application embedded database

This new persistence layer can be enabled per database so you need to specify:
DB.<DBNAME>.Persistence=TRUE
The only configuration required to make it work is the application parameter:
# Persistence Database Directory
DBforBix.PersistenceDir=./persistentdb/

This will enable DBforBIX to store the item directly in the application embedded database (made with H2).
That said doing a practical example if your Zabbix server is, for some reason, unavailable the item acquired from the monitored DBs will be stored in the application embedded database.
I’ve decided to move all the persistence in a database because of the high number of items that are getting saved in your file system. Simply to me wasn’t elegant nor the ideal solution.
This solution drastically reduce the number of files saved in your disk.

The project is hosted here: https://github.com/smartmarmot/DBforBIX.

I’m also updating the configuration you can find here: http://www.smartmarmot.com/wiki/index.php?title=DBforBIX2
DBforBIX

B04239%20_MockupCover_Normal[1]Zabbix_Network_Monitoring3491OS_Mastering%20Zabbix[1]

Tags: , , , , ,

admin on November 7th, 2016

I’m adding more and more functionality to DBforBIX2, this new version has been re-factored again a bit and between the new feature you find:

  • Zabbix JSON protocol now back in the trunk, with multi-item supported.
  • Brand new set of library adopted in order to update the project with the last version of:
    • Apache DBCP2
    • Apache Common
    • Apache Codec
    • Apache Lang3
    • Common Pool2
  • Persistent Stack

Let me spend some words about the Persistence, this can be enabled per database so you need to specify:
DB.<DBNAME>.Persistence=TRUE

This will enable DBforBIX to store the item directly on the file-system, for persistence. So doing a practical example if your Zabbix server is, for some reason, unavailable the item acquired from the DB will be stored on the filesystem. Currently this is an experimental feature, not deeply tested and then not production ready. Anyway as best practice since the number collected can quickly grown on the filesystem is better to enable this feature ONLY for the critical databases. That said the item will be now stored on /opt/dbforbix/temp directory, as soon as the Zabbix is back available all the item stored there will be sent and removed from the filesystem.
The main pros of this solution are:

  1. the number of itmes can quickly grown for a long downtime of the server.
  2. the is no way at the moment to specify a different location for this temporary persistent stack

When I have a bit more time I’ll move the persistence in an internal database in order to avoid the high number of files generated when Zabbix is not accessible.

The project is hosted here: https://github.com/smartmarmot/DBforBIX.

I’m also updating the configuration you can find here: http://www.smartmarmot.com/wiki/index.php?title=DBforBIX2
DBforBIX

B04239%20_MockupCover_Normal[1]Zabbix_Network_Monitoring3491OS_Mastering%20Zabbix[1]

 

admin on October 22nd, 2016

It’s been a long time since my last software publication, anyhow I’m here with a brand new release.
Please note that this release is not compatible with the previous one and must be considered as a BETA.
I’ve done a lot of refactoring and coding, now the code is more elegant and more maintainable. Also I’ve moved the query files to xml with quite a few improvements. Now is finally possible retrieve all the multi column items and the multi row query in an elegant way.
Just to provide an example the query that follow here extract all the fileds and send them as Zabbix items:

<query time=“600” item=maxcount[%1]>SELECT name,value FROM v$parameter WHERE name IN (‘processes’,’sessions’)</query>

Is going to generate the items oracle.maxcount[processes] and oracle.maxcount[sessions] with a single query.
Now is also more readable the period between one sample and the other one in this example every 600 seconds you’ll have your item refreshed (as specified with time=”600″).
I’ve also moved all the code to GitHub, in order to simplify the maintenance and collaboration.
The project is hosted here: https://github.com/smartmarmot/DBforBIX.
In the next days I’ll update the documentation, most likely I’ll add, for consistency, a proper wiki to github.
Enjoy!
DBforBIX

B04239%20_MockupCover_Normal[1]Zabbix_Network_Monitoring3491OS_Mastering%20Zabbix[1]

 

Tags: , ,

I am very pleased to announce you that the book Mastering Zabbix – Second Edition has been selected by the DMK Press to be translated in Russian.
The book is already available in pre-order directly on the DMK Press web site

9e67e3b9-2b78-4cb2-8a9b-70e1b42c587c-large1

Tags: , , ,

admin on February 5th, 2016

I recently had an email exchange with PacktPublishing and I’m glad to let you know that the outcome was the following:

…we could provide your readers a discount of 50% on the eBooks you wrote…

That said why don’t take advantage of this interesting offer using the following links:

 

B04239%20_MockupCover_Normal[1]Zabbix_Network_Monitoring3491OS_Mastering%20Zabbix[1]

Please note that the 50% discount is on the purchase of either 1 eBook, 2 eBooks and/or 3 eBooks together.

Please remember to use the promotion code “SAYO50y” shown in the below banner!!!

Banner_Zabbix_50_off

 

 

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this. To know all the policy detais click here.

Close