Jcrespo has uploaded a new change for review.
https://gerrit.wikimedia.org/r/316558
Change subject: New labs::db::proxy role to load balance and failover replicas
......................................................................
New labs::db::proxy role to load balance and failover replicas
Bug: T148500
Bug: T141097
Bug: T148507
Change-Id: I8f7c8b4da37a3f804e1034f337ff5fbced1b6c81
---
A modules/role/manifests/labs/db/proxy.pp
1 file changed, 38 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/58/316558/1
diff --git a/modules/role/manifests/labs/db/proxy.pp
b/modules/role/manifests/labs/db/proxy.pp
new file mode 100644
index 0000000..53bbbbe
--- /dev/null
+++ b/modules/role/manifests/labs/db/proxy.pp
@@ -0,0 +1,38 @@
+# role::labs::db::proxy
+# Manages proxysql for the replica and other sql services on
+# labs-support network
+
+class role::labs::db::proxy {
+ system::role { 'role::labs::db::proxy':
+ description => 'LabsDB proxy',
+ }
+
+ include standard
+ include passwords::labs::db::proxy
+
+ $admin_user = $passwords::labs::db::proxy::admin_user
+ $admin_password = $passwords::labs::db::proxy::admin_password
+
+ class { 'proxysql':
+ admin_user => $admin_user,
+ admin_password => $admin_password,
+ admin_socket => '/var/run/proxysql/proxysql_admin.sock',
+ mysql_socket => '/var/run/proxysql/proxysql_admin.sock',
+ mysql_port => 3306,
+ }
+
+ file {'/var/run/proxysql':
+ ensure => directory,
+ user => 'proxysql',
+ group => 'root',
+ mode => '755',
+ }
+
+ nrpe::monitor_service { 'proxysql':
+ description => 'proxysql processes',
+ nrpe_command => '/usr/lib/nagios/plugins/check_procs -c 1: \
+-a "proxysql"',
+ critical => false,
+ contact_group => 'admins', # show on icinga/irc only
+ }
+}
--
To view, visit https://gerrit.wikimedia.org/r/316558
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I8f7c8b4da37a3f804e1034f337ff5fbced1b6c81
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
