Brain's Workbench
This worked for Debian 8 (Jessie)
replace original /etc/sources.list with:
deb http://archive.debian.org/debian/ jessie main non-free contrib deb-src http://archive.debian.org/debian/ jessie main non-free contrib deb http://archive.debian.org/debian-security/ jessie/updates main non-free contrib deb-src http://archive.debian.org/debian-security/ jessie/updates main non-free contribapt-update
It will give a keyring error. I tried both:
Step-1: Install LAMP on Debian
I’ve used a bash script to install LAMP. You may find it useful.
#!/bin/bash
########################################################
### This script is created by Hasn T. Emdad Rumi <h.t.emdad@gmail.com>.
### Released under GPL 2.0 licensing
### Date: 12-Aug-2016
########################################################
echo "Updating Debian Repository..."
apt-get install debian-keyring debian-archive-keyring -y
apt-get update
echo "Installing mysql serve & client..."
apt-get install mysql-server mysql-client -y
echo "Installing Apache2 and PHP5..."
apt-get install apache2 php5 libapache2-mod-php5 libapache2-mod-auth-mysql libmysqlclient15-dev php5-mysql php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl php-xml pcre php-common curl phpmyadmin -y
echo "Now rebooting services..."
/etc/init.d/apache2 restart
clear
ip_add=`ifconfig | grep -Eo 'inet (addr:)?([0-9]*\.){3}[0-9]*' | grep -Eo '([0-9]*\.){3}[0-9]*' | grep -v '127.0.0.1'`
l1=" _____ _ _ _ _ _ "
l2=" |_ _| | | | | | | | |"
l3=" | | _ __ ___| |_ __ _| | | ___ __| | |"
l4=" | | | '_ \/ __| __/ _ | | |/ _ \/ _ | |"
l5=" _| |_| | | \__ \ || (_| | | | __/ (_| |_|"
l6=" |_____|_| |_|___/\__\__,_|_|_|\___|\__,_(_)"
echo "$l1"
echo "$l2"
echo "$l3"
echo "$l4"
echo "$l5"
echo "$l6"
echo "=============================================="
echo "Phpmyadmin is available at http://$ip_add/phpmyadmin/"
echo "=============================================="
echo "username: root"
echo "password: (mysql root password)"
echo "Update: innodb_file_per_table=1"
Wheezy and jessie both has gone EOL and repos too. archive repo doesn’t seem to usually work either. So here’s a little trick that worked for me. Below is my repo.list file-
deb http://archive.debian.org/debian jessie main deb http://archive.debian.org/debian-archive/debian-security/ jessie updates/ma$ #deb http://security.debian.org/ jessie/updates non-free contrib main #deb http://mirrors.ocf.berkeley.edu/debian/ jessie-updates main contrib non-fr$ deb http://security.debian.org/ jessie/updates main deb http://ftp.fr.debian.org/debian jessie-updates main
Nowupdate apt as below-
Configure Apache2 for SSL.
root@www:~# vi /etc/apache2/sites-available/default-ssl.conf
# line 3: change to webmaster's email ServerAdmin webmaster@srv.world # line 32,33: change to the one created in [1] SSLCertificateFile /etc/ssl/private/server.crt SSLCertificateKeyFile /etc/ssl/private/server.key
root@www:~# a2ensite default-ssl
Enabling site default-ssl.
First of all, why we choose three nodes and not only two? In any cluster, the number of nodes should be odd, so in the case of disconnection of a node, we assume that the highest group of servers has the fresh data, and should be replicated to the down node to avoid data loss. This is related only to resolve conflicts in data replication, we won’t loose data written only to the disconnected node.
This is used to avoid a circumstance called split brain, in which we can’t automatically choose which node has correct data. Think for example of a 2 node cluster where both nodes are disconnected from each other, and the same record is written to both nodes: who wins when they come back online? We don’t know, so split brain happens, and we have to manually decide wich record is the right one.
The number of nodes that is needed to determine wich part of the cluster has the right data is called QUORUM, in our case, the quorum will be 2. So we need 2 servers always be connected to each other. In case all three nodes will go down, we have a split brain and we must decide wich server should go in bootstrap mode manually, this is the procedure to determine wich will be the main server to resume from the split brain.
Configuring Percona XtraDB Cluster on Debian 8
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.
Node 1 Hostname: mysql1.local.vm IP address: 192.168.152.100 Node 2 Hostname: mysql2.local.vm IP address: 192.168.152.110 Node 3 Hostname: mysql3.local.vm IP address: 192.168.152.120
On each host, modify file /etc/hosts as follows to ensure DNS will work correctly.
Step 1 — Creating the Directory Structure
The first step that we are going to take is to make a directory structure that will hold the site data that we will be serving to visitors.
Our document root, the top-level directory that Apache looks at to find content to serve, will be set to individual directories under the /var/www directory. We will create a directory for each of the virtual hosts we’ll configure.
Within each of these directories, we’ll create a folder called public_html that will hold the web pages we want to serve. This gives us a little more flexibility in how we deploy more complex web applications in the future; the public_html folder will hold web content we want to serve, and the parent folder can hold scripts or application code to support web content.
Create the directories using the following commands:
sudo mkdir -p /var/www/example.com/public_html sudo mkdir -p /var/www/test.com/public_html
Since we created the directories with sudo, they are owned by our root user. If we want our regular user to be able to modify files in our web directories, we change the ownership, like this: