Overview
MySQL Server + phpMyAdmin + LAMP + Apache Web Server on CentOS Stream 9
Deploy a production-ready MySQL database environment on AWS in minutes. This pre-configured AMI by Cloud Infrastructure Services gives DevOps engineers, full-stack developers, and SMB teams a complete LAMP stack - eliminating hours of manual installation and configuration. Whether you are migrating an on-premises LAMP application to AWS, building a new SaaS backend, or setting up a development and testing environment for CI/CD pipelines, this AMI provides a secure, ready-to-use foundation.
What Is Included
- MySQL Server Community Edition - Configure as a standalone database, set up master-slave replication, or deploy InnoDB clustering for high availability and automatic failover.
- phpMyAdmin - Administer databases, tables, columns, indexes, users, and permissions through a web-based GUI without writing SQL commands.
- Apache Web Server - Serve web applications with Mod_Security (Web Application Firewall protecting against OWASP top-10 attacks) and Mod_wsgi for Python WSGI support.
- PHP with Performance Extensions - APCu and Redis extensions for in-memory caching that reduces database load; Swoole for asynchronous, high-throughput PHP processing; MongoDB and Libsodium extensions for flexible data handling and modern cryptography.
- KodExplorer - A web-based file manager for browsing, uploading, and managing server files without SSH access.
- MySQL Shell - Advanced command-line client for SQL, JavaScript, and Python scripting against your database.
Use Cases
- E-commerce and SaaS backends - Host WordPress, Magento, or custom PHP applications with MySQL as the primary data store, using Redis caching to handle concurrent user sessions.
- Read-replica architecture - Configure MySQL replication to distribute read traffic across multiple instances, improving response times for read-heavy applications.
- Development and staging environments - Spin up identical LAMP environments for CI/CD pipelines, enabling developers to test database migrations safely before production deployment.
- High-availability deployments - Use InnoDB clustering with automatic failover to maintain uptime for mission-critical applications.
Security Baseline
- Mod_Security WAF - Pre-installed Apache module providing application-layer firewall protection against SQL injection, XSS, and other common web attacks.
- Libsodium cryptography - Modern encryption library available for application-level data protection.
- MySQL access controls - Configure bind address, user privileges, and TLS connections to restrict database access.
Buyers should configure AWS Security Groups to restrict inbound access to required ports only (SSH 22, HTTP 80, HTTPS 443, MySQL 3306) and enable EBS encryption for data at rest.
Requirements and Limitations
- Minimum instance type: t3.small (2 vCPU, 2 GB RAM) for development workloads. For production databases, m5.large or higher is recommended.
- Storage: Minimum 20 GB EBS volume (gp3 recommended). Size according to your expected database growth.
- Operating system: CentOS Stream 9 (64-bit).
- Not included: Automated backups (configure AWS Backup or mysqldump cron jobs), SSL/TLS certificates (use Let's Encrypt or AWS Certificate Manager), and InnoDB cluster auto-configuration (manual setup required following documentation).
- Region availability: Available in all standard AWS commercial regions.
Highlights
- Comes pre installed with MySQL Server community, phpMyadmin, LAMP Stack and Apache Web Server. Eliminates hours of manual MySQL configuration - deploy a production-capable database environment on AWS in minutes rather than spending time installing and tuning individual components. Includes MySQL Shell for advanced SQL, JavaScript, and Python scripting.
- Built-in security with Mod_Security Web Application Firewall protecting against OWASP top-10 attacks (SQL injection, XSS, CSRF), Libsodium cryptography library for application-level encryption, and granular MySQL access controls. Apache serves applications behind WAF protection while PHP leverages modern cryptographic functions out of the box.
- MySQL Server on AWS is optimised for speed and performance, ready for production ready databases.
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
- ...
Dimension | Cost/hour |
|---|---|
t2.medium Recommended | $0.05 |
t2.micro | $0.05 |
t3.micro | $0.05 |
r5dn.xlarge | $0.05 |
t2.nano | $0.05 |
x1e.32xlarge | $0.05 |
c5a.24xlarge | $0.05 |
g4dn.8xlarge | $0.05 |
m5dn.16xlarge | $0.05 |
z1d.xlarge | $0.05 |
Vendor refund policy
We do not currently support refunds, but you can cancel at any time.
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Latest OS Patches installed. Simply run 'yum update' to install latest OS patches
Additional details
Usage instructions
Scroll down to 'Getting Started' on the following URL: https://cloudinfrastructureservices.co.uk/how-to-setup-mysql-server-phpmyadmin-on-linux-in-azure-aws-gcp/
Resources
Vendor resources
Support
Vendor support
Support Channels
Cloud Infrastructure Services provides email-based technical support for this MySQL LAMP AMI.
Email support at support@cloudinfrastructureservices.co.uk
Or submit a support ticket via https://cloudinfrastructureservices.co.uk/contact-us/
Scope of Support
Support covers assistance with initial deployment, AMI configuration questions, troubleshooting installation issues, and guidance on MySQL replication and InnoDB clustering setup. Our getting started guide provides step-by-step instructions: https://cloudinfrastructureservices.co.uk/how-to-setup-mysql-server-phpmyadmin-on-linux-in-azure-aws-gcp/
Instance Sizing Guidance
- Development/Testing: t3.small (2 vCPU, 2 GB RAM) with 20 GB gp3 EBS
- Small production workloads: t3.medium (2 vCPU, 4 GB RAM) with 50 GB gp3 EBS
- Medium production workloads: m5.large (2 vCPU, 8 GB RAM) with 100 GB gp3 EBS
- Large production workloads: m5.xlarge or higher with provisioned IOPS EBS
Scale your instance type based on concurrent connections, database size, and query complexity. MySQL InnoDB buffer pool should be sized to approximately 70-80% of available RAM.
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.