I have a pod in my AWS EKS Cluster that runs MySQL:5.7. I have an SQL file that initializes and populates the data for it. in a normal docker-compose, I will use a mount point for it in my docker-compose file:
volumes:
- ./<path-to-my-config-directory>:/etc/mysql/conf.d
- ./<path-to-my-persistence-directory>:/var/lib/mysql
- ./<path-to-my-init.sql>:/docker-entrypoint-initdb.d/init.sql
In EKS, I can create a storage class in which to save MySQL data.
How can I use my init.sql file (about 8GB) to initialize the MySQL pods running in the EKS cluster?
Update: there is another question that explains how to do this if you have a small init file or have access to the Kubernetes host: How to initialize mysql container when created on Kubernetes?
In my case though, I am on AWS EKS and my init file is a few gigabytes, so any help would be greatly appreciated.