Fixes T1127.
Details
Details
- Reviewers
dereckson - Maniphest Tasks
- T1127: Provide a MySQL server on Eglide
- Commits
- rOPSedd5def00b54: Deploy MySQL on Eglide
rOPS875cf0fbf58c: Deploy MySQL on Eglide
mysql
Diff Detail
Diff Detail
- Repository
- rOPS Nasqueron Operations
- Lint
Lint Not Applicable - Unit
Tests Not Applicable
Event Timeline
Comment Actions
Diff 2164
Salt master
$ salt eglide state.apply roles/shellserver/database eglide: ---------- ID: mysql Function: pkg.installed Result: True Comment: The following packages were installed/updated: mariadb-server Started: 21:05:54.132674 Duration: 70924.125 ms Changes: ---------- galera: ---------- new: 1 old: galera-3: ---------- new: 25.3.19-2 old: galera3: ---------- new: 1 old: gawk: ---------- new: 1:4.1.3+dfsg-0.1+b1 old: libcgi-fast-perl: ---------- new: 1:2.12-1 old: libcgi-pm-perl: ---------- new: 4.35-1 old: libdbd-mysql-perl: ---------- new: 4.041-1 old: old: libdbi-perl: ---------- new: 1.636-1+b1 old: libfcgi-perl: ---------- new: 0.78-2 old: libhtml-template-perl: ---------- new: 2.95-2 old: libjemalloc1: ---------- new: 3.6.0-9 old: libreadline5: ---------- new: 5.2+dfsg-3+b1 old: libsigsegv2: ---------- new: 2.10-5 old: libterm-readkey-perl: ---------- new: 2.37-1 old: mariadb-client-10.1: ---------- new: 10.1.21-1 old: mariadb-client-core-10.1: ---------- new: 10.1.21-1 old: mariadb-server: ---------- new: 10.1.21-1 old: mariadb-server-10.1: ---------- new: 10.1.21-1 old: mariadb-server-core-10.1: ---------- new: 10.1.21-1 old: percona-xtradb-cluster-galera-25: ---------- new: 1 old: perl-dbdabi-94: ---------- new: 1 old: virtual-mysql-client: ---------- new: 1 old: virtual-mysql-client-core: ---------- new: 1 old: virtual-mysql-server: ---------- new: 1 old: virtual-mysql-server-core: ---------- new: 1 old: wsrep: ---------- new: 1 old: ---------- ID: full_text_search_stopwords_file Function: file.managed Name: /opt/stopwords.txt Result: True Comment: File /opt/stopwords.txt updated Started: 21:07:05.082624 Duration: 1237.092 ms Changes: ---------- diff: New file mode: 0644 ---------- ID: mysql_config Function: file.managed Name: /etc/my.cnf Result: True Comment: File /etc/my.cnf updated Started: 21:07:06.320967 Duration: 868.291 ms Changes: ---------- diff: New file mode: 0644 Summary for eglide ------------ Succeeded: 3 (changed=3) Failed: 0 ------------ Total states run: 3 Total run time: 73.030 s
Diff 2165
Salt master
$ salt eglide state.apply roles/shellserver/database eglide: ---------- ID: mysql Function: pkg.installed Result: True Comment: All specified packages are already installed Started: 21:16:54.148001 Duration: 3101.007 ms Changes: ---------- ID: full_text_search_stopwords_file Function: file.managed Name: /opt/stopwords.txt Result: True Comment: File /opt/stopwords.txt updated Started: 21:16:57.263514 Duration: 885.054 ms Changes: ---------- diff: --- +++ @@ -48,3 +48,23 @@ us in on +de +du +le +la +les +au +à +au +par +et +mais +ou +donc +or +ni +car +pas +que +des +dont ---------- ID: mysql_config Function: file.managed Name: /etc/my.cnf Result: True Comment: File /etc/my.cnf updated Started: 21:16:58.149777 Duration: 739.591 ms Changes: ---------- diff: --- +++ @@ -26,3 +26,5 @@ ft_stopword_file=/opt/stopwords.txt ft_min_word_len =3 ft_boolean_syntax=' |-><()~*:""&^' + +max_connections = 50 Summary for eglide ------------ Succeeded: 3 (changed=2) Failed: 0 ------------ Total states run: 3 Total run time: 4.726 s
Logs
Eglide
$ journalctl | grep mysql Jan 23 21:06:59 eglide.org mysqld[27699]: 2017-01-23 21:06:59 2520773664 [Note] InnoDB: Dumping buffer pool(s) not yet started Jan 23 21:06:59 eglide.org mysqld[27699]: 2017-01-23 21:06:59 3069141200 [Note] Plugin 'FEEDBACK' is disabled. Jan 23 21:06:59 eglide.org mysqld[27699]: 2017-01-23 21:06:59 3069141200 [Note] Server socket created on IP: '127.0.0.1'. Jan 23 21:06:59 eglide.org mysqld[27699]: 2017-01-23 21:06:59 3069141200 [Note] /usr/sbin/mysqld: ready for connections. Jan 23 21:06:59 eglide.org mysqld[27699]: Version: '10.1.21-MariaDB-1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian 9.0 Jan 23 21:07:00 eglide.org mysql[27527]: Starting MariaDB database server: mysqld .. Jan 23 21:07:01 eglide.org /etc/mysql/debian-start[27758]: Upgrading MySQL tables if necessary. Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Looking for 'mysql' as: /usr/bin/mysql Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Phase 1/6: Checking and upgrading mysql database Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Processing databases Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.column_stats OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.columns_priv OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.db OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.event OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.func OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.gtid_slave_pos OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.help_category OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.help_keyword OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.help_relation OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.help_topic OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.host OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.index_stats OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.innodb_index_stats OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.innodb_table_stats OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.plugin OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.proc OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.procs_priv OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.proxies_priv OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.roles_mapping OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.servers OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.table_stats OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.tables_priv OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.time_zone OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.time_zone_leap_second OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.time_zone_name OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.time_zone_transition OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.time_zone_transition_type OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql.user OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Phase 2/6: Fixing views Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Processing databases Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: information_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: performance_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: test Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Phase 3/6: Running 'mysql_fix_privilege_tables' Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Phase 4/6: Fixing table and database names Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Processing databases Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: information_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: performance_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: test Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Phase 5/6: Checking and upgrading tables Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Processing databases Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: information_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: mysql Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: performance_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: test Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Phase 5/6: Checking and upgrading tables Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Processing databases Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: information_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: performance_schema Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: test Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: Phase 6/6: Running 'FLUSH PRIVILEGES' Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27761]: OK Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27802]: Checking for insecure root accounts. Jan 23 21:07:02 eglide.org /etc/mysql/debian-start[27806]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables