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

FromDual has the pleasure to announce the release of the new version 1.1.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, 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 MariaDB, MySQL and compatible databases operation tasks. More information about FromDual Ops Center you can find here.

Download

The new FromDual Ops Center for MariaDB, 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 MariaDB, 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.1.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.1.0

Upgrade from 0.9.x to 1.1.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.1.0

Machine

• Machine check error messages improved.

Instance

• Function check_instance made more robust against system outages.
• Safe account error message improved.
• Instance restart prepared.
• read_only in repo check added.
• Old function removed.
• Replication check moved from cluster check to instance check.
• Instance checks for IO and SQL thread added.
• Function testNode renamed to testInstance.
• Code clean-up and fix in instance check.
• Bug in account creation fixed for MariaDB 10.1 and MariaDB 10.0.
• Instance check improved.
• Target info was added in edit instance.
• Check master_log_slave_updates fixed.
• Function: chanageVariabelsInConfiguatrion added.
• Functions makeInstanceReadOnly and makeInstanceReadWrite redesigned and cleaned-up.
• Instance.inc renamed to TargetOperations.inc
• Database.inc renamed to Target.inc
• log_slave_updates check added to instance.

Cluster

• Failover bugs fixed, error messages improved.
• m/s cluster failover.
• Change master to can now copy masters file and pos to change master to command.
• Functionality switchover added.
• failover_slave_id renamed to failover_instance_id, back button in cluster made correct, check on stopped instance fixed.
• Cluster operations simplified and A_I inc and A_I offset added.
• Adding and deleting cluster fixed.
• read_only is also deployed during failover.
• Final error failover fixed and log_slave_status check added to cluster.
• Show cluster overview fixed.
• Function getMasterInfo fixed for MySQL and MariaDB.
• Missing read_only check on old master was added.
• Failover took wrong user.
• Cluster failover for mm cluster fixed.
• Cluster operations made more colorful to show important operations better.
• Function checkVipUser made ready for 3 node cluster.
• New master is set correctly now.
• Added more information for failover.
• M/s and m/m failover should work now.
• Error messages made more proper.
• Bug in readonly in repo check fixed.
• active_master_id added.
• Failover vip in cluster only if vip is present.
• Reattach slaves implemented.
• Failover slave feature implemented.
• Cluster was only shown if VIP was there, fixed
• One test only true for m/m was also done on m/s, fixed.
• Check instance should not interfere with cluster failover any more.
• read_only and activity added to cluster operations view.
• Cluster failover is moved from VIP to cluster.
• Cluster operations simplified.
• Cluster failover implemented.
• Failover rules moved from vip to cluster.
• Cluster test finished.
• m/m a/a and a/p introduced.
• Cluster vip check added.
• Unique server_id check implemented for cluster.
• Slave read_only in repo check implemented for repl cluster.
• Slave activity on cluster implemented.
• Cluster tests for m/s and m/m properly improved.
• Replication check moved from cluster check to instance check.
• Slave is shown in cluster overview.
• Cluster checks improved and checks display made unique.
• VIP is shown in replication cluster.
• Bug in cluster handling and usability improved.
• HTML code clean-up.
• Some clean-up and M/M cluster fixed.

Load Balancer

• No changes.

Virtual IP (VIP)/Floating IP

• Some VIP cosmetics fixed.
• Amount of error messages reduced during vip start.
• Bug in check for new VIP fixed.
• VIP add check improved.
• Bug in VIP check fixed, various smaller code clean-up.
• VIP failover improved.
• Arping command not found behaviour improved.
• VIP code cleaned-up.
• VIP interface check added.
• VIP nonsense interface already used check removed.
• Column of primary and failover machine added to VIP overview.
• Edit VIP machines are sorted in drop down.
• Key shortcuts added to VIP buttons and html made nicer according to our standards.

Tools

• Error logging in file transfer improved.
• Crontab title changed from hr to hour.
• Crontab error 3800 relaxed to warning.
• Temporay crontab is now cleaned-up to not leave any remains.
• Bug in tools function fixed.
• File transfer bugs fixed.
• Run Crontab Entry now was implemented.
• Adding Crontab entries with keyboard shortcuts is possible now.
• Bug in Crontab with htmlspecialcharacters fixed.
• Jobs: Error messages made more verbose in regular jobs.
• Jobs: Jobs are sorted by start_ts DESC now.
• Jobs: Made job deletion dramatically faster.
• Jobs: Clean-up job remaining.
• Jobs: Button in Job Tool provisioned with keys.
• Jobs: Job checks improved.
• Jobs: Os_user added to job. This means job can be started under every user now!
• Jobs: Special characters from crontab inherited to jobs fixed.
• Jobs: More verbose error messages in job state preparing.
• Jobs: Job gets a start timestamp as soon as it moves to state Preparing.
• Jobs: Code cleaned-up and some bugs fixed.
• Jobs: Function getJobsWithFilter replaces by readJobs.
• Jobs: Function addJob replaced by createJob.
• Crontab: User in crontab can now be chosen, but not in jobs yet!
• Crontab: Special characters from crontab inherited to jobs fixed.
• Crontab: Only log output when error returned, not OK.

Configuration

• Configuration: If focmm crontab is not activated complaints are shown on prominent place.
• Configuration: Delete focmm crontab added.

Database-as-a-Service (DBaaS)

• No changes.

Building and Packaging

• Files directory added to package build instructions to make file copy work.
• rpmlint warning removed.
• Some lintian warnings implemented.
• rpmlint warning removed.

Themes / UI

• Nasty CSS error removed.

General

• myEnv lib updated.
• myEnv library updated.
• Documentation improved and code cosmetics fixed.
• Various minor bugs fixed.
• CHANGELOG updated, license key changed.
• myEnv library updated.
• Library jquery updated from 3.5.0 to 3.6.0.
• CHANGELOG updated.
• Return codes made unique.
• Some minor bugs fixed.
• Status in menu on the left fixed.
• PoC added.
• Compare tables PoC added.
• Smaller code fixes.
• Copyright updated from 2020 to 2021.
• Better error message, GUI test improved.
• Minor bug fixed and typos fixed.
• Function run remote command improved.
• Wording improved.
• Accesskey added to SubmitButton and ContinueButton.
• Constant LOG_ERROR added.
• ssh function run on remote server optimized.
• Typos fixed and page titles made more precise.

Repository

• Node.inc renamed to Catalog.inc.