Commit Graph

49 Commits (master)

Author SHA1 Message Date
Emilien Mantel fe7d09b9cd 💥 Add newer method to setup upstream packages 2022-02-28 10:14:36 +01:00
Emilien M 2089f8eade
New release (#44)
* Manages MariaDB 10.6 + Debian 11
* Fix YAML lint
* Fix ansible lint
* Modernize TravisCI
* Fix service name depending OS version
* Add rsyslog on tests
* Remove useless variable in tests
* Use module mysql_replication instead of command for GTID setup
* Force 'mariadb' as service name if install from upstream
* Rename group vars file and valid YAML lint
* Galera install imrovements
* Do not force galera package name ('galera-3' was hardcoded)
* Prevent some crashes when galera is installed with mariadb at the same
time
* Install galera-3 on Buster + MariaDB from Debian repository
* Use FQDN Ansible modules
2021-09-02 18:17:54 +02:00
Emilien Mantel 860b212ee0 Hide sensitive data - #43 related
- Add new variable (default: false) to enable debugging (show sensitive
data)
- Set true when working with Vagrant
2021-09-01 12:24:40 +02:00
Emilien Mantel ab76aa019d Reemove thread_concurrency config (deprecated) 2020-01-06 18:40:15 +01:00
Emilien M 0b4983e090
Full buster optim (#38)
* Remove Stretch and Percona support
* Delete root password management (On Buster, it uses socket auth)
* Fix sync backups files master -> slave
* Cleanup legacy code on replication slave
* Use modern configuration
* Debian buster configuration style
* Drop logrotate management (useless)
* Add new default values in defaults/main.yml (according with MariaDB doc)
* Travis with Ansible 2.8+
* Drop feature "don't replicate mysql database"
* Fully compatible with python3
2019-12-28 19:02:41 +01:00
Emilien M dac586acbe
Support Debian Buster (#34) 2019-08-07 17:41:45 +02:00
Emilien M 1ebc0e9391
Few improvements(#33)
* README update
* Remove useless legacy files
* Small refactoring for Galera Cluster
* Modern Ansible
* Some changes on travis + Vagrant
* Help debug: display all facts
* Fix galera config for docker
2019-04-16 13:55:38 +02:00
Clément 8802c6d50d Galera improvements (#28)
* add galera cluster name

* add galera cluster stt method

* disable query cache only when mariadb is 10.0
2018-07-14 11:33:43 +02:00
Emilien Mantel adf9e6074f Update somie comments 2018-03-17 18:47:35 +01:00
Emilien Mantel c72c3ac842 Rename mysql_ -> mariadb_ 2018-03-17 17:28:54 +01:00
Emilien Mantel 859bafdb50 Drop MySQL, Percona Server and Jessie support 2018-03-17 17:05:45 +01:00
Emilien Mantel 589754e618
Improve log management (#27)
* New log management (see #25)

- Add logrotate (as optional feature) setup
- Delete obsolete log management (log + log_slow_queries)

* Change log path
2018-03-08 13:01:34 +01:00
Jasper N. Brouwer d74393a21e Use 5M as innodb_log_file_size for MySQL on Jessie 2017-07-05 21:54:57 +02:00
Jasper N. Brouwer 3535d8b43a Pin MariaDB packages 2017-07-03 16:00:11 +02:00
Jasper N. Brouwer 5977497809 Add variable to specify the my.cnf template 2017-07-03 16:00:11 +02:00
Jasper N. Brouwer 266af48a9b Use ansible_processor_cores to calculate thread_concurrency 2017-07-03 16:00:11 +02:00
Jasper N. Brouwer ef67883ab2 Proper comment on why changing innodb_log_file_size breaks the system 2017-07-03 16:00:11 +02:00
Jasper N. Brouwer e38f706eb1 Add variables for apt key-server and -ids 2017-07-03 15:51:28 +02:00
Jasper N. Brouwer 47be1b60a6 Fix broken link (same link, another file) 2017-07-03 15:51:28 +02:00
Emilien Mantel 2aec278e00 Stretch support
- Support Debian Stretch (MariaDB debian/upstream + Galera)
- Doc updated
- New travis tests (with Vagrant)
- Drop support of mysql_innodb_additional_mem_pool_size
- Xtrabackup optionnal installation + package name updatable
- Fix many issues with replication (Ansible 2.3)
- Auto-retreive master IP address on tests
- MySQL tools per OS release
2017-06-28 16:23:15 +02:00
Emilien Mantel 0f1d2bcdcf Auto install percona apt repos if needed 2017-06-01 15:56:08 +02:00
Emilien Mantel 25fa21021d All variables prexied with "mysql_" 2017-06-01 15:33:09 +02:00
Emilien Mantel 4a5a3ec75c Resetup galera 2016-10-03 12:16:56 +02:00
Emilien Mantel e3e3ae1a05 Revert "Add a default serial on handler restart"
This reverts commit f1c68960d5.
2016-09-28 11:55:59 +02:00
Emilien Mantel f1c68960d5 Add a default serial on handler restart 2016-09-28 11:42:38 +02:00
Emilien Mantel 1a57dc1cbf Optionnal apt-src on upstream repositories 2016-09-27 16:26:55 +02:00
Emilien Mantel 994e4d3cc4 mysql_extra_configuration is a hash 2016-09-27 16:21:19 +02:00
Emilien Mantel 0d64e53eab Galera must not be restarted after bootstrap first node 2016-09-25 15:29:51 +02:00
Emilien Mantel c984f19d53 Percona 5.7 don't start... fallback to 5.6 2016-09-25 15:25:00 +02:00
Emilien Mantel a1a40f5ff4 Minor changes 2016-09-25 14:28:10 +02:00
Emilien Mantel 2f560bda96 Don't install percona repository (prevent APT conflicts) 2016-09-25 13:50:30 +02:00
Emilien Mantel cb8a565df6 Force define galera var 2016-09-25 13:48:27 +02:00
Emilien Mantel 17f3731450 mysql_extra_configuration rework 2016-09-25 11:23:38 +02:00
Emilien Mantel deb2e1b811 Merge branch 'master' into mariadb_galera 2016-09-23 18:05:45 +02:00
Emilien Mantel 5dc5c42214 Manage MariaDB 10.2 + Percona server 5.7 2016-09-23 18:00:33 +02:00
Emilien Mantel fc5aa46d94 [GALERA] Install and configuration: first and other nodes 2016-09-23 17:03:13 +02:00
Emilien Mantel f2c7679764 Change innodb buffer (should OOM kill on weak config) 2016-02-09 11:47:37 +01:00
Emilien Mantel c681545b61 Default: install MariaDB from Debian repos 2016-02-09 11:41:06 +01:00
Emilien Mantel a3c233f999 Remove duplicate key 2016-01-25 17:52:18 +01:00
Emilien Mantel 842e2c0a10 innodb_additional_mem_pool_size is deprecated
Deprecated since MySQL 5.6 and removed on MySQL 5.7
No info on other vendors
2016-01-14 16:51:30 +01:00
Emilien Mantel 5d6abb0dda Role organization:
Delete useless files
percona-xtrbackup is optional on Wheezy (unless you use percona apt)
better organization in mysql vendors
2015-08-21 11:24:37 +02:00
Emilien Mantel 8a8966a3f8 Better master and support MariaDB GTID 2015-08-11 11:26:56 +02:00
Emilien Mantel 16b105786b Replication OK (transfert from another git repo) 2015-08-11 10:23:53 +02:00
Emilien Mantel 7eed88df04 New configuration method 2015-08-10 23:45:01 +02:00
Emilien Mantel 5f936c5a52 origin is now default or upstream 2015-07-16 10:58:01 +02:00
Emilien Mantel 1da1c01446 MySQL and Percona works 2015-07-13 12:32:49 +02:00
Emilien Mantel 7b2439e590 Default MySQL works on jessie 2015-07-12 12:47:44 +02:00
Emilien Mantel 4e7528300e Import tasks/defaults/templates/readme from old repo 2015-07-12 11:52:16 +02:00
Emilien Mantel 4955653d48 first commit 2015-07-12 10:42:46 +02:00