Managing a LightDB-A System

This section describes basic system administration tasks performed by a LightDB-A Database system administrator.

• About the LightDB-A Database Release Version Number
  LightDB-A Database version numbers and the way they change identify what has been modified from one LightDB-A Database release to the next.
• Starting and Stopping LightDB-A Database
  In a LightDB-A Database DBMS, the database server instances (the coordinator 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 LightDB-A Database, and how to establish a database session.
• Configuring the LightDB-A Database System
  Server configuration parameters affect the behavior of LightDB-A Database.
• Enabling Compression
  You can configure LightDB-A Database to use data compression with some database features and with some utilities.
• Configuring Proxies for the LightDB-A Interconnect
  You can configure a LightDB-A 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 LightDB-A Database can be configured.
• Backing Up and Restoring Databases
  This topic describes how to use LightDB-A backup and restore features.
• Expanding a LightDB-A System
  To scale up performance and storage capacity, expand your LightDB-A Database system by adding hosts to the system. In general, adding nodes to a LightDB-A cluster achieves a linear scaling of performance and storage capacity.
• Migrating Data with gpcopy
  You can use the gpcopy utility to transfer data between databases in different LightDB-A Database clusters.
• Monitoring a LightDB-A System
  You can monitor a LightDB-A Database system using a variety of tools included with the system or available as add-ons.
• Routine System Maintenance Tasks
  To keep a LightDB-A Database 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 LightDB-A Database cluster.

Parent topic: LightDB-A Database Administrator Guide