FromDual Ops Center for MySQL and compatible databases 1.0.0 has been released

FromDual has the pleasure to announce the release of the new version 1.0.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MySQL and compatible databases.

The FromDual Ops Center for MySQL and compatible databases (focmm) helps DBA's and System Administrators to better manage their MySQL and compatible databases farms. Ops Center makes DBA and Admins life easier!

The main task of Ops Center is to support you in your daily MySQL and compatible databases operation tasks. More information about FromDual Ops Center you can find here.

Download

The new FromDual Ops Center for MySQL and compatible databases (focmm) can be downloaded from here. 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 MySQL and compatible databases 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.0.0

A complete guide on how to install FromDual Ops Center you can find in the Ops Center User Guide.

Upgrade from 0.9.x to 1.0.0

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

Changes in Ops Center 1.0.0

Machine

• Expression Server replaced by Machine.
• Better error handling in getOperatingSystem function.
• Machine does not belong to a Cluster any more: Column cluster_id from table machine removed.
• Machine rename prepared.
• 2 bugs on refresh and edit Machine fixed.
• Instances added to Machine overview.

Instance

• Expression Node replaced by Instance.
• Instance added to Machine and Cluster overview.
• Database Account management implemented.
• Bug in create instance (server_id) fixed.
• Bugs fixed in Instance backup, Instance restore, Instance performance and create Account.
• Variable skip_name_resolve added to create Instance. This makes error probability smaller for accounts with same username but different host.
• Menu title Configuration renamed to Settings.
• Configuration file management implemented.
• Deleting Instance belonging to a Cluster is not possible any more. Cluster must first release instance before instance can be deleted.
• Column instance_type removed.
• Menu Title Variables renamed to Configuration.
• Show Processlist refurbished, filter fields smaller and daemon and system users filtered out.
• Schema management implemented.
• MySQL compatible database version 10.4 defaults for Variables added.
• Missing backup-target is only ERR and not EMERG any more.
• Instance performance advises added for sar.
• Function copyFileFromRemoteServer should preserve timestamp now.
• Connection changed from connect to real_connect to allow SSL connections.
• SSL connection from Ops Center to Target Database and Repository Database is possible now.

Cluster

• CHANGE MASTER TO and Cluster change fixed for systems with more than one Cluster.
• CHANGE MASTER TO password is hidden now as well, all password can be viewed and copied.
• Cluster bugs fixed.
• Cluster functions cleaned-up.
• Galera safe to bootstrap improved.
• Machine removed from Cluster dashboard.
• Instance added to Cluster overview.

Load Balancer

• Better error handling for Load Balancer.
• MaxScale Load Balancer added in overview.
• ProxySQL Load Balancer basics implemented.

Virtual IP (VIP)/Floating IP

• Put Edit VIP buttons in right order.

Tools

• Tool for File Transfer added.
• Tool config-diff compare button added also to top of table.

Configuration

• No changes.

Database-as-a-Service (DBaaS)

• Customer group replaced by Resource group.
• FK added to Resource costs.
• User Group added.
• Logout User put into own function.
• Tabindex for User edit/add added.
• User cannot delete itself any more.
• User comment and User group responsibility added.
• User is logged out from focmm when deleted.

Building and Packaging

• No changes.

Themes / UI

• Keybord usage and Tab Index implemented in some forms.
• jquery upgraded from 3.4.1 to 3.5.0

General

• All HTML code removed in code.
• Constant clean-up.
• Machine, Instance and Cluster overview are sorted now.
• Menu Instance, Machine and Cluster are sorted now, getXxxx function extended to make this possible.
• Order of object and function changed in url.
• Spell check error fixed.
• Title moved a bit more to the right.
• All tests passed for MySQL compatible database 10.5 and MySQL 8.0. Both can be considered as supported now.
• Repository version 124 added, create separated for next major step.