search

devopsicon / files-microservice

Files Microservice
GNU General Public License v3.0
1 stars 0 forks source link

Add MySQL with big blob binary storage #7

Open danielyinanc opened 6 years ago

danielyinanc commented 6 years ago

We are currently using file system to store files, we need to move to MySQL as per our design.

Using database for file/binary storage allows us to use Containerized deployment mechanisms such as Docker, Heroku, Cloud Foundry and/or Kubernetes/Bluemix effectively

xmarkakis commented 6 years ago

hey @danielyinanc could you provide some more information around the issue or help you want?

danielyinanc commented 6 years ago

Just updated description. https://github.com/devopsicon/design has more context... we are trying to use Files Microservice to use a database. Very interesting learning experience it will be for you IMHO.

xmarkakis commented 6 years ago

Maybe we can talk about this more on Monday but I agree, this will be a great learning experience.

I’m wondering where to start. Do I just download the enterprise trial version from the MySQL website and then go from there?

danielyinanc commented 6 years ago

Use community edition... https://dev.mysql.com/downloads/ Heroku comes with a free mysql database which we will use on staging and production but for development, this will do.

Below are some python code samples: https://dev.mysql.com/doc/connector-python/en/connector-python-examples.html https://github.com/mysql/mysql-connector-python/tree/master/examples

How to use python to store a file as blob using python: http://www.mysqltutorial.org/python-mysql-blob/