Differential D1122
Provision MySQL Authored by dereckson on Oct 28 2017, 10:35. Tags None Referenced Files
Subscribers None
Details
MariaDB has been selected as MySQL server flavour, FreeBSD servers with ZFS can benefit from a tweaked configuration For FreeBSD, we also require MariaDB 10.2 instead of 10.1. Fixes T1306. Deploy on Ysul and check ZFS partitions are populated
Diff Detail
Event TimelineComment Actions I reported upstream an issue for recordsize, falsely reporting to be updated in test mode: https://github.com/saltstack/salt/issues/44404 I'm moving zfs states in their independent file, as it's a little scary to run that right now. Comment Actions $ salt-call --local state.apply roles/dbserver-mysql local: ---------- ID: mysql_server_software Function: pkg.installed Result: True Comment: All specified packages are already installed Started: 01:45:51.880169 Duration: 246.099 ms Changes: ---------- ID: arcology/mysql-innodb-data Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-innodb-data was updated Started: 01:45:52.131408 Duration: 563.66 ms Changes: ---------- arcology/mysql-innodb-data: ---------- mountpoint: /var/db/mysql/mysql-innodb-data recordsize: 16k ---------- ID: arcology/mysql-innodb-logs Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-innodb-logs was updated Started: 01:45:52.695790 Duration: 557.842 ms Changes: ---------- arcology/mysql-innodb-logs: ---------- mountpoint: /var/db/mysql/mysql-innodb-logs recordsize: 128k ---------- ID: arcology/mysql-root Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-root was updated Started: 01:45:53.254366 Duration: 574.172 ms Changes: ---------- arcology/mysql-root: ---------- mountpoint: /var/db/mysql/mysql-root recordsize: 8k ---------- ID: /usr/local/etc/my.cnf Function: file.managed Result: True Comment: File /usr/local/etc/my.cnf updated Started: 01:45:53.838402 Duration: 95.623 ms Duration: 95.623 ms Changes: ---------- diff: New file mode: 0644 ---------- ID: /var/run/mysqld Function: file.directory Result: True Comment: Directory /var/run/mysqld updated Started: 01:45:53.934487 Duration: 7.571 ms Changes: ---------- /var/run/mysqld: New Dir ---------- ID: /var/db/mysql Function: file.directory Result: True Comment: Directory /var/db/mysql updated Started: 01:45:53.942532 Duration: 5.229 ms Changes: ---------- group: mysql user: mysql Summary for local ------------ Succeeded: 7 (changed=6) Failed: 0 ------------ Total states run: 7 Total run time: 2.050 s $ zpool history 2017-11-05.01:45:52 zfs set mountpoint=/var/db/mysql/mysql-innodb-data arcology/mysql-innodb-data 2017-11-05.01:45:52 zfs set recordsize=16k arcology/mysql-innodb-data 2017-11-05.01:45:53 zfs set mountpoint=/var/db/mysql/mysql-innodb-logs arcology/mysql-innodb-logs 2017-11-05.01:45:53 zfs set recordsize=128k arcology/mysql-innodb-logs 2017-11-05.01:45:53 zfs set mountpoint=/var/db/mysql/mysql-root arcology/mysql-root 2017-11-05.01:45:58 zfs set recordsize=8k arcology/mysql-root The extraneous set recordsize issue has been commented upstream in the bug describe above. Comment Actions $ /usr/local/etc/rc.d/mysql-server start Installing MariaDB/MySQL system tables in '/var/db/mysql' ... 2017-11-05 13:57:44 34429034496 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used; This may cause repli ction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=ysul.nasqueron.org' or '--log-bin=mysqld-bin' to avoi d this problem. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Cannot open datafile '/var/db/mysql/mysql-innodb-data/ibdata1' 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, an d it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attemp t. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious d ata! 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Database creation was aborted with error Cannot open a file. You may need to delete the ibdata1 file before try ing to start up again. 2017-11-05 13:57:45 34429034496 [ERROR] Plugin 'InnoDB' init function returned error. 2017-11-05 13:57:45 34429034496 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-11-05 13:57:45 34429034496 [ERROR] /usr/local/libexec/mysqld: unknown variable 'bin_log_format=MIXED' 2017-11-05 13:57:45 34429034496 [ERROR] Aborting By the way, Aria totally ignores MyISAM datadir. |