5.5.6. Manage

5.5.6.1. Hosts

Lists of hosts being managed by ClusterControl for the specific cluster. This includes:

  • ClusterControl node
  • PostgreSQL nodes (standalone)
  • PostgreSQL master nodes (replication)
  • PostgreSQL slave nodes (replication)

To remove a host, just select the host and click on the Remove button.

Attention

We strongly recommend user to avoid removing nodes from this page if it still hold a role inside ClusterControl.

5.5.6.2. Configurations

Manage the configuration files of your database nodes. From here you can edit and/or detect whether your database configuration files are in sync and do not diverge. Any changes will not take effect until the database server/process is restarted.

  • Edit/View
    • Edit and view your database configuration files. Any changes will not take effect until the database server/processes is restarted.
  • Restart
    • This button will only appear under Action when ClusterControl detects configuration changes. Click to restart the database service for selected node.
  • Reimport Configuration
    • Re-import configuration if you have:
      • Performed local configuration changes directly on the configuration files
      • Restarted the mysql servers/performed a rolling restart after a configuration change
  • Create New Template
    • Create a new MySQL configuration template file. This template can be used when adding a new node.

5.5.6.3. Developer Studio

Provides functionality to create Advisors, Auto Tuners, or “mini Programs” right within your web browser based on ClusterControl DSL (Domain Specific Language). The DSL syntax is based on JavaScript, with extensions to provide access to ClusterControl’s internal data structures and functions. The DSL allows you to execute SQL statements, run shell commands/programs across all your cluster hosts, and retrieve results to be processed for advisors/alerts or any other actions. Developer Studio is a development environment to quickly create, edit, compile, run, test, debug and schedule your JavaScript programs.

Advisors in ClusterControl are powerful constructs; they provide specific advice on how to address issues in areas such as performance, security, log management, configuration, storage space, etc. They can be anything from simple configuration advice, warning on thresholds or more complex rules for predictions, or even cluster-wide automation tasks based on the state of your servers or databases.

ClusterControl comes with a set of basic advisors that include rules and alerts on security settings, system checks (NUMA, Disk, CPU), queries, innodb, connections, performance schema, Galera configuration, NDB memory usage, and so on. The advisors are open source under an MIT license, and available on GitHub. Through the Developer Studio, it is easy to import new advisors as a JS bundle, or export your own for others to try out.

  • New
    • Name - Specify the file name including folders if you need. E.g. “shared/helpers/cmon.js” will create all appropriate folders if they don’t exist yet.

    • File content:
      • Empty file - Create a new empty file.
      • Galera Template - Create a new file containing skeleton code for Galera monitoring.
      • Generic MySQL Template - Create a new file containing skeleton code for generic MySQL monitoring.
  • Import
  • Export
    • Exports the advisor’s directory to a .tar.gz file. The exported file can be imported to Developer Studio through ClusterControl > Manage > Developer Studio > Import function.
  • Advisors
    • Opens the Advisor list page. See Advisors section.
  • Save
    • Saves the file.
  • Move
    • Moves the file around between different subdirectories.
  • Remove
    • Remove the script.
  • Compile
    • Compiles the script.
  • Compile and run
    • Compile and run the script. The output appears under Message, Graph or Raw response tab down below.
    • The arrow next to the “Compile and Run” button allows us to change settings for a script and, for example, pass some arguments to the main() function.
  • Schedule Advisor
    • Schedules the script as an advisor.

We have covered this in details in this blog post. For full documentation on ClusterControl Domain Specific Language, see ClusterControl DSL section.