hosting database on separate server

Posted by Amit Aggarwal on Server Fault See other posts from Server Fault or by Amit Aggarwal
Published on 2011-02-22T06:31:08Z Indexed on 2011/02/22 7:26 UTC
Read the original article Hit count: 850

Filed under:

mysql

|

hosting

|

app

|

imagick

Hello Experts,

We have an enterprise web app to which our clients post/upload lots of documents [mainly images and pdf files] via web interface, iphone app etc etc. We are also using imagick to split pdf documents into images.

Also, large number of mysql SELECT/UPDATE/DELETE queries happen all day.

Currently, all of this is happening on same server and we are planning to split the process in 3 stages :

1) a server only for database

2) a server only for documents (document upload, splitting etc)

3) a server for the main php web app

Is there any drawback with this kind of structure as compared to hosting everything on same server ?

Please guide.

Thanks, Amit

© Server Fault or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about hosting

Suitable Hosting for Web Development Company: VPS Hosting, Cloud hosting, Shared Hosting

as seen on Pro Webmasters - Search for 'Pro Webmasters'
Hi, We are web development company here in nepal. We are still in growth phase. Our URL: http://www.outsourcingnepal.com We have our clients demanding for web hosting and are now ready for getting hosting package to host websites of our clients. Since we have multiple clients and they want their… >>> More
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hos

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hosting, Michigan Sclera, a Microsoft Hosted Services Provider Partner, is offering key Service Offerings around the Microsoft SharePoint Server 2010 stack. Specifically – if you’re looking for SharePoint… >>> More
Hosting 2 Sites Under 1 DiscountASP.Net Hosting Account

as seen on Server Fault - Search for 'Server Fault'
I've currently got an ASP.Net site hosted with DiscountASP.Net what I would like to do now is put a second site in a subdirectory of this original site and register a new domain to point at the subfolder, so to the end user its 2 completely seperate sites. I've asked DiscountASP support if they could… >>> More
Is virtual hosting any better than shared hosting?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any real performance gain on a virtual hosting over a shared hosting? Do you recommend any virtual hosting costing bellow $100? >>> More
moving from shared-hosting to VPS-hosting

as seen on Server Fault - Search for 'Server Fault'
Hi, I'm thinking of moving my social network from shared hosting to VPS hosting. I'm not familiar with VPS and have no experience. Will that be a problem? Thanks >>> More