diff options
| -rw-r--r-- | inventory/host_vars/db-qa02.qa.fedoraproject.org | 52 | ||||
| -rw-r--r-- | inventory/inventory | 2 | ||||
| -rw-r--r-- | playbooks/groups/postgresql-server.yml | 4 |
3 files changed, 56 insertions, 2 deletions
diff --git a/inventory/host_vars/db-qa02.qa.fedoraproject.org b/inventory/host_vars/db-qa02.qa.fedoraproject.org new file mode 100644 index 000000000..1a6b5eda4 --- /dev/null +++ b/inventory/host_vars/db-qa02.qa.fedoraproject.org @@ -0,0 +1,52 @@ +--- +nm: 255.255.255.0 +gw: 10.5.124.254 +dns: 10.5.126.21 +ks_url: http://10.5.126.23/repo/rhel/ks/kvm-rhel-7 +ks_repo: http://10.5.126.23/repo/rhel/RHEL7-x86_64/ +volgroup: /dev/VirtGuests +eth0_ip: 10.5.124.144 +eth0_nm: 255.255.255.128 +vmhost: virthost-comm03.qa.fedoraproject.org +datacenter: phx2 + +# This is a generic list, monitored by collectd +databases: +- postgres +- buildmaster +- execdb +- openqa +- resultsdb + +# This is a more strict list, to be made publicly available +dbs_to_backup: +- postgres +- buildmaster +- buildmaster_dev +- buildmaster_stg +- execdb +- execdb_stg +- execdb_dev +# these names are also stored as host vars 'openqa_dbname', +# make sure to keep in sync +- openqa +- openqa-stg +- resultsdb +- resultsdb_stg +- resultsdb_dev + +mariadb_root_password: "{{ dbqa01_mysql_root_password }}" + +# These are normally group variables, but in this case db servers are often different +lvm_size: 300000 +mem_size: 16384 +num_cpus: 2 +tcp_ports: [ 5432, 443, 3306 ] +fas_client_groups: sysadmin-qa,sysadmin-noc,sysadmin-veteran + +# kernel SHMMAX value +kernel_shmmax: 68719476736 + +host_backup_targets: ['/backups'] +shared_buffers: "2GB" +effective_cache_size: "6GB" diff --git a/inventory/inventory b/inventory/inventory index 9226f0112..06d7bf3d6 100644 --- a/inventory/inventory +++ b/inventory/inventory @@ -294,6 +294,7 @@ db-s390-koji01.s390.fedoraproject.org db-arm-koji01.qa.fedoraproject.org db-ppc-koji01.ppc.fedoraproject.org db-qa01.qa.fedoraproject.org +db-qa02.qa.fedoraproject.org db-qa-stg01.qa.fedoraproject.org [dbserver-stg] @@ -1294,6 +1295,7 @@ qa05.qa.fedoraproject.org openqa-stg01.qa.fedoraproject.org qa07.qa.fedoraproject.org db-qa01.qa.fedoraproject.org +db-qa02.qa.fedoraproject.org resultsdb01.qa.fedoraproject.org resultsdb-stg01.qa.fedoraproject.org resultsdb-dev01.qa.fedoraproject.org diff --git a/playbooks/groups/postgresql-server.yml b/playbooks/groups/postgresql-server.yml index fca39fbd9..ae0bd0356 100644 --- a/playbooks/groups/postgresql-server.yml +++ b/playbooks/groups/postgresql-server.yml @@ -2,12 +2,12 @@ # NOTE: should be used with --limit most of the time # NOTE: most of these vars_path come from group_vars/backup_server or from hostvars -- include: "/srv/web/infra/ansible/playbooks/include/virt-create.yml myhosts=db-datanommer02.phx2.fedoraproject.org:db-qa01.qa.fedoraproject.org:db-koji01.phx2.fedoraproject.org:db-fas01.stg.phx2.fedoraproject.org:db-fas01.phx2.fedoraproject.org:db01.phx2.fedoraproject.org:db01.stg.phx2.fedoraproject.org:db-s390-koji01.s390.fedoraproject.org:db-arm-koji01.qa.fedoraproject.org:db-ppc-koji01.ppc.fedoraproject.org:db-qa-stg01.qa.fedoraproject.org" +- include: "/srv/web/infra/ansible/playbooks/include/virt-create.yml myhosts=db-datanommer02.phx2.fedoraproject.org:db-qa01.qa.fedoraproject.org:db-koji01.phx2.fedoraproject.org:db-fas01.stg.phx2.fedoraproject.org:db-fas01.phx2.fedoraproject.org:db01.phx2.fedoraproject.org:db01.stg.phx2.fedoraproject.org:db-s390-koji01.s390.fedoraproject.org:db-arm-koji01.qa.fedoraproject.org:db-ppc-koji01.ppc.fedoraproject.org:db-qa-stg01.qa.fedoraproject.org:db-qa02.qa.fedoraproject.org" # Once the instance exists, configure it. - name: configure postgresql server system - hosts: db-datanommer02.phx2.fedoraproject.org:db-qa01.qa.fedoraproject.org:db-koji01.phx2.fedoraproject.org:db-fas01.stg.phx2.fedoraproject.org:db-fas01.phx2.fedoraproject.org:db01.phx2.fedoraproject.org:db01.stg.phx2.fedoraproject.org:db-s390-koji01.s390.fedoraproject.org:db-arm-koji01.qa.fedoraproject.org:db-ppc-koji01.ppc.fedoraproject.org:db-qa-stg01.qa.fedoraproject.org + hosts: db-datanommer02.phx2.fedoraproject.org:db-qa01.qa.fedoraproject.org:db-koji01.phx2.fedoraproject.org:db-fas01.stg.phx2.fedoraproject.org:db-fas01.phx2.fedoraproject.org:db01.phx2.fedoraproject.org:db01.stg.phx2.fedoraproject.org:db-s390-koji01.s390.fedoraproject.org:db-arm-koji01.qa.fedoraproject.org:db-ppc-koji01.ppc.fedoraproject.org:db-qa-stg01.qa.fedoraproject.org:db-qa02.qa.fedoraproject.org user: root gather_facts: True |