• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Migrating MySQL Databases to newly attached SAN

I will be brining our database server down to attach the fiber card which will inturn connect me to a new SAN for storing our Databaase files. Our current Dbs live on a local raid 5 set. Unfortunately our databse is around 350Gb so a simple shutdown and copy wont work as it is our live database. Does anyone know of a replication solution to replicate the local databse files to the new LUN and then I can simply recyle the service once they are in sync and point to the new location? Of course the salemen said yes to all my questions but now I am waiting for them to get back to me with how and so far no luck.
0
csnetops
Asked:
csnetops
1 Solution
 
gandalf97Commented:
Just to clarify...  If you are bringing down the database server, won't that shut off access to the database?  If so, won't it give you a window to copy the data?  How long do you estimate that it would take you to copy the 350GB to the SAN?  If you could do this at an "off" time, I think this would be the simplest approach.

If you really can only afford a couple of minutes of downtime to put in the new fiber card, then you might want to try replication.  Once the SAN is up, you can replicate your database to it and eventually take your other one offline.  Here are some links on MySQL replication to get you started:

http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

http://www.howtoforge.com/mysql_database_replication


0
 
csnetopsAuthor Commented:
I agree this is a better route. I just need to modify and create a new slave so I can chain them. My current issue is I have too slaves that hit the master direct.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now