[Openstack] Using Foreign Keys

Andrew Hutchings andrew at linuxjedi.co.uk
Wed Apr 25 11:38:20 UTC 2012


On 12/04/12 13:35, J. Daniel Schmidt wrote:
> While testing our SUSE OpenStack packages we hit a nasty bug and reported it 
> as:  https://bugs.launchpad.net/keystone/+bug/972502
> 
> We found out that the underlying cause was a lack of referential integrity[1] 
> using sqlite or mysql. When we tried to reproduce this issue on postgresql the 
> usage of foreign keys greatly helped to find the cause.

>From a MySQL prospective that is probably more of an argument to use
transactions, not foreign keys.

Kind Regards
-- 
Andrew Hutchings - LinuxJedi - http://www.linuxjedi.co.uk/




More information about the Openstack mailing list