Initializing a container to run on MySQL using Kubernetes

Question

I'm running mysql as an init container of a kubernetes deployment. For various reasons I need to start mysql in the init container/restore a backup of mysql -> save it into a pvc and then the main pod will be a mysqlpod with the data attached to it. This is because I need to take a snapshot of the disk, and I will have CI monitor the snapshot until the pod is ready/running. So I can't just dump the dump.sql into docker-entrypoint-initdb.d and be done

P粉683665106 · Answer

You can start mysql sleeping in the background before mysqld. Does this work for you?

start_mysql {
    sleep 30
    mysql -u root -ppassword < /data/backups/backup.sql
    mysql -u root -ppassword < /sql-files/sql-files.sql
}

start_mysql &
./entrypoint.sh