[largescale-sig] OpenStack DB Archiver

Belmiro Moreira moreira.belmiro.email.lists at gmail.com
Mon Jul 27 15:10:06 UTC 2020


Arnaud,
thanks for sharing this tool.

On Thu, Jul 16, 2020 at 3:48 PM Arnaud Morin <arnaud.morin at gmail.com> wrote:

> Hello large-scalers!
>
> TLDR: we opensource a tool to help reducing size of databases.
>       See https://github.com/ovh/osarchiver/
>
>
> Few months ago, we released a tool, name osarchiver, which we are using
> on our production environment (at OVH) to help reduce the size of our
> tables in mariadb (or mysql)
>
> In fact, some tables are well know to grow very quickly.
>
> We use it, for example, to clean the OpenStack mistral database from old
> tasks, actions and executions which are older than a year.
>
> Another use case could be to archive some data in another table (e.g. with
> _archived as suffix) if they are 6 months old, and delete this data after
> 1 year.
>
> The source code of this tool is available here:
> https://github.com/ovh/osarchiver/
>
> We were wondering if some other users would be interested in using the
> tool, and maybe move it under the opendev governance?
>
> Feel free to contact us and/or answer this thread.
>
> Cheers,
>
> --
> Arnaud, Pierre-Samuel and OVH team
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200727/4b6347b6/attachment.html>


More information about the openstack-discuss mailing list