Customized master-master deploy ...
I have a requirement to initialize a database with 'undo_tablespace' and related variable settings ('innodb_undo_tablespaces', 'innodb_undo_log_truncate', 'innodb_max_undo_log_size', and' innodb_undo_logs'). A custom template was created prior to the ClusterControl Deploy phase and used during MySQL replication (master-master) deployment, but the resulting databases were not initialized with the custom settings.
Is it possible to make a custom replication template having customized parameters, so that when the databases are created, they are initialized with them?
-
Official comment
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 -
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?
-
Hi,
What you describe also works for me. I have defined a :
/usr/share/cmon/templates/my.cnf.ora57And 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: -
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: 'cmon@earthnew2' -> '<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: 'cmon@earthnew2' -> '<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.pidJun 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.pidJun 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.pidJun 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.pidJun 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. -
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
-
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? -
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.
-
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.pidJun 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.pidJun 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.pidJun 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.pidJun 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:
[root@juggernaut 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] root@localhost 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:40.576522-06:00 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:40.576551-06:00 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:40.576587-06:00 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:40.576602-06:00 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:40.576626-06:00 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:40.576688-06:00 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:40.576712-06:00 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:47.984527-06:00 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:47.984574-06:00 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:47.984647-06:00 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:47.984671-06:00 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:47.984710-06:00 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:47.989331-06:00 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:47.989373-06:00 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:52.146631-06:00 5 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:52.146654-06:00 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:52.146693-06:00 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:52.146707-06:00 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:52.146735-06:00 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:52.147089-06:00 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:52.147117-06:00 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811057-06:00 8 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811131-06:00 8 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811153-06:00 8 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811197-06:00 8 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811216-06:00 8 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811245-06:00 8 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811646-06:00 8 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:54.811675-06:00 8 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.455523-06:00 11 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.455628-06:00 11 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.455664-06:00 11 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.455719-06:00 11 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.455736-06:00 11 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.455765-06:00 11 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.456142-06:00 11 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:41:57.456186-06:00 11 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:42:04.413115-06:00 20 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:42:04.413139-06:00 20 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:42:04.413189-06:00 20 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:42:04.413205-06:00 20 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:42:04.413235-06:00 20 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:42:04.413312-06:00 20 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:42:04.413337-06:00 20 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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:
[root@juggernaut2 ~]# 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] root@localhost 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:28.998821-06:00 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:28.998854-06:00 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:28.998898-06:00 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:28.998913-06:00 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:28.998938-06:00 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:28.998991-06:00 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:28.999013-06:00 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:36.473010-06:00 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:36.473041-06:00 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:36.473093-06:00 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:36.473108-06:00 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:36.473142-06:00 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:36.478122-06:00 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:36.478151-06:00 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:40.586594-06:00 5 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:40.586626-06:00 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:40.586690-06:00 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:40.586712-06:00 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:40.586746-06:00 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:40.587140-06:00 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:40.587177-06:00 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.131532-06:00 8 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.131602-06:00 8 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.131625-06:00 8 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.131669-06:00 8 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.131688-06:00 8 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.131718-06:00 8 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.132034-06:00 8 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:43.132063-06:00 8 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755004-06:00 11 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755092-06:00 11 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755116-06:00 11 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755161-06:00 11 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755176-06:00 11 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755204-06:00 11 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755540-06:00 11 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:45.755569-06:00 11 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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 'root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:52.685499-06:00 20 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:52.685521-06:00 20 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:52.685572-06:00 20 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:52.685592-06:00 20 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:52.685624-06:00 20 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:52.685708-06:00 20 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-06-26T18:46:52.685734-06:00 20 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' 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
-
Hi,
Are you sure you still have these settings in your own template:
[mysqld]
...
# REPLICATION SPECIFIC
server_id=@SERVER_ID@
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
read_only=@READ_ONLY@
sync_binlog=1
report_host=@HOST@
BRjohan
-
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: 'cmon@earthnew2' -> '<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: 'cmon@earthnew2' -> '<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.pidJun 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.pidJun 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.pidJun 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.pidJun 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.
Please sign in to leave a comment.
Comments
16 comments