How OtterTune Works

Overview of how OtterTune interacts with your database to optimize its performance.
OtterTune is a database management system (DBMS) configuration tuning and monitoring service. It uses AI to optimize the performance of your databases through a variety of actionable recommendations.
  1. 1.
    To connect your database to OtterTune, provide the service with AWS IAM permissions to access information about your Amazon RDS/Aurora database fleet.
  2. 2.
    Deploy the OtterTune Agent in your data center with credentials to connect to the target databases in your fleet.
  3. 3.
    The OtterTune Agent connects to the database to retrieve the necessary information. OtterTune only requires access to retrieve the databases’ telemetry (runtime metrics) and configuration information (knobs). For table- and index-level health checks, we collect table, schema, and index names in addition to table- and index-level metrics. For query recommendations, we also collect the query digest and summary statistics. The Agent sends the database’s information to its Repository that keeps track of all previous tuning data.
  4. 4.
    OtterTune’s Compute Engine generates a new configuration recommendation for the database. It then sends this recommendation to the Agent to install on the database.