Linux Tutorials on the topic “mysql”
-
How to Install Drupal 8.1 with Nginx, PHP-FPM and SSL on Ubuntu 16.04
Author: Muhammad Arul • Tags: linux, mysql, nginx, php, server, ubuntu, web server • Comments: 15
Drupal is a well-known open source content management system based on PHP. It is available free of charge and released under the GNU General Public License. In this tutorial, we will install Drupal 8.1 with Nginx web server, MariaDB as the database server and PHP-FPM to handle PHP requests. I will also show you how to install an SSL Certificate to secure the Drupal website.
-
How to Install WordPress with Docker on Ubuntu
Author: Muhammad Arul • Tags: linux, mysql, ubuntu, web server • Comments: 18
In this tutorial, we will install WordPress by using multiple docker containers. Wordpress itself in one container and the MariaDB database in another container. Then we will install Nginx on the host machine as reverse proxy for the WordPress container.
-
The Perfect Server CentOS 7.2 with Apache, Postfix, Dovecot, Pure-FTPD, BIND and ISPConfig 3.1
Author: Till Brehm • Tags: anti-spam/virus, apache, bind, centos, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, web server • Comments: 48
This tutorial shows how to install ISPConfig 3.1 on a CentOS 7.2 (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.
-
-
How to Install Percona XtraDB Cluster on CentOS 7
Author: Muhammad Arul • Tags: centos, linux, mysql • Comments: 3
In this tutorial, I will show you how to install and configure Percona XtraDB Cluster on a CentOS 7 server. We will use Percona XtraDB Cluster 5.6 that is fully compatible to MySQL and the Percona Server.
-
Install Apache, PHP And MySQL On CentOS 7 (LAMP)
Author: howtoforge • Tags: apache, centos, linux, mysql, php, server, web server • Comments: 63
This tutorial shows how you can install an Apache2 webserver on a CentOS 7.0 server with PHP5 support (mod_php) and MySQL support. LAMP is short for Linux, Apache, MySQL, PHP.
-
How to Setup MySQL Master-Master Replication
Author: christensen143 • Tags: linux, mysql, server • Comments: 10
This article consolidates information from several sources into the format I use to setup MySQL Master/Master Replication. The beauty of Linux and open source is that there are many different ways to do this. Please take a look at my references and use them to accommodate any needs you may have.
-
Installing a Web, Email & MySQL Database Cluster on Debian 8.4 Jessie with ISPConfig 3.1
Author: Florian Schaal • Tags: control panels, debian, email, ispconfig, mysql, web server • Comments: 52
This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancy, high availability and load balancing on Debian 8 with the ISPConfig 3 control panel. MySQL Master/Master replication will be used to replicate the MySQL client databases between the servers, Unison will be used to Sync the /var/www (websites) and the Mails will be synced with Dovecot.
-
Replicating a master database using MariaDB 10 on Debian 8
Author: Neil Golden • Tags: debian, linux, mysql, server • Comments: 1
Replicating databases creates redundancy which can protect against data loss, and permit optimized performance for applications. This tutorial will cover the basics of replicating an existing MariaDB 10.0 master database to one or more slaves. In the following examples, the host operating system is Debian 8.
-
How to setup HAProxy as Load Balancer for MariaDB on CentOS 7
Author: Muhammad Arul • Tags: centos, high-availability, linux, mysql • Comments: 8
In this tutorial, I will guide you trough the installation of a MariaDB Galera cluster on CentOS 7 which has an HAProxy load balancer in front. The total setup consists of 4 servers. I will use 3 CentOS 7 servers for the database nodes, 2 nodes will be active and 1 acts as the backup node. The fourth server will be used for the HAProxy load balancer. For the balance algorithm, we use leastconn (but you can use other algorithms).
-
How to Install and Configure MySQL Cluster on CentOS 7
Author: Muhammad Arul • Tags: centos, linux, mysql • Comments: 25
MySQL Cluster is designed to provide a MySQL compatible database with high availability and low latency. The MySQL Cluster technology is implemented through the NDB (Network DataBase) and NDBCLUSTER storage engines and provides shared-nothing clustering and auto-sharding for MySQL database systems. In the shared-nothing architecture, each of nodes has its own memory and disk, the use of shared storage such as NFS, SANs is not recommended and supported.