- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Software Mirror a Database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 02:32 AM
тАО02-06-2002 02:32 AM
The server will be upgrade to A or L class, my HP sales recommend to use sc10 as data storage with software mirror (MirrorUX). They said the CPU can perform mirroring efficiently.
Since sc10 can be hot swapped, if one of the mirrored disk is down, the database service should not be interrupted, the replaced disk can be synchronized.
But my concern is, is it need to stop the database during data synchronization, or need to restart the database after data synchronization?
Please help, thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 02:45 AM
тАО02-06-2002 02:45 AM
Re: Software Mirror a Database
If you have mirrorUx software, the sinconization process impact in the througput, but you don't need to stop your database. This is a O.S process.
Regards,
Justo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 02:48 AM
тАО02-06-2002 02:48 AM
Re: Software Mirror a Database
You can continue to run normally while a syncronisation is made. Of course, you will have a performance drop during this time, though.
HTH,
Vince
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 03:29 AM
тАО02-06-2002 03:29 AM
Re: Software Mirror a Database
Mirroring offers a higher degree of protection (multiple disks can go down, in RAID5 only one can go down and then you are unprotected). You can configure a hot spare to automatically take over the defective disk. But you will need more disks and there *IS* a CPU overhead. If a mirroring configuration with a "cheaper" disk box is less expensive than a configuration with a hardware RAID5 disk box, I think mirroring is a good choice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 04:17 AM
тАО02-06-2002 04:17 AM
Re: Software Mirror a Database
If you want better performance for your data, I suggest adding an fc60 in front of the sc10, and I actually suggest an fc10 over an sc10. If you are going to an L then get fibre channel cards.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 05:58 AM
тАО02-06-2002 05:58 AM
Re: Software Mirror a Database
All I worry about is one of my colleague mentioned that in AIX, a database (raw device) need to restart after a software mirrored disk is replaced and need data synchronization. I afraid it will also happen in HP-UX.
It is my first time to post message here, I found it is very helpful, thanks all again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 06:54 AM
тАО02-06-2002 06:54 AM
Re: Software Mirror a Database
This is because your collegue is using a raw device and then the device is not under the O.S. In your case if you have the database files under the HP/UX file system and with mirror/ux you don't have this problem.
Best Regards,
Justo.
PD: It's your first time, then don't forget to put your points to the replays.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 07:38 AM
тАО02-06-2002 07:38 AM
Re: Software Mirror a Database
Yes, once you replace a disk the logical volume mirrors for that disk will need to be re-synchronized. However, there are commands that allow you to do this with the system up and running. Technical Knowledge Base document# KBAN00000347 gives instructions. I've attached it for your convenience.
My memory about AIX is fuzzy but I'm fairly certain you can mirror or re-sync logical volumes in AIX without stopping the app using those LVs.
Darrell
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 07:42 AM
тАО02-06-2002 07:42 AM
Re: Software Mirror a Database
As far as I understand, the MirrorUX (software mirroring) mirror the data in system level, all it knows is VG or LV, it doesn't care about whether it is a raw device or a file system, therefore, it sync the data block by block when one of the mirrored disk was replaced. Is it correct?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2002 08:06 AM
тАО02-06-2002 08:06 AM
SolutionYes, you are correct. As long as you have the mirroring setup correctly for all the VGs on the system, it should work fine . When a disk fails, the database will still run since it has two copies (primary and mirror disk).
When a new mirror disk is attached, it will get synchronised automatically in the background. You don't need to bring the database down. But, during the synchronisation, there will be some performance bottlneck.
HTH
raj