MySQL-AutoXtrabackup command-line tool, for automating tedious MySQL physical backups management
Project description
MySQL-AutoXtrabackup
MySQL AutoXtrabackup commandline tool written in Python 3. The source code fully typed with hints - structured the project mostly similar to FastAPI and Pydantic
For community from Azerbaijan MySQL User Community: Python Azerbaijan Community.
For any question please open an issue here.
What this project is about?
The idea for this tool, came from my hard times after accidentally deleting the table data. There was a full backup and 12 incremental backups. It took me 20 minutes to prepare necessary commands for preparing backups. If you have compressed + encrypted backups you need also, decrypt and decompress, which is going to add extra time for preparing backups. Then I decided to automate this process. In other words, preparing necessary commands for backup and prepare stage were automated.
If you think, CLI is not for you. We have experimental feature where you can start API server and take backups using API call.
sudo `which autoxtrabackup` --run-server
INFO: Started server process [30238]
INFO: Waiting for application startup.
app started
INFO: Application startup complete.
INFO: Uvicorn running on http://127.0.0.1:5555 (Press CTRL+C to quit)
$ curl -X POST http://127.0.0.1:5555/backup
{"result":"Successfully finished the backup process"}
For the rest please read the full documentation.
Development:
Current major version is >= 2.0 - so if you want to help, please do changes on this branch and then kindly send PR :) I also encourage you to upgrade from older version as the code base fully updated.
Read full documentation here:
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for mysql_autoxtrabackup-2.0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | e8b3de31c93065d2629fee234468c46b7c244bf9f7a55edbc1fc06110f6af86c |
|
MD5 | 0c8dbf3a85fcab4450981fa048cb9e6c |
|
BLAKE2b-256 | 10d727d30fa0f1b6882eea5ce584ff9f8ba9e0b2ef061f5eb3b6c6b3f6c60c7e |
Hashes for mysql_autoxtrabackup-2.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3ef7dccd98f7268f16a1f55ee16e3d5a31f608aee4ff7e7dc2d8d16245a6c1e0 |
|
MD5 | 9568271a20351d3b82a5d70b619cae96 |
|
BLAKE2b-256 | dda4a4ca4984a0ec055c853cb1529d38f89d76dfc4d5b43b6356deeae213f809 |