Debian Codegraph @

support/Database/README

raw
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.