Option to download MySQL about dbdeployer

[datacharmer]

As of version 1.16.0, dbdeployer can download remote MySQL tarballs from a Github repository. The tarball are reduced ones, created inside Mysql-Docker-Minimal.

The tarballs are only available for Linux. However, since the URL for the files is customizable, you can use your own repository to download files for other operating systems.

Example:

$ dbdeployer remote list
Files available in https://raw.githubusercontent.com/datacharmer/mysql-docker-minimal/master/dbdata/available.json
4.1 -> [4.1.22]
5.0 -> [5.0.15 5.0.96]
5.1 -> [5.1.72]
5.5 -> [5.5.60 5.5.61]
5.6 -> [5.6.40 5.6.41]
5.7 -> [5.7.23 5.7.34]
8.0 -> [8.0.12 8.0.13]

msandbox@testdb:~$ dbdeployer remote download 8.0.13
File /home/msandbox/8.0.13.tar.xz downloaded

msandbox@testdb:~$ dbdeployer unpack 8.0.13.tar.xz
Unpacking tarball 8.0.13.tar.xz to $HOME/opt/mysql/8.0.13
.......79

Tarballs for other operating systems (or from other distributions, such as Percona Server, may be made available if someone gives me access to a reliable server that can host the files.

Specifically, minimal tarballs for MacOS are going to be larger than the ones for Linux, and therefore I am skipping plans to include them in the current repository for the time being.

[datacharmer]

This feature is high in the TODO list.
dbdeployer's antecedent, MySQL-Sandbox, has such feature (make_sandbox GET:5.7).

That feature uses a fixed location (my Github repository for reduced MySQL tarballs).

In dbdeployer, it should become dbdeployer unpack GET:5.7 or dbdeployer unpack GET:5.7.xx or dbdeployer unpack --repo-url=https://someplace.org tarball-name.

There are four reasons for delaying the same feature in dbdeployer:

1. the location used is not appropriate for this purpose. GitHub should not be used as a data repository, and the latest releases of MySQL, even when stripped of all unnecessary files, are beyond the recommended limit of 50 MB.
2. The MySQL Community team at Oracle has promised to provide such repository, but it is taking some time.
3. The repository should not only offer a simple MySQL tarball for each version, but also some flavors, such as:
   • complete and ofter unnecessarily heavy MySQL tarball
   • reduced tarball (the very minimum)
   • Reduced tarball with just MySQL server + debug server and plugins
   • MySQL server + MySQL shell + MySQL router
4. The current repository is only for Linux tarballs. I should add MacOs ones and maintain them.

In short, I don't want to release a feature that depends on a location that might not be sustainable.
The alternative to using Oracle's official repository (when it is provided) is that someone in the MySQL community commits to maintaining the repository with a dedicated web server.

BTW, in your examples above, the package to download for MacOs is always a .tar.gz, not a .dmg.