Solved

MySQL Database on SAN?

Posted on 2011-03-15
3
451 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Duplicating MySQL Table columns 5 37
change database name 2 28
insert into database through form with dynamic fields. 2 28
Create a MySQL table as easily as possible 6 35
A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

786 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