Page 1 of 1

Adding Remote MySQL Database Server

Posted: Thu Aug 13, 2015 12:35 am
by SANDPOND
HELLO:

In regard to the following Vesta instructions:
1. It is assumed you already have your second server up and running.
2. On the first server run following command: v-add-database-host mysql new-server.com root password
3. To make sure eveyrhing is in order, check database host list
v-list-database-hosts


QUESTION 1: Does this setup a "secure" SSH connection to the remote server?
QUESTION 2: Can this server be a Percona Server which was set up from scratch?

THANKS !

Re: Adding Remote MySQL Database Server

Posted: Fri Aug 14, 2015 10:50 pm
by skurudo
SANDPOND wrote: QUESTION 1: Does this setup a "secure" SSH connection to the remote server?
Nope, If you don't connect over SSL or some other encrypted tunnel, I would absolutely assume that anything you send or receive from MySQL is done so in clear text that can be intercepted.

Docs:
https://dev.mysql.com/doc/refman/5.1/en ... tions.html
SANDPOND wrote:QUESTION 2: Can this server be a Percona Server which was set up from scratch?
v-list-database-hosts see your Percona server? Then don't see any problem here.