Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I was just seeking some higher advice on whether or not having your main data on one database, then having separate server database to use for frequent updating and reading will prove to be an optimization or a failure. My logic was that sharing the load like this across 2 separate server databases will be quicker than packing it all in on one shared hosting Thanks for your time.

share|improve this question
    
Your "main data"...? –  Michael - sqlbot Feb 15 '13 at 17:58
    
Being the bulk of what I need to store, such as the member details –  kabuto178 Feb 15 '13 at 18:26
add comment

1 Answer

up vote 2 down vote accepted

Yes, you can and should use multiple servers if you have a high load in your mysql.

you need to see what solution works to you:

  • Replication

    • Master -> Slave: In this one, you will write(and also will be able to read) in the master server, and read from slave,

    • Master -> Master: In this one, you will be able to write and read in both servers (they will be action as master and slave), you need to be careful with AUTO_INCREMENTS

  • Cluster: You can have a look on mysql cluster, I'll recommend this option if you have more than 4 server (masters or slaves in total).

share|improve this answer
    
Thanks for your reply, and right away I can see why I would have to be careful with AUTO_INCREMENTS with the Master->Master method. Thanks for the tips. –  kabuto178 Feb 15 '13 at 16:58
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.