SynxDB Best Practices

A best practice is a method or technique that has consistently shown results superior to those achieved with other means. Best practices are found through experience and are proven to reliably lead to a desired result. Best practices are a commitment to use any product correctly and optimally, by leveraging all the knowledge and expertise available to ensure success.

This document does not teach you how to use SynxDB features. Links are provided to other relevant parts of the SynxDB documentation for information on how to use and implement specific SynxDB features. This document addresses the most important best practices to follow when designing, implementing, and using SynxDB.

It is not the intent of this document to cover the entire product or compendium of features, but rather to provide a summary of what matters most in SynxDB. This document does not address edge use cases. While edge use cases can further leverage and benefit from SynxDB features, they require a proficient knowledge and expertise with these features, as well as a deep understanding of your environment, including SQL access, query execution, concurrency, workload, and other factors.

By mastering these best practices, you will increase the success of your SynxDB clusters in the areas of maintenance, support, performance, and scalability.

• Best Practices Summary
  A summary of best practices for SynxDB.
• System Configuration
  Requirements and best practices for system administrators who are configuring SynxDB cluster hosts.
• Schema Design
  Best practices for designing SynxDB schemas.
• Memory and Resource Management with Resource Groups
  Managing SynxDB resources with resource groups.
• Memory and Resource Management with Resource Queues
  Avoid memory errors and manage SynxDB resources.
• System Monitoring and Maintenance
  Best practices for regular maintenance that will ensure SynxDB high availability and optimal performance.
• Loading Data
  Description of the different ways to add data to SynxDB.
• Security
  Best practices to ensure the highest level of system security. 
• Encrypting Data and Database Connections
  Best practices for implementing encryption and managing keys.
• Tuning SQL Queries
  The SynxDB cost-based optimizer evaluates many strategies for running a query and chooses the least costly method.
• High Availability
  SynxDB supports highly available, fault-tolerant database services when you enable and properly configure SynxDB high availability features. To guarantee a required level of service, each component must have a standby ready to take its place if it should fail.