FROM debian:9

RUN apt update
RUN apt install -yq wget
ENV DEBIAN_FRONTEND=noninteractive

RUN cd /tmp
RUN wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-server_5.6.45-1debian9_amd64.deb-bundle.tar
RUN tar -xf mysql-server_5.6.45-1debian9_amd64.deb-bundle.tar --directory /var/cache/apt/archives/

RUN dpkg -R --install /var/cache/apt/archives/ || return 0

RUN apt-get install -fyq

# Remove pre-installed database
RUN rm -rf /var/lib/mysql/*

# Add MySQL configuration
ADD my.cnf /etc/mysql/conf.d/my.cnf
ADD mysqld_charset.cnf /etc/mysql/conf.d/mysqld_charset.cnf

# Add MySQL scripts
ADD import_sql.sh /import_sql.sh
ADD run.sh /run.sh
RUN chmod 755 /*.sh

ADD schema /schema
ADD data /data

# Exposed ENV
ENV MYSQL_USER admin
ENV MYSQL_PASS **Random**

# Replication ENV
ENV REPLICATION_MASTER **False**
ENV REPLICATION_SLAVE **False**
ENV REPLICATION_USER replica
ENV REPLICATION_PASS replica

EXPOSE 3306
CMD ["/run.sh"]