Index
search
Table Of Contents
Primer
What is quasardb?
Shall we dance?
Inserting timeseries data
Working with the data
Organizing your data
That demo is nice, but what happens when I go to production?
Going further
Wrap up
Server Administration
1. Installation
1.1. System Requirements
1.1.1. x64 build
1.1.2. Core2 build
1.1.3. ARM64 build
1.2. Installation
1.3. Next steps
2. Configuration
2.1. QuasarDB Daemon
2.1.1. License
2.1.2. Storage
2.1.3. Networking
2.1.4. Clustering
2.1.5. Security
2.1.6. Performance tuning
2.1.7. Observability
2.1.8. Asynchronous Timeseries Inserter
2.2. QuasarDB Rest Server
2.3. Docker
3. Performance tuning
3.1. Daemon
3.2. Testing cluster connectivity
3.3. Rules of thumb
3.4. Recommendations
3.5. File system
3.6. OS X Recommendations
3.7. Linux Recommendations
4. Routine maintenance tasks
4.1. Graceful shutdown
4.2. Cluster trimming
4.3. Log rotation
4.4. Backups
5. Observability
5.1. Statistics
5.2. Performance Tracing
6. Security
6.1. Enable access-control
6.2. Key management
6.3. Cluster key generation
6.4. User management
6.5. Authentication
6.6. Authorization
6.6.1. Privileges
6.6.2. Reference
6.7. Encrypted communication
6.8. Access control
User Guide
1. Tools
1.1. quasardb shell
1.1.1. Introduction
1.1.2. Command line options
1.1.3. Interactive mode
1.1.4. Non-interactive mode
1.1.5. Command reference
1.2. quasardb import tool
1.2.1. Introduction
1.2.2. Quick Reference
1.2.3. Configuration file
1.2.4. Parsers
1.2.5. Program Options
1.3. quasardb export tool
1.3.1. Introduction
1.3.2. Quick Reference
1.3.3. Program Options
1.4. quasardb database tool
1.4.1. Introduction
1.4.2. Quick Reference
1.4.3. Important notice
1.4.4. Log level
1.4.5. Analyzing
1.4.6. Scanning
1.4.7. Upgrading
1.4.8. Offline compaction
1.4.9. Backup and restore
2. Integrations
2.1. Grafana connector
2.1.1. Introduction
2.1.2. Prerequisites
2.1.3. Installation
2.1.4. Configuration
2.1.5. Usage
2.2. Kafka connector
2.2.1. Introduction
2.2.2. Installation
2.2.3. Configuration
2.2.4. Additional options
2.2.5. Performance Considerations
2.3. Excel
2.3.1. Introduction
2.3.2. Installation
2.3.3. Datasource
2.3.4. First connection
2.3.5. Querying data
2.3.6. Exploring your tables
2.3.7. Editing your dataset
2.4. ODBC
2.4.1. Introduction
2.4.2. Installation
2.4.3. Driver Parameters
2.4.4. Adding a datasource
2.4.5. Using the driver or dsn with pyodbc
2.5. Prometheus Remote Storage
2.5.1. Introduction
2.5.2. Prerequisites
2.5.3. Configuration
2.5.4. How Prometheus metrics are mapped to QuasarDB
2.6. SAS
2.6.1. Introduction
2.6.2. Installation
2.6.3. Configuring the datasource
2.6.4. Test the connection
2.6.5. Examples
2.7. Spark connector
2.7.1. Introduction
2.7.2. Querying quasardb
2.7.3. Writing to quasardb
2.7.4. Tests
2.7.5. A note for macOS users
2.8. Tableau
2.8.1. Introduction
2.8.2. Installation
2.8.3. Datasource
2.8.4. First connection
2.8.5. Querying data
3. APIs
3.1. Tutorial
3.1.1. Requirements
3.1.2. Installing libraries
3.1.3. Importing libraries
3.1.4. Connection management
3.1.5. Creating a table
3.1.6. A word about API types
3.1.7. Row oriented API
3.1.8. Column oriented API
3.1.9. Queries
3.1.10. Dropping a table
3.1.11. Full example
3.2. Reference
4. Best practices
4.1. Managing tables with Tags
4.1.1. Defining your tables
4.1.2. Defining your tags
4.1.3. Querying using tags
4.2. Reaching your performance goals
4.2.1. System architecture
4.2.2. QuasarDB daemon configuration
4.2.3. Database architecture
4.2.4. Importing data
4.2.5. Running queries
Query language
1. Create table
1.1. Synopsis
1.2. Description
1.3. Parameters
1.4. Examples
2. Delete from
2.1. Synopsis
2.2. Description
2.3. Parameters
2.4. Examples
3. Drop table
3.1. Synopsis
3.2. Description
3.3. Parameters
3.4. Examples
4. Alter table
4.1. Synopsis
4.2. Description
4.3. Parameters
4.4. Examples
5. Show tables
5.1. Synopsis
5.2. Description
5.3. Examples
6. Select
6.1. Synopsis
6.2. Description
6.3. Parameters
6.4. Examples
6.5. Advanced examples
6.6. IN FIND example
6.7. ASOF joins
6.7.1. Filtering ASOF join results
6.7.2. Examples
7. Insert
7.1. Synopsis
7.2. Description
7.3. Parameters
7.4. Examples
8. Function & Operators
8.1. Aggregate functions
8.2. Comparison operators
8.3. Logical operators
8.4. Arithmetic operator
8.5. Bitwise operators
8.6. Regular expressions
8.7. IP related functions
8.8. Geographical functions
8.9. Lookup function
8.9.1. Example
8.10. Cast function
9. Timestamps
9.1. Absolute
9.2. Durations
9.3. Offsets
10. Key/value lookups
10.1. Examples
11. Grant
11.1. Synopsis
11.2. Description
11.3. Parameters
11.4. Examples
12. Revoke
12.1. Synopsis
12.2. Description
12.3. Parameters
12.4. Examples
13. Show grants
13.1. Synopsis
13.2. Description
13.3. Parameters
13.4. Examples
14. Show disk usage
14.1. Synopsis
14.2. Description
14.3. Parameters
14.4. Examples
Internals
1. Transactions
1.1. Overview
1.2. Characteristics
1.3. Design
1.3.1. Unique Transaction Identifier
1.3.2. Multiple Versions and Garbage Collection
1.4. Batch or transaction
2. Clustering
2.1. What is a Cluster?
2.2. Stabilization
2.3. Adding a Node to a Cluster
2.4. Removing a Node from a Cluster
2.5. Recovering from Node Failure
2.6. Nodes IDs
3. Data Storage
3.1. Where are Entries Stored in the Cluster?
3.2. Where are Entries Stored in a Node?
3.3. Cache
3.3.1. Transient mode
3.3.2. Persistent read cache
3.3.3. Cloud storage
3.4. Data Migration
3.4.1. Migration Process
3.5. Data replication
3.5.1. Principle
3.5.2. How replication works with migration
3.5.3. Conflict resolution
3.5.4. Impact on reliability
3.5.5. Impact on performance
3.5.6. Fault tolerance
3.5.7. Memory Cache and Eviction
3.6. Data trimming
4. Data Transfer
4.1. Designed for Concurrency
4.1.1. Server
4.1.2. Client
4.2. Guarantees
4.3. The Transfer Process
4.4. Failure Cases
4.4.1. Cluster Unstable
4.4.2. Topology Changed
4.4.3. Timeout
4.5. Data Conflicts
4.5.1. A simple data conflict
4.5.2. Resolving the simple conflict
4.5.3. A more complex data conflict
4.5.4. Best Practice: Plan for Concurrency
5. Change Stream
5.1. Purpose
5.2. Recorded information
5.3. Update types
Support
1. Contact
2. Change log
2.1. 3.9.9 - “Marcus Aurelius” - 7/6/2021
2.1.1. Known bugs
2.1.2. Changes in this version
2.2. 3.9.8 - “Marcus Aurelius” - 3/25/2021
2.2.1. Changes in this version
2.3. 3.9.7 - “Marcus Aurelius” - 2/4/2021
2.3.1. Changes in this version
2.4. 3.9.6 - “Marcus Aurelius” - 12/03/2020
2.4.1. Changes in this version
2.5. 3.9.5 - “Marcus Aurelius” - 11/11/2020
2.5.1. Changes in this version
2.6. 3.9.4 - “Marcus Aurelius” - 9/23/2020
2.6.1. Changes in this version
2.7. 3.9.1 - “Marcus Aurelius” - 8/25/2020
2.7.1. Changes in this version
2.8. 3.9.0 - “Marcus Aurelius” - 8/4/2020
2.8.1. Changes in this version
2.9. 3.8.11 - “Crates” - 5/12/2021
2.9.1. Changes in this version
2.10. 3.8.10 - “Crates” - 1/7/2021
2.10.1. Changes in this version
2.11. 3.8.9 - “Crates” - 9/15/2020
2.11.1. Changes in this version
2.12. 3.8.7 - “Crates” - 7/30/2020
2.12.1. Changes in this version
2.12.2. Known bugs
2.13. 3.8.6 - “Crates” - 7/23/2020
2.13.1. Changes in this version
2.13.2. Known bugs
2.14. 3.8.5 - “Crates” - 7/17/2020
2.14.1. Changes in this version
2.14.2. Known bugs
2.15. 3.8.4 - “Crates” - 7/10/2020
2.15.1. Changes in this version
2.15.2. Known bugs
2.16. 3.8.3 - “Crates” - 6/10/2020
2.16.1. Changes in this version
2.16.2. Known bugs
2.17. 3.8.2 - “Crates” - 5/18/2020
2.17.1. Changes in this version
2.17.2. Known bugs
2.18. 3.8.1 - “Crates” - 4/20/2020
2.18.1. Changes in this version
2.19. 3.8.0 - “Crates” - 4/6/2020
2.19.1. Changes in this version
2.20. 3.7.0 - “Apollodorus” - 3/2/2020
2.20.1. Changes in this version
2.21. 3.6.0 - “Antipater” - 2/3/2020
2.21.1. Changes in this version
2.22. 3.5.0 - “Posidonius” - 12/23/2019
2.22.1. Changes in this version
2.23. 3.4.3 - “Mnesarchus” - 10/15/2019
2.23.1. Changes in this version
2.24. 3.4.2 - “Mnesarchus” - 09/17/2019
2.24.1. Changes in this version
2.25. 3.4.1 - “Mnesarchus” - 08/12/2019
2.25.1. Changes in this version
2.26. 3.4.0 - “Mnesarchus” - 07/23/2019
2.26.1. Changes in this version
2.27. 3.3.0 - “Panaetius” - 05/13/2019
2.27.1. Changes in this version
2.28. 3.2.0 - “Hierocles” - 03/29/2019
2.28.1. Changes in this version
2.29. 3.1.0 - “Diodotus ” - 01/08/2019
2.29.1. Changes in this version
2.30. 3.0.0 - “Posidonius” - 11/21/2018
2.30.1. Changes in this version
2.31. 2.7.0 - “Eratosthenes” - 07/02/2018
2.31.1. Changes in this version
2.32. 2.6.0 - “Cleomedes” - 06/01/2018
2.32.1. Changes in this version
2.33. 2.5.0 - “Theodosius” - 04/20/2018
2.33.1. Changes in this version
2.34. 2.4.0 - “Aratus” - 03/11/2018
2.34.1. Changes in this version
2.35. 2.3.0 - “Epictetus” - 02/15/2018
2.35.1. Changes in this version
2.36. 2.2.0 - “Chrysippus” - 12/21/2017
2.36.1. Changes in this version
2.37. 2.1.0 - “Cleanthes” - 11/01/2017
2.37.1. Changes in this version
2.38. 2.0.0 - “Aristotle” - 01/17/2017
2.38.1. Changes in this version
2.38.2. Changes in the version
2.39. 1.2.1 - “Anaximander” - 05/05/2015
2.39.1. Changes in this version
2.40. 1.2.0 - “Anaximander” - 02/09/2015
2.40.1. Changes in this version
2.41. 1.1.5 - “Pythagoras” - 12/15/2014
2.41.1. Changes in this version
2.42. 1.1.4 - “Pythagoras” - 06/30/2014
2.42.1. Changes in this version
2.43. 1.1.3 - “Pythagoras” - 04/29/2014
2.43.1. Changes in this version
2.44. 1.1.2 - “Pythagoras” - 02/03/2014
2.44.1. About
2.44.2. Changes in this version
2.45. 1.1.1 - “Pythagoras” - 01/07/2014
2.45.1. About
2.45.2. Changes in this version
2.46. 1.1.0 - “Pythagoras” - 09/16/2013
2.46.1. About
2.46.2. Changes in this version
2.47. 1.0.1 SR1 - “Zeno” - 09/11/2013
2.47.1. About
2.47.2. Changes in this version
2.48. 1.0.1 - “Zeno” - 07/08/2013
2.48.1. About
2.48.2. Changes in this version
2.49. 1.0.0 - “Zeno” - 06/10/2013
2.49.1. About
2.49.2. Changes in this version
2.50. 0.7.4 - 03/18/2013
2.50.1. Changes in this version
2.51. 0.7.3 - 02/11/2013
2.51.1. Changes in this version
2.52. 0.7.2 - 01/14/2013
2.52.1. Changes in this version
2.53. 0.7.1 - 10/15/2012
2.53.1. Changes in this version
2.54. 0.7.0 - 09/04/2012
2.54.1. Changes in this version
2.55. 0.6.66 - 07/02/2012
2.55.1. Changes in this version
2.56. 0.6.5 - 06/08/2012
2.56.1. Changes in this version
2.57. 0.6.0 - 01/16/2012
2.57.1. Changes in this version
2.58. 0.5.2 - 11/14/2011
2.58.1. Changes in this version
2.59. 0.5.1 - 10/01/2011
2.59.1. Changes in this version
2.60. 0.5.0 - 08/01/2011
2.60.1. Changes in this version
2.61. 0.4.2 - 05/26/2011
2.61.1. Changes in this version
2.62. 0.4.1 - 05/07/2011
2.62.1. Changes in this version
2.63. 0.4.0 - 04/22/2011
2.63.1. Changes in this version
2.64. 0.3.2 - 02/26/2011
2.64.1. Changes in this version
2.65. 0.3.1 - 02/22/2011
2.65.1. Changes in this version
2.66. 0.2.0 - 11/11/2010
2.66.1. Changes in this version
2.67. 0.1.0 - 07/26/2010
2.67.1. Changes in this version
3. Upgrading your QuasarDB installation
3.1. From 3.7 to 3.8
3.1.1. Recommended procedure
3.1.2. Licenses
3.1.3. Client and daemon
3.1.4. Persistence
3.1.5. Network
3.2. From 3.6 to 3.7
3.2.1. Recommended procedure
3.2.2. Client code
3.2.3. Licenses
3.2.4. Persistence
3.2.5. Network
3.3. From 3.5 to 3.6
3.3.1. Recommended procedure
3.3.2. Configuration
3.3.3. Licenses
3.3.4. Persistence
3.3.5. Network
4. License
4.1. Usage
4.2. License file
4.3. Expiration
4.4. Scope of the licensed rights
4.4.1. Software Use
4.4.2. Updates and Upgrades
4.4.3. Runtime programs
4.4.4. Back-up copies
4.5. Use restrictions
4.5.1. Software modification and reverse engineering
4.5.2. Interoperability
4.6. Third party software
4.7. Limitation of liability
4.8. Indemnifications
4.9. Intellectual property and ownership
5. Credits
Index
Symbols
|
C
|
D
|
L
|
Q
Symbols
--add-header
qdb_csv_generator command line option
--address=<address>:<port>
qdbd command line option
--allowed-origins
qdb_rest command line option
--analyze
qdb_dbtool command line option
--assets-dir
qdb_rest command line option
--async
qdb_import command line option
--backup
qdb_dbtool command line option
--check-syntax
qdb_import command line option
--cluster
qdb_rest command line option
qdbsh command line option
--cluster-private-file=<path>
qdbd command line option
--cluster-public-file=<cluster-public-file>
qdb-benchmark command line option
--cluster-public-key-file
qdb_rest command line option
qdbsh command line option
--cluster-public-key-file=<path_to_file>
qdb_export command line option
qdb_import command line option
--cluster=<address>:<port>
qdb-benchmark command line option
--cluster=<cluster_uri>
qdb_export command line option
qdb_import command line option
--color-output
qdbsh command line option
--compact
qdb_dbtool command line option
--config
qdbd command line option
--config-file
qdb_rest command line option
--config=<path_to_file>
qdb_export command line option
qdb_import command line option
--daemonize
qdbd command line option
--database=<path>
qdb_dbtool command line option
--dry-run
qdb-benchmark command line option
--duration=<duration>
qdb-benchmark command line option
--end-date=<date-string>
qdb_export command line option
--file=<path_to_file>
qdb_csv_generator command line option
qdb_export command line option
qdb_import command line option
--gen-config
qdb_rest command line option
qdbd command line option
--help
qdb-benchmark command line option
qdb_csv_generator command line option
qdb_export command line option
qdb_import command line option
qdb_rest command line option
qdbd command line option
--help-config
qdb_import command line option
--help-parsers
qdb_csv_generator command line option
qdb_import command line option
--host
qdb_rest command line option
--i-auto
qdb_import command line option
--i-make-config=<path_to_new_file>
qdb_import command line option
--i-verbose
qdb_import command line option
--id=<id string>
qdbd command line option
--idle-timeout=<duration>
qdbd command line option
--interactive
qdb_rest command line option
--jobs=<max_threads>
qdb_import command line option
--license-file
qdbd command line option
--limiter-max-bytes-hard=<value>
qdbd command line option
--limiter-max-bytes-soft=<value>
qdbd command line option
--list-commands
qdbsh command line option
--local
qdb_rest command line option
--log-directory=<path>
qdbd command line option
--log-file
qdb_rest command line option
--log-flush-interval=<delay>
qdbd command line option
--log-level=<value>
qdbd command line option
--log-syslog
qdbd command line option
--max-error-count=<max_error_count>
qdb_import command line option
--no-cleanup
qdb-benchmark command line option
--parsers=<parsers_list>
qdb_csv_generator command line option
--pause=<pause_duration>
qdb-benchmark command line option
--peer=<address>:<port>
qdbd command line option
--port
qdb_rest command line option
--repair
qdb_dbtool command line option
--replication=<factor>
qdbd command line option
--request-timeout=<timeout>
qdbd command line option
--restore
qdb_dbtool command line option
--rocksdb-max-bytes=<size-in-bytes>
qdbd command line option
--rocksdb-max-open-files=<count>
qdbd command line option
--rocksdb-root=<path>
qdbd command line option
--scan
qdb_dbtool command line option
--secure
qdb_rest command line option
--security=<boolean>
qdbd command line option
--sessions=<count>
qdbd command line option
--show-tests
qdb-benchmark command line option
--size=<file_size>
qdb_csv_generator command line option
--sizes=<sizes>
qdb-benchmark command line option
--start-date=<date-string>
qdb_export command line option
--storage_engine=<engine>
qdbd command line option
--tests=<tests_regex>
qdb-benchmark command line option
--threads=<threads>
qdb-benchmark command line option
--timeout=<timeout>
qdb_export command line option
qdb_import command line option
--tls-certificate
qdb_rest command line option
--tls-key
qdb_rest command line option
--tls-port
qdb_rest command line option
--transactional
qdb_import command line option
--ts-offset=<time_offset>
qdb_csv_generator command line option
--ts=<timeseries_name>
qdb_export command line option
--tsv
qdb_csv_generator command line option
qdb_export command line option
--upgrade
qdb_dbtool command line option
--user-credentials-file=<path_to_file>
qdb_export command line option
qdb_import command line option
--user-credentials-file=<user-credentials-file>
qdb-benchmark command line option
--user-list=<path>
qdbd command line option
--user-security-file
qdbsh command line option
--verbose
qdb_csv_generator command line option
--verify_backup
qdb_dbtool command line option
--version
qdb-benchmark command line option
qdb_csv_generator command line option
qdb_export command line option
qdb_import command line option
qdbd command line option
-a
qdb_dbtool command line option
-a <address>:<port>
qdbd command line option
-b
qdb_dbtool command line option
-c
qdb_export command line option
qdb_import command line option
qdb_rest command line option
qdbd command line option
-c=<address>:<port>
qdb-benchmark command line option
-d
qdbd command line option
-f
qdb_csv_generator command line option
qdb_export command line option
qdb_import command line option
-h
qdb-benchmark command line option
qdb_csv_generator command line option
qdb_export command line option
qdb_import command line option
qdb_rest command line option
qdbd command line option
-i
qdb_rest command line option
-l
qdb_rest command line option
qdbsh command line option
-l <path>
qdbd command line option
-n
qdb-benchmark command line option
-p
qdb-benchmark command line option
qdb_csv_generator command line option
-r
qdb_dbtool command line option
-r <path>
qdbd command line option
-s
qdb_csv_generator command line option
qdb_rest command line option
-s <count>
qdbd command line option
-v
qdb-benchmark command line option
qdbd command line option
C
config_path
qdb_generate_config command line option
D
db_path
qdb_generate_config command line option
L
log_path
qdb_generate_config command line option
Q
qdb-benchmark command line option
--cluster-public-file=<cluster-public-file>
--cluster=<address>:<port>
--dry-run
--duration=<duration>
--help
--no-cleanup
--pause=<pause_duration>
--show-tests
--sizes=<sizes>
--tests=<tests_regex>
--threads=<threads>
--user-credentials-file=<user-credentials-file>
--version
-c=<address>:<port>
-h
-n
-p
-v
qdb_csv_generator command line option
--add-header
--file=<path_to_file>
--help
--help-parsers
--parsers=<parsers_list>
--size=<file_size>
--ts-offset=<time_offset>
--tsv
--verbose
--version
-f
-h
-p
-s
qdb_dbtool command line option
--analyze
--backup
--compact
--database=<path>
--repair
--restore
--scan
--upgrade
--verify_backup
-a
-b
-r
qdb_export command line option
--cluster-public-key-file=<path_to_file>
--cluster=<cluster_uri>
--config=<path_to_file>
--end-date=<date-string>
--file=<path_to_file>
--help
--start-date=<date-string>
--timeout=<timeout>
--ts=<timeseries_name>
--tsv
--user-credentials-file=<path_to_file>
--version
-c
-f
-h
qdb_generate_config command line option
config_path
db_path
log_path
qdb_import command line option
--async
--check-syntax
--cluster-public-key-file=<path_to_file>
--cluster=<cluster_uri>
--config=<path_to_file>
--file=<path_to_file>
--help
--help-config
--help-parsers
--i-auto
--i-make-config=<path_to_new_file>
--i-verbose
--jobs=<max_threads>
--max-error-count=<max_error_count>
--timeout=<timeout>
--transactional
--user-credentials-file=<path_to_file>
--version
-c
-f
-h
qdb_rest command line option
--allowed-origins
--assets-dir
--cluster
--cluster-public-key-file
--config-file
--gen-config
--help
--host
--interactive
--local
--log-file
--port
--secure
--tls-certificate
--tls-key
--tls-port
-c
-h
-i
-l
-s
qdbd command line option
--address=<address>:<port>
--cluster-private-file=<path>
--config
--daemonize
--gen-config
--help
--id=<id string>
--idle-timeout=<duration>
--license-file
--limiter-max-bytes-hard=<value>
--limiter-max-bytes-soft=<value>
--log-directory=<path>
--log-flush-interval=<delay>
--log-level=<value>
--log-syslog
--peer=<address>:<port>
--replication=<factor>
--request-timeout=<timeout>
--rocksdb-max-bytes=<size-in-bytes>
--rocksdb-max-open-files=<count>
--rocksdb-root=<path>
--security=<boolean>
--sessions=<count>
--storage_engine=<engine>
--user-list=<path>
--version
-a <address>:<port>
-c
-d
-h
-l <path>
-r <path>
-s <count>
-v
qdbsh command line option
--cluster
--cluster-public-key-file
--color-output
--list-commands
--user-security-file
-l