Q

Data migration options

Brett Cooper answers the question: What is the best practice for moving AIX 5.2 data, including an Informix database, over to a SAN that is attached through fiber?

What is the best practice for moving AIX 5.2 data, including an Informix database, over to a SAN that is attached through fiber?
There are multiple answers to your question depending on your goals for the project, budget and your organization's ability to schedule a maintenance period for you to migrate the information. In each of the options there will be a tradeoff. For example, a simple solution might have a high cost and a lower outage period, or a more complex solution might have a lower cost and a longer outage period.

The easiest option would be to schedule maintenance (telling all users and associated applications that the main...

database will be going down for a period of time), perform a full backup to tape of the database and other files that are kept on the local storage, then move to the new storage environment and do a restore, testing before putting the system back into production.

The next option is a bit more complex and does not leave you with a backup copy of the data (I would strongly suggest taking a backup before trying this or any other solution). Take a scheduled maintenance period and install the SAN. Copy the database in its entirety and all associated files to the SAN, reconfigure the database and you are on your way. Also, most databases will allow you to log writes to another location to protect against failures during operations. You can setup the journaling option of your database to do this as well.

Finally, you can use the AIX Logical Volume Manager (LVM) to create a mirror of the database storage from your local storage to the SAN storage. This provides a great advantage as the mirror is a perfect copy of the information within the environment.

If you want to setup a larger environment, you can always setup a remote mirror to another host that has the SAN storage behind it using Veritas Volume Replicator or other remote mirroring solution. This will cost you some budget dollars and will still require a scheduled maintenance period to install the software and configure the environment.

I would strongly suggest testing in a lab prior to the move to the SAN and documenting the procedure you select. In addition, I would suggest working with the vendor of the SAN equipment to insure that you have the right level/latest device drivers and firmware for each part in the SAN: HBA, switch and storage device.

This was first published in November 2005

Dig Deeper on Data management tools

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchSolidStateStorage

  • Tintri VMstore T5000

    Like all of its VM-aware storage systems, Tintri’s first all-flash array -- the Tintri VMstore T5000 -- allows admins to bypass ...

  • SolidFire SF9605

    The high-capacity SolidFire SF9605 uses SolidFire’s Element OS 8 (Oxygen) to deliver new enterprise features such as synchronous ...

  • HPE 3PAR StoreServ 20850

    HPE 3PAR StoreServ 20850 holds 1,024 solid-state drives (SSDs). Hewlett Packard Enterprise claims it can deliver more than three ...

SearchVirtualStorage

SearchCloudStorage

SearchDisasterRecovery

SearchDataBackup

  • Asigra Cloud Backup Version 13

    Asigra Cloud Backup Version 13 provides an AWS Elastic Block Store Snapshot Manager and the ability to support Docker container ...

  • Veeam Availability Suite v8

    Veeam Availability Suite v8 offers several key backup software components in one package, including Veeam Cloud Connect, Snapshot...

  • Druva inSync 5.5

    Druva inSync 5.5 endpoint backup software stands out with its proactive compliance, cloud app integration, full text search and ...

Close