Thank you Christian,

I was just curious as to whether the size of DB was a big issue. Looks
like it isn't from your response and looking at my (limited) usage.

And yes, I'll come up with a suitable backup plan.

Thanks again,
Raghu

On Mar 17, 10:36 pm, Christian Hammond <chip...@chipx86.com> wrote:
> Hi Raghu,
>
> Thanks for the nice words about the project!
>
> Screenshots themselves are stored in your site's
> htdocs/media/uploaded/images/ directory. They're referenced in the database
> but not stored there.
>
> There's no way to archive review requests from the database. I honestly
> don't know how we'd do that cleanly with Django's framework without breaking
> things. What takes up the most space is the stored diffs, not the review
> requests, but again there's no method of archiving these. After 1.0, I'm
> thinking of introducing compression for stored diffs in the database, and
> providing a script to go through and compress all these, which might help a
> little.
>
> Our database at VMware is pretty huge at this point, and we're not hitting
> any issues in the database. Are you just hoping for a space savings?
>
> I recommend using mysqlhotcopy nightly (or whenever) to do a backup of your
> database to a location on the server and ten archiving that. The advantage
> is that you end up with a snapshot of the database without additional writes
> happening during copy. You also want to back up your full site directory
> that you installed into.
>
> Christian
>
> --
> Christian Hammond - chip...@chipx86.com
> Review Board -http://www.review-board.org
> VMware, Inc. -http://www.vmware.com
>
> On Tue, Mar 17, 2009 at 7:34 AM, Raghu <raghu...@gmail.com> wrote:
>
> > First of all let me thank all developers and contributors for this
> > wonderful project. I have been using Reviewboard for the past couple
> > of months in my organization and found this extremely useful. This is
> > a great improvement over an internal tool that we had that helped in
> > generating pretty html diffs, but nothing more.
>
> > By the way I had few questions on the storage side.
>
> > 1. Are the screenshots stored in DB?
> > 2. How can I archive old review requests from the DB? Obviously after
> > few months my DB will grow and I may want to archive old review
> > requests from the DB and restore them later. Is there a way to do
> > this?
>
> > Thanks,
> > Raghu
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To post to this group, send email to reviewboard@googlegroups.com
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to