Linux Tutorials on the topic “mysql”
-
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: 56
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: 10
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.
-
Install MariaDB 10.0 on CentOS 6
Author: Antonio Valencia • Tags: centos, linux, mysql, server • Comments: 2
MariaDB is a community-developed fork of MySQL and aims to be an enhanced, drop-in replacement for it. The following tutorial will guide you through the steps to install MariaDB 10.0 on CentOS 6.
-
How to install WordPress with Apache, MariaDB and PHP 7 on Arch Linux
Author: Abdul Khois • Tags: apache, linux, mysql, php, server • Comments: 7
WordPress is a popular, dynamic, blog-focused content management system. The software is built upon a LAMP or LEMP stack and features an extensive plugin framework and theme system, which allows site owners and developers to deploy easy-to-use and powerful publishing tools. This tutorial will help you how to install and configure WordPress with Apache2, MariaDB and PHP 7 on Arch Linux.
-
How to Install Drupal 8 with Nginx, PHP-FPM and SSL on Ubuntu 15.10
Author: Muhammad Arul • Tags: linux, mysql, nginx, php, server, ubuntu, web server • Comments: 3
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 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.
-
The Perfect Server - Ubuntu 15.10 (nginx, MySQL, PHP, Postfix, BIND, Dovecot, Pure-FTPD and ISPConfig 3)
Author: Till Brehm • Tags: bind, control panels, dns, email, ftp, ispconfig, linux, mysql, nginx, php, postfix, ubuntu, web server • Comments: 16
This tutorial shows the steps to install an Ubuntu 15.10 (Wiley Werewolf) server with Nginx, PHP, MariaDB, Postfix, pure-ftpd, BIND, Dovecot and ISPConfig 3. ISPConfig 3 is a web hosting control panel that allows you to configure the installed services through a web browser. This setup provides a full hosting server with web, email (inc. spam and antivirus filter), Database, FTP and DNS services.
-
Installing Nginx with PHP and MariaDB (as MySQL replacement) - LEMP -on Ubuntu 15.10 (Wiley Werewolf)
Author: Till Brehm • Tags: linux, mysql, nginx, php, ubuntu • Comments: 1
Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 15.10 server with PHP support (through PHP-FPM) and MariaDB (as MySQL replacement). The term LEMP stands for: Linux + Nginx + MySQL + PHP.
-
The Perfect Server - Ubuntu 15.10 (Wily Werewolf) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3
Author: Till Brehm • Tags: apache, bind, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, ubuntu, web server • Comments: 45
This tutorial shows how to install an Ubuntu 15.10 (Wily Werewolf) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).