Tag: migration

Buy 3 new ebooks about Altair SLC directly from this blog site at pre-publication prices

Loading

Pablo Orosco Joerger and I have been writing these 3 ebooks about Altair SLC since October 2024, but before we officially publish them we wanted to offer the latest versions for you to buy, read and review at discount prices. As with other ebooks on this blog, any ebooks bought will have any new editions sent directly to you by email when they are published at a later date at no extra charge. We would just like you to read them, and maybe suggest updates and improvements, and write reviews for the blog site and inside the ebooks for the next editions.

  • Buying ebooks from this blog site requires the buyer to create a blog profile, which includes their email address.
  • This email address will be used to send them the ebook, but should also be maintained over time so that future editions can be sent out for free. The next edition will be the first officially published edition, which could include your review!

Click on the cover images of each of these books to visit the book pages to find out what they are about, or visit the Book Table:

Converting mySQL database to MariaDB: findings so far…

Loading

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

Loading

  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…