[Openstack] [Keystone] Cockroachdb for Keystone Multi-master

Clint Byrum clint at fewbar.com
Fri May 19 20:43:41 UTC 2017

IIRC, Cockroachdb is more or less like Vitess in how it achieves its
scalability. Might be worth considering Vitess, which uses MySQL and
thus would more closely align with the majority of Keystone users that
exist today.


I doubt either one will work without changes to Keystone though.

Excerpts from Adrian Turjak's message of 2017-05-19 10:13:28 +1200:
> Hello fellow OpenStackers,
> For the last while I've been looking at options for multi-region
> multi-master Keystone, as well as multi-master for other services I've
> been developing and one thing that always came up was there aren't many
> truly good options for a true multi-master backend. Recently I've been
> looking at Cockroachdb and while I haven't had the chance to do any
> testing I'm curious if anyone else has looked into it. It sounds like
> the perfect solution, and if it can be proved to be stable enough it
> could solve a lot of problems.
> So, specifically in the realm of Keystone, since we are using sqlalchemy
> we already have Postgresql support, and since Cockroachdb does talk
> Postgres it shouldn't be too hard to back Keystone with it. At that
> stage you have a Keystone DB that could be multi-region, multi-master,
> consistent, and mostly impervious to disaster. Is that not the holy
> grail for a service like Keystone? Combine that with fernet tokens and
> suddenly Keystone becomes a service you can't really kill, and can
> mostly forget about.
> I'm welcome to being called mad, but I am curious if anyone has looked
> at this. I'm likely to do some tests at some stage regarding this,
> because I'm hoping this is the solution I've been hoping to find for
> quite a long time.
> Further reading:
> https://www.cockroachlabs.com/
> https://github.com/cockroachdb/cockroach
> https://www.cockroachlabs.com/docs/build-a-python-app-with-cockroachdb-sqlalchemy.html
> Cheers,
> - Adrian Turjak

More information about the Openstack mailing list