servers:
  docker:
    host: docker:mariaDb
    description: Docker mariaDb
    mysql:
      port: 3306
      username: root
      password: mysql660

  preprod:
    host: preprod.2iopenservice.com
    description: Preprod
    mysql:
      port: 3306
      username: dbcloner
      password: wWZ4hYcrmHLW2mUK
    ssh:
      key_file: ~/.ssh/id_rsa_exploitation
      port: 22
      user: exploitation

  prod-back:
    host: prod-back.2iopenservice.com
    description: Prod-Back
    mysql:
      port: 3306
      username: dbcloner
      password: wWZ4hYcrmHLW2mUK
    ssh:
      key_file: ~/.ssh/id_rsa_exploitation
      port: 22
      user: exploitation

  prod-front:
    host: prod-front.2iopenservice.com
    description: Prod-Front

    mysql:
      port: 3306
      username: dbcloner
      password: wWZ4hYcrmHLW2mUK
    ssh:
      key_file: ~/.ssh/id_rsa_exploitation
      port: 22
      user: exploitation

users:
  opentalent:
    host: localhost
    pwd: nSDC3Bm3ws88qKjV63

  openassos:
    host: localhost
    pwd: Vq2icge7SM3P26CaC3

operations:
  crm:
    dbname: crm
    from_server: prod-back
    to_server: docker
    is_default: True
    compress: True
    grant:
      - opentalent

  adminassos:
    dbname: adminassos
    from_server: prod-back
    to_server: docker
    is_default: True
    compress: True

  openassos:
    dbname: openassos
    from_server: prod-front
    to_server: docker
    is_default: True
    compress: True
    ignore_tables: ['Access', 'matomo.*', 'user_piwik.*', 'zzz_.*', 'tt_content_save', 'tt_content_v59']
    structure_only: ['cf_cache_.*', 'sys_log']
    grant:
      - openassos

  opentalent:
    dbname: opentalent
    from_server: prod-back
    to_server: docker
    is_default: True
    compress: True
    structure_only: ['Audit_.*']
    ignore_tables: []
    ignore_views: []
    grant:
      - opentalent

  metabase:
    dbname: metabase
    from_server: prod-back
    to_server: docker
    is_default: True
    compress: True