On 5/26/2017 12:42 PM, Alfredo Moralejo Alonso wrote:
According to
https://docs.openstack.org/developer/nova/cells.html#first-time-setup
you can specify database connection string with map_cell0 command:
nova-manage cell_v2 map_cell0 --database_connection \
mysql+pymysql://root:secretmysql@dbserver/nova_cell0?charset=utf8
Regards,
Alfredo
On Fri, May 26, 2017 at 5:15 PM, Massimo Sgaravatto
<massimo.sgarava...@gmail.com> wrote:
Thanks
I guess you meant "nova db with cell0 appended" and not "nova_api db with
cell0 appended" as you wrote
My use case is that I share the same percona cluster to host the databases
of multiple openstack installations. So if it is <nova-database-name>-cell0
this is fine. If instead it is hard-coded to nova-cell0, we have a problem
Thanks again, Massimo
2017-05-26 17:04 GMT+02:00 Mike Lowe <joml...@iu.edu>:
The whole cell thing tripped me up earlier this week. From what I
understand it’s hard coded in the upgrade scripts to be the same as the
nova_api db with cell0 appended to the db name but there is a patch in to
change this behavior to match what the install docs say. So it looks like
if you just put the nova_cell0 db on the same host and make the credentials
match your nova db everything will just work out. You can double check by
looking at the cell_mapping table entries in your nova_api db.
On May 26, 2017, at 10:56 AM, Massimo Sgaravatto
<massimo.sgarava...@gmail.com> wrote:
Hi
I am reading the RDO installation guide for Ocata. In the nova section [*]
it is explained how to create the nova_cell0 database, but I can't find how
to set the relevant connection string in the nova configuration file.
Any hints ?
Thanks, Massimo
[*]
https://docs.openstack.org/ocata/install-guide-rdo/nova-controller-install.html
_______________________________________________
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
_______________________________________________
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
_______________________________________________
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
See:
http://lists.openstack.org/pipermail/openstack-operators/2017-May/013565.html
nova-manage cell_v2 simple_cell_setup and nova-manage cell_v2 map_cell0
would originally default the cell0 DB name in the connection URL to be
<api db name>_cell0, which for most was nova_api_cell0. That was wrong,
and fixed in ocata and backported and merged to newton this week, and in
the proposed newton release mentioned in that email above.
^ was if you didn't override this auto-behavior by passing the
connection URL in on the command line. So that's one workaround.
In the end, what we expect is your cell0 db name to be nova_cell0 and
the cell_mappings.database_connection entry in the nova_api database
says the same.
Remember that cells v2 is optional in newton and required in ocata. It'd
be cool to prepare in newton while it's optional but just a heads up
that unless you pick up that fix you need to pass the database
connection URL in on the command line when running the map_cell0 command.
The various commands are also documented here:
https://docs.openstack.org/developer/nova/man/nova-manage.html#nova-cells-v2
Note that not all of these are in newton.
--
Thanks,
Matt
_______________________________________________
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
