| *** cliles has quit IRC | 02:54 | |
| *** resmo has joined #ara | 07:25 | |
| *** resmo has quit IRC | 07:27 | |
| *** openstackgerrit has quit IRC | 08:17 | |
| *** tbielawa has joined #ara | 12:34 | |
| *** sgr has joined #ara | 13:51 | |
| sgr | hello! is anybody familiar with ARA and multiple ansible clients? (a centralized mysql database) | 13:54 |
|---|---|---|
| dmsimard | sgr: o/ | 13:55 |
| dmsimard | Ironically I've been wanting to stand up something like that myself but unfortunately haven't got around to it yet. I can surely help though, and I know of a particular user that does this at scale | 13:55 |
| *** tbielawa is now known as tbielawa|mtg | 13:58 | |
| sgr | It looks like the database is not multi-user aware. the "alembic_version" entry will be overwritten. the other clients receive an exeption: Can't locate revision identified by 'xyz123' | 13:59 |
| dmsimard | Ah, yes, there is a configuration parameter to disable automatic SQL migrations, hang on | 14:03 |
| dmsimard | Turns out it's missing from the documentation (oops) but it's definitely here: https://github.com/openstack/ara/blob/eb171f195fcdd80071d39f4538ea91438fbf801e/ara/config.py#L95 | 14:04 |
| dmsimard | It defaults to true, so you'll want to set it to false | 14:04 |
| dmsimard | either through the env var ARA_AUTOCREATE_DATABASE or autocreate_database under the [ara] block of your ansible.cfg file | 14:04 |
| dmsimard | That will disable automatic database creation and migration so you'll need to do them manually as required -- but that shouldn't be much of an issue because there's no SQL migrations after 0.14.0. | 14:06 |
| dmsimard | The next major release (1.0) is shipping with a significant schema refactor and there is no migration path from a <1.0 database schema to >=1.0 | 14:07 |
| dmsimard | sgr: ^ | 14:11 |
| sgr | yay! thanks for your input. its working now! gracias! | 14:18 |
| dmsimard | sgr: yay, let us know if there's anything else -- and do make note of that 1.0 caveat | 14:19 |
| dmsimard | It mostly means you'll have to start your database from scratch, but otherwise it will work | 14:20 |
| *** tbielawa|mtg is now known as tbielawa|d3m0 | 15:00 | |
| *** sebiwi has joined #ara | 15:24 | |
| *** tbielawa|d3m0 is now known as tbielawa | 15:51 | |
| *** tbielawa is now known as tbielawa|lunch | 15:51 | |
| *** sebiwi has quit IRC | 15:55 | |
| *** sshnaidm is now known as sshnaidm|off | 17:09 | |
| *** tbielawa|lunch is now known as tbielawa | 17:11 | |
| *** themurph has quit IRC | 17:31 | |
| *** themurph has joined #ara | 17:32 | |
| *** themurph has quit IRC | 21:15 | |
| *** tbielawa has quit IRC | 22:32 | |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!