Mysql Mariadb setup help!
Hello ya all. Hope everyone is safe and healthy.
I need to setup a mysql/ mariadb instance... on a cloud server... I need to be able to setup tls / ssl so that the connection is ALWAYS encrypted. This is a pilot setup for me, so I am planning to use let's encrypt certs.
Just trying to see if:
A. Should I just do a native install or use docker?
B. I understand I need to do some type of hardening of the db instance... any suggestions?
C. Should I expose the db instance directly to the outside world as the connections will happen from over the internet... or is there some type of proxy or similar I can use?
D. I will probably need to connect from fixed up, so that will be only allowed host. However my home internet is dynamic ip.. so what options do I have? I would prefer to not open % access. Any suggestions?
E. How to ensure that the connection to the db server are 100% encrypted and deny all non encrypted connections?
Awaiting suggestions. Thanks in advance