Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Zipped Database Images #567

Open
braughtg opened this issue Jul 30, 2022 · 3 comments
Open

Zipped Database Images #567

braughtg opened this issue Jul 30, 2022 · 3 comments
Labels
enhancement Improvement to the project infrastructure A bug/feature related to the project infrastructure. question Further information is requested

Comments

@braughtg
Copy link
Member

The empty and sample databases are stored in compressed .bz files. This is done by taring/zipping the docker/db directory. A question to investigate is if all files in the db directory must be included in the zip. For example, the contents of that directory are:

aria_log.00000001			ib_buffer_pool		mysql
aria_log_control			ib_logfile0		mysql_upgrade_info
ddl_recovery-backup.log			ibdata1			performance_schema
ddl_recovery.log			ibtmp1			sys
farm					multi-master.info

So for example are files that have log in them required for the database to function when the directory restored? If not, then the size of the compressed databases can be reduced. This requires some investigation.

@braughtg braughtg added enhancement Improvement to the project question Further information is requested labels Jul 30, 2022
@braughtg braughtg added the infrastructure A bug/feature related to the project infrastructure. label Jan 16, 2023
@braughtg
Copy link
Member Author

A related issue is that it would be good to extract the database image from the github repository. Having it there with all of its version history each time it is rebuilt is bulky. Perhaps the sample DB should be a separate repo where it is pulled from as a release?

This is related to #613

@NandiniK0401
Copy link

I would like to work on this please!

@braughtg
Copy link
Member Author

@w0501872 This looks like you may be using the GitKit in your course. If that is the case you should be claiming an issue on the "upstream" repo for your course rather than on the main project repo. Your instructor will have given you the proper URL.

That said, if you want to contribute to the "live" FarmData2 project by working on this issue, please let me know!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement Improvement to the project infrastructure A bug/feature related to the project infrastructure. question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants