Find Jobs
Hire Freelancers

Ubuntu docker

$30-250 USD

Slutfört
Publicerad över fem år sedan

$30-250 USD

Betalning vid leverans
We have a physical machine with Ubuntu 14.04 LTS where ran an application called Ubersmith that uses Docker container: https://docs.ubersmith.com/display/UbersmithDocumentation/Ubersmith+and+Docker One of its container has a MySQL Server, and since we wanted to backup the database generating a .sql file to restore on another host if needed, I've installed mysqlclient directly on the OS and I'm using crontab to ran mysqldump twice a day. That is how I do now: 0 1 * * * /usr/bin/mysqldump -h [login to view URL] -u root --password='******' ubersmith > /backup_mysql_cron/[login to view URL] 0 18 * * * /usr/bin/mysqldump -h [login to view URL] -u root --password='*****' ubersmith > /backup_mysql_cron/[login to view URL] - It has worked fine for us until last week, but now, when this cron runs, mysqld start using a big amount of RAM, for example, the server had 16 GB of memory free, and after the dump, it has only 8 GB and this isn't decreasing after the dump process is finished. Because of this cron, the server starts using swap and its applications become too slow and this affects our customers a lot, then we need someone who has a experience with Ubuntu+Docker+MySQL to find a solution to keep running the dump no affecting the server's applications.
Project ID: 18114455

Om projektet

6 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
Tilldelad till:
Använd avatar
Hi, Before accepting, please read: you can actually change your commands for the sql-dump a bit (you can try it manually: mysqldump -h [login to view URL] -u root --password='******' --quick ubersmith > /backup_mysql_cron/[login to view URL] This will read the large tables row by row instead of keeping everything in the buffer (might increase the dump-size, though) Best, C
$30 USD Om 1 dag
5,0 (35 omdömen)
4,7
4,7
6 frilansar lägger i genomsnitt anbud på $139 USD för detta uppdrag
Använd avatar
I have 16 years of experience in web hosting, server administration and php programming See my previous works at https://www.freelancer.com/u/NetFreeHost Message me, let's discuss the project.
$50 USD Om 1 dag
5,0 (760 omdömen)
7,0
7,0
Använd avatar
system admin expert
$250 USD Om 1 dag
5,0 (27 omdömen)
5,4
5,4
Använd avatar
Hi There have you tried adding the following options to tne mysqldump --skip-opt --quick cron line? I would advise you to give it a try. There are reported mysqldump bugs with the behaviour that you are explaining. I can help you to troubleshoot further Regards!
$150 USD Om 3 dagar
5,0 (7 omdömen)
3,6
3,6
Använd avatar
Hello! Try adding a parameter --single transactions for cron, if I do not help, I will analyze the problem and solve it with other backup tools, such as mydumper, which can be more precisely configured to troubleshoot backup problems.
$133 USD Om 1 dag
5,0 (1 omdöme)
2,3
2,3

Om kunden

Flagga för BRAZIL
São Paulo, Brazil
5,0
1
Verifierad betalningsmetod
Medlem sedan nov. 7, 2018

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.