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