From 5c2acb13a0006645353a6ebf782ae230a05cecfd Mon Sep 17 00:00:00 2001
From: Christian Pointner <equinox@spreadspace.org>
Date: Wed, 9 Jan 2019 21:58:38 +0100
Subject: added percona as mysql pkg provider

---
 roles/mysql/defaults/main.yml |  7 ++--
 roles/mysql/files/percona.asc | 82 +++++++++++++++++++++++++++++++++++++++++++
 roles/mysql/tasks/main.yml    |  2 +-
 roles/mysql/tasks/percona.yml | 11 ++++++
 4 files changed, 98 insertions(+), 4 deletions(-)
 create mode 100644 roles/mysql/files/percona.asc
 create mode 100644 roles/mysql/tasks/percona.yml

diff --git a/roles/mysql/defaults/main.yml b/roles/mysql/defaults/main.yml
index 737711a1..748dd194 100644
--- a/roles/mysql/defaults/main.yml
+++ b/roles/mysql/defaults/main.yml
@@ -1,7 +1,8 @@
 ---
+mysql_version: 5.7
+
 mysql_pkg_provider: distro
-mysql_pkg_name: mysql-server
+mysql_pkg_name: "mysql-server-{{ mysql_version }}"
 
-### not done yet
 # mysql_pkg_provider: percona
