User Guidenavigate_next 5. Best practices
quasardb 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. Parallelism
        • 2.1.3. Storage
        • 2.1.4. Networking
        • 2.1.5. Clustering
        • 2.1.6. Security
        • 2.1.7. Performance tuning
        • 2.1.8. Observability
        • 2.1.9. 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
      • 1.5. quasardb REST API
        • 1.5.1. Introduction
        • 1.5.2. Quick Reference
        • 1.5.3. Setting up
        • 1.5.4. Routes
        • 1.5.5. Examples
        • 1.5.6. Options
      • 1.6. quasar cryptocurrency feed handler
        • 1.6.1. Introduction
        • 1.6.2. Description
        • 1.6.3. Usage
        • 1.6.4. Command line options
        • 1.6.5. Configuration file
    • 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. Setup installer
        • 2.4.4. Zip archive
        • 2.4.5. Driver Parameters
        • 2.4.6. Adding a datasource
        • 2.4.7. 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. Streaming changes and continuous queries
        • 3.2.1. Purpose
        • 3.2.2. Features
        • 3.2.3. Limitations
        • 3.2.4. When to use
        • 3.2.5. When not to use
        • 3.2.6. How it works
        • 3.2.7. Available modes
        • 3.2.8. Server configuration
        • 3.2.9. C Programming
        • 3.2.10. Python programming
      • 3.3. Reference
    • 4. Howtos
      • 4.1. Industrial waveform processing with Quasar
        • 4.1.1. Preparation
        • 4.1.2. Electrical waveform
        • 4.1.3. Imports and setups
        • 4.1.4. Load sample data
        • 4.1.5. Waveform capture
        • 4.1.6. Data modelling
        • 4.1.7. Data transformation
        • 4.1.8. Ingestion
        • 4.1.9. Retrieving data
        • 4.1.10. Querying
        • 4.1.11. Conclusion
    • 5. Best practices
      • 5.1. Managing tables with Tags
        • 5.1.1. Defining your tables
        • 5.1.2. Defining your tags
        • 5.1.3. Querying using tags
      • 5.2. Reaching your performance goals
        • 5.2.1. System architecture
        • 5.2.2. QuasarDB daemon configuration
        • 5.2.3. Database architecture
        • 5.2.4. Importing data
        • 5.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. SUBQUERY example
      • 6.8. ASOF joins
        • 6.8.1. Filtering ASOF join results
        • 6.8.2. Examples
      • 6.9. PIVOT
        • 6.9.1. Examples
    • 7. Insert
      • 7.1. Synopsis
      • 7.2. Description
      • 7.3. Parameters
      • 7.4. Examples
    • 8. Update
      • 8.1. Synopsis
      • 8.2. Description
      • 8.3. Parameters
      • 8.4. Examples
    • 9. Function & Operators
      • 9.1. Aggregate functions
      • 9.2. Comparison operators
      • 9.3. Logical operators
      • 9.4. Arithmetic operator
      • 9.5. Bitwise operators
      • 9.6. Regular expressions
      • 9.7. IP related functions
      • 9.8. Geographical functions
      • 9.9. Lookup function
        • 9.9.1. Examples
      • 9.10. Cast function
    • 10. Timestamps
      • 10.1. Absolute
      • 10.2. Durations
      • 10.3. Offsets
    • 11. Key/value lookups
      • 11.1. Examples
    • 12. Grant
      • 12.1. Synopsis
      • 12.2. Description
      • 12.3. Parameters
      • 12.4. Examples
    • 13. Revoke
      • 13.1. Synopsis
      • 13.2. Description
      • 13.3. Parameters
      • 13.4. Examples
    • 14. Show grants
      • 14.1. Synopsis
      • 14.2. Description
      • 14.3. Parameters
      • 14.4. Examples
    • 15. Show disk usage
      • 15.1. Synopsis
      • 15.2. Description
      • 15.3. Parameters
      • 15.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. Changes in this version
        • 2.1.1. 3.10.1 - “Marcus Aurelius” - 12/10/2021
      • 2.2. Changes in this version
        • 2.2.1. 3.13.0 - “Seneca” - 12/3/2021
      • 2.3. Special notes
      • 2.4. Changes in this version
        • 2.4.1. 3.10.0 - “Marcus Aurelius” - 10/1/2021
      • 2.5. Changes in this version
        • 2.5.1. 3.9.9 - “Marcus Aurelius” - 7/6/2021
      • 2.6. Known bugs
      • 2.7. Changes in this version
        • 2.7.1. 3.8.11 - “Crates” - 5/12/2021
      • 2.8. Changes in this version
        • 2.8.1. 3.9.8 - “Marcus Aurelius” - 3/25/2021
      • 2.9. Changes in this version
        • 2.9.1. 3.9.7 - “Marcus Aurelius” - 2/4/2021
      • 2.10. Changes in this version
        • 2.10.1. 3.8.10 - “Crates” - 1/7/2021
      • 2.11. Changes in this version
        • 2.11.1. 3.9.6 - “Marcus Aurelius” - 12/03/2020
      • 2.12. Changes in this version
        • 2.12.1. 3.9.5 - “Marcus Aurelius” - 11/11/2020
      • 2.13. Changes in this version
        • 2.13.1. 3.9.4 - “Marcus Aurelius” - 9/23/2020
      • 2.14. Changes in this version
        • 2.14.1. 3.8.9 - “Crates” - 9/15/2020
      • 2.15. Changes in this version
        • 2.15.1. 3.9.1 - “Marcus Aurelius” - 8/25/2020
      • 2.16. Changes in this version
        • 2.16.1. 3.9.0 - “Marcus Aurelius” - 8/4/2020
      • 2.17. Changes in this version
        • 2.17.1. 3.8.7 - “Crates” - 7/30/2020
      • 2.18. Changes in this version
      • 2.19. Known bugs
        • 2.19.1. 3.8.6 - “Crates” - 7/23/2020
      • 2.20. Changes in this version
      • 2.21. Known bugs
        • 2.21.1. 3.8.5 - “Crates” - 7/17/2020
      • 2.22. Changes in this version
      • 2.23. Known bugs
        • 2.23.1. 3.8.4 - “Crates” - 7/10/2020
      • 2.24. Changes in this version
      • 2.25. Known bugs
        • 2.25.1. 3.8.3 - “Crates” - 6/10/2020
      • 2.26. Changes in this version
      • 2.27. Known bugs
        • 2.27.1. 3.8.2 - “Crates” - 5/18/2020
      • 2.28. Changes in this version
      • 2.29. Known bugs
        • 2.29.1. 3.8.1 - “Crates” - 4/20/2020
      • 2.30. Changes in this version
        • 2.30.1. 3.8.0 - “Crates” - 4/6/2020
      • 2.31. Changes in this version
        • 2.31.1. 3.7.0 - “Apollodorus” - 3/2/2020
      • 2.32. Changes in this version
        • 2.32.1. 3.6.0 - “Antipater” - 2/3/2020
      • 2.33. Changes in this version
        • 2.33.1. 3.5.0 - “Posidonius” - 12/23/2019
      • 2.34. Changes in this version
        • 2.34.1. 3.4.3 - “Mnesarchus” - 10/15/2019
      • 2.35. Changes in this version
        • 2.35.1. 3.4.2 - “Mnesarchus” - 09/17/2019
      • 2.36. Changes in this version
        • 2.36.1. 3.4.1 - “Mnesarchus” - 08/12/2019
      • 2.37. Changes in this version
        • 2.37.1. 3.4.0 - “Mnesarchus” - 07/23/2019
      • 2.38. Changes in this version
        • 2.38.1. 3.3.0 - “Panaetius” - 05/13/2019
      • 2.39. Changes in this version
        • 2.39.1. 3.2.0 - “Hierocles” - 03/29/2019
      • 2.40. Changes in this version
        • 2.40.1. 3.1.0 - “Diodotus ” - 01/08/2019
      • 2.41. Changes in this version
        • 2.41.1. 3.0.0 - “Posidonius” - 11/21/2018
      • 2.42. Changes in this version
        • 2.42.1. 2.7.0 - “Eratosthenes” - 07/02/2018
      • 2.43. Changes in this version
        • 2.43.1. 2.6.0 - “Cleomedes” - 06/01/2018
      • 2.44. Changes in this version
        • 2.44.1. 2.5.0 - “Theodosius” - 04/20/2018
      • 2.45. Changes in this version
        • 2.45.1. 2.4.0 - “Aratus” - 03/11/2018
      • 2.46. Changes in this version
        • 2.46.1. 2.3.0 - “Epictetus” - 02/15/2018
      • 2.47. Changes in this version
        • 2.47.1. 2.2.0 - “Chrysippus” - 12/21/2017
      • 2.48. Changes in this version
        • 2.48.1. 2.1.0 - “Cleanthes” - 11/01/2017
      • 2.49. Changes in this version
        • 2.49.1. 2.0.0 - “Aristotle” - 01/17/2017
      • 2.50. Changes in this version
      • 2.51. Changes in the version
        • 2.51.1. 1.2.1 - “Anaximander” - 05/05/2015
      • 2.52. Changes in this version
        • 2.52.1. 1.2.0 - “Anaximander” - 02/09/2015
      • 2.53. Changes in this version
        • 2.53.1. 1.1.5 - “Pythagoras” - 12/15/2014
      • 2.54. Changes in this version
        • 2.54.1. 1.1.4 - “Pythagoras” - 06/30/2014
      • 2.55. Changes in this version
        • 2.55.1. 1.1.3 - “Pythagoras” - 04/29/2014
      • 2.56. Changes in this version
        • 2.56.1. 1.1.2 - “Pythagoras” - 02/03/2014
      • 2.57. About
      • 2.58. Changes in this version
        • 2.58.1. 1.1.1 - “Pythagoras” - 01/07/2014
      • 2.59. About
      • 2.60. Changes in this version
        • 2.60.1. 1.1.0 - “Pythagoras” - 09/16/2013
      • 2.61. About
      • 2.62. Changes in this version
        • 2.62.1. 1.0.1 SR1 - “Zeno” - 09/11/2013
      • 2.63. About
      • 2.64. Changes in this version
        • 2.64.1. 1.0.1 - “Zeno” - 07/08/2013
      • 2.65. About
      • 2.66. Changes in this version
        • 2.66.1. 1.0.0 - “Zeno” - 06/10/2013
      • 2.67. About
      • 2.68. Changes in this version
        • 2.68.1. 0.7.4 - 03/18/2013
      • 2.69. Changes in this version
        • 2.69.1. 0.7.3 - 02/11/2013
      • 2.70. Changes in this version
        • 2.70.1. 0.7.2 - 01/14/2013
      • 2.71. Changes in this version
        • 2.71.1. 0.7.1 - 10/15/2012
      • 2.72. Changes in this version
        • 2.72.1. 0.7.0 - 09/04/2012
      • 2.73. Changes in this version
        • 2.73.1. 0.6.66 - 07/02/2012
      • 2.74. Changes in this version
        • 2.74.1. 0.6.5 - 06/08/2012
      • 2.75. Changes in this version
        • 2.75.1. 0.6.0 - 01/16/2012
      • 2.76. Changes in this version
        • 2.76.1. 0.5.2 - 11/14/2011
      • 2.77. Changes in this version
        • 2.77.1. 0.5.1 - 10/01/2011
      • 2.78. Changes in this version
        • 2.78.1. 0.5.0 - 08/01/2011
      • 2.79. Changes in this version
        • 2.79.1. 0.4.2 - 05/26/2011
      • 2.80. Changes in this version
        • 2.80.1. 0.4.1 - 05/07/2011
      • 2.81. Changes in this version
        • 2.81.1. 0.4.0 - 04/22/2011
      • 2.82. Changes in this version
        • 2.82.1. 0.3.2 - 02/26/2011
      • 2.83. Changes in this version
        • 2.83.1. 0.3.1 - 02/22/2011
      • 2.84. Changes in this version
        • 2.84.1. 0.2.0 - 11/11/2010
      • 2.85. Changes in this version
        • 2.85.1. 0.1.0 - 07/26/2010
      • 2.86. Changes in this version
    • 3. Upgrading your QuasarDB installation
      • 3.1. How QuasarDB is versionned
        • 3.1.1. Stable and beta
      • 3.2. Things to keep in mind
      • 3.3. Upgrading from 3.8 to 3.10
        • 3.3.1. Recommended procedure
        • 3.3.2. Licenses
        • 3.3.3. Client and daemon
        • 3.3.4. Persistence
        • 3.3.5. Network
      • 3.4. Upgrading from 3.7 to 3.8
        • 3.4.1. Recommended procedure
        • 3.4.2. Licenses
        • 3.4.3. Client and daemon
        • 3.4.4. Persistence
        • 3.4.5. Network
      • 3.5. Upgrading from 3.6 to 3.7
        • 3.5.1. Recommended procedure
        • 3.5.2. Client code
        • 3.5.3. Licenses
        • 3.5.4. Persistence
        • 3.5.5. Network
      • 3.6. Upgrading from 3.5 to 3.6
        • 3.6.1. Recommended procedure
        • 3.6.2. Configuration
        • 3.6.3. Licenses
        • 3.6.4. Persistence
        • 3.6.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

5. Best practices¶

  • 5.1. Managing tables with Tags
  • 5.2. Reaching your performance goals
arrow_backPrevious
4.1. Industrial waveform processing with Quasar
Next arrow_forward
5.1. Managing tables with Tags
© Copyright 2015-2021, quasardb SAS. Generated by Sphinx 2.2.0