Linux Tutorials on the topic “mysql”
-
How to Setup MySQL Master-Master Replication
Author: christensen143 •
Tags: linux, mysql, server •
Comments: 7 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: 45 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: 23 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: 5 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.
-
Getting Started with WP-CLI on Ubuntu 15.10
Author: Muhammad Arul •
Tags: linux, mysql, nginx, php, shell, ubuntu •
Comments: 2 WP-CLI is a tool to provide a command line interface to install and manage a WordPress site. This tutorial explains the installation of Wordpress on a LEMP (Linux + Nginx + MySQL + PHP) server with WP-CLI and shows how to install plugins and themes with WP-CLI on the command line.
-
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.
