Let’s say I have a traditional webapp with two servers, one web and one mysql. Using a VPS or cloud-based provider, how would I go about scaling my database? Without a traditional SAN, how would I make it so that my mysql DB knows where the datafiles are stored?
Answer
Have you considered Amazon RDS?
Amazon Relational Database Service
(Amazon RDS) is a web service that
makes it easy to set up, operate, and
scale a relational database in the
cloud. It provides cost-efficient and
resizable capacity while managing
time-consuming database administration
tasks, freeing you up to focus on your
applications and business.Amazon RDS gives you access to the
full capabilities of a familiar MySQL
database. This means the code,
applications, and tools you already
use today with your existing MySQL
databases work seamlessly with Amazon
RDS…
Attribution
Source : Link , Question Author : sdot257 , Answer Author : Traveling Tech Guy