Solved

MySQL Database on SAN?

Posted on 2011-03-15
3
449 Views
Last Modified: 2012-05-11
I have created a Windows 2008 Load Balancing cluster and I have two separate installs of MySQL on each server (two servers total).

I don't know MySQL at all and I'm wondering if it would be better to syncronize the databases between the two clusterd web servers or should i put the database on a SAN?

For either solution, I would need guidance on the steps needed to make it happen.

Thanks.
0
Comment
Question by:ULadmin
  • 2
3 Comments
 

Author Comment

by:ULadmin
ID: 35149813
A real stumper, huh?

Let me rephrase

1.  Should I put a MySql database on a SAN?  

2. If not, how do I synchonize MySQL databases between two servers?
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 35150159
>1.  Should I put a MySql database on a SAN?  
there is no reason not to put any kind of database onto a SAN
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35154231
actually, I forgot to post something for:
2. If not, how do I synchonize MySQL databases between two servers?

mysql has replication:
http://dev.mysql.com/doc/refman/5.0/en/replication.html
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now