FromDual Ops Center 1.2.0 for MariaDB, MySQL and compatible databases has been released

FromDual has the pleasure to announce the release of the new version 1.2.0 of its 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 DBA's and System Administrators to better manage their MariaDB and MySQL databases and Galera Cluster farms. Ops Center makes DBA and Admins life easier!

The main task of Ops Center is to support you in your daily MariaDB and MySQL operation tasks. More information about FromDual Ops Center you can find under General Information.

Download

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

In the inconceivable case 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, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

Installation of Ops Center 1.2.0

Information on how to install FromDual Ops Center you can find in the Ops Center User Guide.

Upgrade from 0.9.x to 1.2.0

Upgrade from 0.9.x to 1.2.0 should happen automatically. Please do a backup of your Ops Center database instance before you upgrade! Please also check Upgrading.

Changes in Ops Center 1.2.0

Machine

• Delete machine error message improved.
• Add machine made more user friendly.
• Delete machine warning message made more verbose.
• Error handling improved and error messages made more verbose in gathering machine information.

Instance

• Create instance: InnoDB buffer pool size estimation fixed.
• Remove -core- packages from installation selection.
• Access keys added to show instance.
• Instance and machine names are sorted in selection now.
• Error handling improved in performance views.
• Restart instance bug fixed,
• Status cluster_conf_id added.
• Galera node bootstrap is shown correctly now.
• Create schema can do character set now.
• Start instance refactored.
• Create instance is also working for Debian now.
• Restart instance implemented.
• Repository instance cannot be stopped any more to avoid system outages.
• Processlist rewritten to P_S.threads.
• Some more performance views added.
• Delete instance warning message made more verbose.
• Create instance: Machine names are sorted now alphabetically.
• Query Cache remove in create instance because MySQL 8.0 does not support it any more and it is by default off in MariaDB now.
• Instance backup remembers brman path now.

Cluster

• Galera safe_to_bootstrap is working now and can be forced.
• Cluster weight, node weight and segment added for Galera.
• More information in error message when saving cluster.
• Master/Slave features are not shown any more if Galera Cluster is chosen.
• Cluster type cannot be changed any more.
• Galera disable buttons if instance is stopped.
• Galera node bootstrap functionality implemented.
• Galera Cluster configuration deployment implemented.
• Galera Cluster does not show M/S features any more.
• Replication operations: SQL thread state was not displayed correctly.
• GTID related information added to replication operations.
• Delete instance from cluster made a bit more user friendly.

Load Balancer

• Some minor bugs in load balancer and VIP failover fixed.
• Galera Load Balancer balancing policy fixed.
• Page made more user friendly.
• Galera Load Balancer restart implemented.
• Operations for MariaDB MaxScale implemented.
• Load Balancer socket variable normalized.
• Delete Load Balancer implemented.
• Galera Load Balancer configuration is backuped before saving.
• Galera Load Balancer Load Balancer policy change implemented.
• Load Balancer policy added.
• Change weight of load balancer back-end added.
• Galera Load Balancer configuration persist added.
• Galera Load Balancer load balancer configuration file parsed and displayed under settings.
• Galera Load Balancer drain and undrain back-end added.
• Galera Load Balancer version added to operations.
• Galera Load Balancer checks refresh every 10 seconds.
• Galera Load Balancer start and stop implemented
• Statistics for Galera Load Balancer added.
• Operations overview for Galera Load Balancer added.
• Operations menu enabled.

Virtual IP (VIP)/Floating IP

• VIP failover problem fixed.
• Bitmask /32 is wrong, was changed to /24.
• VIP failover made more robust.
• Deploy standard keepalived configuration implemented.
• keepalived version added.
• keepalived failover works fine.
• keepalived failover is working now.
• vip keepalived failover started.
• keepalived stop and start added.
• Checks for keepalived added.
• keepalived flag for vip added.
• VIP can now be kept under keepalived.

Tools

• Back button remove from crontab, makes no sense here.
• Read in readJobs fixed and some error messages improved.
• Display limited to 100 jobs because of memory issues.
• Bug with remaining my_exec.stderr.* files found and fixed. PID 0 kill was caught, mkdir locking replaced by flock locking.

Configuration

• No changes.

Database-as-a-Service (DBaaS)

• No changes.

Building and Packaging

• .ssh directory is created also on RPM.
• MariaDB added as default for Rocky8.
• Syntax error in installation script fixed.
• On Rocky9 httpd and mysqld is now started during package installation.
• php-mysql replaced by php-mysqlnd for RHEL package.
• RPM package building added.
• Directory .ssh for repository user is created during installation.
• Package lsb-release added to Debian.
• Install error message made better for Debian.

Themes / UI

• jquery updated from 3.6.0 to 3.6.1 and jquery ui themes from 1.12.1 to 1.13.2

General

• Changed copyright year from 2022 to 2023.
• Some PHP 8.1 deprecations fixed.
• Repository DB handle added to all writecheck functions.
• PHP function exec replaced by my_exec where possible (ssh, scp).
• whoami fixed, PATH added to my_exec because of Rocky8.
• Function checkBinary also made working locally on Rocky8.
• Bug in testEmail fixed.
• Distribution Debian GNU/Linux is now supported everywhere.
• Apache mod_rewrite enabled by default.
• Add Apache SSL to installation.
• Menu is now controllable via keys.
• FromDual software versions is added.
• Error message more verbose in case sendmail is not installed (Debian).
• myEnv library updated including distro clean-up.
• Better IP guessing during installation.

Repository

• Create repository fixed for mariadb 5.5.
• Code clean-up for focmm configuration file operations.