Tag: migration

Converting mySQL database to MariaDB: findings so far…

On 02Nov2025 I was effectively forced to migrate my blog site’s database from mySQL to MariaDB. Fortunately open-source MariaDB is advertised as compatible with mySQL, so all I did during the migration was:

  1. Replace the mySQL database in the blog site Docker container with an empty MariaDB database by creating a new Docker volume for MariaDB.
  2. Start the blog container, restore the WordPress plugins, and restore the most recent database backup. Remember the MariaDB is compatible with mySQL!
  3. Restart the blog container.

I have now been running the blog site with MariaDB for a week, so what have I noticed?

  • The server is no longer running out of disk space due to frequently created large log files in the database volume (previously mySQL, but now MariaDB). Was there an underlying problem in mySQL?
  • I had been using MariaDB for my ownCloud database in a separate Docker container, but, now that I am running 2 instances of MariaDB in separate containers, there are NO interactions, even though the same database software is being used by both containers! Note that I could, in future, use different versions if necessary.
  • MariaDB feels that it is running faster than mySQL, but, while I have no data to prove this, it is no longer creating any log files, so my feeling may not be just subjective.
  • Not using mySQL means that I am no longer dependent on Oracle support for my databases. Note that I have, for a long time, been using software applications and platforms supported by open-source communities (LibreOffice, WordPress, Linux, Lulu.com, ownCloud, Eclipse, JavaScript, Perl, PHP, GraphViz, and now MariaDB).

3 new things I have learnt about Altair SLC this week

  1. I have always wanted to create a neural network using the SAS language from the moment it was announced, but SAS software restricted this feature to paid-for components that I had no other use for. However, using features available in the free Personal Edition of Altair SLC and Altair Analytics Workbench, I have created a neural network to analyse the Iris data set, which uses PROC MLP, but I created it using pre-built nodes for a Workflow in Analytics Workbench.
  2. I have just watched a video demo from an Altair Employee on the Altair Community site about importing EG project files into Analytics Workbench Workflows. No version numbers were mentioned in or around this video, but it appears to be possible now, or at least soon!
  3. For business users the Linux installation of Altair SLC is treated as a server, rather than a workstation, installation. However, when I installed it I thought that the only way to access it would be as a server from a Windows-installed Analytics Workbench, but there is also a Linux version of Analytics Workbench available to business users, and it looks just like the Windows version.

More reasons to consider migrating from Foundation SAS to Altair SLC!

Keep your eyes open for more books about Altair SLC coming soon…