Find Jobs
Hire Freelancers

Ubuntu docker

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 18114455

Información sobre el proyecto

6 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (35 comentarios)
4,7
4,7
6 freelancers están ofertando un promedio de $139 USD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (760 comentarios)
7,0
7,0
Avatar del usuario
system admin expert
$250 USD en 1 día
5,0 (27 comentarios)
5,4
5,4
Avatar del usuario
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 en 3 días
5,0 (7 comentarios)
3,6
3,6
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
2,3
2,3

Sobre este cliente

Bandera de BRAZIL
São Paulo, Brazil
5,0
1
Forma de pago verificada
Miembro desde nov 7, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.