A collection tools for managing the analytics databases
Project description
Analytics Database Tools
A suite of tools and libraries for managing the analytics database servers.
Installation
Applications
The following command-line applications are installed as part of anadb-tools:
Command |
Description |
---|---|
anadb-analyze |
Inspect each analytics server via CloudFormation and each analytics database in PostgreSQL, updating statistics in the analytics broker database. |
anadb-assign |
Create & assign a new analytics database for a customer. |
anadb-cleanup |
Backup & Delete analytics databases for closed accounts. |
anadb-deploy |
Deploy DDL to all of the analytics databases. |
anadb-migrate |
Move multiple analytics databases to a different server. |
anadb-move |
Move an analytics database to a different server. |
anadb-orphans |
Cleanup orphaned analytics databases. |
anadb-pageview-audit |
Examine all analytics databases to determine which have pageview data. |
anadb-s3backup |
Backup the data in an analytics database to Amazon S3. |
anadb-sequence-fix |
Reset all of the sequences in an analytics database. |
anadb-skeleton |
Create a skeleton CLI application using anadb-tools. |
Common Environment Variables
The following environment variables allow for overriding the database connection information that can be provided by command line switches:
Variable |
Description |
---|---|
ANABROKER_HOST |
The database server to connect to the analytics broker on |
ANABROKER_PORT |
The port to connect to the analytics broker database on |
ANABROKER_DBNAME |
The analytics broker database name. Default: analytics_broker |
ANABROKER_USER |
The user to connect as to the analytics broker db server. Default: the current shell user |
ANADB_USER |
The user to connect to an analytics database server as. Default: the current shell user |
APPDB_HOST |
The database server to connect to for the app database. |
APPDB_PORT |
The database server port to connect on for the app database. |
APPDB_DBNAME |
The database name to connect to for the app database. Default: app |
APPDB_USER |
The user to connect to the app database server as. Default: the current shell user |
Library Modules
Module |
Description |
---|---|
anadb_tools.anabroker |
Methods for connecting to and interacting with anabroker. |
anadb_tools.anadb |
Methods for connecting to and interacting with account specified analytics databases. |
anadb_tools.appdb |
Methods for connecting to and interacting with the app database. |
anadb_tools.common |
Misc common methods including argument parsing and logging configuration. |
anadb_tools.database |
Low-level database commands, including backup. |
anadb_tools.exceptions |
Common exceptions for the anadb-tools package. |
anadb_tools.memcached |
Clears caching keys for analytics broker assignment info. |
Development
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distribution
Hashes for anadb_tools-0.12.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bba8345195c5f3662aacf318a1058134558e73691136d8150911cd3b6af0bb60 |
|
MD5 | c4343089398f30491f5aee3ee1944a51 |
|
BLAKE2b-256 | 449ff39f74bb5d45404e36aeae0ab1cc967f993b1ebf579569649e3fa789bae2 |