FromDual Ops Center for MariaDB and MySQL 0.9.3 has been released

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

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

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

Download

The new FromDual Ops Center for MariaDB and MySQL (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 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 0.9.3

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 0.9.3

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

Changes in Ops Center 0.9.3

Machine

• Machine without a usergroup is not allowed, fixed.
• Machine name number is incremented by one if server already exists.
• Delete machine fixed by setting server_id on instance to null.
• Refresh repo automatization added.
• Monitoring link added to menu.
• Machine performance graphs added to menu.

Instance

• Node renamed to Instance.
• Create instance for CentOS and Ubuntu integrated.
• Instance version comment was too long for PXC. Fixed.
• Data Dictionary version added.
• Special case for error log to syslog added (MariaDB packages on CentOS).
• performance_schema last seen queries added.
• Instance show overview made nicer.
• Bug in instance check fixed.
• Generate password improved thus bad special characters are not suggested any more.
• Instance edit, eye added and field length shortened.
• Instance name checking improved for creating and add.
• Various minor bugs fixed.
• Monitoring link added to menu.

Cluster

• Cluster is clickable now in instance overview.
• Minor Cluster bugs fixed.
• Galera cluster added.
• Master/Slave replication made smoother.

Load Balancer

• HAproxy and glb load balancer added.

Tools

• Jobs: Error logging improved to get more info about aborted jobs.
• Crontab: Run job now icon added.
• Schema compare: Schema drop-down sorted ascending and related code cleaned and refactored.

Configuration

• Crontab: start_jobs.php was removed from crontab and is now started by run_crontab.php.

Database-as-a-Service (DBaaS)

• Pricing plan added.
• Database pricing added.
• Machine cost added.
• Resource cost included into job structure.

Building and Packaging

• Installer: Repository installation hint added to installer.
• Upgrade: Table fixed for MySQL 5.7.
• Packaging: Session folder included into packaging.
• Packaging: DEB and RPM improved for Upgrade.

Themes / UI

• Default theme made a bit nicer.
• Link more visible in default theme.

General

• Disable license warning.
• Link to fromdual license information added.
• Jquery upgraded from 1.12.0 to 1.12.1.
• http authentication brought to Apache version 2.4.
• Session store changed because we loose very often ours sessions.
• Session path also for all frag adapted.
• Function implode syntax made compatible with newer PHP versions.
• Minor typos fixed.
• Minor errors fixed.