MySQL & MariaDB
Get help with MySQL and MariaDB Database Servers. AGIX Linux staff have the know-how and experience to help your organization with Database Server best-practices, current technology in various Cloud environments including Amazon AWS.
This page shows examples of our work that AGIX Linux 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.
See Our Blogs on MySQL & MariaDB
Backup vTigerCRM on Synology (MySQL / MariaDB)
All HowTo's
Linux
MySQL & MariaDB
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 More
Node.JS with MySQL
All HowTo's
Linux
MySQL & MariaDB
Redhat, Fedora and CentOS Linux
Ubuntu, Mint & Debian Linux
This 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 More
Upgrade MariaDB to 10.3 on CentOS 7
All HowTo's
Linux
MariaDB
MySQL & MariaDB
Redhat, Fedora and CentOS Linux
Everything 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
Fail2Ban with MySQL Database for IP Blacklisting
All HowTo's
Linux
MySQL & MariaDB
Redhat, Fedora and CentOS Linux
Ubuntu, Mint & Debian Linux
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
How To Purge Old MySQL Data And Recover Disk Sapce
All HowTo's
MySQL & MariaDB
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
Installing Confluence & Migrating the Database to MySQL or PostgreSQL
AGIX Discussion
All HowTo's
Linux
MySQL & MariaDB
PostgreSQL
Redhat, Fedora and CentOS Linux
Ubuntu, Mint & Debian Linux
Web Servers
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
Find and Fix MySQL Performance Problems with Indexes
All HowTo's
Linux
MySQL & MariaDB
Redhat, Fedora and CentOS Linux
Ubuntu, Mint & Debian Linux
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
Remotely access MySQL on an OpenShift server
All HowTo's
MySQL
MySQL & MariaDB
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 More
Simple Rsyslog/MySQL Log Viewer in PHP
All HowTo's
Linux
MySQL & MariaDB
Redhat, Fedora and CentOS Linux
Ubuntu, Mint & Debian Linux
I’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
Secure Log Remotely to Syslog & Store The Logs in MySQL | Redhat Linux & Centos
All HowTo's
Cyber-Security
Linux
MySQL & MariaDB
Redhat, Fedora and CentOS Linux
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
Need Help?
"*" indicates required fields
Our Team Is Made Up Of Australian Specialists
Need Help?
Click Here