Solved

MySQL Database on SAN?

Posted on 2011-03-15
3
453 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 143

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 143

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Creating and Managing Databases with phpMyAdmin in cPanel.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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