aboutsummaryrefslogtreecommitdiff
path: root/ansible/roles/mariadb
AgeCommit message (Collapse)AuthorFilesLines
2016-11-15Remove Ansible from KollaSteven Dake19-559/+0
Change-Id: I5396e4b9927d3e65b6aa4185238a43a4765a996b
2016-11-14Use check_mode no instead of always_runJeffrey Zhang2-8/+8
Change-Id: If42f9ec1a2371982a47f7fe8269fe39d65c599cf Closes-Bug: #1640247
2016-11-06Merge "Mariadb performance tuning"Jenkins1-0/+10
2016-11-03Move precheck into its own roleJeffrey Zhang1-0/+1
* Merge prechecks.yml and site.yml playbook * Create empty precheck.yml into all roles. Change-Id: I8a138558a26c0a2a66c5fd48ed37be657c99c1dd Implements: blueprint condition-pre-check
2016-10-24Mariadb performance tuningMathias Ewald1-0/+10
Change-Id: Ic2b44de0ce8e8090318380a0fed3ff1bd51dc791 Closes-Bug: #1633178
2016-10-21Merge "Update the upgrade.yml for mariadb roles"Jenkins2-5/+1
2016-10-14Fix mariadb upgrade permission issuezhubingbing1-0/+12
Change-Id: I356d41d030365b7b4f917b1334f9f68e560b7512 Co-Authored-By: Michal (inc0) Jastrzebski <inc007@gmail.com> Partial-Bug: #1631503
2016-10-13Merge "Remove do_reconfigure.yml file for all roles"Jenkins2-68/+65
2016-10-09Choose node with largest seqno number for mariadb recoveryJeffrey Zhang2-1/+57
When all mariadb nodes are stopped gracefully, mariadb galera will write it's last executed position into the grastate.dat file. Need find the node with largest seqno number in that file and recovery from that node. Closes-Bug: #1627717 Change-Id: I6e97c190eec99c966bffde0698f783e519ba14bd
2016-10-02Update the upgrade.yml for mariadb rolescaoyuan2-5/+1
beacause upgrade is not required to recreate the database TrivialFix Change-Id: I50bbb1592dd1fd5262642077bbe3d9bd32503033
2016-09-27Remove do_reconfigure.yml file for all rolesJeffrey Zhang2-68/+65
do_reconfigure.yml is introduced to use serial directive. But we use it in wrong. Now serial has moved to playbook file. So it is time to remove the do_reconfigure.yml file Closes-Bug: #1628152 Change-Id: I8d42d27e6bc302a0e575b0353956eaef9b2ca9fd
2016-09-14Merge "Change Mariadb default character set to utf8"Jenkins1-0/+10
2016-09-14Change Mariadb default character set to utf8Jeffrey Zhang1-0/+10
Closes-Bug: #1623307 Change-Id: I364a8345872ae3b0a7ff684edfe9ff0e22f2c26c Signed-off-by: Jeffrey Zhang <zhang.lei.fly@gmail.com>
2016-09-13Merge "Fix permissions of tmp files"Jenkins1-2/+2
2016-09-13Fix permissions of tmp filesChristian Berendt1-2/+2
When running kolla-ansible as non-root users the tmp files will be created with become user as owner and mode 0600. This way the user running kolla-ansible is not able to read the generated files. This is necessary because of the use of the lookup method, which will not run as become user. TrivialFix Change-Id: If86d114c05a9b2e7fa240718611d78e93100ebdf
2016-09-13Added serial option to site.yml.Mick Thompson2-2/+0
Useful for upgrade etc., which is preferablly done serially. Example usage: tools/kolla-ansible deploy OR tools/kolla-ansible upgrade Closes-Bug: #1576708 DocImpact Change-Id: I34b2e16f8ce53e472a4682a4738c4ac0f5abf00c
2016-08-09Port with_ loop variable syntax to Ansbile 2Duong Ha-Quang1-4/+4
Migrate to full variable syntax in with_ loop instead of bare variables for: - ceph - ceilometer - glance - heat - horizon - keystone - mariadb - memcached - neutron - nova - rabbitmq Change-Id: Ib925b4ecea47ac758a77739c9c7e140f06933b08 Partial-Implements: blueprint ansible2
2016-07-28Enable kolla k8s to override bind api bind address in genconfigMichal (inc0) Jastrzebski2-6/+11
It's good if k8s reuses ansible templates, but we need to abstract all ansible specific variables to achieve that. - Implements ansible override variable api_interface_address. - Adds api_interface_address setting and comments to globals.yml - Makes changes to mariadb templates to accept this new setting. - Disabled Galera when api_interface_address==0.0.0.0 in the case of Kubernetes. Otherwise, mariadb fails to start. - Tested with and without setting to ensure kolla genconfig output does not change when setting is disabled or undefined. Change-Id: Ia0e4951c327be01b717aebb86ef4c3a4e7ed170e Partially-implements: blueprint api-interface-bind-address-override Co-authored-by: David Wang <dcwangmit01@gmail.com> Co-authored-by: Ryan Hallisey <rhallise@redhat.com> Co-authored-by: Kevin Fox <kevin@efox.cc>
2016-06-06Config files having underscores breaks Kolla-Kubernetes.Ken Wronkiewicz4-6/+6
I just thought I'd dash off a quick patch and change the underscore to a dash. Change-Id: Ib34cfc8039de01be7e37176648482f9815ac3848 Closes-Bug: #1589734
2016-06-03Enable HAProxy consider MariaDB wsrep_local_stateEttore Simone4-0/+89
This patch enable wsrep_notify_cmd to rename haproxy user in haproxy_blocked when the node is not ready to serve and restore it when ready. Change-Id: I4f49960d7ff2fa689d6ea730b2574f16f083edc1 Closes-Bug: 1578752 Closes-Bug: 1587752
2016-05-26Merge "Bump the ansible to 2"Jenkins1-0/+6
2016-05-26Merge "add support for non-default database_port in kolla/ansible"Jenkins1-1/+1
2016-05-24Bump the ansible to 2Jeffrey Zhang1-0/+6
DocImpact Change-Id: I3cdfbf84919de80f535c030bd146787ecda40dec partial-Implements: blueprint ansible2
2016-05-23Make configurable the location where config files are mergedRyan Hallisey1-2/+2
An operator may want to specify the location of custom config files so that kolla can detect their location and merge them with the default configs generated. Partially implements: blueprint multi-project-config Change-Id: Ibfb38d07a36dfa7fe25381adc34cc1d3cbe7d1e1
2016-05-13add support for non-default database_port in kolla/ansibleWaldemar Znoinski1-1/+1
This change makes each step of the kolla deployment aware of the port database was configured to listen on. It defaults mariadb_port to database_port. Change-Id: I8e85d5732015afc0a5481cb33e0b629fdfa84a1b Closes-Bug: #1576151 DocImpact
2016-05-03map the host localtime to the containerJeffrey Zhang3-0/+4
Closes-Bug: #1577148 Change-Id: I636cefc63cf532434a41af3898b63dffa711e280
2016-04-11Revert "Add general_log to mariadb container and make heka collect it"Vikram Hosakote1-3/+1
This reverts commit 86bafeee7a8926d212e8d089fade667772dbcc83. Closes-Bug: #1568670 Change-Id: I88563292e29d691c27a3640e5232b9f22c7a288a
2016-04-05Change waiting on mariadb.pidSteven Dake1-9/+6
Previously the code looked at mariadb.pid, but this seemed flakey in function. It seemed racey and prone to failure on slower connections to a registry. The original task was extremely complex and it didnt really verify that the MariaDB was ready to serve connections. Use wait_for with a regex instead. Change-Id: I3aafac04f03639b08e0ef4d6a9c9e1a4499f000c Closes-Bug: #1564278
2016-04-04Merge "Add general_log to mariadb container and make heka collect it"Jenkins1-1/+3
2016-04-04Add general_log to mariadb container and make heka collect itVikram Hosakote1-1/+3
Added general_log to ansible/roles/mariadb/templates/galera.cnf.j2 to improve mariadb logging. This will be helpful to debug mariadb issues especially when mariadb is scaled. Test results of this patch set are at: http://paste.openstack.org/show/492852/ Change-Id: I80438d1bbdd1ed2a1f47489c6f9c45b8107340a0 Closes-Bug: #1563668
2016-03-31Increase database connections to 10000Steven Dake1-1/+1
Scale limit testing on a 64 node cluster with 13 TB RAM and 2600 cores showed that atleast 1800 database connections are required to appropriately start 2000 virtual machines simulateounsly. Other documentation on the internet recommends larger values such as 8000, so we set to a larger value that should be able to handle a maxed out 512GB ram per compute node cluster with all services enabled. Change-Id: I8767cf3fb04e066cc22e796c647e944b4e4a1742 Closes-Bug: #1564275
2016-03-21Fix mysql bootstrapSamYaple3-15/+21
The lightsout recover patch broke multinode mysql. Also the lightsout recovery didnt probably pass the --wsrep-new-cluster flag. This updates the mariadb bootstrap to work with multinode again. Closes-Bug: #1559480 Related-Id: I903c3bcd069af39814bcabcef37684b1f043391f Change-Id: I1ec91a8b2144930ea8f04cc1c201b53712352e4e
2016-03-18Merge "Allow per node configuration with augments"Jenkins1-0/+1
2016-03-17Allow per node configuration with augmentsSamYaple1-0/+1
This type of per node configuration is required to support things like availability zones for nova. As always, if this file doesnt exist it doesnt get used so this change is safe. TrivialFix Change-Id: Iff8172af522c2c96e5f2c173b24a5dfd4d522ed2
2016-03-17After refactor, the upgrade code was missing taskSamYaple1-0/+2
TrivialFix Change-Id: Ic946c613e5197d988897bd450040a1ea66a60f77
2016-03-17Merge "MariaDB lights out recovery"2.0.0.0rc1Jenkins4-65/+109
2016-03-16Remove commented lineMauricio Lima1-1/+0
TrivialFix Change-Id: Iadeada65248160ac34d917c67dca7954e1b449d2
2016-03-16MariaDB lights out recoverySamYaple4-65/+109
This playbook only matters for multinode since AIO can recover from power outage without additional configuration. DocImpact Implements: blueprint mariadb-lights-out Change-Id: I903c3bcd069af39814bcabcef37684b1f043391f
2016-03-16Mariadb upgradeSamYaple2-0/+11
Minor versions of mariadb upgrade do not require full cluster stop. Full cluster stop will need to be address during the move to 10.1 at some time in the future. Change-Id: Ia048a3fd4d79921f827f3b88c623d26db506bfc3 Partially-Implements: blueprint upgrade-kolla Implements: blueprint upgrade-mariadb
2016-03-09Reconfigure mariadb serviceMauricio Lima3-0/+70
Implements reconfiguring the mariadb service. Change-Id: Ia28b85df10494adeb585fa9352ec7d45f95b8e5e Closes-Bug: #1553524
2016-03-03Bump to latest ansible and depsSamYaple1-1/+2
Ansible is pinned to single commit in devel branch to pull in the latest shade module we need (domain control). It will be available in ansible 2.1 TrivialFix Change-Id: I4c21fa1d2cec30d4aeb80e050ef4a62332f9ed45
2016-02-26Change kolla_internal_address variableSamYaple1-1/+1
Due to poor planning on our variable names we have a situation where we have "internal_address" which must be a VIP, but "external_address" which should be a DNS name. Now with two vips "external_vip_address" is a new variable. This corrects that issue by deprecating kolla_internal_address and replacing it with 4 nicely named variables. kolla_internal_vip_address kolla_internal_fqdn kolla_external_vip_address kolla_external_fqdn The default behaviour will remain the same, and the way the variable inheritance is setup the kolla_internal_address variable can still be set in globals.yml and propogate out to these 4 new variables like it normally would, but all reference to kolla_internal_address has been completely removed. Change-Id: I4556dcdbf4d91a8d2751981ef9c64bad44a719e5 Partially-Implements: blueprint ssl-kolla
2016-02-25Merge "Add the default empty reconfigure.yml file to all roles"Jenkins1-0/+1
2016-02-25Add the default empty reconfigure.yml file to all rolesJeffrey Zhang1-0/+1
DocImpact Partially-implements: bp kolla-reconfig Change-Id: I9738e80960bcfbef18d1ef1b7942f81c45684e85
2016-02-24Merge "Ensuring the Mariadb bootstrap configured properly"Jenkins1-1/+4
2016-02-19Make Heka collect MariaDB logsÉric Lemoine3-0/+4
Partially implements: blueprint heka Change-Id: Ib5e740683cee296bcac69228f525594850d62a27
2016-02-16Make a final check to validate mysql worksSamYaple2-0/+11
This ensures mysql works through whatever the vip is Change-Id: Iaeb17240b90ae2f0fef081b42d4ba140dcecd972 Closes-Bug: #1536633
2016-02-14Ensuring the Mariadb bootstrap configured properlyJeffrey Zhang1-1/+4
Make sure extend_start.sh file run to completion Change-Id: I45f6ab1c7d1b7a21ac92bb5f0e9d82a6c135cb5f Closes-Bug: #1545287
2016-02-02Rename kolla_ansible to kolla_toolboxSamYaple1-1/+1
This change is needed for clarity. We have a kolla-ansible script. We have a kolla-mesos repo. We plan to have a kolla-ansible repo. Already we have had far too much confusion about whether we are talking about the container or the project. Naming this kolla-toolbox eliminates all of that confusion and its probably a bit more accurate of a name too. Closes-Bug: #1541053 Change-Id: I8fd1f49d5a22b36ede5b10f46b9fe02ddda9007e
2016-01-28Update all bootstraps to use LabelSamYaple1-0/+2
Add bootstrap label to all bootstrap containers to ensure that when the a new container is launched a difference is seen between it and the bootstrap container since we cannot rely on ENV variables for this. This only affects mariadb at this stage, but it is needed to ensure rabbitmq works when we switch to named volumes. Change-Id: Ia022af26212d2e5445c06149848831037a508407 Closes-Bug: #1538136