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. _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
