Installing MySQL on a separate server

What guide can I follow to have MariaDB installed on a separate server and everything else on another. Also, what specs do you recommend for the DB server? Will the 1GB Linode be good for it and the 2GB for the Web Server for a Wordpress install that gets roughly 4000 uniques per day?

---

 

If I have 4GB RAM, wouldn't FastCGI be a better option than WP Super Cache?

 

I have set things up according to the guides but I cannot seem to connect from my Web Server to my DB server with the Wordpress setup. When running Wordpress setup, database connection can't be established. I've made sure Port 3306 is set in both TCP_IN and TCP_OUT sections as well as whitelisted the IP of the web server on the DB server. What else can be done?

 

|I believe I am granting access. I'm using the following command on my Database server:

update db set Host='xxx.xxx.xxx.xxx' where Db=‘db_name';

I've put the IP address abd db name where required above. And I'm just using the root user for mysql which already has remote access privileges, no?

 

Hmm- when I try to add root using
update user set Host='xx.xx.x.x' where user='root';

I get the following error:
Duplicate entry '80.85.87.60-root' for key 'PRIMARY'

 

Ugh- a bit too technical for someone not very familiar with all this.

How big is the hit if use MySQL on the same server? Should I increase resources on that?

 

Thanks! That worked