On Mon, Jun 4, 2012 at 7:54 PM, Denmat <tu2bg...@gmail.com> wrote: > You should checkout puppetdb which currently locks you into PostgreSQL. > > Docs here: > http://docs.puppetlabs.com/#puppetdbpuppetdb09 > > It's new so may be buggy - though I haven't seen any reports on this > (haven't looked ;) ) > > Indeed, it's targeted specifically at fact and catalog storage. You can set it up solely as an inventory service backend, if you like...in that event, it'll deal just with fact storage. If I'm following this thread correctly, akaroot is trying to store just facts for 30k at a 30m interval per host? 30k hosts is a lot, but PuppetDB does a number of different things than the built-in inventory service backend that may help:
* The SQL and the schema are more explicitly targeting speed * We front DB operations with queues to prevent exhaustion of connections or I/O bandwidth (# of workers is configurable) * We automatically handle DB failures through built-in retry mechanisms (with exponential backoff) You'll need to use PostgreSQL, though. 30k hosts at a 30m runinterval will require some tuning of both PuppetDB and the database, surely...that's around 17 sets of facts every second, which is a lot. Roughly how many facts per node are we talking about, here? I could try running some simulations and see what happens. deepak > Den > > On 05/06/2012, at 4:05, akaroot <mykolaakar...@gmail.com> wrote: > > > Hi! > > Which database would you recommend to use mysql or postgresql for > > puppet? > > Estimated number of nodes 30000, they send reports every 30 minutes. > > Thanks > > > > -- > > You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > > To post to this group, send email to puppet-users@googlegroups.com. > > To unsubscribe from this group, send email to > puppet-users+unsubscr...@googlegroups.com. > > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > > -- Deepak Giridharagopal / Puppet Labs / [irc,twitter] grim_radical -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
