Managing a SynxDB System

This section describes basic system administration tasks performed by a SynxDB system administrator.

• About the SynxDB Release Version Number
  SynxDB version numbers and the way they change identify what has been modified from one SynxDB release to the next.
• Starting and Stopping SynxDB
  In a SynxDB DBMS, the database server instances (the master and all segments) are started or stopped across all of the hosts in the system in such a way that they can work together as a unified DBMS.
• Accessing the Database
  This topic describes the various client tools you can use to connect to SynxDB, and how to establish a database session.
• Configuring the SynxDB System
  Server configuration parameters affect the behavior of SynxDB.
• Enabling Compression
  You can configure SynxDB to use data compression with some database features and with some utilities.
• Configuring Proxies for the SynxDB Interconnect
  You can configure a SynxDB system to use proxies for interconnect communication to reduce the use of connections and ports during query processing.
• Enabling High Availability and Data Consistency Features
  The fault tolerance and the high-availability features of SynxDB can be configured.
• Backing Up and Restoring Databases
  This topic describes how to use SynxDB backup and restore features.
• Expanding a SynxDB System
  To scale up performance and storage capacity, expand your SynxDB system by adding hosts to the system. In general, adding nodes to a SynxDB cluster achieves a linear scaling of performance and storage capacity.
• Migrating Data with cbcopy
  You can use the cbcopy utility to transfer data between databases in different SynxDB clusters.
• Monitoring a SynxDB System
  You can monitor a SynxDB system using a variety of tools included with the system or available as add-ons.
• Routine System Maintenance Tasks
  To keep a SynxDB system running efficiently, the database must be regularly cleared of expired data and the table statistics must be updated so that the query optimizer has accurate information.
• Recommended Monitoring and Maintenance Tasks
  This section lists monitoring and maintenance activities recommended to ensure high availability and consistent performance of your SynxDB cluster.