dbdeployer 1.30.1

Fix issue #80: NDB tarballs were wrongly labeled as regular "mysql" flavor

dbdeployer 1.30.0

BUGS FIXED

• Fix Issue #72 Catalog operations can clash with multiple dbdeployer runs
• Fix wrong description for defaults update
• Fix wrong description for cookbook create
• Fix option --sort-by incorrectly assigned to command cookbook instead of subcommand cookbook list

NEW FEATURES

• Add command dbdeployer info to improve dbdeployer usage in scripts

TESTING

• Add test for parallel usage
• Reinstate parallel deployment in functional test
• Improve replication between sandboxes test, by checking for existing versions better.

dbdeployer 1.29.0

ADJUSTMENTS

• Change upgrade procedure for MySQL 8.0.16+
• Adjust cookbook upgrade recipe to use verbose output

NEW FEATURES

• Add options --dry-run and --verbose to upgrade command

TESTING

• Enhance export tests

dbdeployer 1.28.1

NEW FEATURES

• Add option --sort-by=[name,flavor,script] to cookbook list
• Add option --flavor for versions command
• Add command export to show dbdeployer command structure as JSON
• Add cookbook recipes
  • Single sandbox deployed without starting the server
  • Replication sandbox deployed without starting the servers
  • Replication sandbox with custom names for directories and scripts
  • Single sandbox with admin address enabled

BUGS FIXES

• Fixed plural of custom replication names
• Add missing '$' in recipe skip-start-replication

dbdeployer 1.27.0

Add cookbook recipes:

• replication across multiple versions
• replication from group replication to single sandbox
• replication from group replication to master/slave
• replication from single sandbox to group replication
• replication from master/slave to group replication
• replication between single sandboxes
• circular replication

dbdeployer 1.26.0

NEW FEATURES

• Add custom replication_from script to each sandbox. See Replication between sandboxes
• Add metadata script to each sandbox
• Add option --port-as-server-id
• Add more info in sb_include script
• Add connection info scripts to each sandbox
• Add cookbook scripts for replication between groups, ndb, master/slave.

BUGS FIXED

• Fix "remote get" bug: it should fail on Mac (Issue #76)
• Fix port detection bug for NDB. The cluster port was not used in the search for free ports.
• Sort cookbook listing (it was being displayed in random order)

TESTING

• Add test for replication between sandboxes (single and master/slave)

dbdeployer 1.24.0 with dynamic cookbook recipes

Add new command cookbook with subcommands list, show, create

$ dbdeployer cookbook list
.------------------------.------------------------------------.--------------------------------------------------------------------.--------.
|         recipe         |            script name             |                            description                             | needed |
|                        |                                    |                                                                    | flavor |
+------------------------+------------------------------------+--------------------------------------------------------------------+--------+
| prerequisites          | prerequisites.sh                   | Shows dbdeployer prerequisites and how to make them                |        |
| single                 | single-deployment.sh               | Creation of a single sandbox                                       |        |
| delete                 | delete-sandboxes.sh                | Delete all deployed sandboxes                                      |        |
| fan-in                 | fan-in-deployment.sh               | Creation of a fan-in (many masters, one slave) replication sandbox | mysql  |
| all-masters            | all-masters-deployment.sh          | Creation of an all-masters replication sandbox                     | mysql  |
| group-multi            | group-multi-primary-deployment.sh  | Creation of a multi-primary group replication sandbox              | mysql  |
| replication-restart    | repl-operations-restart.sh         | Show how to restart sandboxes with custom options                  |        |
| replication-operations | repl-operations.sh                 | Show how to run operations in a replication sandbox                |        |
| master-slave           | master-slave-deployment.sh         | Creation of a master/slave replication sandbox                     |        |
| ndb                    | ndb-deployment.sh                  | Shows deployment with ndb                                          | ndb    |
| pxc                    | pxc-deployment.sh                  | Shows deployment with pxc                                          | pxc    |
| remote                 | remote.sh                          | Shows how to get a remote MySQL tarball                            |        |
| group-single           | group-single-primary-deployment.sh | Creation of a single-primary group replication sandbox             | mysql  |
| upgrade                | upgrade.sh                         | Shows a complete upgrade example from 5.5 to 8.0                   | mysql  |
| single-reinstall       | single-reinstall.sh                | Re-installs a single sandbox                                       |        |
| show                   | show-sandboxes.sh                  | Show deployed sandboxes                                            |        |
| tidb                   | tidb-deployment.sh                 | Shows deployment and some operations with TiDB                     | tidb   |
'------------------------'------------------------------------'--------------------------------------------------------------------'--------'

Examples:

$ dbdeployer cookbook create single
recipes/cookbook_include.sh created
recipes/single-deployment.sh created
version=$1
[ -z "$version" ] && version=8.0.16

$ dbdeployer cookbook create single --flavor=percona
$ grep version= recipes/single-deployment.sh
version=$1
[ -z "$version" ] && version=ps8.0.13

dbdeployer cookbook create tidb
dbdeployer cookbook create ndb

$ grep version= recipes/tidb-deployment.sh
tidb_version=tidb3.0.0
client_version=5.7.25

dbdeployer 1.23.0 with NDB support

Add support for MySQL Cluster (NDB)

New features:

• dbdeployer unpack correctly recognises MySQL Cluster flavor (ndb)
• dbdeployer deploy replication supports --topology=ndb and --ndb-nodes=X

Examples:

$ dbdeployer unpack --prefix=ndb ~/Downloads/mysql-cluster-8.0.14-dmr-macos10.14-x86_64.tar.gz
$ dbdeployer unpack --prefix=ndb ~/Downloads/mysql-cluster-gpl-7.6.9-macos10.14-x86_64.tar.gz

$ dbdeployer deploy replication ndb8.0.14 --topology=ndb --concurrent
$HOME/sandboxes/ndb_msb_ndb8_0_14/initialize_nodes
MySQL Cluster Management Server mysql-8.0.14 ndb-8.0.14-dmr
2019-03-16 08:19:55 [ndbd] INFO     -- Angel connected to 'localhost:21400'
2019-03-16 08:19:55 [ndbd] INFO     -- Angel allocated nodeid: 2
2019-03-16 08:19:56 [ndbd] INFO     -- Angel connected to 'localhost:21400'
2019-03-16 08:19:56 [ndbd] INFO     -- Angel allocated nodeid: 3
executing 'start' on node 1
........ sandbox server started
executing 'start' on node 2
.. sandbox server started
executing 'start' on node 3
.. sandbox server started
NDB cluster directory installed in $HOME/sandboxes/ndb_msb_ndb8_0_14
run 'dbdeployer usage multiple' for basic instructions'

$ ~/sandboxes/ndb_msb_ndb8_0_14/test_replication
# master 1
# master 2
# master 3
# slave 1
ok - '3' == '3' - Slaves received tables from all masters
# slave 2
ok - '3' == '3' - Slaves received tables from all masters
# slave 3
ok - '3' == '3' - Slaves received tables from all masters
# pass: 3
# fail: 0

dbdeployer 1.22.0

Fixes Issue #67 (dbdeployer sandbox setup fails with MariaDB 10.4.3) by @dveeden

dbdeployer 1.21.0

NEW FEATURES:

• Added support for Percona Xtradb Cluster (--topology=pxc) [Linux only]
• Added check for Unix tools before deploying.
• Added command delete-binaries
• Added option --overwrite to unpack command
• Added flavors to sandboxes
• Added options --flavor, --table, and --full-info to sandboxes
• Added option --flavor-in-prompt to deploy
• Added option --socket-in-datadir to deploy
• Added option --prompt to deploy single