🚀 **FromDual MyEnv 3.0.0 is LIVE!**

The ultimate multi-instance database environment just got better. Now with enhanced **PostgreSQL** support plus compatibility with the latest platforms:

✅ Red Hat 10
✅ Ubuntu 24.04
✅ Debian 13
✅ MySQL 8.4
✅ MariaDB 11.8

Manage your **MariaDB, MySQL & PostgreSQL** instances like a pro.

📥 **Download:** https://support.fromdual.com/admin/public/download.php

📖 **Release notes:** https://www.fromdual.com/blog/myenv-release-notes/fromdual-environment-myenv-3.0.0-has-been-released/

#DatabaseManagement #MySQL #MariaDB #PostgreSQL #DevOps #OpenSource

FromDual delivers the new version 2.2.1 of its popular database performance monitoring solution for MariaDB, Galera Cluster, MySQL and PostgreSQL.

The FromDual Performance Monitor enables database and system administrators to monitor their databases and machines and receive notifications if something is not working as usual.

The FromDual Performance Monitor is freely available for testing purposes.

Further details can be found here: https://www.fromdual.com/blog/fromdual-performance-monitor-2.2.1-has-been-released/.

Image by edwardbrownca on Pixabay

What is the quickest way to load data into the #database?

We recently analysed this for #MariaDB / #MySQL and #PostgreSQL and showed that the simplest method is not the fastest.

You can see more details and the results here: https://www.fromdual.com/blog/load-data-quick-into-the-database/

In the tests in my previous articles, I found that #MariaDB completely ruined the concept of the dynamically configurable #InnoDB buffer pool!

And this within a long-term support release series. To prevent this from affecting your production environment, I have described more about this here:

https://www.fromdual.com/blog/mariadb-dynamically-configurable-buffer-pool-broken/

Image Author: Cplakidas, GNU FDL v1.2

Someone is deleting my shared memory segments!

With #PostgreSQL under myEnv we regularly get shared memory segment errors:

psql: error: connection to server on socket "/tmp/.s.PGSQL.5433" failed:
FATAL: could not open shared memory segment "/PostgreSQL.4220847662":

I have described why this happens here:

https://www.fromdual.com/blog/deleted-postgresql-shared-memory-segments/

Load CSV files into the database

Proof of concept how to load data from a CSV file into a #MariaDB/#MySQL or #PostgreSQL database to display locations on an #OpenStreeMap map with #Leaflet.

https://www.fromdual.com/blog/load-csv-files-into-the-database/

Arrived at #ULB. Room UB2.252A was tricky to find for me. It is huge and pretty full.

#fosdem #database #postgresql #mysql