0
votes
2answers
324 views

Should i separate MYSQL from PHP and NODE JS to another server

I am a PHP Programmer and working on community website. I am using Apache NodeJS Php and Mysql on server: 24GB RAM Intel i7 950 8Cores 8Threads 3.06GHz, 120GB SSD HDD 12GB SWAP (dedicated server) OS: ...
1
vote
1answer
682 views

centos mysql keeps crashing, what to do?

I recently got a dedicated server under CentOS with OVH. Everything has been working fine since 2 months, but starting a few days ago mysql keeps crashing and that causes various problems with my ...
1
vote
2answers
2k views

Issue Starting MySQL Daemon

I have just come across the most random error I've seen my MySQL daemon spew out yet, everything was working fine, then all of a sudden it randomly crashed and it now outputting this when I start it ...
0
votes
1answer
2k views

Error running MySQL Daemon

I'm getting a bizarre error running my mysql daemon as the user 'mysql' here is what the command spews out, now I've checked and the instance isn't running already :S So, I have no idea why it's ...
2
votes
3answers
177 views

Create a full replica of web server using different hosting company, is it logical?

Is it logical to create a full replica of our webserver, just on a less powerful machine, using other hosting provider ( just because its cheaper ). The idea is to have a plan B, in case main server ...
3
votes
1answer
206 views

Document and best practices for configuration of a dedicated server (Centos) to serve just one website

I have just bought a dedicated server and they provide me a IP address, access info as root and machive with Centos 5. I would like to serve my django app in that machine but because I have no ...
0
votes
1answer
342 views

MySQL memory usage monitoring and logging

I have noticed that my dedicated server is using 336mb for mysql. The server only has around 10 domains that are regularly visited throughout the day (there's roughly 10 more but are hardly ever ...
0
votes
1answer
85 views

Beginning the process of searching for dedicated server

I need help about choosing the right dedicated hosting service, one which will suite my needs, and what equipment I will need. All I can tell you is that while most of the computers will be dells ...
0
votes
1answer
303 views

Guide to setting up a RHEL5 dedicated web-server for a LAMP website?

I'm setting up a dedicated webserver which will host just one website, ours, which runs on PHP/MYSQL. What all steps should I undertake to make sure everything is configured properly? Is there a ...
0
votes
2answers
79 views

Migrated to new server, DNS setup >48 hrs, some MySQL inserts from domain still show up on old server

Title says it all - I've migrated to a new dedicated server at a different IP.. It's been more than 48 hours since DNS was setup. Some MySQL inserts (standard php variables invoke mysql) from at ...
2
votes
2answers
4k views

Are MySQL databases always stored in /var on CentOS?

Are MySQL databases always stored in /var on CentOS? Specifically - If a new CentOS/cPanel server that needs to support MySQL, doesn't have that partition, but only has these, does that mean MySQL ...
1
vote
1answer
336 views

Migrate servers without losing any data / time-limited MySQL dump?

Is there a way to migrate from an old dedicated server to a new one without losing any data in-between - and with no downtime? In the past, I've had to lose MySQL data between the time when the new ...
0
votes
4answers
3k views

Apache and MySQL taking all the memory? Maximum connections?

I've a had one of our servers going down (network wise) but keeping its uptime (so looks the server is not losing its power) recently. I've asked my hosting company to investigate and I've been told, ...
1
vote
6answers
12k views

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’

Overnight one of our servers had too many connections. Upon rebooting I now get the following via Plesk: ERROR: PleskFatalException Can't connect to local MySQL server through socket ...