-# mysql_pkg_name: percona-server-server
+# mysql_pkg_name: "percona-server-server-{{ mysql_version }}"
diff --git a/roles/mysql/files/percona.asc b/roles/mysql/files/percona.asc
new file mode 100644
index 00000000..ccbf2db2
--- /dev/null
+++ b/roles/mysql/files/percona.asc
@@ -0,0 +1,82 @@
+-----BEGIN PGP PUBLIC KEY BLOCK-----
+
+mI0ESPEdbwEEAKyi0t8ZOC6bkBrFdQii9DAbswT20XQz96kvXjXL8pjBYN+RvfiK
+axmLnPlHtP30BqWoG1XwY+TQSbtwhwdAOhQMn5FkSiHroBDBO2fOEhKD17IeyYmL
+6r1zK1Bm2xhwe394mFEtvBLAdpgM/sIK5fXxtErnsyOSuj5tisWUOS9VABEBAAG0
+L1RvdGFsbHkgTGVnaXQgU2lnbmluZyBLZXkgPG1hbGxvcnlAZXhhbXBsZS5vcmc+
+iNAEEwEIADoWIQS8w5ktumkEKZDnUnODoPEdhQfvpQUCSPEdbwIbAQYLCQgHAwIH
+FQoJCAsDAgQWAgMBAh4BAheAAAoJEIOg8R2FB++lxnYD/1RrRmDeGdUswe1kovHs
+uG6+pANG7mwoa1NZjw8eeFwnlTbcXJjojJc7YUf59wYg7q1L/HjIC9s3Xhjz1yV6
+ykwxSOUp/iODmTHBc3pdVZ6V7TeftGZjV+1pfGGuXZSj+reAB9d1AupTWO9n87DA
+ZqDMcLOqLP32LLcv8MsmnLaXmQINBFd0veABEADyFa8jPHXhhX1XS9W7Og4p+jLx
+B0aowElk4Kt6lb/mYjwKmQ779ZKUAvb1xRYFU1/NEaykEl/jxE7RA/fqlqheZzBb
+lB3WLIPM0sMfh/D4fyFCaKKFk2CSwXtYfhk9DOsBP2K+ZEg0PoLqMbLIBUxPl61Z
+Iy2tnF3G+gCfGu6pMHK7WTtInnruMKk51s9Itc9vUeUvRGDcFIiEEq0xJhEX/7J/
+WAReD5Am/kD4CvkkunSqbhhuB6DV9tAeEFtDppEHdFDzfHfTOwlHLgTvgVETDgLg
+TRXzztgBVKl7Gdvc3ulbtowBuBtbuRr49+QIlcBdFZmM6gA4V5P9/qrkUaarvuIk
+XWQYs9/8oCd3SRluhdxXs3xX1/gQQXYHUhcdAWrqS56txncXf0cnO2v5kO5rlOX1
+ovpNQsc69R52LJKOLA1KmjcaJNtC+4e+SF2upK14gtXK384z7owXYUA4NRZOEu+U
+Aw7wAoiIWPUfzMEHYi8I3RszEtpVyOQC5YyYgwzIdt4YxlVJ0CUoinvtIygies8L
+kA5GQvaGJHYG1aQ3i9WDddCXwtoV1uA4EZlEWjTXlSRc92jhSKut/EWbmYHEUhmv
+cfFErrxUPqirpVZHSaXY5RdhKVFyx9JcRuIQ0SJxeHQPlaEkyhKpTDN5Cw7USLwo
+XfIu2w0w0W06LdXZ7wARAQABtEZQZXJjb25hIE15U1FMIERldmVsb3BtZW50IFRl
+YW0gKFBhY2thZ2luZyBrZXkpIDxteXNxbC1kZXZAcGVyY29uYS5jb20+iQI3BBMB
+CgAhBQJXdL3gAhsDBQsJCAcDBRUKCQgLBRYCAwEAAh4BAheAAAoJEJM0ol+FB++l
+4koQAKkrRP+K/p/TGlnqlbNyS5gdSIB1hxT3iFwIdF9EPZq0U+msh8OY7omV/82r
+Jp4T5cIJFvivtWQpEwpUjJtqBzVrQlF+12D1RFPSoXkmk6t4opAmCsAmAtRHaXIz
+U9WGJETaHl57Trv5IPMv15X3TmLnk1mDMSImJoxWJMyUHzA37BlPjvqQZv5meuwe
+LCbL4qJS015s7Uz+1f/FsiDLsrlE0iYCAScfBeRSKF4MSnk5huIGgncaltKJPnNY
+ppXUb2wt+4X2dpY3/V0BoiG8YBxV6N7sA7lC/OoYF6+H3DMlSxGBQEb1i9b6ypwZ
+IbG6CnM2abLqO67D3XGx559/FtAgxrDBX1f63MQKlu+tQ9mOrCvSbt+bMGT6frFo
+pgH6XiSOhOiMmjUazVRBsXRK/HM5qIk5MK0tGPSgpc5tr9NbMDmp58OQZYQscslK
+hx0EDDYHQyHfYFS2qoduRwQG4BgpZm2xjGM/auCvdZ+pxjqy7dnEXvMVf0i1Bylk
+yW4p+oK5nEwY3KHljsRxuJ0+gjfyj64ihNMSqDX5k38T2GPSXm5XAN+/iazlIuiq
+PQKLZWUjTOwr2/AA6AztU/fmsXV2swz8WekqT2fphvWKUOISr3tEGG+HF1iIY43B
+oAMHYYOcdSI1ZODZq3Wic+zlN1WzPshDB+d3acxeV5JhstvPiQQcBBABCAAGBQJY
+CWSTAAoJEHpjgJ3lEnYiM40gALkOg65HOAOGkBV6WG9BTpQgnhsmrvC/2ozZ6dV5
+577/zYCf6ZB5hMO3mSwcrjTGX5+yD1CyVQEayWuUxoV2By+N9an98660hWAIYTSN
+iRwSFITDbLVqXOp7t/B7Bddhj3ZrzA3Eo5bV/QyS/zyKGF1tMkA64IJkQ3292g1L
+7RYfNG5h1IBB/xY2xCVcKNT2XcFbAPOct30bqMyT4mdT39WdYg0l4U3zOutemFYs
+4uyObzrVNOKln0thZpfNJdRq+OfkE6XwW2UwhTK0/GM5l1Y3NJW64DGPyM7KKcE4
+FTgq1MRaWepw5sAZr6pTqasWuWUf20la1M9fIdyxJsAbWn1bhpPIOl3NZ88dRK6X
+I8Ly36fRa2as/lPeG7ql2ymaOVFDBHqfB+gAWMzkwF7TS+02er4kg9vnpErPc/aA
+0lMKmyXHkMANLAnWBA7tx+7sEKck8XcY4e1OiwpUXRxC+UlSaJYQtE/kmoC2NPQB
+0FhhvC/VQ0sBOYOAbJ5GukEJVDB7QqqGKjzaKE0LUADCXJFcLY4yMA9bP9U+Ex/G
+62YcYn0g1amriKAAkEBRvBOp/qUFSj6b+EqEC5w2my3cLBnATrzskGm32XNOFdpw
+R469rOqxomtVedH72vW3sS1etcGw/SHBSplDYTzcnAJQbHvD6LEeOQeWPbA77PD9
+ASlx7jGZj3GCq0tc7dndjTLyiL+A4EsRxEUDrH30d8TLaYd1WSD6v5i/xa0r3rXQ
+UmPviBBzRpJxl0CFB/db2L6a/A2EHkOWjpcL2XSJgcgIVlYZCgM1OEuDGURbLUM9
+qNiFogdBNCkGTkqjIFES0iq4lBA4vphcXR8C34OP+7DeT1RthyPjmvi/ErXIQLTp
+R2Yuwl9/nI2gx6ddZFqkoHFcPSyE152uJRsYdtL9iIeEIPH//WZ0Fz+h6hhfLiPh
+6AN1LH3wxKqLW4hAAZ8ytUqANNZT+7o6EVQHI6VyoigS5TJ34h36jKjRvfUaP4Ff
+kGaPRpfR/cKUiNaCIJRaIFlvlUdbN+biQO3WRxwdyUdgDSETZnLiym6pKuCpLsic
+/3+fOyBuWuIxxvGGm3XUt3Lmtvlkey/sSCwInioxn0drYosq+FZP/ocBQ9aeyxZ5
+Fqyxqg0BInrusfthXA35WUExVsjwidFPeftz2VbV9gD1Og3JN2Rhd7FzxH0lrLgh
+xh129R1QVPZiDOiaJQO4QObsC5YXmzF0A/25qJ9Y8UJrsnWrPvjpH41p70Sl6iDW
+Kigdxi6LD9NrwOnw9qBkIlmjbJL6WKrvjxgVoCo4iP8jtHUx0jwn2qsMkGqO3NM2
+xWb6MBVzU7nZsyGpH5OzlrHYoYziw8v6zCLZj8eg3EgFxe+5Ag0EV3S94AEQAJ+4
+dVt7Lmobk/qtGEBfal139/uLAd1xbX56/EJ8JHl8fOw7UtHCUcz0ZGqXO0rODHMA
+h+BRep0xdSzq9bxqB+S7nneHyAGquF2r00frn9h6fNX9K/1z8QbOwFC6tq7VELiB
+8niOAB527gVApm9Wv//Q1Na4mbd6XeithjPisurv1q9KAPtD+4rz+PvXOAImLGwX
+OMLx6FGU60x1609NjfrNzYuNBIxNKkTtK8RuuTrIMqlC9lpuXd2aQSQG+gWlq3vH
+6Ldm0ELNEVPHasf/0NYoI75K4ZUFezy+Eu0C8oqNtYYZT0uuYRJlxqEjp+WIfnDb
+w2+k64mWvxGf/qNCYkMM8o7nRcozyGlPoMGogT31ipgtTNcAp/hjzwXIe+U7qSJV
+tdo5jPU5OoJZWqNoxgVuI9bo2ANfSHIT24bSV80D0/l52rI9IRpM36SkP05WobpH
+S48EIVjy7bk2s1GEyogVB28jnh4S03SS0U/QWuUUWSDpL6X7dCyv2wwMoJRVMn8G
+QrCqR2FO/ldjgqIgQlCO8wqvS8fmViI8MZf/cqwkv6vEmMD77haHjRYEtgNINZIB
+8I9KiSDWVGM5owOGcflidR4SToyHLrUNBGwf7ESl4v8XUvTq7RaH7SJeopckDiO9
+ThfAZKTODfJppuWRie6fmbKEhBizAh0LIQfhaXdJABEBAAGJAh8EGAEKAAkFAld0
+veACGwwACgkQkzSiX4UH76XGqRAAgLuPPUJa361sqC60tEVzF7E1BmhMAA9OTc6O
+qp4ItY7VyYe2aM1JdNzmulfvy88RhCPNCkABFnECmkB14kcHOb1Ct+LKjtNbw/QZ
+/1z2nWY9S2XaDQE29FTvNjOAIXVojAq1L5c7ZR1NPnobLm9rF3UGJODwn3K2QgZK
+S5JdI4BJ4YLlGY3dJoPrKiZVrjzeT2RWGFI5TMrBgr1/ZaAaEjXHGlUXktttGEKg
+TPiJr9OomhZ0f9qC6XfgAZY6A9GEy74USlv+eiezvddPBC1xeJkB73PhmW1WxJyK
+iWBHM/CRfEyZZUyZ71jKZUI9OvPE+LqdzqelJnMTbvmbTa7zpXaG3APYxtK4aZxN
+2YA899eBDlcznsQsSUNs0DV43WNkCHNgEu/rdf6c07LrKy5pzlDujPIE4ik2SwuV
+4DT4XOydiY+UarNi2cPqcWCUOfz3yOT8taTCK0vjvZ+HxFFsNh9+xd5qWLLpbZNg
+qtCXnZqMtXsPk9RRL3FKUA9x09K5cDOHsaE4oOiaZbAt8+jS5g3deNr4CRbXfly3
+Ph68Km9mOQFN+iDTsUaW6Z25Qrl8e8liJLJXU/lIqvjvbYLyNYKjZhxL4ixmBUUW
+5jVsboe2Iiak/vkgzQbeDW7J3Y6EX2cYNLGOniQpadSgZ1XQ/VtRdoBu9dHOUhzH
+t04Pu1k=
+=cZXG
+-----END PGP PUBLIC KEY BLOCK-----
diff --git a/roles/mysql/tasks/main.yml b/roles/mysql/tasks/main.yml
index ecd0ef90..22b37fcf 100644
--- a/roles/mysql/tasks/main.yml
+++ b/roles/mysql/tasks/main.yml
@@ -11,5 +11,5 @@
     state: present
     force: yes
 
-- name: remove unsecure defaults
+- name: remove insecure defaults
   import_tasks: mysql-secure-installation.yml
diff --git a/roles/mysql/tasks/percona.yml b/roles/mysql/tasks/percona.yml
new file mode 100644
index 00000000..1bef3a03
--- /dev/null
+++ b/roles/mysql/tasks/percona.yml
@@ -0,0 +1,11 @@
+---
+- name: Add percona repository key
+  apt_key:
+    data: "{{ lookup('file', 'percona.asc') }}"
+    state: present
+
+- name: Add percona repository
+  apt_repository:
+    repo: "deb http://repo.percona.com/apt {{ ansible_distribution_release }} main"
+    state: present
+    filename: percona-release
-- 
cgit v1.2.3