--- # Copyright 2015, Rackspace US, Inc. # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. - name: Create DB for service mysql_db: login_user: "root" login_password: "secrete" login_host: "127.0.0.1" name: "{{ db_name }}" state: "present" delegate_to: "{{ groups['galera_all'][0] }}" run_once: True no_log: true - name: Grant access to the DB for the service mysql_user: login_user: "root" login_password: "secrete" login_host: "127.0.0.1" name: "{{ db_user | default(db_name) }}" password: "{{ db_password }}" host: "{{ item }}" state: "present" priv: "{{ db_name }}.*:ALL" append_privs: "{{ db_append_privs | default(omit) }}" with_items: - "localhost" - "%" delegate_to: "{{ groups['galera_all'][0] }}" run_once: True no_log: true