Find Jobs
Hire Freelancers

DBA shell scripting expert required; Make a mysql script replication autostart.

$15-25 USD / hour

Mbyllur
Postuar over 3 years ago

$15-25 USD / hour

Hello there, We need to have mysql recuriment from our server A to server B. We have made one script to get run but in past weeks we got errors. The concept is following: Script should do mysql replication exactly every 10-15 mins from SERVER A to SERVER B. It should replace all old entries with new ones. After that to delete any temporary files. To give you more sense: we manage a custom built a payment gateway. Many sites use this to manage payments. So it is critical that this site is ALWAYS online. If it fails, it means our customer could lose hours of orders on all sites. So we have 2 servers: one server A (main server used), and a server B that is a backup server. Through cloudflare, if server A become unavallable for more than some seconds, it automatically switch on server B. This is why server B need to synch always with server A, to have a up-to date version. And if server A fails and B becomes main, I am not sure how they could make it work: ideally, we should automatically switch back to the server A when it is working again, and server A would synchronize on server B to be itself also, up-to date. So data is never loss.
ID e Projektit: 26368918

Rreth projektit

14 propozime
Projekt në distancë
Aktive 4 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
14 freelancers are bidding on average $20 USD/orë for this job
Avatari i Përdoruesit
I can code a script for backing data in server B from Server A. Please, share the details of the table. I'd worked for over 8 years on php and mysql. Check my portfolio here: https://www.freelancer.com/u/fattahaabdul I'd be very happy to discuss and move ahead. Thanks, -Xipe Tech India
$25 USD në 40 ditë
5,0 (153 përshtypje)
8,1
8,1
Avatari i Përdoruesit
Hello Here is a senior full-stack developer and I have rich experience in MySQL, PostgreSQL, NoSQL, etc. After checking your project detail carefully and I am sure for your project we need to high query skill. So I can do your project in a short time and I can start work immediately. I hope we can discuss your project in more detail via chat. Looking forward to hearing from you. Best Regards
$20 USD në 40 ditë
4,9 (28 përshtypje)
5,9
5,9
Avatari i Përdoruesit
Dear Employer, I think you require db replication. if yes i can do and experienced in DB replication. Please ping once for further clarification. Thanks
$15 USD në 40 ditë
4,5 (33 përshtypje)
5,0
5,0
Avatari i Përdoruesit
I have experience in MySQL replication setup and shell scripting 8 years of experience in Linux server management and cloud systems which includes Installation, Monitoring, and Optimization. I can handle the installation of applications on Linux. I do web hosting support, Website migration, and Automation on server platform.
$15 USD në 40 ditë
5,0 (20 përshtypje)
4,0
4,0
Avatari i Përdoruesit
Hello, I have rich experience with Linux and Mysql. I read job description and I can do your project. I can even work on urgent basis and complete your project soon contact me for more information Thank you.
$15 USD në 40 ditë
4,6 (12 përshtypje)
4,1
4,1
Avatari i Përdoruesit
I HAVE DONE A SIMILAR JOB. Hello, I am an expert in database management and administration. I specialize in MYSQL, ORACLE and Postgress. I can work on your work ASAP. Come over the chat we discuss more. Thank you
$20 USD në 40 ditë
5,0 (19 përshtypje)
3,8
3,8
Avatari i Përdoruesit
Hi. Thanks for your job posting. Here's talent DB Manager with full experience of developing and maintaining many websites Database. MySQL is one of my expertise, and auto scripting daily, weekly and hourly is not problem for me. Please discuss more via chat. Regards.
$20 USD në 40 ditë
5,0 (6 përshtypje)
3,4
3,4
Avatari i Përdoruesit
I have got plenty of experience in this sort of work i.e DBA shell scripting expert required; Make a mysql script replication autostart. kinds of works and I am totally capable to execute the above-mentioned tasks i.e Hello there, We need to have mysql recuriment from our server A to server B I am professional Database Administration, SQL, PHP, MySQL and Linux software engineer and I am available from now for this Looking for a positive response Thanks
$20 USD në 35 ditë
5,0 (2 përshtypje)
3,0
3,0
Avatari i Përdoruesit
Nice to meet you I am an Amazon Cloud Architect for the web infrastructure serving 90 million page impressions and 12 TB Internet traffic per month. The AWS services I use are EC2, ELB, MySQL RDS, VPC, CloudFront, ElastiCache, CloudWatch, CloudFormation, OpsWorks, ElasticBeanstalk, CodeDeploy, S3, SES, SQS and SNS. I have 20 years of Linux SysAdmin experience. I currently use Apache, Nginx, Ldirectord, MySQL, Perl, PHP, Memcached, Sphinx, Bind, Typo3, WordPress, Send-mail, Postfix, NFS, Samba, Snort, Vsftpd, aide, Nagios, Cacti, Puppet and a bunch of other traditional Linux software. I am good at database-administration,linux,mysql,php,sql If you’re looking for a developer that’s truly an expert, driven by passion, not afraid to take on a challenge, and will be there with you every step of the way then look no further as I’m your guy.
$21 USD në 40 ditë
4,3 (2 përshtypje)
2,5
2,5
Avatari i Përdoruesit
Hi there, I have good experience with implementing MySQL replication. There are a few ways to implement the replication. I can do this. I worked as a Database administrator in company before and managed several MySQL and Oracle Database. Then I built the replication in MySQL and Oracle to backup the data real-time. Please provide me your environments. I can start right now. I look forward to discussing job with you. Best Regards, Nazar Miroshnichenko
$25 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
making the MySQL server A send changes on the real time to MySQL server B AND make the the server B send changes on real time to server A if it is the active server at that time. of course one of the servers must be idle at a time . I can do that if you have MySQL server on both sides . if you need to switch between hosts that depends many factors and i am not sure how this is done but i will find out .
$20 USD në 40 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i PHILIPPINES
BULAN, Philippines
5,0
12
Mënyra e pagesës u verifikua
Anëtar që nga gush 9, 2019

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.