Get help with MySQL and MariaDB Database Servers. AGIX staff have the know-how and experience to help your organisation with Database Server best-practices, current technology in various Cloud environments including Amazon AWS.
This page shows examples of our work that AGIX shares freely with you. For a fully supported compute environment, contact our team to find out how we can help your organization move forward in the right way.
Contact our friendly team to get started.
Synology include the vTiger CRM suite as a plugin/add-on. They didn’t include a backup solution though. This how-to described how to backup the vTiger CRM database. The idea is to dump the database regularly, into a place that some other backup process includes. For example, if you have a “Shared
Read moreThis article shows how to implement a small Node.js application that pulls data from a local MySQL server. We’re doing this on a CentOS server but that’s not important – any Linux will do. But if you’re using Windows, the installation process will differ. yum install nodejs npm install mysql
Read moreEverything you see here is found more formally at “https://mariadb.com/docs/operations/upgrades/upgrade-community-server-cs103-centos7/”. This page is basically just my notes in case I can’t find the other site when I need it in future. We’re using CentOS 7 and upgrading from “MariaDB 5.5” to “MariaDB 10.3”. Backup your DB and config files first.
Read more
This article demonstrates how to configure Fail2Ban to use a MySQL (or MariaDB, etc) as the storage repository for IP blocking records. This allow multiple Fail2Ban services (running on multiple servers) to report and use a central IP blocking repository. A little context. In this article, we’re installing everything on
Read more
This article demonstrates how to delete old data from a MySQL table and recover the disk space from the removed data. This works with MYISAM databases. USE mydatabase; DELETE FROM mytable WHERE time < NOW() - INTERVAL 1 WEEK; The above will remove anything older than 1 week. We're relying
Read more
This article explains the process of installing Confluence on your own server and then later migrating your content and settings from the “evaluation” database to something more professional such as MySQL or PostgreSQL. This article is basically an example with sensible assumptions. We’re using CentOS 7. When you first get
Read more
So you have a MySQL database and it’s running like a dog. A slow dog, not one of those fast ones. This article is for you. Actually, this article is more of a story about a recent problem a client had with a large Magento database that had become too
Read more
OpenShift doesn’t allow remote access to MySQL gear. You have to use IPTables to work around this limitation. The good news is that it’s a simple process. This article is a walk-through showing how i’ve done it. First we need to get the application ID of the OpenShift application we’re
Read moreI’ve previously documented how to configure Rsyslog to store logs in MySQL which gives a good tutorial on setting up MySQL as the Rsyslog backend and also remote logging to that Rsyslog server. To extend on that, you can easily view and filter the logs using the php web-app below.
Read more
This article explains how to create an Rsyslog server that logs to MySQL (MariaDB). We’ve used CentOS 7 for this article. A few tips to save you time: If you’re logging from a remote node to this server, make sure you have proper host names because that’s what ends up in
Read more