Find Jobs
Hire Freelancers

Python workers, autoscale, SQL Alchemy, database connection pool

$2 USD / hour

Closed
Posted over 5 years ago

$2 USD / hour

Description of our setup: We have an API which has a connection pool with 10 concurrent permanent database connections. For the API we use use sqlalchemy, because the database models were written for sqlalchemy. We have different types of python workers, lets call them type A, type B, type C. Each type of worker is processing different things by design. Description of our problem: We are using AWS EC2 instance autoscaling feature to scale all types of workers so that we could have for example 6 A, 20 B and 50 C type workers as needed. We are using the basic RDS instance for our MySQL database which I believe has 66 MaxConnectionLimit. The problem is that currently each worker is creating a permanent connection to the DB, which means that at some point we will hit the 66 concurrent connection limit and the app will crash. The work scope Have a solution so that the app would not crash when the total number of all types of instances is more than the MaxConnectionLimit. I will not be able to share our source code, therefore you will have to make a simple app that matches our design with some dummy workers, a simple way to launch a new worker so that we can test the case when there are more workers than the MaxConnectionLimit. If you have read all the description and understand the task, please start your proposal with !SREEHC.
Project ID: 18280403

About the project

2 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $9 USD/hour for this job
User Avatar
!SREEHC. Hello Prospects, I will create the app. Thank for posting details. Please provide complete details. Thank you, With Regards,
$2 USD in 40 days
5.0 (3 reviews)
2.6
2.6

About the client

Flag of UNITED STATES
Santa Clara, United States
5.0
18
Payment method verified
Member since Oct 8, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.