Another option could be ProxySQL, where you can cache queries on the ProxySQL server. Source: about 1 year ago

Also, if you're not using it yet, I can recommend looking at ProxySQL to do your read-write/read-only failover controls. Source: over 1 year ago

What are the recommendations here? I took a look into ProxySQL and it looks like since v2, it can do frontend and backend SSL connections. I have it locally working on a docker setup. Source: over 1 year ago

DB: Split you write-read operations. You may scale read as needed. Write operations can be slow if you have too many indices, so make sure to use only the ones you really need. Your DBMS may have some configuration to optimise, for example in MySQL if you do NOT need ACID compliance you can set innodb_flush_log_at_trx_commit = 2 to achieve better write speed. For MySQL you should also look into https://proxysql.com/. Source: over 1 year ago

A Layer-7 Database Load Balancer is optional here. An L7-DBLB can be used for various use cases (eg: ProxySQL). One or more database instances handle queries from the web server. A Client-side DB query/connection load balancing can also be used instead of an L7-DBLB according to the use case of the application. - Source: dev.to / almost 2 years ago

Use load balancers and distribute load accordingly to your redundant spring boot services. - Source: dev.to / 2 months ago

• Amazon Elastic Container Service (Amazon ECS) is a fully managed container orchestration service that helps you easily deploy, manage, and scale containerized applications. • AWS Fargate is a serverless, pay-as-you-go compute engine that lets you focus on building applications without managing servers. AWS Fargate is compatible with both Amazon Elastic Container Service (Amazon ECS) and Amazon Elastic... - Source: dev.to / 8 months ago

Elite Dangerous. With proper setup, AWS works great. And I am sure there are hundreds or even thousands of games using them, but not all are willing to share that information. Source: 12 months ago

Terraform templates can be used to automate the deployment and configuration of the Presentation Tier components. This Terraform code snippet can be used to deploy an AWS Elastic Load Balancer (ELB):. - Source: dev.to / about 1 year ago

Assuming you already have two LBs (as above), most services will offer auto scaling of some description to handle this (e.g., https://aws.amazon.com/elasticloadbalancing/). Source: about 1 year ago