On Tue, Jun 5, 2012 at 12:07 AM, Gary Larizza <g...@puppetlabs.com> wrote: > On Mon, Jun 4, 2012 at 8:48 PM, Brian Gupta <brian.gu...@brandorr.com> wrote: >> On Mon, Jun 4, 2012 at 11:19 PM, Gary Larizza <g...@puppetlabs.com> wrote: >>> On Mon, Jun 4, 2012 at 7:54 PM, Denmat <tu2bg...@gmail.com> wrote: >>>> Hi, >>>> >>>> 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 ;) ) >>> >>> PuppetDB will store Inventory Data as well as exported resources and >>> catalog data (from Puppet itself), but it will not store reports from >>> the Puppet Dashboard. To do that, the Puppet Dashboard requires a >>> MySQL database backend. It doesn't CURRENTLY support Postgres, though >>> I suspect that will change in the future. >> >> Gary, >> >> Assuming we are just talking about report stores, Akaroot is looking >> at storing 60,000 reports per hour. Can a single storeconfigs MySQL >> instance handle that? (That's 1000 reports per minute.) >> > > Just to correct the terminology - storeconfigs refers to the act of > storing resources that have been exported from nodes, as well as > storing your inventory data (Facter facts). There's documentation > here that should help --> > http://docs.puppetlabs.com/guides/inventory_service.html With > storeconfigs, it's information that can be pulled from within a Puppet > run. > > Reports, on the other hand, contain information on transactional > events FROM a Puppet run. Reports are stored in the Puppet Dashboard, > which is a separate database (Storeconfigs uses one database - > potentially PuppetDB, Dashboard uses another database. Storeconfigs > can be MySQL or Postgres but the database backend for the Dashboard > must be MySQL). > > As for handling 1000 reports per minute, it's up to how you tune your > MySQL setup. Puppet is going to send reports to your database > 'server' (credentials are provided in puppet.conf, so it could be a > VIP based on what you're doing on the backend). I'll let others with > better experience in that area comment on what they've seen in > production.
Thanks Gary for clarifying. My apologies, it's late here. > > >> Thanks, >> Brian >> >>>> >>>> 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. >>>> >>> >>> >>> >>> -- >>> >>> Gary Larizza >>> Professional Services Engineer >>> Puppet Labs >>> >>> -- >>> 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. >> > > > > -- > > Gary Larizza > Professional Services Engineer > Puppet Labs > > -- > 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.