We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Migrating MySQL Databases to newly attached SAN

csnetops
csnetops asked
on
Medium Priority
227 Views
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.
Comment
Watch Question

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


Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.