Find Jobs
Hire Freelancers

Ubuntu docker

$30-250 USD

已完成
已发布超过 5 年前

$30-250 USD

货到付款
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: 18114455

关于此项目

5提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
5.0 (35条评论)
4.7
4.7
5威客以平均价$140 USD来参与此工作竞价
用户头像
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 在1天之内
5.0 (1755条评论)
8.2
8.2
用户头像
system admin expert
$250 USD 在1天之内
5.0 (27条评论)
5.4
5.4
用户头像
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 在3天之内
5.0 (7条评论)
3.6
3.6

关于客户

BRAZIL的国旗
São Paulo, Brazil
5.0
1
会员自11月 7, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。