AWS DevOps Optimization for Laravel System
Budget: $250 – $750 SGD
We are seeking an experienced AWS DevOps Engineer with strong backend development knowledge to optimize our database and application server load balancing infrastructure. Our current setup is underutilizing our database resources due to improper query routing configuration.
Current Infrastructure
Database Tier:
• AWS RDS MySQL cluster with 1 writer instance and 2 reader instances
• Issue: Load is not evenly distributed across reader instances
• Problem manifestation: Majority of read queries are being routed to the writer instance; only the writer and 1 reader instance handle significant traffic; 1 reader instance remains largely idle
Application Tier:
• Backend system built with Laravel PHP and MySQL
• Multiple EC2 instances requiring Application Load Balancer (ALB) configuration
• ALB setup needs optimization/configuration
Key Objectives:
1. Diagnose and fix RDS read/write query routing – Ensure read queries are properly distributed across both reader instances while write queries go exclusively to the writer instance
2. Review backend codebase – Audit Laravel PHP code to identify and correct any misconfigurations in database connection handling, query routing logic, or connection pool settings that may cause queries to default to the writer instance
3. Implement proper RDS reader endpoint usage – Configure the application to use RDS cluster reader endpoint for read operations and writer endpoint for write operations
4. Configure ALB for EC2 instances – Set up and optimize Application Load Balancer to properly distribute traffic across EC2 backend servers
5. Verify load distribution – Test and validate that read queries are evenly distributed across the 2 reader instances and that the previously idle instance is now receiving appropriate traffic
Laravel: 5.8
PHP: 7.4
MySQL: 8
Please submit your proposal including your server management experience. Please note the selected candidate would be required to connect with us remotely and share the KT on the configuration and provide detailed documentation for our existing team.
Current Infrastructure
Database Tier:
• AWS RDS MySQL cluster with 1 writer instance and 2 reader instances
• Issue: Load is not evenly distributed across reader instances
• Problem manifestation: Majority of read queries are being routed to the writer instance; only the writer and 1 reader instance handle significant traffic; 1 reader instance remains largely idle
Application Tier:
• Backend system built with Laravel PHP and MySQL
• Multiple EC2 instances requiring Application Load Balancer (ALB) configuration
• ALB setup needs optimization/configuration
Key Objectives:
1. Diagnose and fix RDS read/write query routing – Ensure read queries are properly distributed across both reader instances while write queries go exclusively to the writer instance
2. Review backend codebase – Audit Laravel PHP code to identify and correct any misconfigurations in database connection handling, query routing logic, or connection pool settings that may cause queries to default to the writer instance
3. Implement proper RDS reader endpoint usage – Configure the application to use RDS cluster reader endpoint for read operations and writer endpoint for write operations
4. Configure ALB for EC2 instances – Set up and optimize Application Load Balancer to properly distribute traffic across EC2 backend servers
5. Verify load distribution – Test and validate that read queries are evenly distributed across the 2 reader instances and that the previously idle instance is now receiving appropriate traffic
Laravel: 5.8
PHP: 7.4
MySQL: 8
Please submit your proposal including your server management experience. Please note the selected candidate would be required to connect with us remotely and share the KT on the configuration and provide detailed documentation for our existing team.
Related categories:
PHP
MySQL
Amazon Web Services
Laravel
Backend Development
DevOps
Database Management