search

DickinsonCollege / FarmData2

FarmData2 provides support for the operation and certification requirements of small organic farming operations.
Other
18 stars 136 forks source link

Zipped Database Images #567

Open braughtg opened 2 years ago

braughtg commented 2 years ago

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 commented 1 year ago

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 commented 7 months ago

I would like to work on this please!

braughtg commented 7 months ago

@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!