FromDual Ops Center 1.2.2 for MariaDB and MySQL databases has been released

FromDual is pleased to announce the release of the new version 1.2.2 of the popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases.

The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBAs and system administrators to better manage their MariaDB and MySQL databases and Galera Cluster farms. Ops Center makes life easier for DBAs and Admins!

The main purpose of the Ops Center is to help you with your daily MariaDB and MySQL operations. More information about FromDual Ops Center can be found in the General Information section.

Download now

The new FromDual Ops Center for MariaDB and MySQL (focmm) can be downloaded from our download page. How to install and use focmm is documented in the Ops Center User Guide.

In the unlikely event that you find a bug in the FromDual Ops Center for MariaDB and MySQL please report it to the FromDual bug tracker or just send us an email.

Any feedback, comments and testimonials are also welcome! Please send them to feedback@fromdual.com.

Installing Ops Center 1.2.2

Information on how to install FromDual Ops Center can be found in the Ops Center User Guide.

Upgrading from 0.9.x to 1.2.2

The upgrade from 0.9.x to 1.2.2 should be automatic. Please make a backup of your Ops Center database instance before upgrading! See also Upgrading.

Important: In some cases the directory focmm/tmp/start_jobs.lock is missing. In this case jobs will not start. Please check the log file under focmm/log/start_jobs.log and create the folder accordingly. There should also be a file called pid in this folder. Create this file if it does not exist.

Downgrading from 1.2.2

Downgrading from 1.2.2 to 1.2.1 should work.

Changes in Ops Center 1.2.2

Machine

• Machine information is automatically gathered after first successful check now.
• Machine function calls optimized.
• Ssh key check added for machine.
• Some tests around machine library added.
• Function createPublicKey + page refactored.
• Copy of ssh key and ssh command implemented.
• Skip machines which are down during gathering resource costs.
• Error message in pricing when adding a new machine was fixed.

Instance

• Instance operations are now faster when instance is running but not reachable.
• Node check improved in cluster and instance, works now also correctly on multi instance environments.
• PID file is gathered now.
• Stop instance on instance operations improved if a Galera cluster node.
• Instance is now checked immediately after start or restart and checks are set to failed after instance stop. So the instance state is more appropriate and in time now.
• Link added to read_only variable comment.
• Instance is shown orange when ping check was not run yet. This is fixed now.
• Error log gathering improved in instance operations.
• If mysql_upgrade_info file is missing error is suppressed now.
• Gather instance information is done now right after the first successful check.
• Check database_ping was removed from general instance tests to avoid noise in the database error log.
• Check instance_ping_check removed from instanceTest to avoid error log messages on a regular base, wondering what kind of impact this has...
• innodb_log_writer_threads rule added to instance configuration.
• Target connect function error logging improved.
• Continue button is handled correctly now when stopping, starting or restarting an instance.
• Instance operations location of error log is shown now.
• Refactored instance operations code for moving Galera buttons out.
• Function refreshInstance refactored because we need this information for Galera Cluster.
• Unknown array_keys error message fixed in instance.
• Foreign MariaDB/MySQL repositories should now be considered as well.
• Optimized instance handling.
• Instance error log handling can now handle systemd/journalctl.
• Instance hardening when creating instance improved.
• Create instance improved.
• Create instance bug fixed.
• Instance create on Rocky 9, fixed.
• Create instance for Rocky 8 improved.
• Check for restart also removed, so also restart works now.
• Check removed to allow a running but not reachable instance to be restarted, restart and start button added.
• Non existing configuration was not handled correctly, fixed.
• Edit instance placeholder added and default instance name changed from mysqld to mariadbd.
• Create instance output made nicer in case of failure.

Cluster

• Cluster overview signal lights are also working now for Galera.
• Cluster operations returns faster now if machine is not reachable.
• Cluster show checks non important information removed.
• Cluster checks in menu are now shown correctly.
• grastate.dat async check added.
• Cluster check made async.
• Instance state added to cluster operations and check view.
• M/S cluster tests made more robust against strange situations.
• Some bugs in M/S cluster fixed.
• focmm user passwords should sync in galera.
• Bootstrap should distribute focmm user on all nodes.
• Bootstrap on Debian fixed again.
• Error message for missing grastate.dat file is suppressed now.
• Deploy configuration button is now on a new line.
• 2 little bugs in M/S cluster operations removed.
• Instance operations improved with Galera clusters.
• Soft bootstrap implemented.
• Cluster node bootstrap, start stop fixed.
• Function bootstrap implemented.
• Async rolling cluster restart added.
• Problem with rolling restart fixed.
• Cluster check and operations is read if not OK. Failed, same behaviour as before!
• Rolling cluster restart and other buttons added to cluster operations.
• Variable wsrep_node_name is set to instance name per default.
• Galera cluster config deployment made smoother and fixed bug.
• Sort order of cluster nodes and title of table clarified.
• Page start/stop notices added to cluster.php.
• Indention problem in function getClusterChecks fixed.

Load Balancer

• Terms load-balancer and loadbalancer replaced by load balancer.
• User radmin added for ProxySQL monitoring.
• Socket default for HAproxy changed to the new standards.

Virtual IP (VIP)/Floating IP

• Status grey image does not exist in vip_show_checks, fixed.

Tools

• Crontab: Missing library in check_instances.php added.
• Crontab: html tags removed in mail.
• Crontab: Error messages and error handling in crontab and start jobs improved, lock file directory is created automatically now.

Configuration

• No changes.

Database-as-a-Service (DBaaS)

• No changes.

Building and Packaging

• Bulid moved to MyEnv project.
• Missing Rocky Linux branch added.
• Package redhat-lsb-core does not exist on Rocky 9 any more, spec file adapted.
• Package build test fixed.

Themes / UI

• jquery updated from 3.6.3 to 3.7.1

General

• Modification for license key automation added.
• Package installation ssh-keygen is only called if key does not exist. So upgrade should work without error/warning.
• Some tests fixed, bug in createPublicKey fixed.
• Function listRemoteDirectory does not write needlessly error messages any more.
• HTML tag placeholder added for add function, add object and save object made more error prone.
• Variable tx_isolation replaced by transaction_isolation which was deprecated in MariaDB 11.2 and MySQL 5.7.
• Code clean-up.
• Some menu items opened a new tab which was not intended. Fixed.
• Field naming made consistent.
• Error handling and error messages improved.
• Copyright year updated from 2023 to 2024.
• Message downgraded from ERROR to DEBUG.
• Function runRemoteCommand will return an error code again when going_back_to functionality implemented.
• Function renderDropDown newline was removed.
• Function renderSubmitButton accepts a title now.
• Function runRemoteCommand can suppress error logging now.
• Command apt-get replaced by apt.
• Distribution information refactored.
• Function whoami cleaned-up.
• PHP 8.0 function calls removed again because of Debian 10/11 support.
• User interaction made unique among all 5 different objects.
• Redundant DEBUG information removed.
• Configuration file was removed again when not needed any more (clean-up).
• Command yum replaced by dnf, also apt-get partly.
• Command which replaced by type -p to make it Rocky 9 compliant.
• Some more lsb_release stuff removed.
• myEnv.inc library updated, lsb_release removed.
• Dead code message added.

Repository

• No changes.

Documentation

• Version changed from 1.2.0 to 1.2.1 and TLS conflict on ubuntu 22.04 fixed.
• Build automatized.
• Documentation for M/S updated.
• All text taken over from CMS.
• Load balancer documentation added.