main.yml

---

- file:
    path: /etc/noblogs
    state: directory
    group: docker-noblogs
    mode: 0750

- name: Install noblogs config
  template:
    src: config.json.j2
    dest: /etc/noblogs/config.json
    group: docker-noblogs
    mode: 0640

- name: Install robots.txt
  template:
    src: robots.txt.j2
    dest: /etc/noblogs/robots.txt

- name: Create noblogs data directory
  file:
    path: "/opt/noblogs/{{ item }}"
    state: directory
    owner: docker-noblogs
    group: docker-noblogs
    mode: 0700
  with_items:
    - cache
    - data
    - tmp/sessions
    - tmp/uploads

- include_role:
    name: mariadb
  vars:
    mariadb_instance: noblogs
    mariadb_port: 3307
    mariadb_metrics_port: 9307
    mariadb_server_id: "{{ shard_id | regex_replace('\\D', '') }}"
    mariadb_enable_replication: true
    mariadb_replication_password: "{{ noblogs_db_replication_password }}"
    mariadb_master_host: "noblogs-master.{{ domain }}"
    mariadb_is_master: "{{ float_noblogs_is_master }}"
    mariadb_ulimit_nofile: 65535
    mariadb_replicate_dbs:
      - noblogs
    mariadb_settings:
      max_connections: 5000
      default-storage-engine: MyISAM
      key_buffer_size: "2048M"
      thread_stack: "192K"
      sort_buffer_size: "8M"
      tmp_table_size: "64M"
      max_heap_table_size: "64M"
      join_buffer_size: "256K"
      query_cache_limit: 1048576
      query_cache_size: "128M"
      query_cache_type: 1
      table_open_cache: 8192
      binlog-do-db: noblogs
      binlog-format: MIXED
      expire_logs_days: 7
      max_allowed_packet: "16M"

- name: Create noblogs MySQL user
  mysql_user:
    name: noblogs
    host: "{{ item }}"
    password: "{{ noblogs_db_user_password }}"
    login_unix_socket: "/var/run/mariadb-noblogs/server.sock"
    priv: "*.*:ALL"
    state: present
  loop:
    - localhost
    - "%"

# If the database directory for the 'noblogs' db does not exist,
# initialize the db. Only run on the master host.
- stat:
    path: /var/lib/mariadb/noblogs/noblogs
  register: noblogs_db_dir

- set_fact:
    noblogs_initialize: "{{ float_noblogs_is_master and not noblogs_db_dir.stat.exists }}"

- copy:
    src: "bootstrap/wordpress-base.sql"
    dest: "/etc/noblogs/wordpress-base.sql"
  when: noblogs_initialize

- name: Create noblogs database
  mysql_db:
    name: noblogs
    state: import
    target: /etc/noblogs/wordpress-base.sql
    login_unix_socket: "/var/run/mariadb-noblogs/server.sock"
  when: noblogs_initialize

- name: Create noblogs database shard
  mysql_db:
    name: "noblogs_{{ shard_id | regex_replace('\\D', '') }}"
    state: present
    login_unix_socket: "/var/run/mariadb-noblogs/server.sock"

- name: Install noblogs cron jobs
  copy:
    dest: /etc/cron.d/noblogs
    src: noblogs.cron

- name: Configure backup handler
  template:
    dest: /etc/tabacco/handlers/mysql-noblogs.yml
    src: backup/mysql-noblogs-handler.yml.j2

- name: Configure backup source
  template:
    dest: /etc/tabacco/sources/noblogs.yml
    src: backup/noblogs-source.yml.j2