Find Jobs
Hire Freelancers

Python workers, autoscale, SQL Alchemy, database connection pool

$2 USD / hour

Avslutat
Publicerad över fem år sedan

$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

Om projektet

2 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
2 frilansar lägger i genomsnitt anbud på $9 USD/timme för detta uppdrag
Använd avatar
!SREEHC. Hello Prospects, I will create the app. Thank for posting details. Please provide complete details. Thank you, With Regards,
$2 USD Om 40 dagar
5,0 (3 omdömen)
2,6
2,6

Om kunden

Flagga för UNITED STATES
Santa Clara, United States
5,0
18
Verifierad betalningsmetod
Medlem sedan okt. 8, 2014

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.