| 1 |
/* |
| 2 |
* Argus Software |
| 3 |
* Copyright (c) 2000-2024 QoSient, LLC |
| 4 |
* All rights reserved. |
| 5 |
* |
| 6 |
* Permission to use, copy, modify, and distribute this software and |
| 7 |
* its documentation for any purpose and without fee is hereby granted, |
| 8 |
* provided that the above copyright notice appear in all copies and |
| 9 |
* that both that copyright notice and this permission notice appear |
| 10 |
* in supporting documentation, and that the name of QoSient not be |
| 11 |
* used in advertising or publicity pertaining to distribution of the |
| 12 |
* software without specific, written prior permission. |
| 13 |
* |
| 14 |
* QOSIENT, LLC DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS |
| 15 |
* SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND |
| 16 |
* FITNESS, IN NO EVENT SHALL QOSIENT, LLC BE LIABLE FOR ANY |
| 17 |
* SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER |
| 18 |
* RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF |
| 19 |
* CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN |
| 20 |
* CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. |
| 21 |
* |
| 22 |
*/ |
| 23 |
|
| 24 |
These scripts are intended to manage various aspects of using MySQL |
| 25 |
with Argus data. While the list is short now, we hope that it will |
| 26 |
grow quickly. |
| 27 |
|
| 28 |
MySQL.Archive.sh - This program moves argus data from a standard MySQL |
| 29 |
archive to a standard native file system archive, and indexes for |
| 30 |
time. Standard implies that the database table and the native file |
| 31 |
system repository have the datetime as a part of its name. |
| 32 |
|
| 33 |
This program is intended to provide repository migration for formal |
| 34 |
data rention policies. The notion is that you'll have data in the |
| 35 |
database for some period of time, and then you will want to move the |
| 36 |
primitive data, so that its available, but not within the RDMBS. |
| 37 |
|
| 38 |
The database repository should have been created using rasqlinsert(), |
| 39 |
and have the 'record' attribute in its schema definition. This is |
| 40 |
the actual argus record that will be inserted into the native file |
| 41 |
system archive. rasql() will read the data from the data base, |
| 42 |
and pipe its output to rasplit() which will populate the native |
| 43 |
file system archive. |
| 44 |
|
| 45 |
You will need to set these variables to your liking: |
| 46 |
MYSQL_USER="the mysql account that has permissions on the table" |
| 47 |
MYSQL_HOST="the host where mysql runs" |
| 48 |
MYSQL_DATABASE="the mysql database name" |
| 49 |
MYSQL_TABLE="the table name, the script will add the data string to the end" |
| 50 |
|
| 51 |
ARCHIVE_FILESYSTEM="/Path/To/The/Argus/Archive" |
| 52 |
|
| 53 |
If you have any issues, send email to the list. |