forked from awslabs/amazon-redshift-utils
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathreplay.yaml
More file actions
72 lines (55 loc) · 2.1 KB
/
replay.yaml
File metadata and controls
72 lines (55 loc) · 2.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
# Directory for extracted workload, relative to current directory
workload_location: ""
# Endpoint and username of cluster to replay again
target_cluster_endpoint: ""
master_username: ""
# Required only for playback using ODBC (pyodbc)
odbc_driver: ""
# If original driver isn't supported (e.g. JDBC), use this driver. "psql" or
# "odbc" are the only valid values.
default_interface: "psql"
# Optional - Leaving it empty defers to connections.json. "all on" preserves
# time between transactions. "all off" disregards time between transactions,
# executing them as a batch.
time_interval_between_transactions: "all on"
# Optional - Leaving it empty defers to connections.json. "all on" preserves
# time between queries. "all off" disregards time between queries, executing
# them as a batch.
time_interval_between_queries: "all on"
# Should COPY statements be executed?
execute_copy_statements: "false"
# Should UNLOAD statements be executed?
execute_unload_statements: "false"
# Optional - Where the UNLOADs and system table unload goes
replay_output: ""
# Optional - Leaving this blank means UNLOADs will not be replayed. IAM role
# for UNLOADs to be performed with.
unload_iam_role: ""
# Location of the SQL file containing queries to unload system tables
unload_system_table_queries: "unload_system_tables.sql"
# IAM role to UNLOAD system tables from source cluster to S3 location for later
# analysis
target_cluster_system_table_unload_iam_role: ""
# Include filters will work as "db AND user AND pid". Exclude filters will work as "db OR user OR pid".
filters:
include:
database_name: ['*']
username: ['*']
pid: ['*']
exclude:
database_name: []
username: []
pid: []
##
## The settings below probably don't need to be modified for a typical run
##
# Set the amount of logging
log_level: info
# number of proceses to use to parallelize the work. If omitted or null, uses
# one process per cpu - 1
num_workers: ~
# output warnings if connections are not within this number of seconds from
# their expected time.
connection_tolerance_sec: 300
# Number of simplereplay logfiles to maintain
backup_count: 1