Reply:Re: [kolla] questions when using external mysql

Mark Goddard mark at stackhpc.com
Thu Sep 3 07:33:56 UTC 2020


On Thu, 3 Sep 2020 at 05:04, sosogh <sosogh at 126.com> wrote:

> Hi Mark :
>
> I have read further on external-mariadb-guide.html .
>
> if setting  "use_preconfigured_databases = yes" and  and
> "use_common_mariadb_user = yes " ,
> people has to create the " new fresh " DB (nova , glance ,keystone etc)
> manually  .
> the more openstack serivces  enabled , the more databases have to be
> created .
> so why people will want to create the " new fresh " DB manually  rather
> than letting kolla-ansible to do it ?
> what would be this case ?
>

The use case is where the DBMS is entirely managed outside of Kolla
Ansible, and the DB user does not have privileges required to create a
database. If you set use_preconfigured_databases to no (the default), Kolla
Ansible will create the necessary databases.

>
> IMHO, the blueprint (
> https://blueprints.launchpad.net/kolla-ansible/+spec/external-mariadb-support)
> maybe more likely to be:
> people create ready-to-use mysql account , and apply  the mysql
> address/account  to  kolla-ansible ,
> then kolla-ansible use  it as  a common user across databases
>
>
>
> 在 2020-09-02 16:35:24,"Mark Goddard" <mark at stackhpc.com> 写道:
>
>
>
> On Tue, 1 Sep 2020 at 15:48, sosogh <sosogh at 126.com> wrote:
>
>> Hi list:
>>
>> I want to use kolla-ansible to deploy openstack , but using external
>> mysql.
>> I am following these docs:
>>
>> https://docs.openstack.org/kolla-ansible/latest/user/quickstart.html
>>
>>
>> https://docs.openstack.org/kolla-ansible/latest/reference/databases/external-mariadb-guide.html
>> .
>>
>
> Hi, could you start by telling us which version or branch of Kolla Ansible
> you are using?
>
>>
>> I have some questions:
>>
>> ################
>> ##  Question 1 ##
>> ################
>>
>>  According to the offical doc , if setting it  in inventory
>> file(multinode),
>>
>>
>> kolla-ansible -i ./multinode deploy will throw out error:
>>
>>
>> I guest when kolla-ansible running the playbook against
>> myexternalmariadbloadbalancer.com ,
>>
>> the """register: find_custom_fluentd_inputs""" in """TASK [common : Find
>> custom fluentd input config files]"""  maybe null .
>>
>
> I think this could be an issue with a recent change to the common role,
> where the condition for the 'Find custom fluentd input config files' task
> changed slightly. I have proposed a potential fix for this, could you try
> it out and report back? https://review.opendev.org/749463
>
>>
>> ################
>> ##  Question 2 ##
>> ################
>>
>>  According to the offical doc , If the MariaDB username is not root, set
>> database_username in /etc/kolla/globals.yml file:
>>
>>
>> But in kolla-ansible/ansible/roles/xxxxxx/tasks/bootstrap.yml  , they
>> use  ''' login_user: "{{ database_user }}"  ''' , for example :
>>
>> You are correct, this is an issue in the documentation. I have proposed a
> fix here: https://review.opendev.org/749464
>
>
>> So at last  , I took the following steps:
>> 1. """not""" setting [mariadb] in inventory file(multinode)
>> 2. set "database_user: openstack" for  "privillegeduser"
>>
>> PS:
>> My idea is that if using an external ready-to-use mysql (cluster),
>> it is enough to tell kolla-ansible only the address/user/password of the
>> external DB.
>> i.e. setting them in the file /etc/kolla/globals.yml and passwords.yml ,
>> no need to add it into inventory file(multinode)
>>
>
> I agree, I did not expect to need to change the inventory for this use
> case.
>
>>
>> Finally , it is successful to  deploy openstack via kolla-ansible .
>> So far I have not found any problems.
>>  Are the steps what I took  good ( enough ) ?
>> Thank you !
>>
>>
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/f3b8e3ab/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 2938 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/f3b8e3ab/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 95768 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/f3b8e3ab/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 2508 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/f3b8e3ab/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 22016 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200903/f3b8e3ab/attachment-0007.png>


More information about the openstack-discuss mailing list