In this tutorial, I will show you step by step to configure MySQL securely for remote connections with SSL. MySQL is an open source relational database system that works on many Operating Systems including Windows, Linux, MacOS and FreeBSD. It is probably the most popular OpenSource RDBMS and a central component of the LAMP and LEMP Stacks.
10 Older Entries »
In this tutorial, I will show you how to install Magento 2.1 with Nginx, PPHP 7.0 (FPM) and MySQL 5.7 on a CentOS 7 server. Magento is a widely used open source shop and content management system for e-commerce websites based on the PHP Zend Framework.
In today's business, it is increasingly necessary to share workspaces, labs, tools, and any other type of resources. Making the most of the available resources has become a competitive advantage for modern businesses. Booked is open source software written in PHP and MySQL that helps organizations and groups efficiently manage, record and track resources of any kind. It allows you to create schedules so users can find schedules available for resource use.
Cerb is a free and open source web-based application software for collaboration and email automation. It is written in PHP language and uses MySQL/MariaDB as a database. It is used for sending a large number of emails. Here, we will explain how to install Cerb on CentOS 7 server.
This tutorial shows how you can install an Apache webserver on a CentOS 7 server with PHP (mod_php with PHP 5.4, PHP 7.0, or PHP 7.1) and MySQL support. This setup is often referred to as LAMP which stands for Linux - Apache - MySQL - PHP.
This tutorial shows how to install ISPConfig 3.1 on a CentOS 7.3 (64Bit) server. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more.
In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server.
In general, CPanel and WHM have been leaning towards support of MariaDB over other flavors. This is partly due to the upstream repos replacing the MySQL package with MariaDB (for example, on CentOS).
MySQL 5.6 is still supported though, which means they are keeping support for core MySQL products. But if you want to get some extra performance enhancements or enterprise features for free, without getting too many bells and whistles, you might want to install Percona Server.
I’ve done this work on a new dedicated server with the latest WHM and CPanel on CentOS 7, with MySQL 5.6 installed. …[Read more]
In this article, I will show you how it’s possible to perform an online migration from a 3 members Galera cluster setup (in this case I’m using PXC 5.7.14) to a 3 members MySQL Group Replication cluster setup (MySQL Community 5.7.17).
Don’t forget that before adopting Group Replication as database backend, you should validate that your application do match GR requirements and limitations. When this is validated, you can start !
So first, let’s have a look at the current situation:
We have an application (sysbench 0.5), reading and writing to a Galera Cluster ( …[Read more]
Redmine is an open source web application for project management and issue tracker. In this tutorial, we will install Redmine 3.2 with Nginx as the web server, MySQL as the database server on a CentOS 7 (64 bit) operating system.
Historically I do not care much about MariaDB's MaxScale, at least since I know how to build it from source when needed. But,
as a support engineer who work at MariaDB, sometimes I have to
deal with problems related to MaxScale, and this week it happened
so that I had to explain what to do to implement automatic
restarts of MaxScale "daemon" in case of crashes on RHEL
In the process I had found out that two of my most often used Linux distributions, CentOS 6.x and Ubuntu 14.04, actually use Upstart, so good old System V's init tricks and scripts work there only partially and only because somebody cared to integrate them into this "new" …
10 Older Entries »