MySQL

  1. Install MySQL Server
  2. Examine the MySQL Configurations
  3. Generate MySQL Server Configurations using Percona’s Tool.
  4. Install and Configure MySQL Admin
  5. Connect to MySQL Database
  6. Create a database and Tables
  7. Query Data - SELECT
  8. Modify Data - UPDATE/ALTER
  9. Backup MySQL Database

    Apache

  10. Install Apache Web Server with Default Virtual host
  11. Examine Apache Configurations
  12. Create Virtual Hosts
  13. Add Redirect and Rewrite Rules with Apache
  14. Configure SSL with Apache

    PHP Application

  15. Install PHP
  16. Configure PHP with Apache
  17. Install and setup Wordpress with Apache with MySQL Backend

    Nginx

  18. Install Nginx
  19. Examine Nginx Configurations
  20. Configure Nginx as Load Balancer/ Reverse Proxy
  21. Configure SSL Certificate with Nginx

    Tomcat

  22. Install Java and prerequisites
  23. Install Tomcat
  24. Tomcat Configurations
  25. Deploy a Sample Application with Tomcat