You are here
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 frominstanceTest
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
tomariadbd
. - 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 bytransaction_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
toDEBUG
. - Function
runRemoteCommand
will return an error code again whengoing_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 byapt
. - 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 bydnf
, alsoapt-get
partly. - Command
which
replaced bytype -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.
- Shinguz's blog
- Log in or register to post comments