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](mailto:contact@fromdual.com?Subject=Bug report for focmm).
Any feedback, statements and testimonials are welcome as well! Please send them to [feedback@fromdual.com](mailto:feedback@fromdual.com?Subject=Feedback for focmm “Feedback for focmm”).
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.
FromDual Ops Center 1.2.0 for MariaDB, MySQL and compatible databases has been released appeared first on MariaDB.org
Thu, 2023-01-19 12:01 — Shinguz
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.
DownloadThe 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](mailto:contact@fromdual.com?Subject=Bug report for focmm).
Any feedback, statements and testimonials are welcome as well! Please send them to [feedback@fromdual.com](mailto:feedback@fromdual.com?Subject=Feedback for focmm “Feedback for focmm”).
Installation of Ops Center 1.2.0Information on how to install FromDual Ops Center you can find in the Ops Center User Guide.
Upgrade from 0.9.x to 1.2.0Upgrade 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.0Machine-core- packages from installation selection.cluster_conf_id added.P_S.threads.brman path now.safe_to_bootstrap is working now and can be forced.my_exec.stderr.* files found and fixed. PID 0 kill was caught, mkdir locking replaced by flock locking..ssh directory is created also on RPM.httpd and mysqld is now started during package installation.php-mysql replaced by php-mysqlnd for RHEL package.RPM package building added..ssh for repository user is created during installation.lsb-release added to Debian.writecheck functions.ssh, scp).whoami fixed, PATH added to my_exec because of Rocky8.checkBinary also made working locally on Rocky8.testEmail fixed.mod_rewrite enabled by default.sendmail is not installed (Debian).tags:
| # | Наименование новости | Тональность | Информативность | Дата публикации |
|---|---|---|---|---|
| 1 | FromDual Ops Center 1.2.1 for MariaDB, MySQL and compatible databases has been released | 0 | 4.71 | 07-02-2023 |
| 2 | FromDual Ops Center 1.2.2 for MariaDB and MySQL databases has been released | 0 | 4.43 | 29-04-2024 |
| 3 | Ops Center Release Notes | 0 | 8.02 | 29-04-2024 |
| 4 | FromDual Performance Monitor for MariaDB 2.1.0 has been released | 0 | 4.91 | 09-12-2023 |
| 5 | FromDual Performance Monitor 2.2.1 has been released | 0 | 5.36 | 19-02-2026 |
| 6 | MariaDB/MySQL Environment MyEnv 2.1.0 has been released | 0 | 7.02 | 28-02-2024 |
| 7 | FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.0 has been released | 0 | 3.77 | 25-06-2024 |
| 8 | FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.1 has been released | 0 | 3.77 | 12-08-2024 |
| 9 | FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.2 has been released | 0 | 4.16 | 22-10-2025 |
| 10 | FromDual Performance Monitor for MariaDB/MySQL allows SNMP monitoring | 0 | 4.44 | 23-06-2022 |