Run process to resynchronize mirrors during database backups?? What does it mean???


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Run process to resynchronize mirrors during database backups?? What does it mean???
# 1  
Old 04-14-2002
Run process to resynchronize mirrors during database backups?? What does it mean???

does anyone have any idea of what this means and if you do, please elaborate more on what you know about this and the importance it carries along.

by the way, we dealing with Linux and Solaris 8 systems here
# 2  
Old 04-14-2002
When you have a disk mirrored, both copies must be the same. Sometimes, they are not and then you need to synchronize them (usually by running a command to copy one to the other - realize this is not a cp command but is being explained that way)

With Solaris you would be probably using one of two software products - DiskSuite or Veritas. The commands for each are entirely different. Suggest you figure out which you are using and read the manuals.

$ df -kl

If the output has devices that contain /md/ - Disksuite is being used there.
If the output has devices that contain /vx/ - Veritas Volume Manager is being used.

Opinion - DiskSuite for OS drives - Veritas for Data drives. Veritas is a pain in the neck when dealing with OS drives (which is why most don't use it for OS). DiskSuite isn't as robust for Database/Data drives which is why you spend some $$$ and get Veritas. DiskSuite comes with Solaris 2.6 and above. Not sure about below 2.6.

Check out docs.sun.com for on-line docs on DiskSuite.

Check out Veritas Support for on-line docs on Veritas.


For Linux Mirrors check out this link.

For general info on Raid levels

The subject you posted "Run process to resynchronize mirrors during database backups" - was this an error while running backups? If so - is it happening on both Linux & Solaris? What type of backup (data dumps, ufsdumps, vxdumps, 3rd party backup solution {version}). Give more info unless you are just looking for information on Raid.
thehoghunter
# 3  
Old 04-14-2002
The thing here is that, I am learning about this mirroring stuff.


I was reading a "Linux Red Hat 6.1 Bible" book and they talked about backing up data to hard drives and they go on to list the advantages and disadvantages

Now, they say that for Linux Red Hat systems, I can download the file mirrordir-0.10.39.tar.gz. after downloading, I then unzip and cd to the directory and type the commands "configure" and "make install" to install the new downloaded file.

now, after all the installing is done and assuming that I already have a ready second hard drive. They say I have to make a new directory by typing "mkdir -p /mirror/home"

assuming I want to mirror the home directory on my original disk to the second hard drive, I have to mount the second hard drive by typing "mount /dev/hdb5 /mirror/home"

/dev/hdb5 stands for the second hard drive.

now, to do the actual mirroring, I have to type "mirrordir /home /mirror/home"

this command causes the contents of the /home directory on my original disk to be exactly duplicated in the /mirror/home directory


now, what I want to know is that, to those who actually do this at work, is this example I got from the linux book a good example for a beginner like me to follow?? and if not, please, set me right.

thanks
# 4  
Old 04-15-2002
The example in the book is a little confusing because few people would have a database in their home directory Smilie A more practical example would be a MySQL user who has the database located in /usr/local/mysql/data and is running an application than requires mirroring...... then you might have the mirror on /mirror/mysql/data.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. HP-UX

Database replication process stopped in server

Hi, A database (Oracle) replication process was executed by the DBA team in one server (serverX). However, this replication process gets terminated, and there are no errors in the replication log. But there is error in the OS log files (syslog.log) : Aug 8 16:51:47 L28dre02 sshd: subsystem... (1 Reply)
Discussion started by: anaigini45
1 Replies

2. Shell Programming and Scripting

How to run a remote database query?

Thank you for taking the time to read my issue. I need to set up a script to run from a wagon wheel type toplogy where 1 server needs to query about 10 to 15 remote servers for duplicate values in a database table. If a duplicate value is found, send an email to me( or wall command to console).... (5 Replies)
Discussion started by: lutador72
5 Replies

3. UNIX and Linux Applications

database takes long time to process

Hi, we currently having a issue where when we send jobs to the server for the application lawson, it is taking a very long time to complete. here are the last few lines of the database log. 2012-09-18-10.35.55.707279-240 E244403536A576 LEVEL: Warning PID : 950492 ... (1 Reply)
Discussion started by: techy1
1 Replies

4. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

5. Shell Programming and Scripting

How to run a particular process

Hi I have a perl script where i created 3 nmap scans and the results will output to a text file. But when i run the code the first ip address gets scanned then the others after, but i want to be able to choose which ip address to scan. Here is my code: (`nmap -v -r 99.xxx.xxx -p... (0 Replies)
Discussion started by: kingbp
0 Replies

6. Shell Programming and Scripting

script to monitor the process system when a process from user takes longer than 15 min run.

get email notification from from system when a process from XXXX user takes longer than 15 min run.Let me know the time estimation for the same. hi ,any one please tell me , how to write a script to get email notification from system when a process from as mentioned above a xxxx user takes... (1 Reply)
Discussion started by: kirankrishna3
1 Replies

7. Solaris

Solaris 10 network, process, database related comands

Hi everbody, Can anyone let me know the resources for list of network, process, database related commands of solaris10 possibly with little bit of explanation. Thanks in advance, Chandra Sekhar. (1 Reply)
Discussion started by: chandoo.java
1 Replies

8. UNIX for Dummies Questions & Answers

how to run cron job to truncate database table

hi i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database i have a main database - db1 and i have a table in that database - userips i wish to create a cron job that truncates or removes all the info... (9 Replies)
Discussion started by: wingchun22
9 Replies

9. UNIX for Dummies Questions & Answers

backing up file everytime script run and saving other backups

how would i go about creatng a backup of a file everytime a script is run so that the next time it is run the old backup gets pushed back and the most recent backup is 1st. (new)backup.1 (old)backup.2 that kind of idea?? (4 Replies)
Discussion started by: knc9233
4 Replies

10. UNIX for Dummies Questions & Answers

How can I run a process under particular ID?

I have a script that needs to run under ID say "xyz". the way I do normally is to "su" to the id, enter the password of "xyz" and run the process. However, is there any way run the process under "xyz" without "su" to the ID. A person with root access would be able to run any process under any ID as... (4 Replies)
Discussion started by: ucbus
4 Replies
Login or Register to Ask a Question