Migrating MySQL Databases to newly attached SAN

Posted on 2009-02-13
Last Modified: 2013-11-14
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.
Question by:csnetops
    LVL 2

    Accepted Solution

    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:


    Author Closing Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This article describes some very basic things about SQL Server filegroups.
    AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now