Private Networking - mysql server

July 22, 2014 5.3k views
post
By:
post

Hey all.

I was wondering if anyone could help me in what i'm doing wrong here.

I want to have a droplet be mysql server for my other droplets.
Both droplets are on amsterdam2. both with private networking turned on.
one is running ubuntu with lamp on. the other is a fresh ubuntu only with mysql installed.
i use SSH key for both servers.
i have set my bind-address to my mysql eth1 inet address.
When i set bind-adress up to the servers eth0, could i connect from my own pc.
both servers can ping each other.

I want the mysql server to only be visible on the private network

Soo. what am i doing wrong here? :)

Log In to Comment
1 Answer
post July 22, 2014

never mind :D

Forgot that i should probably install a mysql client on the website server.

(read this https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql to understand that)

How To Set Up a Remote Database to Optimize Site Performance with MySQL
by Justin Ellingwood
When your site begins to get more visitors, you may have to think about how to handle the additional traffic. One easy way of doing this is to separate your database operations from your web server so that each can handle its own load. In this guide, we'll demonstrate how to do this for a WordPress site built on Nginx by configuring a remote MySQL database.
Reply
Have another answer? Share your knowledge.