WebFaction
Community site: login faq

Hello,

We have another question relating to changes to our current tech infrastructure. As of right now, we have a single, dedicated server which is running Django on apache, mysql percona and various batch jobs running throughout the day which is managed by cron.

The database is taking the bulk of the cpu and is likely to grow in load very soon. We are thinking of getting another dedicated server just for the mysql database to give it full capacity of the processor. Given the these dedicated servers will be within the webfaction intranet, we would like to know if it's possible for the web server on one host to connect to the database server on the other host without any encryption or ssh tunneling. Is it possible to set this up? Thanks.

Alok

This question is marked "community wiki".

asked 13 Feb '12, 19:54

alokist
326
accept rate: 0%

edited 13 Feb '12, 20:15

seanf
12.2k41836


Yes, this can be done by adding a dedicated IP address to your server running percona. On a dedicated IP address, we can open a port for your mysql server, and then you can configure mysql to only accept remote connections from the IP address of your other server. In this way, you should be able to achieve server-to-server direct communication without needing an SSH tunnel.

In order to add a dedicated IP address and/or open ports in an IP address, simply open a support ticket.

permanent link

answered 14 Feb '12, 03:32

ryans ♦♦
5.0k93360
accept rate: 43%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×103
×17
×6
×5
×4

question asked: 13 Feb '12, 19:54

question was seen: 2,480 times

last updated: 14 Feb '12, 03:32

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM