summaryrefslogtreecommitdiff
path: root/scripts
Commit message (Collapse)AuthorAgeFilesLines
* Merge branch '10.1' into 10.2Sergei Golubchik2018-09-241-3/+12
|\
| * MDEV-17173: correct parsing of 12.13.14.15:4444/xtrabackup_sst leaving ↵Daniel Black2018-09-131-3/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | LSN/SST_VER blank Correcting commit e78e308e818 $ . scripts/wsrep_sst_common.sh --address 12.13.14.15:4444/xtrabackup_sst ; set | grep WSREP_SST WSREP_SST_OPT_ADDR=12.13.14.15:4444/xtrabackup_sst WSREP_SST_OPT_ADDR_PORT=4444 WSREP_SST_OPT_AUTH= WSREP_SST_OPT_BINLOG= WSREP_SST_OPT_BINLOG_INDEX= WSREP_SST_OPT_BYPASS=0 WSREP_SST_OPT_CONF=' ' WSREP_SST_OPT_DATA= WSREP_SST_OPT_DEFAULT= WSREP_SST_OPT_EXTRA_DEFAULT= WSREP_SST_OPT_HOST=12.13.14.15 WSREP_SST_OPT_HOST_UNESCAPED=12.13.14.15 WSREP_SST_OPT_LSN= WSREP_SST_OPT_MODULE=xtrabackup_sst WSREP_SST_OPT_PATH=xtrabackup_sst WSREP_SST_OPT_PORT=4444 WSREP_SST_OPT_PSWD= WSREP_SST_OPT_SST_VER= WSREP_SST_OPT_SUFFIX_DEFAULT= WSREP_SST_OPT_SUFFIX_VALUE= WSREP_SST_OPT_USER= . scripts/wsrep_sst_common.sh --address 12.13.14.15:4444/xtrabackup_sst/1234/5676 ; set | grep WSREP_SST WSREP_SST_OPT_ADDR=12.13.14.15:4444/xtrabackup_sst/1234/5676 WSREP_SST_OPT_ADDR_PORT=4444 WSREP_SST_OPT_AUTH= WSREP_SST_OPT_BINLOG= WSREP_SST_OPT_BINLOG_INDEX= WSREP_SST_OPT_BYPASS=0 WSREP_SST_OPT_CONF=' ' WSREP_SST_OPT_DATA= WSREP_SST_OPT_DEFAULT= WSREP_SST_OPT_EXTRA_DEFAULT= WSREP_SST_OPT_HOST=12.13.14.15 WSREP_SST_OPT_HOST_UNESCAPED=12.13.14.15 WSREP_SST_OPT_LSN=1234 WSREP_SST_OPT_MODULE=xtrabackup_sst WSREP_SST_OPT_PATH=xtrabackup_sst/1234/5676 WSREP_SST_OPT_PORT=4444 WSREP_SST_OPT_PSWD= WSREP_SST_OPT_SST_VER=5676 WSREP_SST_OPT_SUFFIX_DEFAULT= WSREP_SST_OPT_SUFFIX_VALUE= WSREP_SST_OPT_USER=
* | Merge branch '10.1' into 10.2Oleksandr Byelkin2018-09-145-10/+76
|\ \ | |/
| * Merge branch '10.0-galera' into 10.1Sergei Golubchik2018-09-071-3/+9
| |\
| | * Also include InnoDB undo tablespaces in rsync sstVasil Dimov2018-08-031-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | If --innodb-undo-tablespaces is used, then InnoDB stores undo in a separate file(s) which whould also be replicated. This fixes Issue#337 This filter will cause sst failed at applying undo... https://github.com/codership/mysql-wsrep/issues/337
| | * Put one filter per line in wsrep_sst_rsync.shVasil Dimov2018-08-031-2/+8
| | | | | | | | | | | | | | | This way it is more readable and easy to change, also if a new entry is added or one removed, the diff will be easier to read.
| | * Merge tag 'mariadb-10.0.36' into 10.0-galeraJan Lindström2018-08-025-23/+40
| | |\
| | * \ Merge pull request #645 from grooverdan/10.0-wsrep_sst_common_bashismJan Lindström2018-07-191-1/+1
| | |\ \ | | | | | | | | | | MDEV-15549 - wsrep_sst_common: fix per shellcheck
| | | * | wsrep_sst_common: fix per shellcheckDaniel Black2018-03-071-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | shellcheck -s sh wsrep_sst_common.sh In wsrep_sst_common.sh line 258: [ -n $3 ] && reval=$3 ^-- SC2070: -n doesn't work with unquoted arguments. Quote or use [[ ]]. ^-- SC2086: Double quote to prevent globbing and word splitting.
| | * | | fix galera sst testsSergei Golubchik2018-06-151-3/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | note that ${A#foo} is $A if there's no prefix foo. That's why galera nodes tried to connect to 127.0.0.1:127.0.0.1 if there was no port in the address Followup for 2b35db5ac4e
| * | | | Merge branch '11.0' into 10.1Oleksandr Byelkin2018-09-061-1/+1
| |\ \ \ \
| | * | | | Fix typo in `--srcdir` option in echo message status of mysql_install_dbAnel Husakovic2018-08-251-1/+1
| | | |_|/ | | |/| |
| * | | | Merge pull request #855 from tempesta-tech/sysprg/10.1-MDEV-10756Jan Lindström2018-09-063-2/+38
| |\ \ \ \ | | | | | | | | | | | | MDEV-10756: wsrep_sst_xtrabackup-v2 does not support innodb_data_home_dir
| | * | | | MDEV-10756: wsrep_sst_xtrabackup-v2 does not support innodb_data_home_dirJulius Goryavsky2018-08-273-2/+38
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Current versions of xtrabackup-v2 and mariabackup support the option --innodb-data-home-dir, but this parameter is not passed to them from the SST script, since the SST script does not receive this information from mysqld. The transfer of this information to the SST is already fixed by the MDEV-10754 patch, but we need to process it in the SST script. Also, we should take into account that on the joiner side the corresponding information is not read yet from the configuration file (at the mysqld side) during the start of SST, so the script must itself read it. https://jira.mariadb.org/browse/MDEV-10756
| * | | | | MDEV-15436: If log_bin and log_bin_index is different SST with rsync fails.Jan Lindström2018-09-052-8/+39
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Problem was that in SST log_bin_index name and directory was not handled and passed to rsync SST script. wsrep_sst_common.sh Read binlog index dirname and filename if --binlog-index parameter is provided. Read binlog filenames from that file from donor and write transfered binlog filenames to that file in joiner. mysqld.cc, mysqld.h Moved opt_binlog_index_name from static to global and added it to extern. wsrep_sst.cc generate_binlog_index_opt_val New function to generate binlog index name if opt_binlog_index_name is given on configuration. sst_prepare_other Add binlog index configuration to SST command. wsrep_sst.h Add new SST parameter --binlog-index Add test case.
| * | | | | galera_new_cluster.sh: unused variablesDaniel Black2018-09-031-3/+0
| | | | | |
* | | | | | Merge 10.1 into 10.2Marko Mäkelä2018-08-313-5/+35
|\ \ \ \ \ \ | |/ / / / /
| * | | | | MDEV-15512 - Fix sh parse error when [sst] config value has spaces.Jan Lindström2018-08-291-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merged https://github.com/MariaDB/server/pull/617 authored by Colin Mollenhour.
| * | | | | Merge pull request #539 from ↵Jan Lindström2018-08-281-2/+1
| |\ \ \ \ \ | | |/ / / / | |/| | | | | | | | | | | | | | | | grooverdan/10.1-wsrep_sst_rsync_read_MYSQL_BASE_VERSION_config MDEV-14851: galera_recovery to read correct configuration file sections
| | * | | | Merge branch '10.1' into 10.1-wsrep_sst_rsync_read_MYSQL_BASE_VERSION_configDaniel Black2018-02-047-143/+99
| | |\ \ \ \
| | * | | | | galera_recovery: misses reading default configuration groupsDaniel Black2018-01-131-2/+1
| | | | | | |
| | * | | | | wsrep_sst_rsync: read correct configuration sectionsDaniel Black2018-01-131-13/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 4bb49d84a9df had a single option, --mysqld to obtain the required innodb_log_group_home_dir. 83664e21e4fb675 enumberated the groups when --mysqld was sufficient.
| * | | | | | Fixes of the base patch for compatibility with the 10.1 branchJulius Goryavsky2018-08-171-1/+1
| | | | | | |
| * | | | | | Reverting changes made to support the mtr under the rootJulius Goryavsky2018-08-131-2/+0
| | | | | | |
| * | | | | | Fixes after review and correction of the problems caused by the fact that ↵Julius Goryavsky2018-08-092-4/+31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | during the SST innodb plugin is not yet initialized, as well as problems with running tests from the root user (not directly related to the MDEV-10754).
| * | | | | | Merge branch '10.1' of https://github.com/MariaDB/server into ↵Julius Goryavsky2018-08-086-30/+95
| |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | sysprg/10.1-MDEV-10754
| * | | | | | | MDEV-10754 wsrep_sst_rsync does not support innodb_data_home_dirJulius Goryavsky2018-07-261-1/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | If innodb_data_home_dir path specified in the configuration file then rsync IST/SST will fail because the wsrep_sst_rsync.sh script does not read this parameter from the configuration file and then tries to find the data files in the default directory. To fix this error, we need to add reading of the innodb_data_home_dir configuration parameter to the rsync-related SST script.
* | | | | | | | Use stunnel during rsync SST if availablebenrubson2018-08-241-10/+64
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (cherry picked from commit 1adc382c2fb4300059d130521a24a1dab141531e)
* | | | | | | | After-merge fix: Revert MDEV-15511Marko Mäkelä2018-08-211-66/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | My conflict resolution for the script did not work out after all, and apparently I was testing a wrong version. Revert MDEV-15511 from MariaDB 10.2 for now.
* | | | | | | | Merge 10.1 into 10.2Marko Mäkelä2018-08-211-14/+66
|\ \ \ \ \ \ \ \ | | |/ / / / / / | |/| | | | | |
| * | | | | | | Merge pull request #609 from benrubson/stunnelJan Lindström2018-08-051-7/+60
| |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | MDEV-15511 - Use stunnel during rsync SST if available
| | * | | | | | | Use stunnel during rsync SST if availablebenrubson2018-02-121-7/+60
| | | |_|/ / / / | | |/| | | | |
* | | | | | | | MDEV-16906 No groups to be reported (check your GNRs) - mysqld_multi does ↵Sergei Golubchik2018-08-071-6/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | not see instances make mysqld_multi to use same rules for my.cnf directories that all other tools are using (see my_default.c).
* | | | | | | | MDEV-14637: Fix hang due to persistent statisticsMarko Mäkelä2018-08-032-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Similar to the tables SYS_FOREIGN and SYS_FOREIGN_COLS, the tables mysql.innodb_table_stats and mysql.innodb_index_stats are updated by the InnoDB internal SQL parser, which fails to enforce the size limits of the data. Due to this, it is possible for InnoDB to hang when there are persistent statistics defined on partitioned tables where the total length of table name, partition name and subpartition name exceeds the incorrectly defined limit VARCHAR(64). That column should have been defined as VARCHAR(199). btr_node_ptr_max_size(): Interpret the VARCHAR(64) as VARCHAR(199), to prevent a hang in the case that the upgrade script has not been run. dict_table_schema_check(): Ignore difference in the length of the table_name column. ha_innobase::max_supported_key_length(): For innodb_page_size=4k, return a larger value so that the table mysql.innodb_index_stats can be created. This could allow "impossible" tables to be created, such that it is not possible to insert anything into a secondary index when both the secondary key and the primary key are long, but this is the easiest and most consistent way. The Oracle fix would only ignore the maximum length violation for the two statistics tables. os_file_get_status_posix(), os_file_get_status_win32(): Handle ENAMETOOLONG as well. This patch is based on the following change in MySQL 5.7.23. Not all changes were applied, and our variant allows persistent statistics to work without hangs even if the table definitions were not upgraded. From fdbdce701ab8145ae234c9d401109dff4e4106cb Mon Sep 17 00:00:00 2001 From: Aditya A <aditya.a@oracle.com> Date: Thu, 17 May 2018 16:11:43 +0530 Subject: [PATCH] Bug #26390736 THE FIELD TABLE_NAME (VARCHAR(64)) FROM MYSQL.INNODB_TABLE_STATS CAN OVERFLOW. In mysql.innodb_index_stats and mysql.innodb_table_stats tables the table name column didn't take into consideration partition names which can be more than varchar(64).
* | | | | | | | Merge 10.1 into 10.2Marko Mäkelä2018-08-028-32/+88
|\ \ \ \ \ \ \ \ | |/ / / / / / /
| * | | | | | | Merge branch '10.0' into bb-10.1-merge-sanjaOleksandr Byelkin2018-07-255-23/+35
| |\ \ \ \ \ \ \ | | |_|/ / / / / | |/| | | / / / | | | |_|/ / / | | |/| | | |
| | * | | | | Merge branch '5.5' into bb-10.0-merge-sanjaOleksandr Byelkin2018-07-233-3/+3
| | |\ \ \ \ \
| | | * | | | | MDEV-15050 scripts: mysql_install_db.{sh|pl}, mysqld_multi - mysqld is in ↵Daniel Black2018-07-163-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | @sbindir@ Closes #551
| | * | | | | | MDEV-14882 mysql_upgrade performs unnecessary conversions back and forthSergei Golubchik2018-07-191-20/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | avoid round-robin conversions, if the column is MODIFY-ed, it should always be modified to its final definition, not to some intermediate state. also avoid other unconditional changes, like ALTER TABLE event DROP PRIMARY KEY; ALTER TABLE event ADD PRIMARY KEY(db, name);
| | * | | | | | MDEV-11790 WITHOUT_SERVER installs mysqld_safe_helperSergei Golubchik2018-07-191-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Don't install server files if WITHOUT_SERVER is specified. "Server files" are defined as files going into the MariaDB-Server RPM, that is files in the components Server, ManPagesServer, Server_Scripts, IniFiles, SuportFiles, and Readme.
| * | | | | | | Merge branch '10.0' into bb-10.1-mergebb-10.1-merge-sanjaOleksandr Byelkin2018-07-191-0/+5
| |\ \ \ \ \ \ \ | | |/ / / / / /
| | * | | | | | Merge branch '5.5' into bb-10.0-mergeOleksandr Byelkin2018-07-171-0/+5
| | |\ \ \ \ \ \ | | | |/ / / / /
| | | * | | | | Added more help text in case mysql_install_db fails.Michael Widenius2018-06-271-0/+5
| | | | | | | |
| * | | | | | | Merge pull request #786 from codership/10.1-MDEV-14612Jan Lindström2018-07-181-7/+2
| |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | MDEV-14612 wsrep_sst_mariabackup unnecessarily converts address to host name
| | * | | | | | | MDEV-14612 wsrep_sst_mariabackup unnecessarily converts address to host namesjaakola2018-06-071-7/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SST script for mariabackup (wsrep_sst_mariabackup.sh) does reverse DNS to convert the joiner's IP address to domain name, and this is not always a wanted feature. It is not understood why this remote host DNS conversion is in the script, in the first place, but conversion was originally added by commit: commit 3d8aacba861044843417b710fff208b8bd6a53c4 Author: Nirbhay Choubey <nirbhay.choubey@gmail.com> Date: Wed Feb 22 15:58:45 2017 -0500 In this commit, REMOTEHOST variable is removed and replaced by REMOTEIP. All references to joiner is therefore by IP address only.
| * | | | | | | | MDEV-15442 xtrabackup-v2 SST donor stuck in DONOR/DESYNCED state when joiner ↵mkaruza2018-06-202-1/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | is killed SST transfer scripts rsync and maribackup now monitor parent process and will cleanup if process dies
| * | | | | | | | MDEV-15442 xtrabackup-v2 SST donor stuck in DONOR/DESYNCED state when joiner ↵mkaruza2018-06-191-1/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | is killed Monitor mysqld process and if it is terminated during sst stream kill xtrabackup-v2 script and children
* | | | | | | | | Merge branch '10.1' into 10.2Sergei Golubchik2018-06-213-16/+42
|\ \ \ \ \ \ \ \ \ | |/ / / / / / / /
| * | | | | | | | more sst test failuresSergei Golubchik2018-06-151-7/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * xtrabackup no longer support --compact * wsrep_sst_mysqldump wasn't always using --default-file * wsrep_sst.cc overquoted --default-file for wsrep_sst_mysqldump also remove redundant lines config and test lines, compiler warnings, and mark big tests as big.
| * | | | | | | | fix galera sst testsSergei Golubchik2018-06-141-3/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | note that ${A#foo} is $A if there's no prefix foo. That's why galera nodes tried to connect to 127.0.0.1:127.0.0.1 if there was no port in the address Followup for 2b35db5ac4e