Open Stack

Excerpts from Matthew Mosesohn's message of 2014-02-20 16:03:44 +0000:
> Hi Stackers,
> 
> I'm curious to find out if we have anyone already using pt-archiver to
> purge Keystone tokens in MySQL + Galera in production under heavy load with
> Galera in multi-master mode. I'm referring to the tripleo script that uses
> pt-archiver to clean up keystone tokens here:
> https://github.com/openstack/tripleo-image-elements/blob/master/elements/keystone/cleanup-keystone-tokens.sh
> 
> I have two questions:
> Does this need to be run on every Galera host or just against one?
> Second, does it have any major impact on production? What is the likelihood
> of causing issues with API DB transactions while pt-archiver is purging
> keystone tokens table?
> 

It just need to be run "somewhere".

The script does 500 row transactions, which should prevent long locks
slowing down writes to the gaps between the ids and I think will lessen
the liklihood of any commit failures.