~/talk

DBdeployer, the Community Edition

Talkat Percona Live Online 2020 · 2020-10-20..10-21· [databases]
slides:none on file

dbdeployer is a Go command line tool shipped as a single binary per OS that initializes an environment, downloads MySQL/Percona tarballs, and deploys isolated sandboxes: single instances, one master two slaves replication, three‑node group replication (default all primaries) and full MySQL Cluster and Percona XtraDB Cluster support. Sandboxes include custom scripts (use, start, stop, show log), concurrent deploy speeds parallel node creation, features like clone and custom roles work for MySQL 8.0, and send kill destroy simulates crashes and forces fast deletion.

AI-written summary · about

  1. 0:00dbdeployer The Community edition Giuseppe Maxia
  2. 1:17dbdeployer . Command line tool
  3. 2:10Main features Isolated sandboxes (different directories, ports, sockets) . Single sandbox • Replication sandbox . Group replication • MySQL Cluster (NDB) • Percona XtraDB cluster • Customised scripts for each sandbox
  4. 3:33Main operations
  5. 4:39downloads dbdeployer downloads list dbdeployer downloads get-by-version 8.0 --newest --minimal
  6. 5:37unpack dbdeployer unpack mysql-8.0.21-linux-glibc2.17-x86_64-mininal.tar.xz
  7. 6:00deploy single dbdeployer deploy single 8.0.21
  8. 6:22deploy replication dbdeployer deploy replication 8.0 --concurrent
  9. 7:27deploy group replication dbdeployez deploy replication 8.0 --topology-group --concurrent
  10. 8:01sandboxes dbdeployer sandboxes --full-info
  11. 8:32Sandbox usage
  12. 9:36multiple sandbox (1)
  13. 10:34delete dbdeployer delete all --concurrent --skip-confirm
  14. 10:59Usability Features added at community requests
  15. 11:09dbdeployer init Prepares the environment to use dbdeployer from scratch
  16. 12:22dbdeployer delete-binaries Deletes an expanded tarball
  17. 12:53NDB deployments
  18. 14:39Clone
  19. 14:55Set/unset default sandbox Defines a sandbox as default, and run all operations on that one.
  20. 15:17custom roles Add customised roles and assign to users.
  21. 15:33Add custom master options Define flexible replication options during deployment
  22. 15:50send_kill destroy! Allows simulation of server crash. . Also allows faster delete operations
  23. 17:16DEMO
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.