Forum: Managing VoltDB

Post: Monitoring in Community Edition

Monitoring in Community Edition
radek1st
Aug 10, 2012
Hi,

I'm interested in getting the performance statistics of the db like transactions/s, latency and memory usage (ideally through REST API). I can see the statistics using the Studio, but is there a way I could get it programmatically? Possibly do it the same as the Studio does it (does it use some private API?). I know there is a Manager in a paid for edition, but I'm interested in a Community Edition.

BTW, I have the db set up with username and password, but I can access it without providing the credentials going directly to http://host:8080/studio/. This is a possible security issue.

Cheers,
Radek
Hi, Volt has an extensive
awilson
Aug 10, 2012
Hi,

Volt has an extensive list of system procedures ( http://community.voltdb.com/docs/UsingVoltDB/AppSysProc ) that should provide you with all the statistics you are looking for. Pay particular attention to @Statistics, @SystemInformation and @SystemCatalog.

One comment about latency is that it is best calculated from a client rather than through system procs and their execution times. You'll want to factor in the quality of the network and client machine rather than just relying on the cluster execution times. The examples/voter/AsyncClient.java is a good example of how to calculate meaningful latency.

Thanks,
Andy
There are two management
awilson
Aug 10, 2012
There are two management guides related to security. One is for VEM and the other is just general management.

The section in the general user's guide is at http://community.voltdb.com/docs/UsingVoltDB/ChapSecurity and describes how to setup more generic security.

The VEM security settings are found here: http://community.voltdb.com/docs/MgtGuide/SetUpChap
It should cover everything you are looking for.

Thanks,
Andy
Thanks Andy
radek1st
Aug 10, 2012
There are two management guides related to security. One is for VEM and the other is just general management.

The section in the general user's guide is at http://community.voltdb.com/docs/UsingVoltDB/ChapSecurity and describes how to setup more generic security.

The VEM security settings are found here: http://community.voltdb.com/docs/MgtGuide/SetUpChap
It should cover everything you are looking for.

Thanks,
Andy


Thanks a lot Andy!

Radek