[kolla] questions when using external mysql
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.... 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 . ################ ## 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 : 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) 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 !
On Tue, 1 Sep 2020 at 15:48, sosogh <sosogh@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... .
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 !
Hi Mark:
Hi, could you start by telling us which version or branch of Kolla Ansible you are using?
root@ubt-1804:~# pip show kolla-ansible Name: kolla-ansible Version: 10.1.0.dev260 I download them via "git clone" , it is master branch by default . git clone https://github.com/openstack/kolla git clone https://github.com/openstack/kolla-ansible
could you try it out and report back? https://review.opendev.org/749463
I will try it later. 在 2020-09-02 16:35:24，"Mark Goddard" <mark@stackhpc.com> 写道： On Tue, 1 Sep 2020 at 15:48, sosogh <sosogh@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.... 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 !
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 ? IMHO, the blueprint (https://blueprints.launchpad.net/kolla-ansible/+spec/external-mariadb-suppor...) 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@stackhpc.com> 写道： On Tue, 1 Sep 2020 at 15:48, sosogh <sosogh@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.... 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 !
On Thu, 3 Sep 2020 at 05:04, sosogh <sosogh@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-suppor...) 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@stackhpc.com> 写道：
On Tue, 1 Sep 2020 at 15:48, sosogh <sosogh@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... .
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 !
participants (2)
-
Mark Goddard
-
sosogh