PuppetDB database tunning

[shell heriyanto]

Hi,

I've been use puppetdb about 6 months ago, and now the database more than 6gigs

Is that any way to "recycle" database? the data on database more than 30days

removed, I try to find is that any option in puppetDB so far, or we need to tune from database side(i use postgresql)?

Thanks for any comment.

Best regards,

Heriyanto

[Klavs Klavsen]

http://docs.puppetlabs.com/puppetdb/1.3/maintain_and_tune.html

[shell heriyanto]

This what i'am find, thank you Klavs.

--
You received this message because you are subscribed to the Google Groups "Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users...@googlegroups.com.
To post to this group, send email to puppet...@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[shell heriyanto]

no efect, this my configuration:

gc-interval = 60

node-ttl = 30m

node-purge-ttl = 30m

report-ttl = 30m

I make ttl fast to see the change but still, my database still grow bigger. Its need to remove the database fast and create again, to make this work?

how ttl work? is it just count when we do add the option, so the older database still save?

thanks for any comment.

[Ken Barber]

What kind of database is this? Postgresql or the built-in HSQLDB? And
- how are you calculating the database size?

[shell heriyanto]

Hi Ken thanks for your reply,

We using Postgresql, we just have about 150 puppet agent, and for 130 agent its just run once per day, every day its take about 150MB. 

We using puppetDB 1.1.0. I will try to update puppetDB today.

[shell heriyanto]

Already update to 1.3.1, the old database still there. Theres script for remove it via postgres script or puppet stanza to clean this such as after 30days old?