View All Products
Compute
Storage
Networking
Databases
Services
Developer Tools
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ Linodes, Private IP, and MySQL
Log in to Ask a Question

Linodes, Private IP, and MySQL

development

I have some questions over performance issues I've seen when using the Private IPs and mysql.

I have a 720 connected to a mysql db on a 360. The 720 accesses the remote db across the private ip. In my test setup I am seeing a lot of DB timeouts and perfomance is nearly unusable.

I've ran a similar setup on a gridlayer account (nice but I like Linodes pricing :)) and I was able to push data fine.

Is there something I am missing here?

2 Replies

I'm running the same with Drupal and don't see any issues, performance is great. I'd look at your MySQL configuration …..

Conventional wisdom would say you should run your database on your most powerful, ram fuelled server and cluster your webservers over the smaller servers.

I'm assuming (almost certainly incorrectly) that you're running just the database on the 360 and just the httpd on the 720.

But anyway, even without reversing them, you should check to see how much RAM your database server is using. If it's eating into swap, it will destroy performance…

… But even then it shouldn't be timing out unless you're doing seriously heavy queries.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct