Setting Up Proxmox VE with Application and Database VMs

explain the steps on the following:

1. Install Proxmox VE for my actual server.

2. In the server, create two Virtual Machines.

• One Application VM for running Ubuntu and PHP applications.
• Another Database VM for managing the MariaDB database.

3. Establish two subdirectories under the Application VM.

• One for the internet application system.
• One for the web application system.

4. Create two databases in the MariaDB under the Database VM.

• One for the internet application system.
• One for the web application system.

To set up your server with Proxmox VE and create the specified virtual machines and configurations, follow these steps:

Step 1: Install Proxmox VE on Your Server

1. Prepare Your Server:

   • Ensure your server meets the minimum requirements for Proxmox VE.
   • Backup any important data on the server, as the installation will erase existing data.

2. Download Proxmox VE:

   • Go to the Proxmox VE download page and download the latest ISO image.

3. Create a Bootable USB Drive:

   • Use a tool like Rufus (Windows) or Etcher (Mac/Linux) to create a bootable USB drive with the Proxmox VE ISO.

4. Install Proxmox VE:

   • Insert the USB drive into your server and boot from it.
   • Follow the on-screen instructions to install Proxmox VE. This includes selecting the target hard drive, setting up the network, and configuring the root password and email.

5. Access the Proxmox Web Interface:

   • Once installed, access the Proxmox web interface by navigating to https://<your-server-ip>:8006 in a web browser.
   • Log in using the root account and the password you set during installation.

Step 2: Create Two Virtual Machines

1. Create the Application VM:

   • In the Proxmox web interface, click on "Create VM."
   • Configure the VM with a name (e.g., "AppVM"), select the Ubuntu ISO for installation, and allocate resources (CPU, RAM, disk space) as needed.
   • Complete the VM creation process and start the VM.
   • Install Ubuntu on the VM by following the standard installation process.

2. Create the Database VM:

   • Repeat the process to create another VM (e.g., "DBVM") for the database.
   • Allocate appropriate resources for running MariaDB.
   • Install a minimal Linux distribution (e.g., Ubuntu Server) on this VM.

Step 3: Establish Subdirectories in the Application VM

1. Access the Application VM:

   • Use SSH or the Proxmox console to access the Ubuntu VM.

2. Create Subdirectories:

   • Navigate to the directory where you want to create the subdirectories (e.g., /var/www).
   • Use the following commands to create the subdirectories:

     mkdir /var/www/internet_app
     mkdir /var/www/web_app
     

   • These directories will host your internet and web application systems, respectively.

Step 4: Create Databases in the Database VM

1. Access the Database VM:

   • Use SSH or the Proxmox console to access the database VM.

2. Install MariaDB:

   • Update the package list and install MariaDB:

     sudo apt update
     sudo apt install mariadb-server
     

3. Secure MariaDB Installation:

   • Run the security script to set the root password and secure the installation:

     sudo mysql_secure_installation
     

4. Create Databases:

   • Log in to the MariaDB shell:

     sudo mysql -u root -p
     

   • Create the databases for your applications:

     CREATE DATABASE internet_app_db;
     CREATE DATABASE web_app_db;
     

   • Exit the MariaDB shell:

     EXIT;
     

By following these steps, you will have set up Proxmox VE on your server, created two virtual machines for your application and database, established subdirectories for your applications, and created the necessary databases in MariaDB.