diff --git a/roles/mariadb/templates/my.cnf b/roles/mariadb/templates/my.cnf index 3267e78..036a2d6 100644 --- a/roles/mariadb/templates/my.cnf +++ b/roles/mariadb/templates/my.cnf @@ -1,31 +1,31 @@ [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default_storage_engine=InnoDB bind-address=0.0.0.0 sql_mode=STRICT_ALL_TABLES max_allowed_packet=48M symbolic-links=0 max_connections=800 local_infile=0 ft_stopword_file=/srv/stopwords.txt ft_min_word_len=3 ft_boolean_syntax=' |-><()~*:""&^' innodb_buffer_pool_size=2000M innodb_log_file_size=48M innodb_autoinc_lock_mode=2 innodb_flush_log_at_trx_commit=0 innodb_doublewrite=0 server_id={{ ansible_hostname[-1:]|int+1 }} log-bin="{{ mysql_cluster_name }}" log_slave_updates=0 binlog_format=MIXED sync_binlog=0 -expire_logs_days=7 +expire_logs_days={{ mysql_binlog_expire }} [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mysqld.pid diff --git a/vars/main.yml.example b/vars/main.yml.example index e66ae79..329af81 100644 --- a/vars/main.yml.example +++ b/vars/main.yml.example @@ -1,133 +1,134 @@ --- env: prod project_name: "c4science" ansible_ssh_user: "centos" proxy: no http_proxy: "" https_proxy: "" no_proxy: "localhost" proxy_url: "{{ http_proxy }}" __no_proxy: "{{ no_proxy }}" user_pwd_root: "" user_pwd_centos: "" # OpenStack keypair_name: "" image_id: "" image_id_coreos: "" public_net: "" private_net: "" flavor_id_small: "" flavor_id_medium: "" flavor_id_large: "" flavor_id_small_backup: "" private_net_backup: "" image_id_backup: "" region_main: "" region_back: "" # Storage glusterfs_default_release: 38 s3_access_key: "" s3_secret_key: "" s3_endpoint: "" s3_bucket: "" s3_region: "" # Lbs internal_ip: 0.0.0.0 external_ip: 0.0.0.0 backup_ip: 0.0.0.0 ip_range: "10.0.0.0/16" notif_port: 22280 jenkins_port: 8080 stats_port: 8082 monit_port: 8081 monit_user: admin monit_pass: rolling_reboot_proxy_host: "{{ external_ip }}" rolling_reboot_pause: 30 rolling_reboot_wait_delay: 20 # App developer_mode: false http_scheme: 'http://' domain: example.com file_domain: "example-cdn.com" phabricator_branch: production phabricator_path: /srv/ repositories_path: /var/repo/ files_path: /var/files/ phd_user: phabricator www_user: apache vcs_user: git vcs_port_front: 22 vcs_port_back: 2222 jenkins_prefix: "/" jenkins_url: "{{ http_scheme }}jenkins.{{ domain }}{{ jenkins_prefix }}" jenkins_user: "admin" jenkins_token: "" jenkins_cred: "xxx-yyy-zzz" shib_metadata_file: "metadata.xml" shib_metadata_provider: "http://example.com/{{ shib_metadata_file }}" google_webmaster_file: "googleXYZ.html" phab_admin_apikey: 'api-xyz' phd_pull_number: 6 # Dbs mysql_repl_user: "repl" mysql_repl_pass: "" mysql_app_user: "" mysql_app_pass: "" mysql_shib_user: "" mysql_shib_pass: "" mysql_shib_db: "shibboleth" mysql_lbs_user: "haproxy" mysql_cluster_name: "" mysql_host: "10.0.0.0/255.255.0.0" +mysql_binlog_expire: 7 # SSH ssh_keys: - "ssh-rsa mysuperkey1" - "ssh-rsa mysuperkey2" # Swap swap_path: "/swapfile" dd_bs_size_mb: 32 swap_count: 128 swappiness: 10 vfs_cache_pressure: 50 # Email configure_postfix: true enable_postfix_domain_rewrite: true enable_postfix_relayhost: true postfix_relayhost: "[{{ internal_ip }}]" postfix_rewrite_domain: "{{ domain }}" email_alias_phabricator: "" email_alias_postmaster: "" email_alias_admin: "" email_monitoring: "" # Config files php_ini: '../roles/phabricator/templates/php.ini' php_enable: '../roles/phabricator/templates/php.sh' sudoers: '../roles/phabricator/templates/sudoers' ssh_hook: '../roles/phabricator/templates/ssh_hook.sh' sshd_config: '../roles/phabricator/templates/sshd_config' sshd_init: '../roles/phabricator/templates/sshd_init' phd_init: '../roles/phabricator/templates/phd_init' phd_pull: '../roles/phabricator/templates/pull-daemons.sh' aphlict_init: '../roles/phabricator/templates/aphlict_init' aphlict_conf: '../roles/phabricator/templates/aphlict.custom.json' myconfig: '../roles/phabricator/templates/myconfig.conf.php' cust_phab_update_repo: '../roles/phabricator/templates/phab_update_repo.sh' cust_repo_gc: '../roles/phabricator/templates/repo-gc.sh' cust_compact_storage: '../roles/phabricator/templates/compact-storage.sh' repo_clusterize: '../roles/phabricator/templates/clusterize.py' arcanist_config: '../roles/phabricator/templates/arcrc'