Hello!
I have 2 vps and have ping a private network:
- VPS 1 : 10.0.1.2
- VPS 2: 10.0.1.3
How do I setup remote sql: install wordops on both servers and follow the instructions for remote sql to vps 2?
WordOps with a remote MySQL server
You may need to create this file, otherwise edit the existing one: /etc/mysql/conf.d/my.cnf (in most cases this is the correct location)
Reference back to your MySQL database hostname, user, and password that were setup.
[client]
host=yourdb.cluster-xxxx.rds.amazonaws.com
user=youruser
password="supersecret"
These values will then be used during creation of a new site