You are here

Instances

Table of Contents


Instance overview

The Instance overview of a new (= empty) Ops Center looks as follows:

Empty Instance overview

Before you can start working with Ops Center you have to add an (existing) Database Instance to the Ops Center. Creating a Database Instance is a different topic discusses further down.

When you have added some Database Instances you can select an instance in the Instance overview to change the settings or check the state of the instance:

Instance overview

To add a new Instance to the Ops Center click on the Add Instance button.

Add or edit an Instance

In the form Add new/Edit Instance you have to enter:

  • A unique Instance name (this name must be unique across your whole company which you want to manage with Ops Center). Ideally this name is the same you use in MyEnv and in the FromDual Backup Manager.
  • The machine this instance is located on.
  • The directory where the MariaDB/MySQL binaries are installed (basedir). Typically this is /usr. If the instance is under MyEnv control use the same value as in myenv.conf. If you are not sure try this command: dirname $(dirname $(which mysqld)).
  • The directory where the MariaDB/MySQL data are located (datadir). Typically this is /var/lib/mysql. If you are not sure try this command: SHOW GLOBAL VARIABLES LIKE 'datadir';.
  • The location of your database instance configuration file (my.cnf or my.ini typically located under /etc or /etc/mysql).
  • The service name or IP address your instance listens to. This is often the same name or IP address as the server. If you have a dedicated name/IP for your instance use this one.
  • The port your MariaDB/MySQL instance listens to (typically 3306).
  • The instance user Ops Center should use. You should use a user which clearly identifies what it is used for. So we recommend: focmm_admin. But you can also use root. This user should be created as follows:
    CREATE USER 'focmm_admin'@'<ip_of_focmm>' IDENTIFIED BY '<some_secret_password>';
    GRANT ALL ON *.* TO 'focmm_admin'@'<ip_of_focmm>'
  • The instance users password as specified above (<ip_of_focmm>).
  • If this instance is readonly or not. This is mostly important for replication slaves.

Add or edit Instance

Configuration overview

In the Instance settings overview you can either edit the instance again, delete it or choose some other instance operations:

Instance Settings overview

Instance Checks

To get an overview of the state of your instance you can either click the Check Instance button for all checks or you can run each check individually by clicking on the Check now button:

Instance checks

When you run the checks Ops Center shows you for each check what it was doing, what the result was and what you should do to fix the problem:

Checking the instance

You might be surprised that some checks have been performed already. This is because Ops Center runs periodically in the background all the jobs. So it might have happened Ops Center was faster than you checking the instance...

If all checks passed successful the instance checks look as follows:

Instance checks successful

Do not try to continue here as long as not all checks are OK. The further steps will not work.

Operations

In the operations tab you:

  • Stop and start your instance.
  • Set instance to readonly or read-write.
  • Backup your instance.
  • And see the 20 last lines of your MariaDB/MySQL error log.

Instance operations

Starting a instance looks as follows:

Start instance

Stopping a instance looks as follows:

Stop instance

And setting a instance to readonly as follows:

Set instance readonly

Important: If you want to make the readonly state persistent after the next instance restart you have to manually add it to the instance configuration file (my.cnf).

Processlist

In the processlist you can see who is actually connected to the instance and which query is running:

Processlist

You can further filter for specific connections or sort most of the columns. If a query is using too much of resources you can also kill the query or event terminate the connection. The refresh interval can be set from 2 to 60 seconds.

Variables

In the variables tab you see all the actual instance configuration variables and their values. If Ops Centers has an opinion about your settings the values are marked in color and an information icon is shown:

Variables

Processlist

Schema

Accounts

Under the Accounts tab you can create new or edit existing MariaDB/MySQL Accounts and grant or revoke privileges to or from these Accounts.

An Account in our terminology is the combination of a MariaDB/MySQL username and password. For example root@localhost is an Account. A user is a username without the host. For example the Accounts root@localhost and root@127.0.0.1 both belong to the same user root.

With the Create Account button on the bottom you can create new Accounts. With the View Link or the Edit Link on the right you can view Account details or Edit an Account.

Account Details

In the Account Details you can see the Global Privileges,

the Schema Privileges and the Table and Column Privileges of an Account:

Edit Account

Here you can grant and revoke privileges to and from an Account. The password of an Account is not visible here because the password hashing algorithm of MariaDB/MySQL does not allow to revert the password from the hash.

Delete Account

An Account can be deleted in Account Details on the bottom.

Configuration

Performance

Monitoring