Linux Tutorials on the topic “mysql”
-
How to Enable SSL and Remote Connections for MySQL on CentOS 7
Author: Muhammad Arul •
Tags: centos, linux, mysql •
Comments: 7 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.
-
The Perfect Server - Ubuntu 17.04 (Zesty Zapus) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1
Author: Till Brehm •
Tags: apache, bind, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, ubuntu, web server •
Comments: 22 This tutorial shows how to install an Ubuntu 17.04 (Zesty Zapus) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1, and how to install ISPConfig. ISPConfig 3 is a web hosting 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).
-
How to install Percona XtraDB Cluster for MySQL on Debian 8
Author: Matteo Temporini •
Tags: debian, linux, mysql, server •
Comments: 0 In this article, I will show you how to configure a MySQL database cluster with three nodes in a multi-master replication. Multi-master replication allows writing of records in each node, so if a node will fail, we can work on the other as if nothing happened. This tutorial describes how to install and configure three Percona XtraDB Cluster nodes on Debian 8 servers, we will be using the packages from the Percona repositories.
-
-
How to install Apache, PHP 7.1 and MySQL on CentOS 7.3 (LAMP)
Author: Till Brehm •
Tags: apache, centos, linux, mysql, php, server, web server •
Comments: 23 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.
-
The Perfect Server CentOS 7.3 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: 30 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.
-
The Perfect Server - Ubuntu 16.10 (Yakkety Yak) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1
Author: Till Brehm •
Tags: apache, bind, control panels, dns, email, ftp, ispconfig, linux, mysql, php, postfix, ubuntu, web server •
Comments: 33 This tutorial shows how to install an Ubuntu 16.10 (Yakkety Yak) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1, and how to install ISPConfig. ISPConfig 3 is a web hosting 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).
-
How to install Wordpress with Nginx, MariaDB and HHVM on Ubuntu 16.04 LTS
Author: Muhammad Arul •
Tags: linux, mysql, nginx, server, ubuntu, web server •
Comments: 10 This tutorial describes the steps to install WordPress with Nginx, MariaDB and HHVM on Ubuntu 16.04 Server. HHVM (Hip Hop Virtual Machine) is a just-in-time compiler developed by Facebook to run applications that are written in PHP and Hack language. HHVM is faster than the traditional PHP engine from ZEND and is used by Facebook to serve billions of web requests per day.
-
How to Install a MySQL Cluster on Ubuntu 16.04
Author: Muhammad Arul •
Tags: linux, mysql, ubuntu •
Comments: 24 In this tutorial, I will show you how to install a 'MySQL Cluster' on Ubuntu 16.04 LTS (Xenial Xerus). MySQL Cluster is a technology to provide high availability for MySQL Databases. It uses NDB (Network DataBase) or NDBCLUSTER as the database storage engine. MySQL Cluster is designed as multi-master ACID architecture with no single point of failure, it uses automatic sharding (partitioning) to scale out read and write processes.
-
Perform Hot Backups of MySQL Databases with Percona XtraBackup on Ubuntu 16.04
Author: Muhammad Arul •
Tags: backup, linux, mysql, ubuntu •
Comments: 3 Percona XtraBackup is an open source backup utility for MySQL. It supports all MySQL flavours like Percona Server, MariaDB, and (Oracle) MySQL. Percona Xtrabackup performs a Hot Backup for MySQL. In this tutorial, I will show you how to create a hot MySQL database backup with the OpenSource tool Percona XtraBackup on Ubuntu 16.04 (Xenial Xerus).
-
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.
