Customized master-master deploy ...

Comments

16 comments

  • Official comment
    Avatar
    Johan

    Hi,

    I cannot reproduce this.
    On the controller, please edit:
    /usr/share/cmon/templates/my.cnf.repl57

    and then add the variables there under the [mysqld] section.

    E.g, i set innodb_max_undo_log_size=512M (the default is 1G), and the setting is applied correctly. See screenshot.

    Comment actions Permalink
  • Avatar
    Johan

    Hi,

    Which vendor and version did you select ? 

    Best regards

    Johan

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    Oracle/MySQL v5.7.22

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    I will have to recreate the nodes in the cluster (or maybe the entire cluster?) because the 'undo_tablespace' option must be in template at database initialization.

    I had created my own template in '/usr/share/cmon/templates', copied from 'my.cnf.repl57', and then referenced it during the deploy procedure.  Is it better to edit '/usr/share/cmon/templates/my.cnf.repl57' versus create my own template and reference it when 1st deploying the cluster?

     

    0
    Comment actions Permalink
  • Avatar
    Johan

    Hi,

    What you describe also works for me. I have defined a :
     /usr/share/cmon/templates/my.cnf.ora57

    And i use it as follows (see screenshot) in the deployment dialog:


    Then in the job messages i get:


    21:55:16]: Loaded template '/usr/share/cmon/templates/my.cnf.ora57'.
    [21:55:16]: Using config template 'my.cnf.ora57' from '/usr/share/cmon/templates'.
    [21:55:16]: 10.10.10.40:3306: Using template 'my.cnf.ora57'.
    [21:55:16]: Cluster type is 'replication'.

    Looking at the variables after the successful deployment i see:

    0
    Comment actions Permalink
  • Avatar
    Johan

    What do you get Ijob messages) and what do you enter for the configuration template?
    Also what cmon version do you use:

    cmon --version

    BR

    johan

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    # cmon --version
    cmon, version 1.6.1.2605

    For the template name, I typed in my.cnf.jmodran.repl57.  My configuration screen looks like this:

    0
    Comment actions Permalink
  • Avatar
    Johan

    I need to see the job messages for the create cluster job. Go to the "Activity" then press Jobs, select the create cluster job you ran, and copy the job messages here.


    BR
    johan

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    There are these messages for both nodes, but I am more concerned with the database being created/initialized with the 'undo_tablespace' and related variable settings ('innodb_undo_tablespaces', 'innodb_undo_log_truncate', 'innodb_max_undo_log_size', and' innodb_undo_logs').

    • SQL Thread STOPPED (err: Error 'Operation CREATE USER failed for 'cmon'@'earthnew2.neuco.com'' on query. Default database: ''. Query: 'CREATE USER 'cmon'@'earthnew2.neuco.com' IDENTIFIED WITH 'mysql_native_password' AS '*A0E3D9DC09CD91E46E034BD254C8CAAFC9090928'', errno: 1396)<br/>IO Thread RUNNING.

     

    Here is the Create Cluster log:

    [18:53:02]:Job finished, all the nodes have been created successfully.
    [18:53:02]:Generated & set RPC authentication token.
    [18:53:02]:Cluster is running.
    [18:53:01]:Waiting until the initial cluster starts up.
    [18:53:01]:Registering the cluster on the web UI.
    [18:53:01]:Cluster is running.
    [18:52:58]:Waiting until the initial cluster starts up.
    [18:52:58]:Sending SIGHUP to the controller process.
    [18:52:58]:Configuration written to '<em style='color: #007e18;'>/etc/cmon.d/cmon_1.cnf</em>'.
    [18:52:58]:Generating configuration for cluster <strong style='color: #59a449;'>neuco-prod-01</strong>.
    [18:52:58]:Generating and writing the new configuration.
    [18:52:58]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Detected OS = 'redhat'
    [18:52:58]:<em style='color: #1abc9c;'>juggernaut</em>: Detecting the OS.
    [18:52:58]:<em style='color: #f3990b;'>juggernaut2</em>:3306: The datadir is <em style='color: #0b33b5;'>/data/production_mysql/</em>.
    [18:52:58]:Connected succesfully: '[email protected]' -> '<em style='color: #f3990b;'>juggernaut2</em>:3306'.
    [18:52:53]:Granting controller 'cmon'@'earthnew2.neuco.com' on 'juggernaut2' (host was not allowed to connect).
    [18:52:53]:<em style='color: #1abc9c;'>juggernaut</em>:3306: The datadir is <em style='color: #0b33b5;'>/data/production_mysql/</em>.
    [18:52:53]:Connected succesfully: '[email protected]' -> '<em style='color: #1abc9c;'>juggernaut</em>:3306'.
    [18:52:48]:Granting controller 'cmon'@'earthnew2.neuco.com' on 'juggernaut' (host was not allowed to connect).
    [18:52:48]:Determining data directories.
    [18:52:45]:<em style='color: #1abc9c;'>juggernaut</em>: granting 'backupuser'.
    [18:52:43]:<em style='color: #1abc9c;'>juggernaut</em>: granting cmon.
    [18:52:43]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Node is read-only.
    [18:52:42]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Node is writable.
    [18:52:41]:Granting controller (earthnew2).
    [18:52:41]:Controller 'earthnew2' could not be resolved. Probably already a valid FQDN.
    [18:52:41]:Checking if resolve of 'earthnew2' is needed, and attempting to resolve to a hostname
    [18:52:39]:Detected that <strong style='color: #59a449;'>skip_name_resolve</strong> is not used on the target server(s).
    [18:52:37]:Check SELinux statuses.
    [18:52:37]:All 2 hosts are accessible by SSH.
    [18:52:37]:<em style='color: #f3990b;'>juggernaut2</em>: Access with ssh/sudo granted.
    [18:52:37]:<em style='color: #1abc9c;'>juggernaut</em>: already checked 2 seconds ago.
    [18:52:37]:Checking ssh/sudo on 2 hosts.
    [18:52:37]:Checking that nodes are not in another cluster.
    [18:52:37]:Found in total 2 nodes.
    [18:52:37]:Found node: '<em style='color: #f3990b;'>juggernaut2</em>'
    [18:52:37]:Found node: '<em style='color: #1abc9c;'>juggernaut</em>'
    [18:52:36]:<em style='color: #1abc9c;'>juggernaut</em>:3306: sanity check
    [18:52:35]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Verifying the MySQL user/password.
    [18:52:35]:<em style='color: #1abc9c;'>juggernaut</em>: Access with ssh/sudo granted.
    [18:52:35]:<em style='color: #1abc9c;'>juggernaut</em>: Checking ssh/sudo.
    [18:52:34]:Adding existing MySQL cluster.
    [18:52:34]:Verifying controller host and cmon password.
    [18:52:34]:Adding cluster with type '<strong style='color: #59a449;'>replication</strong>', vendor '<strong style='color: #59a449;'>oracle</strong>'.
    [18:52:33]:Setting up replication link 1: juggernaut2 -> juggernaut
    [18:52:31]:Setting up replication link 0: juggernaut -> juggernaut2
    [18:52:28]:<em style='color: #f3990b;'>juggernaut2</em>:3306: GRANT REPLICATION SLAVE ON *.* TO 'rpl_user'@'juggernaut'
    [18:52:26]:<em style='color: #f3990b;'>juggernaut2</em>:3306: CREATE USER 'rpl_user'@'juggernaut' IDENTIFIED BY 'xx xxx'
    [18:52:26]:<em style='color: #f3990b;'>juggernaut2</em>: using '<em style='color: #f3990b;'>juggernaut2</em>' for SSH connection.
    [18:52:26]:Setting up replication link 1: juggernaut2 -> juggernaut
    [18:52:25]:<em style='color: #1abc9c;'>juggernaut</em>:3306: GRANT REPLICATION SLAVE ON *.* TO 'rpl_user'@'juggernaut2'
    [18:52:23]:<em style='color: #1abc9c;'>juggernaut</em>:3306: CREATE USER 'rpl_user'@'juggernaut2' IDENTIFIED BY 'xx xxx'
    [18:52:23]:<em style='color: #1abc9c;'>juggernaut</em>: using '<em style='color: #1abc9c;'>juggernaut</em>' for SSH connection.
    [18:52:23]:Setting up replication link 0: juggernaut -> juggernaut2
    [18:52:23]:Create users, grants.
    [18:52:18]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing SET GLOBAL rpl_semi_sync_slave_enabled=1
    [18:52:17]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
    [18:52:16]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_timeout =1000
    [18:52:15]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_enabled=1
    [18:52:14]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
    [18:52:13]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Secured installation.
    [18:52:13]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing FLUSH PRIVILEGES
    [18:52:13]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing DROP DATABASE IF EXISTS test
    [18:52:12]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND authentication_string=''
    [18:52:11]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')
    [18:52:10]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing DELETE FROM mysql.user WHERE User=''
    [18:52:09]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Securing installation.
    [18:52:09]:<em style='color: #f3990b;'>juggernaut2</em>:3306: MySQL is installed and started.
    [18:52:09]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
    [18:51:58]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Setting the MySQL root password.
    [18:51:58]:<em style='color: #f3990b;'>juggernaut2</em>: Server responded to 'mysqladmin ping'
    [18:51:58]:<em style='color: #f3990b;'>juggernaut2</em>: service status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Mon 2018-06-25 18:51:57 CDT; 1s ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Main PID: 25365 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-25365 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 25 18:51:55 juggernaut2 systemd[1]: Starting MySQL Server...
    Jun 25 18:51:57 juggernaut2 systemd[1]: Started MySQL Server.
    [18:51:58]:<em style='color: #f3990b;'>juggernaut2</em>: Started MySQL daemon.
    [18:51:57]:<em style='color: #f3990b;'>juggernaut2</em>: MySQL status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Mon 2018-06-25 18:51:57 CDT; 510ms ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 25362 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
    Process: 25340 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 25365 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-25365 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 25 18:51:55 juggernaut2 systemd[1]: Starting MySQL Server...
    Jun 25 18:51:57 juggernaut2 systemd[1]: Started MySQL Server.

    [18:51:52]:<em style='color: #f3990b;'>juggernaut2</em>: This may take a while to initialize.
    [18:51:52]:<em style='color: #f3990b;'>juggernaut2</em>: (service='mysqld', vendor='oracle', OS=['centos', '7.4.1708']).
    [18:51:52]:<em style='color: #f3990b;'>juggernaut2</em>: Starting MySQL daemon.
    [18:51:51]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Searching and removing '<em style='color: #007e18;'>/root/.my.cnf</em>'.
    [18:51:51]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Searching and removing '<em style='color: #007e18;'>/usr/my.cnf</em>'.
    [18:51:50]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Installed MySQL system tables.
    [18:51:50]:<em style='color: #f3990b;'>juggernaut2</em>:3306: /usr/sbin/mysqld --initialize-insecure: ok.
    [18:51:42]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Installing MySQL system tables.
    [18:51:41]:Writing file '<em style='color: #f3990b;'>juggernaut2</em>:<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'
    [18:51:40]:Writing file '<em style='color: #f3990b;'>juggernaut2</em>:<em style='color: #007e18;'>/etc/my.cnf</em>'
    [18:51:40]:Data directory is '<em style='color: #0b33b5;'>/data/production_mysql</em>', ok.
    [18:51:40]:Base directory is '<em style='color: #0b33b5;'>/usr/</em>', ok.
    [18:51:40]:Checking MySql configuration file(s).
    [18:51:40]:Preparing backup secrets config file '<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'.
    [18:51:40]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Uploading the generated <em style='color: #007e18;'>my.cnf</em>.
    [18:51:35]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Verifying the MySQL installation.
    [18:51:34]:<em style='color: #f3990b;'>juggernaut2</em>:3306: post-installation for oracle.
    [18:50:13]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Installing Oracle(tm) (replication) redhat
    [18:50:13]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Installing the MySQL packages.
    [18:50:10]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Prepare MySQL environment (user/group).
    [18:50:10]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Cleaning old MySql packages: Repository mysql-connectors-community is listed more than once in the configuration
    Repository mysql-tools-community is listed more than once in the configuration
    Repository mysql55-community is listed more than once in the configuration
    Repository mysql56-community is listed more than once in the configuration
    Repository mysql57-community is listed more than once in the configuration
    No Match for argument: MySQL*
    No Match for argument: mysql-5.6-pkg-list
    No Match for argument: mysql-cmds
    No Match for argument: mysql80-community-release-el7-1.noarch.rpm
    No Match for argument: Percona*
    No Match for argument: MariaDB*
    No Match for argument: mariadb*
    No Match for argument: galera*
    No Match for argument: galera
    warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave

    [18:49:45]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Removing old MySQL packages from the host.
    [18:49:22]:<em style='color: #f3990b;'>juggernaut2</em>: Using external repositories.
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Total disk space: 40188 MB.
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Detected free disk space: 39.18 GiB.
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Checking free-disk space of '<em style='color: #0b33b5;'>/data/production_mysql</em>'.
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Detected memory: 15.51 GiB.
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Detecting total memory.
    [18:49:21]:Loaded template '<em style='color: #007e18;'>/usr/share/cmon/templates/my.cnf.repl57</em>'.
    [18:49:21]:Using config template '<em style='color: #007e18;'>my.cnf.repl57</em>' from '<em style='color: #0b33b5;'>/usr/share/cmon/templates</em>'.
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Using template '<em style='color: #007e18;'>my.cnf.repl57</em>'.
    [18:49:21]:Cluster type is '<strong style='color: #59a449;'>replication</strong>'.
    [18:49:21]:Not using <strong style='color: #59a449;'>skip_name_resolve</strong>, as there is a hostname in the servers list.
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>: Verifying helper packages (checking '<strong style='color: #110679;'>socat</strong>').
    [18:49:21]:<em style='color: #f3990b;'>juggernaut2</em>: Finished with helper packages.
    [18:49:19]:<em style='color: #f3990b;'>juggernaut2</em>: Upgrading <strong style='color: #110679;'>openssl openssl-libs</strong>.
    [18:49:12]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>openssl</strong>.
    [18:49:06]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>tar</strong>.
    [18:49:05]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>iproute2</strong>.
    [18:49:04]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>bzip2</strong>.
    [18:49:03]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>pigz</strong>.
    [18:49:02]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>gnupg2</strong>.
    [18:48:56]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>curl</strong>.
    [18:48:54]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>wget</strong>.
    [18:48:53]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>libevent</strong>.
    [18:48:52]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>libaio</strong>.
    [18:48:47]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>rsync</strong>.
    [18:48:46]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>psmisc</strong>.
    [18:48:44]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper-Names</strong>.
    [18:48:43]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>which</strong>.
    [18:48:42]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper</strong>.
    [18:48:41]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>socat</strong>.
    [18:48:36]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>nc</strong>.
    [18:48:35]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>netcat</strong>.
    [18:48:33]:<em style='color: #f3990b;'>juggernaut2</em>: Installing <strong style='color: #110679;'>net-tools</strong>.
    [18:48:26]:<em style='color: #f3990b;'>juggernaut2</em>: Upgrading ca-certificates.
    [18:48:18]:<em style='color: #f3990b;'>juggernaut2</em>: Upgrading nss.
    [18:48:18]:<em style='color: #f3990b;'>juggernaut2</em>: Installing helper packages.
    [18:48:17]:<em style='color: #f3990b;'>juggernaut2</em>: Setting <strong style='color: #59a449;'>vm.swappiness</strong> = 1.
    [18:48:17]:<em style='color: #f3990b;'>juggernaut2</em>: Tuning OS parameters.
    [18:48:17]:<em style='color: #f3990b;'>juggernaut2</em>: Flushing iptables.
    [18:48:16]:<em style='color: #f3990b;'>juggernaut2</em>: Disabling firewalld.
    [18:48:15]:<em style='color: #f3990b;'>juggernaut2</em>: Checking firewall.
    [18:48:15]:<em style='color: #f3990b;'>juggernaut2</em>: vendor='centos' release='7' type='redhat'.
    [18:48:15]:<em style='color: #f3990b;'>juggernaut2</em>: Checking SELinux status (<strong style='color: #59a449;'>enabled</strong> = false).
    [18:48:14]:<em style='color: #f3990b;'>juggernaut2</em>: Check and disable AppArmor.
    [18:48:14]:Setting up server <em style='color: #f3990b;'>juggernaut2</em>:3306.
    [18:48:08]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing SET GLOBAL read_only=0
    [18:48:07]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing SET GLOBAL rpl_semi_sync_slave_enabled=1
    [18:48:06]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
    [18:48:06]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_timeout =1000
    [18:48:05]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_enabled=1
    [18:48:04]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
    [18:48:03]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Secured installation.
    [18:48:03]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing FLUSH PRIVILEGES
    [18:48:02]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing DROP DATABASE IF EXISTS test
    [18:48:01]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND authentication_string=''
    [18:48:00]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')
    [18:47:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing DELETE FROM mysql.user WHERE User=''
    [18:47:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Securing installation.
    [18:47:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: MySQL is installed and started.
    [18:47:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
    [18:47:48]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Setting the MySQL root password.
    [18:47:48]:<em style='color: #1abc9c;'>juggernaut</em>: Server responded to 'mysqladmin ping'
    [18:47:48]:<em style='color: #1abc9c;'>juggernaut</em>: service status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Mon 2018-06-25 18:47:46 CDT; 1s ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Main PID: 1734 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-1734 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 25 18:47:45 juggernaut systemd[1]: Starting MySQL Server...
    Jun 25 18:47:46 juggernaut systemd[1]: Started MySQL Server.
    [18:47:47]:<em style='color: #1abc9c;'>juggernaut</em>: Started MySQL daemon.
    [18:47:47]:<em style='color: #1abc9c;'>juggernaut</em>: MySQL status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Mon 2018-06-25 18:47:46 CDT; 540ms ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 1731 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
    Process: 1729 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 1734 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-1734 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 25 18:47:45 juggernaut systemd[1]: Starting MySQL Server...
    Jun 25 18:47:46 juggernaut systemd[1]: Started MySQL Server.

    [18:47:42]:<em style='color: #1abc9c;'>juggernaut</em>: This may take a while to initialize.
    [18:47:42]:<em style='color: #1abc9c;'>juggernaut</em>: (service='mysqld', vendor='oracle', OS=['centos', '7.4.1708']).
    [18:47:42]:<em style='color: #1abc9c;'>juggernaut</em>: Starting MySQL daemon.
    [18:47:40]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Searching and removing '<em style='color: #007e18;'>/root/.my.cnf</em>'.
    [18:47:40]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Searching and removing '<em style='color: #007e18;'>/usr/my.cnf</em>'.
    [18:47:40]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Installed MySQL system tables.
    [18:47:40]:<em style='color: #1abc9c;'>juggernaut</em>:3306: /usr/sbin/mysqld --initialize-insecure: ok.
    [18:47:32]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Installing MySQL system tables.
    [18:47:31]:Writing file '<em style='color: #1abc9c;'>juggernaut</em>:<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'
    [18:47:30]:Writing file '<em style='color: #1abc9c;'>juggernaut</em>:<em style='color: #007e18;'>/etc/my.cnf</em>'
    [18:47:30]:Data directory is '<em style='color: #0b33b5;'>/data/production_mysql</em>', ok.
    [18:47:30]:Base directory is '<em style='color: #0b33b5;'>/usr/</em>', ok.
    [18:47:30]:Checking MySql configuration file(s).
    [18:47:30]:Preparing backup secrets config file '<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'.
    [18:47:30]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Uploading the generated <em style='color: #007e18;'>my.cnf</em>.
    [18:47:25]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Verifying the MySQL installation.
    [18:47:24]:<em style='color: #1abc9c;'>juggernaut</em>:3306: post-installation for oracle.
    [18:46:02]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Installing Oracle(tm) (replication) redhat
    [18:46:02]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Installing the MySQL packages.
    [18:45:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Prepare MySQL environment (user/group).
    [18:45:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Cleaning old MySql packages: Repository mysql-connectors-community is listed more than once in the configuration
    Repository mysql-tools-community is listed more than once in the configuration
    Repository mysql55-community is listed more than once in the configuration
    Repository mysql56-community is listed more than once in the configuration
    Repository mysql57-community is listed more than once in the configuration
    No Match for argument: MySQL*
    No Match for argument: mysql-5.6-pkg-list
    No Match for argument: mysql-cmds
    No Match for argument: mysql-tuning
    No Match for argument: mysql80-community-release-el7-1.noarch.rpm
    No Match for argument: Percona*
    No Match for argument: MariaDB*
    No Match for argument: mariadb*
    No Match for argument: galera*
    No Match for argument: galera
    warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave

    [18:45:29]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Removing old MySQL packages from the host.
    [18:44:59]:<em style='color: #1abc9c;'>juggernaut</em>: Using external repositories.
    [18:44:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Total disk space: 37164 MB.
    [18:44:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Detected free disk space: 36.23 GiB.
    [18:44:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Checking free-disk space of '<em style='color: #0b33b5;'>/data/production_mysql</em>'.
    [18:44:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Detected memory: 15.51 GiB.
    [18:44:59]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Detecting total memory.
    [18:44:59]:Loaded template '<em style='color: #007e18;'>/usr/share/cmon/templates/my.cnf.repl57</em>'.
    [18:44:59]:Using config template '<em style='color: #007e18;'>my.cnf.repl57</em>' from '<em style='color: #0b33b5;'>/usr/share/cmon/templates</em>'.
    [18:44:58]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Using template '<em style='color: #007e18;'>my.cnf.repl57</em>'.
    [18:44:58]:Cluster type is '<strong style='color: #59a449;'>replication</strong>'.
    [18:44:58]:Not using <strong style='color: #59a449;'>skip_name_resolve</strong>, as there is a hostname in the servers list.
    [18:44:58]:<em style='color: #1abc9c;'>juggernaut</em>: Verifying helper packages (checking '<strong style='color: #110679;'>socat</strong>').
    [18:44:58]:<em style='color: #1abc9c;'>juggernaut</em>: Finished with helper packages.
    [18:44:53]:<em style='color: #1abc9c;'>juggernaut</em>: Upgrading <strong style='color: #110679;'>openssl openssl-libs</strong>.
    [18:44:42]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>openssl</strong>.
    [18:44:34]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>tar</strong>.
    [18:44:30]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>iproute2</strong>.
    [18:44:26]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>bzip2</strong>.
    [18:44:22]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>pigz</strong>.
    [18:44:18]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>gnupg2</strong>.
    [18:44:08]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>curl</strong>.
    [18:44:04]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>wget</strong>.
    [18:44:01]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>libevent</strong>.
    [18:43:57]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>libaio</strong>.
    [18:43:48]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>rsync</strong>.
    [18:43:44]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>psmisc</strong>.
    [18:43:40]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper-Names</strong>.
    [18:43:36]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>which</strong>.
    [18:43:32]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper</strong>.
    [18:43:28]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>socat</strong>.
    [18:43:20]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>nc</strong>.
    [18:43:16]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>netcat</strong>.
    [18:43:11]:<em style='color: #1abc9c;'>juggernaut</em>: Installing <strong style='color: #110679;'>net-tools</strong>.
    [18:43:00]:<em style='color: #1abc9c;'>juggernaut</em>: Upgrading ca-certificates.
    [18:42:49]:<em style='color: #1abc9c;'>juggernaut</em>: Upgrading nss.
    [18:42:49]:<em style='color: #1abc9c;'>juggernaut</em>: Installing helper packages.
    [18:42:49]:<em style='color: #1abc9c;'>juggernaut</em>: Setting <strong style='color: #59a449;'>vm.swappiness</strong> = 1.
    [18:42:49]:<em style='color: #1abc9c;'>juggernaut</em>: Tuning OS parameters.
    [18:42:49]:<em style='color: #1abc9c;'>juggernaut</em>: Flushing iptables.
    [18:42:48]:<em style='color: #1abc9c;'>juggernaut</em>: Disabling firewalld.
    [18:42:46]:<em style='color: #1abc9c;'>juggernaut</em>: Checking firewall.
    [18:42:46]:<em style='color: #1abc9c;'>juggernaut</em>: vendor='centos' release='7' type='redhat'.
    [18:42:46]:<em style='color: #1abc9c;'>juggernaut</em>: Checking SELinux status (<strong style='color: #59a449;'>enabled</strong> = false).
    [18:42:46]:<em style='color: #1abc9c;'>juggernaut</em>: Check and disable AppArmor.
    [18:42:46]:Setting up server <em style='color: #1abc9c;'>juggernaut</em>:3306.
    [18:42:46]:Found replication link 1: <em style='color: #f3990b;'>juggernaut2</em> -> <em style='color: #1abc9c;'>juggernaut</em>.
    [18:42:46]:Found replication link 0: <em style='color: #1abc9c;'>juggernaut</em> -> <em style='color: #f3990b;'>juggernaut2</em>.
    [18:42:45]:<em style='color: #f3990b;'>juggernaut2</em>:3306: Checking if host already exists in another cluster.
    [18:42:45]:<em style='color: #1abc9c;'>juggernaut</em>:3306: Checking if host already exists in another cluster.
    [18:42:45]:All 2 hosts are accessible by SSH.
    [18:42:45]:<em style='color: #f3990b;'>juggernaut2</em>: Access with ssh/sudo granted.
    [18:42:44]:<em style='color: #1abc9c;'>juggernaut</em>: Access with ssh/sudo granted.
    [18:42:44]:Checking ssh/sudo on 2 hosts.
    [18:42:44]:Verifying job parameters.

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    I will recreate the cluster after I come back from a meeting.  I appreciate your help.

    Would you try and create a master-master MySQL replication with the following and see if the database initializes correctly.  These are the parameters I added:

    • innodb_undo_tablespaces=95
    • innodb_undo_log_truncate=on
    • innodb_max_undo_log_size=2G
    • innodb_undo_logs=64
    • datadir=/data/production_mysql
    • innodb_undo_directory=/data/production_mysql/undolog
    0
    Comment actions Permalink
  • Avatar
    Johan

    I can see that the wrong template is used, but i can't reproduce it.

    Can you try again, make sure you have the template in /usr/share/cmon/templates/

    and that you refer it with the filename (not the entire path) in the Template (and make sure there are no spaces before or after).

    i recommend that you do as follows:

    1) Remove the nodes from the cluster (from the UI, you can do Manage -> Hosts, and select the mysql servers, and press Remove)
    2) Delete the cluster
    3) update clustercontrol (but i am pretty sure this is not the problem). Do the following as sudo/root:
    Redhat:  
    yum install clustercontrol-controller clustercontrol
    service cmon restart
    Ubuntu/debian:
    apt-get update apt-get install clustercontrol clustercontrol-controller
    service cmon restart
    4) Reload the UI, go to the Deployment dialog again and make sure the template filename is written correctly.

    What do you get now?

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    I'm running the community version and cannot remove the nodes that way.  I used the Node tab and Unregistered the nodes.  The secondary node's (JUGGERNAUT2) Remove Node log data:

    • [15:57:17]: Updating load balancers
    • [15:57:17]: juggernaut:3306 - Deleting user 'cmon'@'juggernaut2'.
    • [15:57:17]: Deleting user 'cmon'@'juggernaut2' from cmon db
    • [15:57:17]: juggernaut2: All processes stopped.
    • [15:57:14]: juggernaut2: Stopping MySQL service.
    • [15:57:14]: juggernaut2: Stopping processes without the process manager: mysqld_safe;mysqld;rsync;mysqlchk;xtrabackup;innobackupex;wsrep_sst_xtrabackup;wsrep_sst_xtrabackup-v2;wsrep_sst_mariabackup;socat;nc;wsrep_sst_rsync;innobackupex;xbstream.
    • [15:57:12]: juggernaut2: Stopping MySQL service.
    • [15:57:12]: juggernaut2: Removed MySQL server.
    • [15:57:10]: juggernaut2: All processes stopped.
    • [15:57:04]: juggernaut2: Stopping MySQL service.
    • [15:57:04]: juggernaut2:3306: Stopping mysqld (timeout=600, force stop after timeout=true).
    • [15:57:00]: juggernaut2: All processes stopped.
    • [15:56:42]: juggernaut2: Stopping MySQL service.
    • [15:56:41]: juggernaut2:3306: Stopping mysqld (timeout=180, force stop after timeout=true).
    • [15:56:41]: juggernaut2:3306: removing from cluster.
    • [15:56:41]: Removing node juggernaut2: checking job parameters.

    The primary node's (JUGGERNAUT) Remove Node log data:

    • [16:01:16]: Updating load balancers
    • [16:01:15]: Deleting user 'cmon'@'juggernaut' from cmon db
    • [16:01:15]: juggernaut: All processes stopped.
    • [16:01:13]: juggernaut: Stopping MySQL service.
    • [16:01:13]: juggernaut: Stopping processes without the process manager: mysqld_safe;mysqld;rsync;mysqlchk;xtrabackup;innobackupex;wsrep_sst_xtrabackup;wsrep_sst_xtrabackup-v2;wsrep_sst_mariabackup;socat;nc;wsrep_sst_rsync;innobackupex;xbstream.
    • [16:01:10]: juggernaut: Stopping MySQL service.
    • [16:01:10]: juggernaut: Removed MySQL server.
    • [16:01:08]: juggernaut: All processes stopped.
    • [16:01:05]: juggernaut: Stopping MySQL service.
    • [16:01:05]: juggernaut:3306: Stopping mysqld (timeout=600, force stop after timeout=true).
    • [16:01:05]: juggernaut: Will stop the read-write node in forced mode.
    • [16:01:02]: juggernaut: All processes stopped.
    • [16:00:52]: juggernaut: Stopping MySQL service.
    • [16:00:52]: juggernaut:3306: Stopping mysqld (timeout=180, force stop after timeout=true).
    • [16:00:52]: juggernaut:3306: removing from cluster.
    • [16:00:52]: Removing node juggernaut: checking job parameters.

    Re-creating the custom template right now.

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    Created cluster from scratch.  Job specs:

    {
      "command": "create_cluster",
      "job_data": {
        "api_id": "1",
        "cluster_name": "neuco-production-01",
        "cluster_type": "replication",
        "config_template": "my.cnf.neuco.repl57",
        "datadir": "/data/production_mysql",
        "db_password": "Neuco5101",
        "disable_firewall": true,
        "disable_selinux": true,
        "generate_token": true,
        "install_software": true,
        "nodes": [
          {
            "hostname": "10.1.1.17",
            "hostname_data": "10.1.1.17",
            "hostname_internal": "",
            "port": "3306"
          },
          {
            "hostname": "10.1.1.18",
            "hostname_data": "10.1.1.18",
            "hostname_internal": "",
            "port": "3306"
          }
        ],
        "port": "3306",
        "software_package": "",
        "ssh_keyfile": "/root/.ssh/id_rsa",
        "ssh_port": "22",
        "ssh_user": "root",
        "sudo_password": "",
        "topology": {
          "master_slave_links": [
            {
              "10.1.1.17": "10.1.1.18"
            },
            {
              "10.1.1.18": "10.1.1.17"
            }
          ]
        },
        "user_id": 1,
        "vendor": "oracle",
        "version": "5.7"
      }
    }

    Cluster create job log:

    [18:47:06]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Failed to change master: mysql: [Warning] Using a password on the command line interface can be insecure.
    ERROR 1777 (HY000) at line 1: CHANGE MASTER TO MASTER_AUTO_POSITION = 1 cannot be executed because @@GLOBAL.GTID_MODE = OFF.

    [18:47:05]:Setting up replication link 0: 10.1.1.17 -> 10.1.1.18
    [18:47:02]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: GRANT REPLICATION SLAVE ON *.* TO 'rpl_user'@'10.1.1.17'
    [18:47:00]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: CREATE USER 'rpl_user'@'10.1.1.17' IDENTIFIED BY 'xx xxx'
    [18:47:00]:<em style='color: #2ecc71;'>10.1.1.18</em>: using '<em style='color: #2ecc71;'>10.1.1.18</em>' for SSH connection.
    [18:47:00]:Setting up replication link 1: 10.1.1.18 -> 10.1.1.17
    [18:46:59]:<em style='color: #3498db;'>10.1.1.17</em>:3306: GRANT REPLICATION SLAVE ON *.* TO 'rpl_user'@'10.1.1.18'
    [18:46:58]:<em style='color: #3498db;'>10.1.1.17</em>:3306: CREATE USER 'rpl_user'@'10.1.1.18' IDENTIFIED BY 'xx xxx'
    [18:46:57]:<em style='color: #3498db;'>10.1.1.17</em>: using '<em style='color: #3498db;'>10.1.1.17</em>' for SSH connection.
    [18:46:57]:Setting up replication link 0: 10.1.1.17 -> 10.1.1.18
    [18:46:57]:Create users, grants.
    [18:46:57]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing SET GLOBAL rpl_semi_sync_slave_enabled=1
    [18:46:56]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
    [18:46:55]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_timeout =1000
    [18:46:54]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_enabled=1
    [18:46:53]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
    [18:46:52]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Secured installation.
    [18:46:52]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing FLUSH PRIVILEGES
    [18:46:51]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DROP DATABASE IF EXISTS test
    [18:46:51]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND authentication_string=''
    [18:46:50]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')
    [18:46:49]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DELETE FROM mysql.user WHERE User=''
    [18:46:48]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Securing installation.
    [18:46:48]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: MySQL is installed and started.
    [18:46:48]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
    [18:46:38]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Setting the MySQL root password.
    [18:46:38]:<em style='color: #2ecc71;'>10.1.1.18</em>: Server responded to 'mysqladmin ping'
    [18:46:38]:<em style='color: #2ecc71;'>10.1.1.18</em>: service status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Tue 2018-06-26 18:46:36 CDT; 1s ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Main PID: 15115 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-15115 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 26 18:46:34 juggernaut2 systemd[1]: Starting MySQL Server...
    Jun 26 18:46:36 juggernaut2 systemd[1]: Started MySQL Server.
    [18:46:37]:<em style='color: #2ecc71;'>10.1.1.18</em>: Started MySQL daemon.
    [18:46:36]:<em style='color: #2ecc71;'>10.1.1.18</em>: MySQL status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Tue 2018-06-26 18:46:36 CDT; 487ms ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 15112 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
    Process: 15090 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 15115 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-15115 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 26 18:46:34 juggernaut2 systemd[1]: Starting MySQL Server...
    Jun 26 18:46:36 juggernaut2 systemd[1]: Started MySQL Server.

    [18:46:32]:<em style='color: #2ecc71;'>10.1.1.18</em>: This may take a while to initialize.
    [18:46:32]:<em style='color: #2ecc71;'>10.1.1.18</em>: (service='mysqld', vendor='oracle', OS=['centos', '7.4.1708']).
    [18:46:32]:<em style='color: #2ecc71;'>10.1.1.18</em>: Starting MySQL daemon.
    [18:46:30]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Searching and removing '<em style='color: #007e18;'>/root/.my.cnf</em>'.
    [18:46:30]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Searching and removing '<em style='color: #007e18;'>/usr/my.cnf</em>'.
    [18:46:30]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installed MySQL system tables.
    [18:46:30]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: /usr/sbin/mysqld --initialize-insecure: ok.
    [18:46:18]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installing MySQL system tables.
    [18:46:17]:Writing file '<em style='color: #2ecc71;'>10.1.1.18</em>:<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'
    [18:46:16]:Writing file '<em style='color: #2ecc71;'>10.1.1.18</em>:<em style='color: #007e18;'>/etc/my.cnf</em>'
    [18:46:16]:Data directory is '<em style='color: #0b33b5;'>/data/production_mysql</em>', ok.
    [18:46:16]:Base directory is '<em style='color: #0b33b5;'>/usr/</em>', ok.
    [18:46:16]:Checking MySql configuration file(s).
    [18:46:16]:Preparing backup secrets config file '<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'.
    [18:46:16]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Uploading the generated <em style='color: #007e18;'>my.cnf</em>.
    [18:46:11]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Verifying the MySQL installation.
    [18:46:10]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: post-installation for oracle.
    [18:44:45]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installing Oracle(tm) (replication) redhat
    [18:44:45]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installing the MySQL packages.
    [18:44:42]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Prepare MySQL environment (user/group).
    [18:44:42]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Cleaning old MySql packages: No Match for argument: MySQL*
    No Match for argument: mysql-5.6-pkg-list
    No Match for argument: mysql-cmds
    No Match for argument: mysql80-community-release-el7-1.noarch.rpm
    No Match for argument: Percona*
    No Match for argument: MariaDB*
    No Match for argument: mariadb*
    No Match for argument: galera*
    No Match for argument: galera
    warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave

    [18:44:14]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Removing old MySQL packages from the host.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>: Using external repositories.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Total disk space: 40188 MB.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Detected free disk space: 38.07 GiB.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Checking free-disk space of '<em style='color: #0b33b5;'>/data/production_mysql</em>'.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Detected memory: 15.51 GiB.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Detecting total memory.
    [18:43:49]:Loaded template '<em style='color: #007e18;'>/usr/share/cmon/templates/my.cnf.neuco.repl57</em>'.
    [18:43:49]:Using config template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>' from '<em style='color: #0b33b5;'>/usr/share/cmon/templates</em>'.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Using template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>'.
    [18:43:49]:Cluster type is '<strong style='color: #59a449;'>replication</strong>'.
    [18:43:49]:Using <strong style='color: #59a449;'>skip_name_resolve</strong> as all servers are defined by IP.
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>: Verifying helper packages (checking '<strong style='color: #110679;'>socat</strong>').
    [18:43:49]:<em style='color: #2ecc71;'>10.1.1.18</em>: Finished with helper packages.
    [18:43:44]:<em style='color: #2ecc71;'>10.1.1.18</em>: Upgrading <strong style='color: #110679;'>openssl openssl-libs</strong>.
    [18:43:40]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>openssl</strong>.
    [18:43:36]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>tar</strong>.
    [18:43:32]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>iproute2</strong>.
    [18:43:28]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>bzip2</strong>.
    [18:43:24]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>pigz</strong>.
    [18:43:20]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>gnupg2</strong>.
    [18:43:16]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>curl</strong>.
    [18:43:12]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>wget</strong>.
    [18:43:09]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>libevent</strong>.
    [18:43:05]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>libaio</strong>.
    [18:43:01]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>rsync</strong>.
    [18:42:57]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>psmisc</strong>.
    [18:42:53]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper-Names</strong>.
    [18:42:49]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>which</strong>.
    [18:42:45]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper</strong>.
    [18:42:41]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>socat</strong>.
    [18:42:37]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>nc</strong>.
    [18:42:33]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>netcat</strong>.
    [18:42:24]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>net-tools</strong>.
    [18:42:22]:<em style='color: #2ecc71;'>10.1.1.18</em>: Upgrading ca-certificates.
    [18:42:14]:<em style='color: #2ecc71;'>10.1.1.18</em>: Upgrading nss.
    [18:42:14]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing helper packages.
    [18:42:13]:<em style='color: #2ecc71;'>10.1.1.18</em>: Setting <strong style='color: #59a449;'>vm.swappiness</strong> = 1.
    [18:42:13]:<em style='color: #2ecc71;'>10.1.1.18</em>: Tuning OS parameters.
    [18:42:13]:<em style='color: #2ecc71;'>10.1.1.18</em>: Flushing iptables.
    [18:42:12]:<em style='color: #2ecc71;'>10.1.1.18</em>: Disabling firewalld.
    [18:42:11]:<em style='color: #2ecc71;'>10.1.1.18</em>: Checking firewall.
    [18:42:11]:<em style='color: #2ecc71;'>10.1.1.18</em>: vendor='centos' release='7' type='redhat'.
    [18:42:11]:<em style='color: #2ecc71;'>10.1.1.18</em>: Checking SELinux status (<strong style='color: #59a449;'>enabled</strong> = false).
    [18:42:10]:<em style='color: #2ecc71;'>10.1.1.18</em>: Check and disable AppArmor.
    [18:42:10]:Setting up server <em style='color: #2ecc71;'>10.1.1.18</em>:3306.
    [18:42:09]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL read_only=0
    [18:42:08]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL rpl_semi_sync_slave_enabled=1
    [18:42:08]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
    [18:42:07]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_timeout =1000
    [18:42:06]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_enabled=1
    [18:42:05]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
    [18:42:04]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Secured installation.
    [18:42:04]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing FLUSH PRIVILEGES
    [18:42:03]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DROP DATABASE IF EXISTS test
    [18:42:02]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND authentication_string=''
    [18:42:01]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')
    [18:42:01]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DELETE FROM mysql.user WHERE User=''
    [18:42:00]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Securing installation.
    [18:42:00]:<em style='color: #3498db;'>10.1.1.17</em>:3306: MySQL is installed and started.
    [18:42:00]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
    [18:41:49]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Setting the MySQL root password.
    [18:41:49]:<em style='color: #3498db;'>10.1.1.17</em>: Server responded to 'mysqladmin ping'
    [18:41:49]:<em style='color: #3498db;'>10.1.1.17</em>: service status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Tue 2018-06-26 18:41:48 CDT; 1s ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Main PID: 31440 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-31440 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 26 18:41:46 juggernaut systemd[1]: Starting MySQL Server...
    Jun 26 18:41:48 juggernaut systemd[1]: Started MySQL Server.
    [18:41:49]:<em style='color: #3498db;'>10.1.1.17</em>: Started MySQL daemon.
    [18:41:48]:<em style='color: #3498db;'>10.1.1.17</em>: MySQL status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Tue 2018-06-26 18:41:48 CDT; 479ms ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 31437 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
    Process: 31435 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 31440 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-31440 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 26 18:41:46 juggernaut systemd[1]: Starting MySQL Server...
    Jun 26 18:41:48 juggernaut systemd[1]: Started MySQL Server.

    [18:41:44]:<em style='color: #3498db;'>10.1.1.17</em>: This may take a while to initialize.
    [18:41:44]:<em style='color: #3498db;'>10.1.1.17</em>: (service='mysqld', vendor='oracle', OS=['centos', '7.4.1708']).
    [18:41:44]:<em style='color: #3498db;'>10.1.1.17</em>: Starting MySQL daemon.
    [18:41:42]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Searching and removing '<em style='color: #007e18;'>/root/.my.cnf</em>'.
    [18:41:42]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Searching and removing '<em style='color: #007e18;'>/usr/my.cnf</em>'.
    [18:41:42]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installed MySQL system tables.
    [18:41:42]:<em style='color: #3498db;'>10.1.1.17</em>:3306: /usr/sbin/mysqld --initialize-insecure: ok.
    [18:41:28]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installing MySQL system tables.
    [18:41:27]:Writing file '<em style='color: #3498db;'>10.1.1.17</em>:<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'
    [18:41:26]:Writing file '<em style='color: #3498db;'>10.1.1.17</em>:<em style='color: #007e18;'>/etc/my.cnf</em>'
    [18:41:26]:Data directory is '<em style='color: #0b33b5;'>/data/production_mysql</em>', ok.
    [18:41:26]:Base directory is '<em style='color: #0b33b5;'>/usr/</em>', ok.
    [18:41:26]:Checking MySql configuration file(s).
    [18:41:26]:Preparing backup secrets config file '<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'.
    [18:41:26]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Uploading the generated <em style='color: #007e18;'>my.cnf</em>.
    [18:41:21]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Verifying the MySQL installation.
    [18:41:20]:<em style='color: #3498db;'>10.1.1.17</em>:3306: post-installation for oracle.
    [18:39:54]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installing Oracle(tm) (replication) redhat
    [18:39:54]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installing the MySQL packages.
    [18:39:52]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Prepare MySQL environment (user/group).
    [18:39:52]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Cleaning old MySql packages: No Match for argument: MySQL*
    No Match for argument: mysql-5.6-pkg-list
    No Match for argument: mysql-cmds
    No Match for argument: mysql-tuning
    No Match for argument: mysql80-community-release-el7-1.noarch.rpm
    No Match for argument: Percona*
    No Match for argument: MariaDB*
    No Match for argument: mariadb*
    No Match for argument: galera*
    No Match for argument: galera
    warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave

    [18:39:22]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Removing old MySQL packages from the host.
    [18:38:56]:<em style='color: #3498db;'>10.1.1.17</em>: Using external repositories.
    [18:38:56]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Total disk space: 37164 MB.
    [18:38:56]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Detected free disk space: 35.12 GiB.
    [18:38:55]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Checking free-disk space of '<em style='color: #0b33b5;'>/data/production_mysql</em>'.
    [18:38:55]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Detected memory: 15.51 GiB.
    [18:38:55]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Detecting total memory.
    [18:38:55]:Loaded template '<em style='color: #007e18;'>/usr/share/cmon/templates/my.cnf.neuco.repl57</em>'.
    [18:38:55]:Using config template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>' from '<em style='color: #0b33b5;'>/usr/share/cmon/templates</em>'.
    [18:38:55]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Using template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>'.
    [18:38:55]:Cluster type is '<strong style='color: #59a449;'>replication</strong>'.
    [18:38:55]:Using <strong style='color: #59a449;'>skip_name_resolve</strong> as all servers are defined by IP.
    [18:38:55]:<em style='color: #3498db;'>10.1.1.17</em>: Verifying helper packages (checking '<strong style='color: #110679;'>socat</strong>').
    [18:38:55]:<em style='color: #3498db;'>10.1.1.17</em>: Finished with helper packages.
    [18:38:50]:<em style='color: #3498db;'>10.1.1.17</em>: Upgrading <strong style='color: #110679;'>openssl openssl-libs</strong>.
    [18:38:46]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>openssl</strong>.
    [18:38:42]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>tar</strong>.
    [18:38:38]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>iproute2</strong>.
    [18:38:34]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>bzip2</strong>.
    [18:38:30]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>pigz</strong>.
    [18:38:26]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>gnupg2</strong>.
    [18:38:22]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>curl</strong>.
    [18:38:18]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>wget</strong>.
    [18:38:14]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>libevent</strong>.
    [18:38:10]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>libaio</strong>.
    [18:38:06]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>rsync</strong>.
    [18:38:02]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>psmisc</strong>.
    [18:37:58]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper-Names</strong>.
    [18:37:54]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>which</strong>.
    [18:37:49]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper</strong>.
    [18:37:45]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>socat</strong>.
    [18:37:41]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>nc</strong>.
    [18:37:37]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>netcat</strong>.
    [18:37:28]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>net-tools</strong>.
    [18:37:26]:<em style='color: #3498db;'>10.1.1.17</em>: Upgrading ca-certificates.
    [18:37:16]:<em style='color: #3498db;'>10.1.1.17</em>: Upgrading nss.
    [18:37:16]:<em style='color: #3498db;'>10.1.1.17</em>: Installing helper packages.
    [18:37:16]:<em style='color: #3498db;'>10.1.1.17</em>: Setting <strong style='color: #59a449;'>vm.swappiness</strong> = 1.
    [18:37:16]:<em style='color: #3498db;'>10.1.1.17</em>: Tuning OS parameters.
    [18:37:16]:<em style='color: #3498db;'>10.1.1.17</em>: Flushing iptables.
    [18:37:15]:<em style='color: #3498db;'>10.1.1.17</em>: Disabling firewalld.
    [18:37:13]:<em style='color: #3498db;'>10.1.1.17</em>: Checking firewall.
    [18:37:13]:<em style='color: #3498db;'>10.1.1.17</em>: vendor='centos' release='7' type='redhat'.
    [18:37:13]:<em style='color: #3498db;'>10.1.1.17</em>: Checking SELinux status (<strong style='color: #59a449;'>enabled</strong> = false).
    [18:37:13]:<em style='color: #3498db;'>10.1.1.17</em>: Check and disable AppArmor.
    [18:37:13]:Setting up server <em style='color: #3498db;'>10.1.1.17</em>:3306.
    [18:37:13]:Found replication link 1: <em style='color: #2ecc71;'>10.1.1.18</em> -> <em style='color: #3498db;'>10.1.1.17</em>.
    [18:37:13]:Found replication link 0: <em style='color: #3498db;'>10.1.1.17</em> -> <em style='color: #2ecc71;'>10.1.1.18</em>.
    [18:37:12]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Checking if host already exists in another cluster.
    [18:37:12]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Checking if host already exists in another cluster.
    [18:37:12]:All 2 hosts are accessible by SSH.
    [18:37:12]:<em style='color: #2ecc71;'>10.1.1.18</em>: Access with ssh/sudo granted.
    [18:37:11]:<em style='color: #3498db;'>10.1.1.17</em>: Access with ssh/sudo granted.
    [18:37:11]:Checking ssh/sudo on 2 hosts.
    [18:37:11]:Verifying job parameters.

     

    JUGGERNAUT MySQL logfile:

    [[email protected] yum.repos.d]# cat /var/log/mysql/mysqld.log
    2018-06-26T23:41:29.266818Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
    2018-06-26T18:41:29.267095-06:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2018-06-26T18:41:29.267159-06:00 0 [Note] Ignoring --secure-file-priv value as server is running with --initialize(-insecure) or --bootstrap.
    2018-06-26T18:41:29.267219-06:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22-log) starting as process 30839 ...
    2018-06-26T18:41:29.271091-06:00 0 [Note] --initialize specifed on an existing data directory.
    2018-06-26T18:41:29.274682-06:00 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768.
    2018-06-26T18:41:29.274752-06:00 0 [Note] InnoDB: PUNCH HOLE support available
    2018-06-26T18:41:29.274813-06:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2018-06-26T18:41:29.274839-06:00 0 [Note] InnoDB: Uses event mutexes
    2018-06-26T18:41:29.274855-06:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2018-06-26T18:41:29.274870-06:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2018-06-26T18:41:29.274885-06:00 0 [Note] InnoDB: Using Linux native AIO
    2018-06-26T18:41:29.275716-06:00 0 [Note] InnoDB: Number of pools: 1
    2018-06-26T18:41:29.275978-06:00 0 [Note] InnoDB: Using CPU crc32 instructions
    2018-06-26T18:41:29.280602-06:00 0 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M
    2018-06-26T18:41:29.870406-06:00 0 [Note] InnoDB: Completed initialization of buffer pool
    2018-06-26T18:41:29.937834-06:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2018-06-26T18:41:29.947896-06:00 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
    2018-06-26T18:41:29.949301-06:00 0 [Note] InnoDB: Setting file './ibdata1' size to 100 MB. Physically writing the file full; Please wait ...
    2018-06-26T18:41:29.950738-06:00 0 [Note] InnoDB: Progress in MB:
    100
    2018-06-26T18:41:30.211306-06:00 0 [Note] InnoDB: File './ibdata1' size is now 100 MB.
    2018-06-26T18:41:30.211995-06:00 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 512 MB
    2018-06-26T18:41:30.213432-06:00 0 [Note] InnoDB: Progress in MB:
    100 200 300 400 500
    2018-06-26T18:41:31.804640-06:00 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 512 MB
    2018-06-26T18:41:31.805032-06:00 0 [Note] InnoDB: Progress in MB:
    100 200 300 400 500
    2018-06-26T18:41:34.349678-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo001 did not exist: new to be created
    2018-06-26T18:41:34.349754-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo001 size to 20 MB
    2018-06-26T18:41:34.349816-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:34.373284-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo002 did not exist: new to be created
    2018-06-26T18:41:34.373346-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo002 size to 20 MB
    2018-06-26T18:41:34.373367-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:34.396919-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo003 did not exist: new to be created
    2018-06-26T18:41:34.396946-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo003 size to 20 MB
    2018-06-26T18:41:34.396959-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:34.672431-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo004 did not exist: new to be created
    2018-06-26T18:41:34.672508-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo004 size to 20 MB
    2018-06-26T18:41:34.672534-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:34.696953-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo005 did not exist: new to be created
    2018-06-26T18:41:34.697062-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo005 size to 20 MB
    2018-06-26T18:41:34.697093-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:34.944011-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo006 did not exist: new to be created
    2018-06-26T18:41:34.944072-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo006 size to 20 MB
    2018-06-26T18:41:34.944098-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:34.966876-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo007 did not exist: new to be created
    2018-06-26T18:41:34.966909-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo007 size to 20 MB
    2018-06-26T18:41:34.966922-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:34.989096-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo008 did not exist: new to be created
    2018-06-26T18:41:34.989129-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo008 size to 20 MB
    2018-06-26T18:41:34.989143-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.012696-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo009 did not exist: new to be created
    2018-06-26T18:41:35.012726-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo009 size to 20 MB
    2018-06-26T18:41:35.012740-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.035180-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo010 did not exist: new to be created
    2018-06-26T18:41:35.035214-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo010 size to 20 MB
    2018-06-26T18:41:35.035228-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.058305-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo011 did not exist: new to be created
    2018-06-26T18:41:35.058352-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo011 size to 20 MB
    2018-06-26T18:41:35.058368-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.263609-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo012 did not exist: new to be created
    2018-06-26T18:41:35.263661-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo012 size to 20 MB
    2018-06-26T18:41:35.263681-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.287764-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo013 did not exist: new to be created
    2018-06-26T18:41:35.287839-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo013 size to 20 MB
    2018-06-26T18:41:35.287863-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.312090-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo014 did not exist: new to be created
    2018-06-26T18:41:35.312190-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo014 size to 20 MB
    2018-06-26T18:41:35.312209-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.335749-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo015 did not exist: new to be created
    2018-06-26T18:41:35.335806-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo015 size to 20 MB
    2018-06-26T18:41:35.335823-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.357735-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo016 did not exist: new to be created
    2018-06-26T18:41:35.357766-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo016 size to 20 MB
    2018-06-26T18:41:35.357780-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.380046-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo017 did not exist: new to be created
    2018-06-26T18:41:35.380077-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo017 size to 20 MB
    2018-06-26T18:41:35.380091-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.402898-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo018 did not exist: new to be created
    2018-06-26T18:41:35.402945-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo018 size to 20 MB
    2018-06-26T18:41:35.402962-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.583004-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo019 did not exist: new to be created
    2018-06-26T18:41:35.583066-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo019 size to 20 MB
    2018-06-26T18:41:35.583084-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.605315-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo020 did not exist: new to be created
    2018-06-26T18:41:35.605366-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo020 size to 20 MB
    2018-06-26T18:41:35.605384-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.627778-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo021 did not exist: new to be created
    2018-06-26T18:41:35.627841-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo021 size to 20 MB
    2018-06-26T18:41:35.627860-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.650141-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo022 did not exist: new to be created
    2018-06-26T18:41:35.650191-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo022 size to 20 MB
    2018-06-26T18:41:35.650210-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.674606-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo023 did not exist: new to be created
    2018-06-26T18:41:35.674647-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo023 size to 20 MB
    2018-06-26T18:41:35.674660-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.696749-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo024 did not exist: new to be created
    2018-06-26T18:41:35.696820-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo024 size to 20 MB
    2018-06-26T18:41:35.696841-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.881496-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo025 did not exist: new to be created
    2018-06-26T18:41:35.881560-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo025 size to 20 MB
    2018-06-26T18:41:35.881578-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.903814-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo026 did not exist: new to be created
    2018-06-26T18:41:35.903862-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo026 size to 20 MB
    2018-06-26T18:41:35.903879-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.926050-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo027 did not exist: new to be created
    2018-06-26T18:41:35.926092-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo027 size to 20 MB
    2018-06-26T18:41:35.926106-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.949345-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo028 did not exist: new to be created
    2018-06-26T18:41:35.949377-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo028 size to 20 MB
    2018-06-26T18:41:35.949400-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.971431-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo029 did not exist: new to be created
    2018-06-26T18:41:35.971463-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo029 size to 20 MB
    2018-06-26T18:41:35.971476-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:35.993591-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo030 did not exist: new to be created
    2018-06-26T18:41:35.993638-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo030 size to 20 MB
    2018-06-26T18:41:35.993654-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.256861-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo031 did not exist: new to be created
    2018-06-26T18:41:36.256937-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo031 size to 20 MB
    2018-06-26T18:41:36.256959-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.280509-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo032 did not exist: new to be created
    2018-06-26T18:41:36.280608-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo032 size to 20 MB
    2018-06-26T18:41:36.280629-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.303017-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo033 did not exist: new to be created
    2018-06-26T18:41:36.303053-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo033 size to 20 MB
    2018-06-26T18:41:36.303066-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.325688-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo034 did not exist: new to be created
    2018-06-26T18:41:36.325724-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo034 size to 20 MB
    2018-06-26T18:41:36.325738-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.348853-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo035 did not exist: new to be created
    2018-06-26T18:41:36.348893-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo035 size to 20 MB
    2018-06-26T18:41:36.348907-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.371509-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo036 did not exist: new to be created
    2018-06-26T18:41:36.371563-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo036 size to 20 MB
    2018-06-26T18:41:36.371584-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.394978-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo037 did not exist: new to be created
    2018-06-26T18:41:36.395015-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo037 size to 20 MB
    2018-06-26T18:41:36.395029-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.417164-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo038 did not exist: new to be created
    2018-06-26T18:41:36.417194-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo038 size to 20 MB
    2018-06-26T18:41:36.417208-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.439018-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo039 did not exist: new to be created
    2018-06-26T18:41:36.439051-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo039 size to 20 MB
    2018-06-26T18:41:36.439065-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.461540-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo040 did not exist: new to be created
    2018-06-26T18:41:36.461595-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo040 size to 20 MB
    2018-06-26T18:41:36.461613-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.484228-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo041 did not exist: new to be created
    2018-06-26T18:41:36.484255-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo041 size to 20 MB
    2018-06-26T18:41:36.484269-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.507091-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo042 did not exist: new to be created
    2018-06-26T18:41:36.507122-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo042 size to 20 MB
    2018-06-26T18:41:36.507136-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.529427-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo043 did not exist: new to be created
    2018-06-26T18:41:36.529453-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo043 size to 20 MB
    2018-06-26T18:41:36.529467-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.685908-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo044 did not exist: new to be created
    2018-06-26T18:41:36.685969-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo044 size to 20 MB
    2018-06-26T18:41:36.685987-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.709198-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo045 did not exist: new to be created
    2018-06-26T18:41:36.709242-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo045 size to 20 MB
    2018-06-26T18:41:36.709257-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.731839-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo046 did not exist: new to be created
    2018-06-26T18:41:36.731884-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo046 size to 20 MB
    2018-06-26T18:41:36.731911-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.753586-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo047 did not exist: new to be created
    2018-06-26T18:41:36.753616-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo047 size to 20 MB
    2018-06-26T18:41:36.753630-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.775128-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo048 did not exist: new to be created
    2018-06-26T18:41:36.775164-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo048 size to 20 MB
    2018-06-26T18:41:36.775178-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:36.797043-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo049 did not exist: new to be created
    2018-06-26T18:41:36.797084-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo049 size to 20 MB
    2018-06-26T18:41:36.797100-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.215101-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo050 did not exist: new to be created
    2018-06-26T18:41:37.215171-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo050 size to 20 MB
    2018-06-26T18:41:37.215193-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.239024-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo051 did not exist: new to be created
    2018-06-26T18:41:37.239061-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo051 size to 20 MB
    2018-06-26T18:41:37.239074-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.261827-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo052 did not exist: new to be created
    2018-06-26T18:41:37.261875-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo052 size to 20 MB
    2018-06-26T18:41:37.261889-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.286950-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo053 did not exist: new to be created
    2018-06-26T18:41:37.286993-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo053 size to 20 MB
    2018-06-26T18:41:37.287009-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.311516-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo054 did not exist: new to be created
    2018-06-26T18:41:37.311563-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo054 size to 20 MB
    2018-06-26T18:41:37.311636-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.334594-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo055 did not exist: new to be created
    2018-06-26T18:41:37.334664-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo055 size to 20 MB
    2018-06-26T18:41:37.334682-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.357781-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo056 did not exist: new to be created
    2018-06-26T18:41:37.357836-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo056 size to 20 MB
    2018-06-26T18:41:37.357850-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.643601-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo057 did not exist: new to be created
    2018-06-26T18:41:37.643668-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo057 size to 20 MB
    2018-06-26T18:41:37.643694-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.666907-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo058 did not exist: new to be created
    2018-06-26T18:41:37.666965-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo058 size to 20 MB
    2018-06-26T18:41:37.666982-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.689661-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo059 did not exist: new to be created
    2018-06-26T18:41:37.689694-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo059 size to 20 MB
    2018-06-26T18:41:37.689708-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.712115-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo060 did not exist: new to be created
    2018-06-26T18:41:37.712164-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo060 size to 20 MB
    2018-06-26T18:41:37.712185-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.735002-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo061 did not exist: new to be created
    2018-06-26T18:41:37.735047-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo061 size to 20 MB
    2018-06-26T18:41:37.735071-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.757756-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo062 did not exist: new to be created
    2018-06-26T18:41:37.757822-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo062 size to 20 MB
    2018-06-26T18:41:37.757841-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.970025-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo063 did not exist: new to be created
    2018-06-26T18:41:37.970088-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo063 size to 20 MB
    2018-06-26T18:41:37.970109-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:37.993723-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo064 did not exist: new to be created
    2018-06-26T18:41:37.993757-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo064 size to 20 MB
    2018-06-26T18:41:37.993771-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.016030-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo065 did not exist: new to be created
    2018-06-26T18:41:38.016061-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo065 size to 20 MB
    2018-06-26T18:41:38.016075-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.038221-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo066 did not exist: new to be created
    2018-06-26T18:41:38.038254-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo066 size to 20 MB
    2018-06-26T18:41:38.038305-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.060199-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo067 did not exist: new to be created
    2018-06-26T18:41:38.060232-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo067 size to 20 MB
    2018-06-26T18:41:38.060245-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.082842-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo068 did not exist: new to be created
    2018-06-26T18:41:38.082891-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo068 size to 20 MB
    2018-06-26T18:41:38.082907-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.314925-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo069 did not exist: new to be created
    2018-06-26T18:41:38.314980-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo069 size to 20 MB
    2018-06-26T18:41:38.315000-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.338398-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo070 did not exist: new to be created
    2018-06-26T18:41:38.338430-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo070 size to 20 MB
    2018-06-26T18:41:38.338444-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.362573-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo071 did not exist: new to be created
    2018-06-26T18:41:38.362621-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo071 size to 20 MB
    2018-06-26T18:41:38.362645-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.386854-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo072 did not exist: new to be created
    2018-06-26T18:41:38.386889-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo072 size to 20 MB
    2018-06-26T18:41:38.386903-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.409724-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo073 did not exist: new to be created
    2018-06-26T18:41:38.409753-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo073 size to 20 MB
    2018-06-26T18:41:38.409766-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.432662-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo074 did not exist: new to be created
    2018-06-26T18:41:38.432703-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo074 size to 20 MB
    2018-06-26T18:41:38.432718-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.455778-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo075 did not exist: new to be created
    2018-06-26T18:41:38.455831-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo075 size to 20 MB
    2018-06-26T18:41:38.455856-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.589121-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo076 did not exist: new to be created
    2018-06-26T18:41:38.589172-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo076 size to 20 MB
    2018-06-26T18:41:38.589189-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.612169-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo077 did not exist: new to be created
    2018-06-26T18:41:38.612198-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo077 size to 20 MB
    2018-06-26T18:41:38.612212-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.634574-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo078 did not exist: new to be created
    2018-06-26T18:41:38.634614-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo078 size to 20 MB
    2018-06-26T18:41:38.634630-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.657533-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo079 did not exist: new to be created
    2018-06-26T18:41:38.657567-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo079 size to 20 MB
    2018-06-26T18:41:38.657580-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.680415-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo080 did not exist: new to be created
    2018-06-26T18:41:38.680443-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo080 size to 20 MB
    2018-06-26T18:41:38.680456-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.703126-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo081 did not exist: new to be created
    2018-06-26T18:41:38.703155-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo081 size to 20 MB
    2018-06-26T18:41:38.703168-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.941352-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo082 did not exist: new to be created
    2018-06-26T18:41:38.941405-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo082 size to 20 MB
    2018-06-26T18:41:38.941421-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.964111-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo083 did not exist: new to be created
    2018-06-26T18:41:38.964142-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo083 size to 20 MB
    2018-06-26T18:41:38.964155-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:38.986382-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo084 did not exist: new to be created
    2018-06-26T18:41:38.986412-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo084 size to 20 MB
    2018-06-26T18:41:38.986426-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.008860-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo085 did not exist: new to be created
    2018-06-26T18:41:39.008892-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo085 size to 20 MB
    2018-06-26T18:41:39.008906-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.031941-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo086 did not exist: new to be created
    2018-06-26T18:41:39.031984-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo086 size to 20 MB
    2018-06-26T18:41:39.032005-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.054309-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo087 did not exist: new to be created
    2018-06-26T18:41:39.054355-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo087 size to 20 MB
    2018-06-26T18:41:39.054390-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.307504-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo088 did not exist: new to be created
    2018-06-26T18:41:39.307567-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo088 size to 20 MB
    2018-06-26T18:41:39.307588-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.330951-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo089 did not exist: new to be created
    2018-06-26T18:41:39.330993-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo089 size to 20 MB
    2018-06-26T18:41:39.331010-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.353885-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo090 did not exist: new to be created
    2018-06-26T18:41:39.353926-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo090 size to 20 MB
    2018-06-26T18:41:39.354507-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.376641-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo091 did not exist: new to be created
    2018-06-26T18:41:39.376675-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo091 size to 20 MB
    2018-06-26T18:41:39.376688-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.398737-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo092 did not exist: new to be created
    2018-06-26T18:41:39.398765-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo092 size to 20 MB
    2018-06-26T18:41:39.398778-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.420908-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo093 did not exist: new to be created
    2018-06-26T18:41:39.420950-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo093 size to 20 MB
    2018-06-26T18:41:39.420965-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.654005-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo094 did not exist: new to be created
    2018-06-26T18:41:39.654066-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo094 size to 20 MB
    2018-06-26T18:41:39.654090-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.677818-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo095 did not exist: new to be created
    2018-06-26T18:41:39.677851-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo095 size to 20 MB
    2018-06-26T18:41:39.677865-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:41:39.708598-06:00 0 [Note] InnoDB: Opened 95 undo tablespaces
    2018-06-26T18:41:39.708632-06:00 0 [Note] InnoDB: 0 undo tablespaces made active
    2018-06-26T18:41:39.860857-06:00 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
    2018-06-26T18:41:39.860986-06:00 0 [Warning] InnoDB: New log files created, LSN=157995
    2018-06-26T18:41:39.861034-06:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2018-06-26T18:41:39.861136-06:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2018-06-26T18:41:39.876336-06:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2018-06-26T18:41:39.876565-06:00 0 [Note] InnoDB: Doublewrite buffer not found: creating new
    2018-06-26T18:41:39.895209-06:00 0 [Note] InnoDB: Doublewrite buffer created
    2018-06-26T18:41:39.895559-06:00 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
    2018-06-26T18:41:39.998819-06:00 0 [Note] InnoDB: 32 redo rollback segment(s) found. 32 redo rollback segment(s) are active.
    2018-06-26T18:41:39.998894-06:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2018-06-26T18:41:40.000116-06:00 0 [Warning] InnoDB: Creating foreign key constraint system tables.
    2018-06-26T18:41:40.003618-06:00 0 [Note] InnoDB: Foreign key constraint system tables created
    2018-06-26T18:41:40.003688-06:00 0 [Note] InnoDB: Creating tablespace and datafile system tables.
    2018-06-26T18:41:40.003981-06:00 0 [Note] InnoDB: Tablespace and datafile system tables created.
    2018-06-26T18:41:40.004033-06:00 0 [Note] InnoDB: Creating sys_virtual system tables.
    2018-06-26T18:41:40.004291-06:00 0 [Note] InnoDB: sys_virtual table created
    2018-06-26T18:41:40.004601-06:00 0 [Note] InnoDB: Waiting for purge to start
    2018-06-26T18:41:40.054758-06:00 0 [Note] InnoDB: 5.7.22 started; log sequence number 0
    2018-06-26T18:41:40.054780-06:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10117ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
    2018-06-26T18:41:40.055752-06:00 0 [Note] Plugin 'FEDERATED' is disabled.
    2018-06-26T18:41:40.059592-06:00 0 [Note] Salting uuid generator variables, current_pid: 30839, server_start_time: 1530056489, bytes_sent: 0,
    2018-06-26T18:41:40.059706-06:00 0 [Note] Generated uuid: '793a6e11-799a-11e8-9627-005056a58e29', server_start_time: 8680406808310007712, bytes_sent: 196036224
    2018-06-26T18:41:40.059746-06:00 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 793a6e11-799a-11e8-9627-005056a58e29.
    2018-06-26T18:41:40.060971-06:00 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2018-06-26T18:41:40.062578-06:00 1 [Note] Creating the system database
    2018-06-26T18:41:40.062627-06:00 1 [Warning] [email protected] is created with an empty password ! Please consider switching off the --initialize-insecure option.
    2018-06-26T18:41:40.063120-06:00 1 [Note] Creating the system tables
    2018-06-26T18:41:40.352261-06:00 1 [Note] Filling in the system tables, part 1
    2018-06-26T18:41:40.354324-06:00 1 [Note] Filling in the system tables, part 2
    2018-06-26T18:41:40.354352-06:00 1 [Note] Filling in the mysql.help table
    2018-06-26T18:41:40.575217-06:00 1 [Note] Creating user for internal session service
    2018-06-26T18:41:40.576073-06:00 1 [Note] Creating the sys schema
    2018-06-26T18:41:40.576490-06:00 1 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.576522-06:00 1 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.576551-06:00 1 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.576587-06:00 1 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.576602-06:00 1 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.576626-06:00 1 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.576688-06:00 1 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.576712-06:00 1 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:40.782273-06:00 1 [Note] Bootstrapping complete
    2018-06-26T18:41:40.782999-06:00 0 [Note] Giving 0 client threads a chance to die gracefully
    2018-06-26T18:41:40.783065-06:00 0 [Note] Shutting down slave threads
    2018-06-26T18:41:40.783087-06:00 0 [Note] Forcefully disconnecting 0 remaining clients
    2018-06-26T18:41:40.783866-06:00 0 [Note] Binlog end
    2018-06-26T18:41:40.785362-06:00 0 [Note] InnoDB: FTS optimize thread exiting.
    2018-06-26T18:41:40.785582-06:00 0 [Note] InnoDB: Starting shutdown...
    2018-06-26T18:41:40.885913-06:00 0 [Note] InnoDB: Dumping buffer pool(s) to /data/production_mysql/ib_buffer_pool
    2018-06-26T18:41:40.886308-06:00 0 [Note] InnoDB: Buffer pool(s) dump completed at 180626 18:41:40
    2018-06-26T18:41:42.145773-06:00 0 [Note] InnoDB: Shutdown completed; log sequence number 2347729
    2018-06-26T18:41:42.145963-06:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2018-06-26T23:41:46.914216Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
    2018-06-26T18:41:46.914568-06:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2018-06-26T18:41:46.917742-06:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22-log) starting as process 31440 ...
    2018-06-26T18:41:46.922539-06:00 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768.
    2018-06-26T18:41:46.922653-06:00 0 [Note] InnoDB: PUNCH HOLE support available
    2018-06-26T18:41:46.922710-06:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2018-06-26T18:41:46.922739-06:00 0 [Note] InnoDB: Uses event mutexes
    2018-06-26T18:41:46.922760-06:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2018-06-26T18:41:46.922782-06:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2018-06-26T18:41:46.922825-06:00 0 [Note] InnoDB: Using Linux native AIO
    2018-06-26T18:41:46.923751-06:00 0 [Note] InnoDB: Number of pools: 1
    2018-06-26T18:41:46.924048-06:00 0 [Note] InnoDB: Using CPU crc32 instructions
    2018-06-26T18:41:46.928011-06:00 0 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M
    2018-06-26T18:41:47.480951-06:00 0 [Note] InnoDB: Completed initialization of buffer pool
    2018-06-26T18:41:47.553616-06:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2018-06-26T18:41:47.581423-06:00 0 [Note] InnoDB: Opened 95 undo tablespaces
    2018-06-26T18:41:47.581478-06:00 0 [Note] InnoDB: 31 undo tablespaces made active
    2018-06-26T18:41:47.581878-06:00 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2018-06-26T18:41:47.804276-06:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2018-06-26T18:41:47.804417-06:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2018-06-26T18:41:47.830625-06:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2018-06-26T18:41:47.830897-06:00 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
    2018-06-26T18:41:47.910406-06:00 0 [Note] InnoDB: 32 redo rollback segment(s) found. 32 redo rollback segment(s) are active.
    2018-06-26T18:41:47.910461-06:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2018-06-26T18:41:47.911520-06:00 0 [Note] InnoDB: Waiting for purge to start
    2018-06-26T18:41:47.962096-06:00 0 [Note] InnoDB: 5.7.22 started; log sequence number 2347729
    2018-06-26T18:41:47.962413-06:00 0 [Note] InnoDB: Loading buffer pool(s) from /data/production_mysql/ib_buffer_pool
    2018-06-26T18:41:47.962703-06:00 0 [Note] Plugin 'FEDERATED' is disabled.
    2018-06-26T18:41:47.979232-06:00 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
    2018-06-26T18:41:47.979291-06:00 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2018-06-26T18:41:47.979376-06:00 0 [Note] IPv6 is available.
    2018-06-26T18:41:47.979427-06:00 0 [Note] - '::' resolves to '::';
    2018-06-26T18:41:47.979569-06:00 0 [Note] Server socket created on IP: '::'.
    2018-06-26T18:41:47.982834-06:00 0 [Note] InnoDB: Buffer pool(s) load completed at 180626 18:41:47
    2018-06-26T18:41:47.984433-06:00 0 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:47.984527-06:00 0 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:47.984574-06:00 0 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:47.984647-06:00 0 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:47.984671-06:00 0 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:47.984710-06:00 0 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:47.989331-06:00 0 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:47.989373-06:00 0 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:48.007346-06:00 0 [Note] Event Scheduler: Loaded 0 events
    2018-06-26T18:41:48.007660-06:00 0 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.7.22-log' socket: '/data/production_mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
    2018-06-26T18:41:52.146551-06:00 5 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:52.146631-06:00 5 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:52.146654-06:00 5 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:52.146693-06:00 5 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:52.146707-06:00 5 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:52.146735-06:00 5 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:52.147089-06:00 5 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:52.147117-06:00 5 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811057-06:00 8 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811131-06:00 8 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811153-06:00 8 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811197-06:00 8 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811216-06:00 8 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811245-06:00 8 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811646-06:00 8 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:54.811675-06:00 8 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.455523-06:00 11 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.455628-06:00 11 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.455664-06:00 11 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.455719-06:00 11 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.455736-06:00 11 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.455765-06:00 11 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.456142-06:00 11 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:41:57.456186-06:00 11 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:00.121571-06:00 14 [Note] Plugin mysqlx reported: 'Scheduler "work" started.'
    2018-06-26T18:42:00.121884-06:00 14 [Note] Plugin mysqlx reported: 'Scheduler "network" started.'
    2018-06-26T18:42:00.122561-06:00 0 [Note] Plugin mysqlx reported: 'Neither MySQL Server nor Mysqlx Plugin has valid SSL configuration'
    2018-06-26T18:42:00.122652-06:00 0 [Warning] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'
    2018-06-26T18:42:00.122688-06:00 0 [Note] Plugin mysqlx reported: 'For more information, please see the Using Secure Connections with X Plugin section in the MySQL documentation.'
    2018-06-26T18:42:00.122858-06:00 0 [Note] Plugin mysqlx reported: 'IPv6 is available'
    2018-06-26T18:42:00.123046-06:00 0 [Note] Plugin mysqlx reported: 'X Plugin listens on TCP (bind-address:'::', port:33060)'
    2018-06-26T18:42:00.123066-06:00 0 [Note] Plugin mysqlx reported: 'X Plugin listens on UNIX socket (/var/run/mysqld/mysqlx.sock)'
    2018-06-26T18:42:00.123101-06:00 0 [Note] Plugin mysqlx reported: 'Server starts handling incoming connections'
    2018-06-26T18:42:04.413009-06:00 20 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:04.413115-06:00 20 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:04.413139-06:00 20 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:04.413189-06:00 20 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:04.413205-06:00 20 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:04.413235-06:00 20 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:04.413312-06:00 20 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:04.413337-06:00 20 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:42:06.114318-06:00 22 [Note] Semi-sync replication initialized for transactions.
    2018-06-26T18:42:06.114368-06:00 22 [Note] Semi-sync replication enabled on the master.
    2018-06-26T18:42:06.114500-06:00 0 [Note] Starting ack receiver thread
    2018-06-26T18:46:59.735469-06:00 27 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000002, pos: 2574), semi-sync up to file , position 0.
    2018-06-26T18:46:59.735542-06:00 27 [Note] Semi-sync replication switched OFF.

     

    JUGGERNAUT2 MySQL log file:

    [[email protected] ~]# cat /var/log/mysql/mysqld.log
    2018-06-26T23:46:18.655433Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
    2018-06-26T18:46:18.655642-06:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2018-06-26T18:46:18.655699-06:00 0 [Note] Ignoring --secure-file-priv value as server is running with --initialize(-insecure) or --bootstrap.
    2018-06-26T18:46:18.655769-06:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22-log) starting as process 14493 ...
    2018-06-26T18:46:18.658146-06:00 0 [Note] --initialize specifed on an existing data directory.
    2018-06-26T18:46:18.661343-06:00 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768.
    2018-06-26T18:46:18.661449-06:00 0 [Note] InnoDB: PUNCH HOLE support available
    2018-06-26T18:46:18.661505-06:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2018-06-26T18:46:18.661528-06:00 0 [Note] InnoDB: Uses event mutexes
    2018-06-26T18:46:18.661541-06:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2018-06-26T18:46:18.661553-06:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2018-06-26T18:46:18.661565-06:00 0 [Note] InnoDB: Using Linux native AIO
    2018-06-26T18:46:18.662398-06:00 0 [Note] InnoDB: Number of pools: 1
    2018-06-26T18:46:18.662700-06:00 0 [Note] InnoDB: Using CPU crc32 instructions
    2018-06-26T18:46:18.666855-06:00 0 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M
    2018-06-26T18:46:19.195488-06:00 0 [Note] InnoDB: Completed initialization of buffer pool
    2018-06-26T18:46:19.272310-06:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2018-06-26T18:46:19.282404-06:00 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
    2018-06-26T18:46:19.283825-06:00 0 [Note] InnoDB: Setting file './ibdata1' size to 100 MB. Physically writing the file full; Please wait ...
    2018-06-26T18:46:19.285366-06:00 0 [Note] InnoDB: Progress in MB:
    100
    2018-06-26T18:46:19.385552-06:00 0 [Note] InnoDB: File './ibdata1' size is now 100 MB.
    2018-06-26T18:46:19.386305-06:00 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 512 MB
    2018-06-26T18:46:19.387923-06:00 0 [Note] InnoDB: Progress in MB:
    100 200 300 400 500
    2018-06-26T18:46:20.827453-06:00 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 512 MB
    2018-06-26T18:46:20.827821-06:00 0 [Note] InnoDB: Progress in MB:
    100 200 300 400 500
    2018-06-26T18:46:22.826518-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo001 did not exist: new to be created
    2018-06-26T18:46:22.826565-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo001 size to 20 MB
    2018-06-26T18:46:22.826597-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:22.848473-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo002 did not exist: new to be created
    2018-06-26T18:46:22.848513-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo002 size to 20 MB
    2018-06-26T18:46:22.848529-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:22.871200-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo003 did not exist: new to be created
    2018-06-26T18:46:22.871249-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo003 size to 20 MB
    2018-06-26T18:46:22.871283-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:22.893312-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo004 did not exist: new to be created
    2018-06-26T18:46:22.893339-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo004 size to 20 MB
    2018-06-26T18:46:22.893353-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:22.915767-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo005 did not exist: new to be created
    2018-06-26T18:46:22.915803-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo005 size to 20 MB
    2018-06-26T18:46:22.915818-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.100250-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo006 did not exist: new to be created
    2018-06-26T18:46:23.100320-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo006 size to 20 MB
    2018-06-26T18:46:23.100336-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.122316-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo007 did not exist: new to be created
    2018-06-26T18:46:23.122346-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo007 size to 20 MB
    2018-06-26T18:46:23.122360-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.144280-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo008 did not exist: new to be created
    2018-06-26T18:46:23.144310-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo008 size to 20 MB
    2018-06-26T18:46:23.144324-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.166558-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo009 did not exist: new to be created
    2018-06-26T18:46:23.166597-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo009 size to 20 MB
    2018-06-26T18:46:23.166621-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.188495-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo010 did not exist: new to be created
    2018-06-26T18:46:23.188534-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo010 size to 20 MB
    2018-06-26T18:46:23.188552-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.210312-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo011 did not exist: new to be created
    2018-06-26T18:46:23.210351-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo011 size to 20 MB
    2018-06-26T18:46:23.210367-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.232081-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo012 did not exist: new to be created
    2018-06-26T18:46:23.232117-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo012 size to 20 MB
    2018-06-26T18:46:23.232136-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.563091-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo013 did not exist: new to be created
    2018-06-26T18:46:23.563145-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo013 size to 20 MB
    2018-06-26T18:46:23.563161-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.585374-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo014 did not exist: new to be created
    2018-06-26T18:46:23.585428-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo014 size to 20 MB
    2018-06-26T18:46:23.585444-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.608220-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo015 did not exist: new to be created
    2018-06-26T18:46:23.608246-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo015 size to 20 MB
    2018-06-26T18:46:23.608274-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.630468-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo016 did not exist: new to be created
    2018-06-26T18:46:23.630495-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo016 size to 20 MB
    2018-06-26T18:46:23.630508-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.652303-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo017 did not exist: new to be created
    2018-06-26T18:46:23.652331-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo017 size to 20 MB
    2018-06-26T18:46:23.652344-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.674516-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo018 did not exist: new to be created
    2018-06-26T18:46:23.674558-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo018 size to 20 MB
    2018-06-26T18:46:23.674856-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.810861-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo019 did not exist: new to be created
    2018-06-26T18:46:23.810933-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo019 size to 20 MB
    2018-06-26T18:46:23.810954-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.833870-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo020 did not exist: new to be created
    2018-06-26T18:46:23.833913-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo020 size to 20 MB
    2018-06-26T18:46:23.833939-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.856035-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo021 did not exist: new to be created
    2018-06-26T18:46:23.856062-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo021 size to 20 MB
    2018-06-26T18:46:23.856075-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.878137-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo022 did not exist: new to be created
    2018-06-26T18:46:23.878175-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo022 size to 20 MB
    2018-06-26T18:46:23.878191-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.900300-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo023 did not exist: new to be created
    2018-06-26T18:46:23.900329-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo023 size to 20 MB
    2018-06-26T18:46:23.900342-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:23.922395-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo024 did not exist: new to be created
    2018-06-26T18:46:23.922424-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo024 size to 20 MB
    2018-06-26T18:46:23.922438-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.217755-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo025 did not exist: new to be created
    2018-06-26T18:46:24.217822-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo025 size to 20 MB
    2018-06-26T18:46:24.217839-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.240749-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo026 did not exist: new to be created
    2018-06-26T18:46:24.240799-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo026 size to 20 MB
    2018-06-26T18:46:24.240821-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.263147-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo027 did not exist: new to be created
    2018-06-26T18:46:24.263184-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo027 size to 20 MB
    2018-06-26T18:46:24.263199-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.285712-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo028 did not exist: new to be created
    2018-06-26T18:46:24.285739-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo028 size to 20 MB
    2018-06-26T18:46:24.285762-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.307801-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo029 did not exist: new to be created
    2018-06-26T18:46:24.307829-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo029 size to 20 MB
    2018-06-26T18:46:24.307843-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.329997-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo030 did not exist: new to be created
    2018-06-26T18:46:24.330041-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo030 size to 20 MB
    2018-06-26T18:46:24.330060-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.353239-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo031 did not exist: new to be created
    2018-06-26T18:46:24.353290-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo031 size to 20 MB
    2018-06-26T18:46:24.353305-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.479444-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo032 did not exist: new to be created
    2018-06-26T18:46:24.479495-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo032 size to 20 MB
    2018-06-26T18:46:24.479511-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.616382-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo033 did not exist: new to be created
    2018-06-26T18:46:24.616483-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo033 size to 20 MB
    2018-06-26T18:46:24.616499-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.677338-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo034 did not exist: new to be created
    2018-06-26T18:46:24.677396-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo034 size to 20 MB
    2018-06-26T18:46:24.677413-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.701590-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo035 did not exist: new to be created
    2018-06-26T18:46:24.701620-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo035 size to 20 MB
    2018-06-26T18:46:24.701634-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.724099-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo036 did not exist: new to be created
    2018-06-26T18:46:24.724140-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo036 size to 20 MB
    2018-06-26T18:46:24.724155-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.746801-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo037 did not exist: new to be created
    2018-06-26T18:46:24.746830-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo037 size to 20 MB
    2018-06-26T18:46:24.746854-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.769231-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo038 did not exist: new to be created
    2018-06-26T18:46:24.769286-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo038 size to 20 MB
    2018-06-26T18:46:24.769311-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.791371-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo039 did not exist: new to be created
    2018-06-26T18:46:24.791398-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo039 size to 20 MB
    2018-06-26T18:46:24.791411-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.813487-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo040 did not exist: new to be created
    2018-06-26T18:46:24.813521-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo040 size to 20 MB
    2018-06-26T18:46:24.813536-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.836290-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo041 did not exist: new to be created
    2018-06-26T18:46:24.836341-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo041 size to 20 MB
    2018-06-26T18:46:24.836362-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.870170-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo042 did not exist: new to be created
    2018-06-26T18:46:24.870200-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo042 size to 20 MB
    2018-06-26T18:46:24.870214-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:24.891764-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo043 did not exist: new to be created
    2018-06-26T18:46:24.891790-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo043 size to 20 MB
    2018-06-26T18:46:24.891803-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.133367-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo044 did not exist: new to be created
    2018-06-26T18:46:25.133419-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo044 size to 20 MB
    2018-06-26T18:46:25.133435-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.155995-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo045 did not exist: new to be created
    2018-06-26T18:46:25.156043-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo045 size to 20 MB
    2018-06-26T18:46:25.156066-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.178596-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo046 did not exist: new to be created
    2018-06-26T18:46:25.178626-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo046 size to 20 MB
    2018-06-26T18:46:25.178640-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.200599-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo047 did not exist: new to be created
    2018-06-26T18:46:25.200644-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo047 size to 20 MB
    2018-06-26T18:46:25.200669-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.223596-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo048 did not exist: new to be created
    2018-06-26T18:46:25.223630-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo048 size to 20 MB
    2018-06-26T18:46:25.223644-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.246762-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo049 did not exist: new to be created
    2018-06-26T18:46:25.246829-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo049 size to 20 MB
    2018-06-26T18:46:25.246853-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.270070-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo050 did not exist: new to be created
    2018-06-26T18:46:25.270105-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo050 size to 20 MB
    2018-06-26T18:46:25.270118-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.443011-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo051 did not exist: new to be created
    2018-06-26T18:46:25.443066-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo051 size to 20 MB
    2018-06-26T18:46:25.443082-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.466114-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo052 did not exist: new to be created
    2018-06-26T18:46:25.466165-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo052 size to 20 MB
    2018-06-26T18:46:25.466182-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.489214-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo053 did not exist: new to be created
    2018-06-26T18:46:25.489242-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo053 size to 20 MB
    2018-06-26T18:46:25.489280-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.511912-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo054 did not exist: new to be created
    2018-06-26T18:46:25.511946-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo054 size to 20 MB
    2018-06-26T18:46:25.511960-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.534382-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo055 did not exist: new to be created
    2018-06-26T18:46:25.534410-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo055 size to 20 MB
    2018-06-26T18:46:25.534424-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.556744-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo056 did not exist: new to be created
    2018-06-26T18:46:25.556783-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo056 size to 20 MB
    2018-06-26T18:46:25.556799-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.686588-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo057 did not exist: new to be created
    2018-06-26T18:46:25.686662-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo057 size to 20 MB
    2018-06-26T18:46:25.686682-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.708879-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo058 did not exist: new to be created
    2018-06-26T18:46:25.708907-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo058 size to 20 MB
    2018-06-26T18:46:25.708920-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.737678-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo059 did not exist: new to be created
    2018-06-26T18:46:25.737705-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo059 size to 20 MB
    2018-06-26T18:46:25.737719-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.759926-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo060 did not exist: new to be created
    2018-06-26T18:46:25.759966-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo060 size to 20 MB
    2018-06-26T18:46:25.759982-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.782400-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo061 did not exist: new to be created
    2018-06-26T18:46:25.782427-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo061 size to 20 MB
    2018-06-26T18:46:25.782440-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.804548-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo062 did not exist: new to be created
    2018-06-26T18:46:25.804575-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo062 size to 20 MB
    2018-06-26T18:46:25.804588-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.929681-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo063 did not exist: new to be created
    2018-06-26T18:46:25.929743-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo063 size to 20 MB
    2018-06-26T18:46:25.929761-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.952017-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo064 did not exist: new to be created
    2018-06-26T18:46:25.952066-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo064 size to 20 MB
    2018-06-26T18:46:25.952083-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.974410-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo065 did not exist: new to be created
    2018-06-26T18:46:25.974439-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo065 size to 20 MB
    2018-06-26T18:46:25.974452-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:25.997758-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo066 did not exist: new to be created
    2018-06-26T18:46:25.997788-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo066 size to 20 MB
    2018-06-26T18:46:25.997801-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.020350-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo067 did not exist: new to be created
    2018-06-26T18:46:26.020377-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo067 size to 20 MB
    2018-06-26T18:46:26.020390-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.042871-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo068 did not exist: new to be created
    2018-06-26T18:46:26.042900-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo068 size to 20 MB
    2018-06-26T18:46:26.042914-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.065041-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo069 did not exist: new to be created
    2018-06-26T18:46:26.065079-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo069 size to 20 MB
    2018-06-26T18:46:26.065102-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.349004-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo070 did not exist: new to be created
    2018-06-26T18:46:26.349061-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo070 size to 20 MB
    2018-06-26T18:46:26.349077-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.371716-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo071 did not exist: new to be created
    2018-06-26T18:46:26.371763-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo071 size to 20 MB
    2018-06-26T18:46:26.371779-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.394750-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo072 did not exist: new to be created
    2018-06-26T18:46:26.394789-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo072 size to 20 MB
    2018-06-26T18:46:26.394803-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.417322-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo073 did not exist: new to be created
    2018-06-26T18:46:26.417371-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo073 size to 20 MB
    2018-06-26T18:46:26.417441-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.439854-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo074 did not exist: new to be created
    2018-06-26T18:46:26.439882-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo074 size to 20 MB
    2018-06-26T18:46:26.439895-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.461827-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo075 did not exist: new to be created
    2018-06-26T18:46:26.461871-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo075 size to 20 MB
    2018-06-26T18:46:26.461896-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.642093-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo076 did not exist: new to be created
    2018-06-26T18:46:26.642145-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo076 size to 20 MB
    2018-06-26T18:46:26.642160-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.664024-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo077 did not exist: new to be created
    2018-06-26T18:46:26.664062-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo077 size to 20 MB
    2018-06-26T18:46:26.664077-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.686138-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo078 did not exist: new to be created
    2018-06-26T18:46:26.686175-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo078 size to 20 MB
    2018-06-26T18:46:26.686196-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.708827-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo079 did not exist: new to be created
    2018-06-26T18:46:26.708862-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo079 size to 20 MB
    2018-06-26T18:46:26.708875-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.730460-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo080 did not exist: new to be created
    2018-06-26T18:46:26.730489-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo080 size to 20 MB
    2018-06-26T18:46:26.730503-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:26.752781-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo081 did not exist: new to be created
    2018-06-26T18:46:26.752832-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo081 size to 20 MB
    2018-06-26T18:46:26.752849-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.073087-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo082 did not exist: new to be created
    2018-06-26T18:46:27.073141-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo082 size to 20 MB
    2018-06-26T18:46:27.073158-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.096483-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo083 did not exist: new to be created
    2018-06-26T18:46:27.096527-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo083 size to 20 MB
    2018-06-26T18:46:27.096551-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.119778-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo084 did not exist: new to be created
    2018-06-26T18:46:27.119807-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo084 size to 20 MB
    2018-06-26T18:46:27.119832-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.141792-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo085 did not exist: new to be created
    2018-06-26T18:46:27.141819-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo085 size to 20 MB
    2018-06-26T18:46:27.141833-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.164836-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo086 did not exist: new to be created
    2018-06-26T18:46:27.164864-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo086 size to 20 MB
    2018-06-26T18:46:27.164878-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.186793-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo087 did not exist: new to be created
    2018-06-26T18:46:27.186831-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo087 size to 20 MB
    2018-06-26T18:46:27.186855-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.209531-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo088 did not exist: new to be created
    2018-06-26T18:46:27.209558-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo088 size to 20 MB
    2018-06-26T18:46:27.209571-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.594676-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo089 did not exist: new to be created
    2018-06-26T18:46:27.594728-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo089 size to 20 MB
    2018-06-26T18:46:27.594744-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.617420-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo090 did not exist: new to be created
    2018-06-26T18:46:27.617460-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo090 size to 20 MB
    2018-06-26T18:46:27.617476-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.639399-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo091 did not exist: new to be created
    2018-06-26T18:46:27.639441-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo091 size to 20 MB
    2018-06-26T18:46:27.639454-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.662208-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo092 did not exist: new to be created
    2018-06-26T18:46:27.662250-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo092 size to 20 MB
    2018-06-26T18:46:27.662279-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.686812-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo093 did not exist: new to be created
    2018-06-26T18:46:27.686853-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo093 size to 20 MB
    2018-06-26T18:46:27.686867-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.708964-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo094 did not exist: new to be created
    2018-06-26T18:46:27.709008-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo094 size to 20 MB
    2018-06-26T18:46:27.709024-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.840379-06:00 0 [Note] InnoDB: Data file /data/production_mysql/undolog/undo095 did not exist: new to be created
    2018-06-26T18:46:27.840437-06:00 0 [Note] InnoDB: Setting file /data/production_mysql/undolog/undo095 size to 20 MB
    2018-06-26T18:46:27.840454-06:00 0 [Note] InnoDB: Database physically writes the file full: wait...
    2018-06-26T18:46:27.870620-06:00 0 [Note] InnoDB: Opened 95 undo tablespaces
    2018-06-26T18:46:27.870648-06:00 0 [Note] InnoDB: 0 undo tablespaces made active
    2018-06-26T18:46:28.351715-06:00 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
    2018-06-26T18:46:28.351872-06:00 0 [Warning] InnoDB: New log files created, LSN=157995
    2018-06-26T18:46:28.351919-06:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2018-06-26T18:46:28.352014-06:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2018-06-26T18:46:28.367778-06:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2018-06-26T18:46:28.367990-06:00 0 [Note] InnoDB: Doublewrite buffer not found: creating new
    2018-06-26T18:46:28.383366-06:00 0 [Note] InnoDB: Doublewrite buffer created
    2018-06-26T18:46:28.383692-06:00 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
    2018-06-26T18:46:28.481090-06:00 0 [Note] InnoDB: 32 redo rollback segment(s) found. 32 redo rollback segment(s) are active.
    2018-06-26T18:46:28.481172-06:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2018-06-26T18:46:28.481918-06:00 0 [Warning] InnoDB: Creating foreign key constraint system tables.
    2018-06-26T18:46:28.484727-06:00 0 [Note] InnoDB: Foreign key constraint system tables created
    2018-06-26T18:46:28.484779-06:00 0 [Note] InnoDB: Creating tablespace and datafile system tables.
    2018-06-26T18:46:28.485012-06:00 0 [Note] InnoDB: Tablespace and datafile system tables created.
    2018-06-26T18:46:28.485055-06:00 0 [Note] InnoDB: Creating sys_virtual system tables.
    2018-06-26T18:46:28.485251-06:00 0 [Note] InnoDB: sys_virtual table created
    2018-06-26T18:46:28.485627-06:00 0 [Note] InnoDB: Waiting for purge to start
    2018-06-26T18:46:28.535792-06:00 0 [Note] InnoDB: 5.7.22 started; log sequence number 0
    2018-06-26T18:46:28.535969-06:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9263ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
    2018-06-26T18:46:28.536587-06:00 0 [Note] Plugin 'FEDERATED' is disabled.
    2018-06-26T18:46:28.540136-06:00 0 [Note] Salting uuid generator variables, current_pid: 14493, server_start_time: 1530056778, bytes_sent: 0,
    2018-06-26T18:46:28.540230-06:00 0 [Note] Generated uuid: '252d1096-799b-11e8-9de6-005056a5314b', server_start_time: 4079416838997608679, bytes_sent: 198010944
    2018-06-26T18:46:28.540277-06:00 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 252d1096-799b-11e8-9de6-005056a5314b.
    2018-06-26T18:46:28.541229-06:00 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2018-06-26T18:46:28.542575-06:00 1 [Note] Creating the system database
    2018-06-26T18:46:28.542632-06:00 1 [Warning] [email protected] is created with an empty password ! Please consider switching off the --initialize-insecure option.
    2018-06-26T18:46:28.543039-06:00 1 [Note] Creating the system tables
    2018-06-26T18:46:28.786187-06:00 1 [Note] Filling in the system tables, part 1
    2018-06-26T18:46:28.788086-06:00 1 [Note] Filling in the system tables, part 2
    2018-06-26T18:46:28.788116-06:00 1 [Note] Filling in the mysql.help table
    2018-06-26T18:46:28.997610-06:00 1 [Note] Creating user for internal session service
    2018-06-26T18:46:28.998373-06:00 1 [Note] Creating the sys schema
    2018-06-26T18:46:28.998783-06:00 1 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:28.998821-06:00 1 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:28.998854-06:00 1 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:28.998898-06:00 1 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:28.998913-06:00 1 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:28.998938-06:00 1 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:28.998991-06:00 1 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:28.999013-06:00 1 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:29.199156-06:00 1 [Note] Bootstrapping complete
    2018-06-26T18:46:29.199615-06:00 0 [Note] Giving 0 client threads a chance to die gracefully
    2018-06-26T18:46:29.199654-06:00 0 [Note] Shutting down slave threads
    2018-06-26T18:46:29.199671-06:00 0 [Note] Forcefully disconnecting 0 remaining clients
    2018-06-26T18:46:29.199858-06:00 0 [Note] Binlog end
    2018-06-26T18:46:29.201491-06:00 0 [Note] InnoDB: FTS optimize thread exiting.
    2018-06-26T18:46:29.201635-06:00 0 [Note] InnoDB: Starting shutdown...
    2018-06-26T18:46:29.301877-06:00 0 [Note] InnoDB: Dumping buffer pool(s) to /data/production_mysql/ib_buffer_pool
    2018-06-26T18:46:29.302343-06:00 0 [Note] InnoDB: Buffer pool(s) dump completed at 180626 18:46:29
    2018-06-26T18:46:30.561716-06:00 0 [Note] InnoDB: Shutdown completed; log sequence number 2347729
    2018-06-26T18:46:30.561874-06:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2018-06-26T23:46:35.323416Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
    2018-06-26T18:46:35.323800-06:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2018-06-26T18:46:35.326210-06:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22-log) starting as process 15115 ...
    2018-06-26T18:46:35.330739-06:00 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768.
    2018-06-26T18:46:35.330835-06:00 0 [Note] InnoDB: PUNCH HOLE support available
    2018-06-26T18:46:35.330876-06:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2018-06-26T18:46:35.330894-06:00 0 [Note] InnoDB: Uses event mutexes
    2018-06-26T18:46:35.330908-06:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2018-06-26T18:46:35.330920-06:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2018-06-26T18:46:35.330932-06:00 0 [Note] InnoDB: Using Linux native AIO
    2018-06-26T18:46:35.331681-06:00 0 [Note] InnoDB: Number of pools: 1
    2018-06-26T18:46:35.331895-06:00 0 [Note] InnoDB: Using CPU crc32 instructions
    2018-06-26T18:46:35.335753-06:00 0 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M
    2018-06-26T18:46:35.896107-06:00 0 [Note] InnoDB: Completed initialization of buffer pool
    2018-06-26T18:46:35.988357-06:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2018-06-26T18:46:36.016252-06:00 0 [Note] InnoDB: Opened 95 undo tablespaces
    2018-06-26T18:46:36.016322-06:00 0 [Note] InnoDB: 31 undo tablespaces made active
    2018-06-26T18:46:36.016689-06:00 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2018-06-26T18:46:36.250894-06:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2018-06-26T18:46:36.251027-06:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2018-06-26T18:46:36.268047-06:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2018-06-26T18:46:36.268334-06:00 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
    2018-06-26T18:46:36.351834-06:00 0 [Note] InnoDB: 32 redo rollback segment(s) found. 32 redo rollback segment(s) are active.
    2018-06-26T18:46:36.351898-06:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2018-06-26T18:46:36.352678-06:00 0 [Note] InnoDB: Waiting for purge to start
    2018-06-26T18:46:36.403345-06:00 0 [Note] InnoDB: 5.7.22 started; log sequence number 2347729
    2018-06-26T18:46:36.404187-06:00 0 [Note] InnoDB: Loading buffer pool(s) from /data/production_mysql/ib_buffer_pool
    2018-06-26T18:46:36.404509-06:00 0 [Note] Plugin 'FEDERATED' is disabled.
    2018-06-26T18:46:36.422640-06:00 0 [Note] InnoDB: Buffer pool(s) load completed at 180626 18:46:36
    2018-06-26T18:46:36.468341-06:00 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
    2018-06-26T18:46:36.468403-06:00 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2018-06-26T18:46:36.468506-06:00 0 [Note] IPv6 is available.
    2018-06-26T18:46:36.468589-06:00 0 [Note] - '::' resolves to '::';
    2018-06-26T18:46:36.468660-06:00 0 [Note] Server socket created on IP: '::'.
    2018-06-26T18:46:36.472927-06:00 0 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.473010-06:00 0 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.473041-06:00 0 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.473093-06:00 0 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.473108-06:00 0 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.473142-06:00 0 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.478122-06:00 0 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.478151-06:00 0 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:36.494981-06:00 0 [Note] Event Scheduler: Loaded 0 events
    2018-06-26T18:46:36.495287-06:00 0 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.7.22-log' socket: '/data/production_mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
    2018-06-26T18:46:40.586480-06:00 5 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:40.586594-06:00 5 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:40.586626-06:00 5 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:40.586690-06:00 5 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:40.586712-06:00 5 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:40.586746-06:00 5 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:40.587140-06:00 5 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:40.587177-06:00 5 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.131532-06:00 8 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.131602-06:00 8 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.131625-06:00 8 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.131669-06:00 8 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.131688-06:00 8 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.131718-06:00 8 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.132034-06:00 8 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:43.132063-06:00 8 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755004-06:00 11 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755092-06:00 11 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755116-06:00 11 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755161-06:00 11 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755176-06:00 11 [Warning] 'db' entry 'sys [email protected]localhost' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755204-06:00 11 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755540-06:00 11 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:45.755569-06:00 11 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:48.394849-06:00 14 [Note] Plugin mysqlx reported: 'Scheduler "work" started.'
    2018-06-26T18:46:48.394943-06:00 14 [Note] Plugin mysqlx reported: 'Scheduler "network" started.'
    2018-06-26T18:46:48.395668-06:00 0 [Note] Plugin mysqlx reported: 'Neither MySQL Server nor Mysqlx Plugin has valid SSL configuration'
    2018-06-26T18:46:48.395790-06:00 0 [Warning] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'
    2018-06-26T18:46:48.395808-06:00 0 [Note] Plugin mysqlx reported: 'For more information, please see the Using Secure Connections with X Plugin section in the MySQL documentation.'
    2018-06-26T18:46:48.395888-06:00 0 [Note] Plugin mysqlx reported: 'IPv6 is available'
    2018-06-26T18:46:48.396084-06:00 0 [Note] Plugin mysqlx reported: 'X Plugin listens on TCP (bind-address:'::', port:33060)'
    2018-06-26T18:46:48.396232-06:00 0 [Note] Plugin mysqlx reported: 'X Plugin listens on UNIX socket (/var/run/mysqld/mysqlx.sock)'
    2018-06-26T18:46:48.396307-06:00 0 [Note] Plugin mysqlx reported: 'Server starts handling incoming connections'
    2018-06-26T18:46:52.685426-06:00 20 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:52.685499-06:00 20 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:52.685521-06:00 20 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:52.685572-06:00 20 [Warning] 'db' entry 'performance_schema [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:52.685592-06:00 20 [Warning] 'db' entry 'sys [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:52.685624-06:00 20 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:52.685708-06:00 20 [Warning] 'tables_priv' entry 'user [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:52.685734-06:00 20 [Warning] 'tables_priv' entry 'sys_config [email protected]' ignored in --skip-name-resolve mode.
    2018-06-26T18:46:54.366960-06:00 22 [Note] Semi-sync replication initialized for transactions.
    2018-06-26T18:46:54.367005-06:00 22 [Note] Semi-sync replication enabled on the master.
    2018-06-26T18:46:54.367120-06:00 0 [Note] Starting ack receiver thread
    2018-06-26T18:47:02.502694-06:00 26 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000002, pos: 2574), semi-sync up to file , position 0.
    2018-06-26T18:47:02.502779-06:00 26 [Note] Semi-sync replication switched OFF.

     

    The databases are running on both systems, but ClusterControl says "Your cluster list is empty!"

    Thoughts?

     

    Leaving for the day.

     

    John

    0
    Comment actions Permalink
  • Avatar
    Johan

    Hi,

    Are you sure you still have these settings in your own template:
    [mysqld]
    ...
    # REPLICATION SPECIFIC
    [email protected][email protected]
    binlog_format=ROW
    log_bin=binlog
    log_slave_updates=1
    gtid_mode=ON
    enforce_gtid_consistency=1
    relay_log=relay-bin
    expire_logs_days=7
    [email protected][email protected]
    sync_binlog=1
    [email protected]@

    BR

    johan

    0
    Comment actions Permalink
  • Avatar
    Jmodran

    Success!  Looks very good!

    Thank you very much for assisting with this deployment.

    John

     

    Cluster create Job Specs:

    {
      "command": "create_cluster",
      "job_data": {
        "api_id": "1",
        "cluster_name": "production-01",
        "cluster_type": "replication",
        "config_template": "my.cnf.neuco.repl57",
        "datadir": "/data/production_mysql",
        "db_password": "Neuco5101",
        "disable_firewall": true,
        "disable_selinux": true,
        "generate_token": true,
        "install_software": true,
        "nodes": [
          {
            "hostname": "10.1.1.17",
            "hostname_data": "10.1.1.17",
            "hostname_internal": "",
            "port": "3306"
          },
          {
            "hostname": "10.1.1.18",
            "hostname_data": "10.1.1.18",
            "hostname_internal": "",
            "port": "3306"
          }
        ],
        "port": "3306",
        "software_package": "",
        "ssh_keyfile": "/root/.ssh/id_rsa",
        "ssh_port": "22",
        "ssh_user": "root",
        "sudo_password": "",
        "topology": {
          "master_slave_links": [
            {
              "10.1.1.17": "10.1.1.18"
            },
            {
              "10.1.1.18": "10.1.1.17"
            }
          ]
        },
        "user_id": 1,
        "vendor": "oracle",
        "version": "5.7"
      }
    }

     

    Full Job Details:

    [13:58:00]:Job finished, all the nodes have been created successfully.
    [13:58:00]:Generated & set RPC authentication token.
    [13:58:00]:Cluster is running.
    [13:57:59]:Waiting until the initial cluster starts up.
    [13:57:59]:Registering the cluster on the web UI.
    [13:57:59]:Cluster is running.
    [13:57:56]:Waiting until the initial cluster starts up.
    [13:57:56]:Sending SIGHUP to the controller process.
    [13:57:56]:Configuration written to '<em style='color: #007e18;'>/etc/cmon.d/cmon_2.cnf</em>'.
    [13:57:56]:Generating configuration for cluster <strong style='color: #59a449;'>production-01</strong>.
    [13:57:56]:Generating and writing the new configuration.
    [13:57:56]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Detected OS = 'redhat'
    [13:57:56]:<em style='color: #3498db;'>10.1.1.17</em>: Detecting the OS.
    [13:57:56]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: The datadir is <em style='color: #0b33b5;'>/data/production_mysql/</em>.
    [13:57:56]:Connected succesfully: '[email protected]' -> '<em style='color: #2ecc71;'>10.1.1.18</em>:3306'.
    [13:57:56]:<em style='color: #3498db;'>10.1.1.17</em>:3306: The datadir is <em style='color: #0b33b5;'>/data/production_mysql/</em>.
    [13:57:56]:Connected succesfully: '[email protected]' -> '<em style='color: #3498db;'>10.1.1.17</em>:3306'.
    [13:57:51]:Granting controller 'cmon'@'10.1.1.118' on '10.1.1.17' (host was not allowed to connect).
    [13:57:51]:Determining data directories.
    [13:57:48]:<em style='color: #3498db;'>10.1.1.17</em>: granting 'backupuser'.
    [13:57:46]:<em style='color: #3498db;'>10.1.1.17</em>: granting cmon.
    [13:57:46]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Node is read-only.
    [13:57:45]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Node is writable.
    [13:57:44]:Granting controller (earthnew2).
    [13:57:42]:Detected that <strong style='color: #59a449;'>skip_name_resolve</strong> is used on the target server(s).
    [13:57:40]:Check SELinux statuses.
    [13:57:40]:All 2 hosts are accessible by SSH.
    [13:57:40]:<em style='color: #2ecc71;'>10.1.1.18</em>: Access with ssh/sudo granted.
    [13:57:40]:<em style='color: #3498db;'>10.1.1.17</em>: already checked 2 seconds ago.
    [13:57:40]:Checking ssh/sudo on 2 hosts.
    [13:57:40]:Checking that nodes are not in another cluster.
    [13:57:40]:Found in total 2 nodes.
    [13:57:40]:Found node: '<em style='color: #2ecc71;'>10.1.1.18</em>'
    [13:57:40]:Found node: '<em style='color: #3498db;'>10.1.1.17</em>'
    [13:57:39]:<em style='color: #3498db;'>10.1.1.17</em>:3306: sanity check
    [13:57:38]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Verifying the MySQL user/password.
    [13:57:38]:<em style='color: #3498db;'>10.1.1.17</em>: Access with ssh/sudo granted.
    [13:57:38]:<em style='color: #3498db;'>10.1.1.17</em>: Checking ssh/sudo.
    [13:57:38]:Adding existing MySQL cluster.
    [13:57:37]:Verifying controller host and cmon password.
    [13:57:37]:Adding cluster with type '<strong style='color: #59a449;'>replication</strong>', vendor '<strong style='color: #59a449;'>oracle</strong>'.
    [13:57:36]:Setting up replication link 1: 10.1.1.18 -> 10.1.1.17
    [13:57:34]:Setting up replication link 0: 10.1.1.17 -> 10.1.1.18
    [13:57:31]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: GRANT REPLICATION SLAVE ON *.* TO 'rpl_user'@'10.1.1.17'
    [13:57:29]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: CREATE USER 'rpl_user'@'10.1.1.17' IDENTIFIED BY 'xx xxx'
    [13:57:29]:<em style='color: #2ecc71;'>10.1.1.18</em>: using '<em style='color: #2ecc71;'>10.1.1.18</em>' for SSH connection.
    [13:57:29]:Setting up replication link 1: 10.1.1.18 -> 10.1.1.17
    [13:57:28]:<em style='color: #3498db;'>10.1.1.17</em>:3306: GRANT REPLICATION SLAVE ON *.* TO 'rpl_user'@'10.1.1.18'
    [13:57:27]:<em style='color: #3498db;'>10.1.1.17</em>:3306: CREATE USER 'rpl_user'@'10.1.1.18' IDENTIFIED BY 'xx xxx'
    [13:57:26]:<em style='color: #3498db;'>10.1.1.17</em>: using '<em style='color: #3498db;'>10.1.1.17</em>' for SSH connection.
    [13:57:26]:Setting up replication link 0: 10.1.1.17 -> 10.1.1.18
    [13:57:26]:Create users, grants.
    [13:57:25]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing SET GLOBAL rpl_semi_sync_slave_enabled=1
    [13:57:24]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
    [13:57:24]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_timeout =1000
    [13:57:23]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_enabled=1
    [13:57:22]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
    [13:57:21]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Secured installation.
    [13:57:21]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing FLUSH PRIVILEGES
    [13:57:20]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DROP DATABASE IF EXISTS test
    [13:57:19]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND authentication_string=''
    [13:57:18]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')
    [13:57:18]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing DELETE FROM mysql.user WHERE User=''
    [13:57:17]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Securing installation.
    [13:57:17]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: MySQL is installed and started.
    [13:57:17]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
    [13:57:06]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Setting the MySQL root password.
    [13:57:06]:<em style='color: #2ecc71;'>10.1.1.18</em>: Server responded to 'mysqladmin ping'
    [13:57:06]:<em style='color: #2ecc71;'>10.1.1.18</em>: service status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Wed 2018-06-27 13:57:05 CDT; 1s ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Main PID: 418 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-418 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 27 13:57:03 juggernaut2 systemd[1]: Starting MySQL Server...
    Jun 27 13:57:05 juggernaut2 systemd[1]: Started MySQL Server.
    [13:57:06]:<em style='color: #2ecc71;'>10.1.1.18</em>: Started MySQL daemon.
    [13:57:05]:<em style='color: #2ecc71;'>10.1.1.18</em>: MySQL status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Wed 2018-06-27 13:57:05 CDT; 514ms ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 416 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
    Process: 393 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 418 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-418 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 27 13:57:03 juggernaut2 systemd[1]: Starting MySQL Server...
    Jun 27 13:57:05 juggernaut2 systemd[1]: Started MySQL Server.

    [13:57:01]:<em style='color: #2ecc71;'>10.1.1.18</em>: This may take a while to initialize.
    [13:57:01]:<em style='color: #2ecc71;'>10.1.1.18</em>: (service='mysqld', vendor='oracle', OS=['centos', '7.4.1708']).
    [13:57:01]:<em style='color: #2ecc71;'>10.1.1.18</em>: Starting MySQL daemon.
    [13:56:59]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Searching and removing '<em style='color: #007e18;'>/root/.my.cnf</em>'.
    [13:56:59]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Searching and removing '<em style='color: #007e18;'>/usr/my.cnf</em>'.
    [13:56:59]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installed MySQL system tables.
    [13:56:59]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: /usr/sbin/mysqld --initialize-insecure: ok.
    [13:56:47]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installing MySQL system tables.
    [13:56:46]:Writing file '<em style='color: #2ecc71;'>10.1.1.18</em>:<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'
    [13:56:46]:Writing file '<em style='color: #2ecc71;'>10.1.1.18</em>:<em style='color: #007e18;'>/etc/my.cnf</em>'
    [13:56:46]:Data directory is '<em style='color: #0b33b5;'>/data/production_mysql</em>', ok.
    [13:56:46]:Base directory is '<em style='color: #0b33b5;'>/usr/</em>', ok.
    [13:56:46]:Checking MySql configuration file(s).
    [13:56:46]:Preparing backup secrets config file '<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'.
    [13:56:46]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Uploading the generated <em style='color: #007e18;'>my.cnf</em>.
    [13:56:41]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Verifying the MySQL installation.
    [13:56:40]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: post-installation for oracle.
    [13:55:17]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installing Oracle(tm) (replication) redhat
    [13:55:17]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Installing the MySQL packages.
    [13:55:14]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Prepare MySQL environment (user/group).
    [13:55:14]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Cleaning old MySql packages: No Match for argument: MySQL*
    No Match for argument: mysql-5.6-pkg-list
    No Match for argument: mysql-cmds
    No Match for argument: mysql80-community-release-el7-1.noarch.rpm
    No Match for argument: Percona*
    No Match for argument: MariaDB*
    No Match for argument: mariadb*
    No Match for argument: galera*
    No Match for argument: galera
    warning: file /etc/my.cnf: remove failed: No such file or directory

    [13:54:50]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Removing old MySQL packages from the host.
    [13:54:27]:<em style='color: #2ecc71;'>10.1.1.18</em>: Using external repositories.
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Total disk space: 40188 MB.
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Detected free disk space: 39.18 GiB.
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Checking free-disk space of '<em style='color: #0b33b5;'>/data/production_mysql</em>'.
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Detected memory: 15.51 GiB.
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Detecting total memory.
    [13:54:26]:Loaded template '<em style='color: #007e18;'>/usr/share/cmon/templates/my.cnf.neuco.repl57</em>'.
    [13:54:26]:Using config template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>' from '<em style='color: #0b33b5;'>/usr/share/cmon/templates</em>'.
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Using template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>'.
    [13:54:26]:Cluster type is '<strong style='color: #59a449;'>replication</strong>'.
    [13:54:26]:Using <strong style='color: #59a449;'>skip_name_resolve</strong> as all servers are defined by IP.
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>: Verifying helper packages (checking '<strong style='color: #110679;'>socat</strong>').
    [13:54:26]:<em style='color: #2ecc71;'>10.1.1.18</em>: Finished with helper packages.
    [13:54:24]:<em style='color: #2ecc71;'>10.1.1.18</em>: Upgrading <strong style='color: #110679;'>openssl openssl-libs</strong>.
    [13:54:23]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>openssl</strong>.
    [13:54:22]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>tar</strong>.
    [13:54:20]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>iproute2</strong>.
    [13:54:19]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>bzip2</strong>.
    [13:54:18]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>pigz</strong>.
    [13:54:17]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>gnupg2</strong>.
    [13:54:16]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>curl</strong>.
    [13:54:15]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>wget</strong>.
    [13:54:14]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>libevent</strong>.
    [13:54:11]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>libaio</strong>.
    [13:54:10]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>rsync</strong>.
    [13:54:09]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>psmisc</strong>.
    [13:54:08]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper-Names</strong>.
    [13:54:06]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>which</strong>.
    [13:54:05]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper</strong>.
    [13:54:04]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>socat</strong>.
    [13:54:03]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>nc</strong>.
    [13:54:02]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>netcat</strong>.
    [13:54:00]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing <strong style='color: #110679;'>net-tools</strong>.
    [13:53:58]:<em style='color: #2ecc71;'>10.1.1.18</em>: Upgrading ca-certificates.
    [13:53:57]:<em style='color: #2ecc71;'>10.1.1.18</em>: Upgrading nss.
    [13:53:57]:<em style='color: #2ecc71;'>10.1.1.18</em>: Installing helper packages.
    [13:53:57]:<em style='color: #2ecc71;'>10.1.1.18</em>: Setting <strong style='color: #59a449;'>vm.swappiness</strong> = 1.
    [13:53:57]:<em style='color: #2ecc71;'>10.1.1.18</em>: Tuning OS parameters.
    [13:53:57]:<em style='color: #2ecc71;'>10.1.1.18</em>: Flushing iptables.
    [13:53:56]:<em style='color: #2ecc71;'>10.1.1.18</em>: Disabling firewalld.
    [13:53:54]:<em style='color: #2ecc71;'>10.1.1.18</em>: Checking firewall.
    [13:53:54]:<em style='color: #2ecc71;'>10.1.1.18</em>: vendor='centos' release='7' type='redhat'.
    [13:53:54]:<em style='color: #2ecc71;'>10.1.1.18</em>: Checking SELinux status (<strong style='color: #59a449;'>enabled</strong> = false).
    [13:53:54]:<em style='color: #2ecc71;'>10.1.1.18</em>: Check and disable AppArmor.
    [13:53:54]:Setting up server <em style='color: #2ecc71;'>10.1.1.18</em>:3306.
    [13:53:53]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL read_only=0
    [13:53:52]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL rpl_semi_sync_slave_enabled=1
    [13:53:51]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
    [13:53:50]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_timeout =1000
    [13:53:49]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing SET GLOBAL rpl_semi_sync_master_enabled=1
    [13:53:48]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
    [13:53:48]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Secured installation.
    [13:53:48]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing FLUSH PRIVILEGES
    [13:53:47]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DROP DATABASE IF EXISTS test
    [13:53:46]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND authentication_string=''
    [13:53:45]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')
    [13:53:44]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing DELETE FROM mysql.user WHERE User=''
    [13:53:43]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Securing installation.
    [13:53:43]:<em style='color: #3498db;'>10.1.1.17</em>:3306: MySQL is installed and started.
    [13:53:43]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Executing INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'
    [13:53:33]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Setting the MySQL root password.
    [13:53:33]:<em style='color: #3498db;'>10.1.1.17</em>: Server responded to 'mysqladmin ping'
    [13:53:33]:<em style='color: #3498db;'>10.1.1.17</em>: service status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Wed 2018-06-27 13:53:31 CDT; 1s ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Main PID: 17381 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-17381 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 27 13:53:30 juggernaut systemd[1]: Starting MySQL Server...
    Jun 27 13:53:31 juggernaut systemd[1]: Started MySQL Server.
    [13:53:32]:<em style='color: #3498db;'>10.1.1.17</em>: Started MySQL daemon.
    [13:53:32]:<em style='color: #3498db;'>10.1.1.17</em>: MySQL status: * mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
    `-override.conf
    Active: active (running) since Wed 2018-06-27 13:53:31 CDT; 469ms ago
    Docs: man:mysqld(8)
    http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 17378 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
    Process: 17376 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 17381 (mysqld)
    CGroup: /system.slice/mysqld.service
    `-17381 /usr/sbin/mysqld --daemonize --pid-file=/data/production_mysql/mysql.pid

    Jun 27 13:53:30 juggernaut systemd[1]: Starting MySQL Server...
    Jun 27 13:53:31 juggernaut systemd[1]: Started MySQL Server.

    [13:53:28]:<em style='color: #3498db;'>10.1.1.17</em>: This may take a while to initialize.
    [13:53:28]:<em style='color: #3498db;'>10.1.1.17</em>: (service='mysqld', vendor='oracle', OS=['centos', '7.4.1708']).
    [13:53:28]:<em style='color: #3498db;'>10.1.1.17</em>: Starting MySQL daemon.
    [13:53:26]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Searching and removing '<em style='color: #007e18;'>/root/.my.cnf</em>'.
    [13:53:26]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Searching and removing '<em style='color: #007e18;'>/usr/my.cnf</em>'.
    [13:53:26]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installed MySQL system tables.
    [13:53:26]:<em style='color: #3498db;'>10.1.1.17</em>:3306: /usr/sbin/mysqld --initialize-insecure: ok.
    [13:53:12]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installing MySQL system tables.
    [13:53:11]:Writing file '<em style='color: #3498db;'>10.1.1.17</em>:<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'
    [13:53:10]:Writing file '<em style='color: #3498db;'>10.1.1.17</em>:<em style='color: #007e18;'>/etc/my.cnf</em>'
    [13:53:10]:Data directory is '<em style='color: #0b33b5;'>/data/production_mysql</em>', ok.
    [13:53:10]:Base directory is '<em style='color: #0b33b5;'>/usr/</em>', ok.
    [13:53:10]:Checking MySql configuration file(s).
    [13:53:10]:Preparing backup secrets config file '<em style='color: #007e18;'>/etc/my.cnf.d/secrets-backup.cnf</em>'.
    [13:53:10]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Uploading the generated <em style='color: #007e18;'>my.cnf</em>.
    [13:53:05]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Verifying the MySQL installation.
    [13:53:04]:<em style='color: #3498db;'>10.1.1.17</em>:3306: post-installation for oracle.
    [13:51:34]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installing Oracle(tm) (replication) redhat
    [13:51:34]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Installing the MySQL packages.
    [13:51:31]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Prepare MySQL environment (user/group).
    [13:51:31]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Cleaning old MySql packages: No Match for argument: MySQL*
    No Match for argument: mysql-5.6-pkg-list
    No Match for argument: mysql-cmds
    No Match for argument: mysql-tuning
    No Match for argument: mysql80-community-release-el7-1.noarch.rpm
    No Match for argument: Percona*
    No Match for argument: MariaDB*
    No Match for argument: mariadb*
    No Match for argument: galera*
    No Match for argument: galera
    warning: file /etc/my.cnf: remove failed: No such file or directory

    [13:51:05]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Removing old MySQL packages from the host.
    [13:50:35]:<em style='color: #3498db;'>10.1.1.17</em>: Using external repositories.
    [13:50:35]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Total disk space: 37164 MB.
    [13:50:35]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Detected free disk space: 36.23 GiB.
    [13:50:35]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Checking free-disk space of '<em style='color: #0b33b5;'>/data/production_mysql</em>'.
    [13:50:35]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Detected memory: 15.51 GiB.
    [13:50:34]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Detecting total memory.
    [13:50:34]:Loaded template '<em style='color: #007e18;'>/usr/share/cmon/templates/my.cnf.neuco.repl57</em>'.
    [13:50:34]:Using config template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>' from '<em style='color: #0b33b5;'>/usr/share/cmon/templates</em>'.
    [13:50:34]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Using template '<em style='color: #007e18;'>my.cnf.neuco.repl57</em>'.
    [13:50:34]:Cluster type is '<strong style='color: #59a449;'>replication</strong>'.
    [13:50:34]:Using <strong style='color: #59a449;'>skip_name_resolve</strong> as all servers are defined by IP.
    [13:50:34]:<em style='color: #3498db;'>10.1.1.17</em>: Verifying helper packages (checking '<strong style='color: #110679;'>socat</strong>').
    [13:50:34]:<em style='color: #3498db;'>10.1.1.17</em>: Finished with helper packages.
    [13:50:30]:<em style='color: #3498db;'>10.1.1.17</em>: Upgrading <strong style='color: #110679;'>openssl openssl-libs</strong>.
    [13:50:26]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>openssl</strong>.
    [13:50:25]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>tar</strong>.
    [13:50:23]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>iproute2</strong>.
    [13:50:21]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>bzip2</strong>.
    [13:50:19]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>pigz</strong>.
    [13:50:18]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>gnupg2</strong>.
    [13:50:16]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>curl</strong>.
    [13:50:14]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>wget</strong>.
    [13:50:12]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>libevent</strong>.
    [13:50:11]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>libaio</strong>.
    [13:50:09]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>rsync</strong>.
    [13:50:07]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>psmisc</strong>.
    [13:50:05]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper-Names</strong>.
    [13:50:04]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>which</strong>.
    [13:50:00]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>perl-Data-Dumper</strong>.
    [13:49:59]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>socat</strong>.
    [13:49:55]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>nc</strong>.
    [13:49:53]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>netcat</strong>.
    [13:49:49]:<em style='color: #3498db;'>10.1.1.17</em>: Installing <strong style='color: #110679;'>net-tools</strong>.
    [13:49:47]:<em style='color: #3498db;'>10.1.1.17</em>: Upgrading ca-certificates.
    [13:49:46]:<em style='color: #3498db;'>10.1.1.17</em>: Upgrading nss.
    [13:49:46]:<em style='color: #3498db;'>10.1.1.17</em>: Installing helper packages.
    [13:49:45]:<em style='color: #3498db;'>10.1.1.17</em>: Setting <strong style='color: #59a449;'>vm.swappiness</strong> = 1.
    [13:49:45]:<em style='color: #3498db;'>10.1.1.17</em>: Tuning OS parameters.
    [13:49:45]:<em style='color: #3498db;'>10.1.1.17</em>: Flushing iptables.
    [13:49:44]:<em style='color: #3498db;'>10.1.1.17</em>: Disabling firewalld.
    [13:49:43]:<em style='color: #3498db;'>10.1.1.17</em>: Checking firewall.
    [13:49:42]:<em style='color: #3498db;'>10.1.1.17</em>: vendor='centos' release='7' type='redhat'.
    [13:49:42]:<em style='color: #3498db;'>10.1.1.17</em>: Checking SELinux status (<strong style='color: #59a449;'>enabled</strong> = false).
    [13:49:42]:<em style='color: #3498db;'>10.1.1.17</em>: Check and disable AppArmor.
    [13:49:42]:Setting up server <em style='color: #3498db;'>10.1.1.17</em>:3306.
    [13:49:42]:Found replication link 1: <em style='color: #2ecc71;'>10.1.1.18</em> -> <em style='color: #3498db;'>10.1.1.17</em>.
    [13:49:42]:Found replication link 0: <em style='color: #3498db;'>10.1.1.17</em> -> <em style='color: #2ecc71;'>10.1.1.18</em>.
    [13:49:42]:<em style='color: #2ecc71;'>10.1.1.18</em>:3306: Checking if host already exists in another cluster.
    [13:49:41]:<em style='color: #3498db;'>10.1.1.17</em>:3306: Checking if host already exists in another cluster.
    [13:49:41]:All 2 hosts are accessible by SSH.
    [13:49:41]:<em style='color: #2ecc71;'>10.1.1.18</em>: Access with ssh/sudo granted.
    [13:49:41]:<em style='color: #3498db;'>10.1.1.17</em>: Access with ssh/sudo granted.
    [13:49:41]:Checking ssh/sudo on 2 hosts.
    [13:49:41]:Verifying job parameters.

     

     

    0
    Comment actions Permalink
  • Avatar
    Johan

    Awesome!
    Glad I could help.

    Thanks,
    johan

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk