Deploy MySQL on Eglide
ClosedPublic
Actions

Authored by dereckson on Jan 23 2017, 21:03.

Details

Reviewers

dereckson

Maniphest Tasks

T1127: Provide a MySQL server on Eglide

Commits

rOPSedd5def00b54: Deploy MySQL on Eglide
rOPS875cf0fbf58c: Deploy MySQL on Eglide

Summary

Fixes T1127.

Test Plan

mysql

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

No Lint Coverage

Unit

No Test Coverage

Branch

T1127 (branched from master)

Build Status

Buildable 1312
Build 1560: arc lint + arc unit

Event Timeline

dereckson created this revision.Jan 23 2017, 21:03

dereckson planned changes to this revision.Jan 23 2017, 21:13

dereckson added inline comments.

roles/shellserver/database/files/my.cnf
25	+max_connections
roles/shellserver/database/files/stopwords.txt
2	+de du le la les au à par et mais ou donc or ni car pas que des qui dont

50 connections, French stop words (thanks Ælfgar)

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