Can the container and account SQLite databases be migrated to MySQL?

Asked by Sree Bhaskar on 2013-11-13

Since most of the modules on OpenStack use MySQL, is there a way to migrate the SQLite databases (account and container server files) to MySQL? Has anyone tried this out and is this a supported configuration?

Thanks
Sree

Question information

Language:
English Edit question
Status:
Answered
For:
OpenStack Object Storage (swift) Edit question
Assignee:
No assignee Edit question
Last query:
2013-11-13
Last reply:
2014-03-19
Samuel Merritt (torgomatic) said : #1

With SQLite, each account and container DB replica is its own file, which is critical for availability during storage-node failure and also critical for replication. There's no way to switch that out for another SQL database, nor will there be.

Shri Javadekar (shrinand) said : #2

The Red Hat Openstack documentation suggests that they use MySQL [1]. Is that a typo? Can someone confirm either way?

-Shri

[1] https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Linux_OpenStack_Platform/2/html/Release_Notes/sect-OpenStackNotes-Intro_Chapter-Test_Section_5-swift.html

Samuel Merritt (torgomatic) said : #3

Maybe other stuff uses MySQL, but Swift does not. That document is wrong.

Can you help with this problem?

Provide an answer of your own, or ask Sree Bhaskar for more information if necessary.

To post a message you must log in.