Find Jobs
Hire Freelancers

Restore 12 MB databases and optimize linux SQL server

$30-120 USD

Avslutat
Publicerad över två år sedan

$30-120 USD

Betalning vid leverans
Hello, The hard disc of my SQL linux/centos server has failed. The hosting company installed centos again with new hard disc. Here is what I need from you: 1) Optimize the server to run as a SQL ONLY database server to save resource so it should not handle any http request etc. 2) Create users for each of the three databases and upload the 3 databases I will send you of 3 MB, 12 MB and 18 MB. 3) Make those databases accessible to the IP address of the HTTP server only (I will send you the IP address) 4) Create a CRON to backup those 3 databases every 24 hours in compressed format ([login to view URL]) so I can connect through FTP and download them. Server specifications for your information: CPU: Intel Xeon Quad-Core E3-1220 3.1GHz: Included Operating System CentOS 6 64-bit: Included 8GB DDR3 RAM 120GB SSD 100Mbps: Included I need you to set up the SQL server to handle hundreds of queries per second, centos already installed. Make sure firewall does not ban IPs easily, 99% of ips hitting this server are proxies/bots. I don't need a beginner for this project because SQL server settings must be set up properly. The HTTP server sends hundreds of requests per second. I don't want the SQL server to overload or to show error messages. i.e. too many connections. I understand that you need some time to tweak the settings and that some errors may show until then :) You must be available to start and finish right away as this is an urgent project. Make sure you remain online until database server fully working. Thanks! Note: A nice review will be left if all works fine when you have finished :)
Project ID: 32148753

Om projektet

10 anbud
Distansprojekt
Senaste aktivitet två å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
10 frilansar lägger i genomsnitt anbud på $94 USD för detta uppdrag
Använd avatar
Hello. I would like to help you with creating 3 databases. I have experience. Please read my feedbacks. Thank you.
$30 USD Om 1 dag
4,9 (1143 omdömen)
7,7
7,7
Använd avatar
Dear Client, I can help you in Restore databases and optimize linux SQL server. I am an CentOS expert and you are talking about MZ architecture where application/web server is facing public and DB is behind that server. Ping me to start a chat. I am an algorithm expert.
$100 USD Om 3 dagar
5,0 (7 omdömen)
4,2
4,2
Använd avatar
Hello sir how are you doing? I have read the project detail and really interested in your project, I am full stack developer with multiple frameworks, I have great experience doing similar jobs regarding to these skills Linux, System Admin, MySQL and Database Administration. Please start the chat, also I have some questions so we can have detailed discussion about project and finalize the timeline. Thanks Regards Umair
$120 USD Om 10 dagar
4,9 (6 omdömen)
4,0
4,0
Använd avatar
Hi, I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker
$100 USD Om 3 dagar
5,0 (11 omdömen)
3,8
3,8
Använd avatar
Hi, I am interested in your project. I can easily install/configure/optims MySQL DB server and make connection with other webserver. I am a experienced System Admin have 10 year plus Exp. • Solid experience with Linux • Linux administration like user creation, lvm, RAID level config file permission, ssh, scp, Samba server, DHCP Server, DNS Bind Server, Web server, FTP server and OS patching, fine tuning etc • Linux + Mac package installation, i.e, OpenOffice, Libreoffice, virtual box, VMWare Workstation, zoom, vlc, team, anydesk, teamviewer • Ability to work effectively within a team and with minimal supervision • Experience with AWS- including but not limited to EC2, S3, RDS, IAM and Router53 • Proficient with Git and Git Workflow • Experience With Docker Container orchestration systems Such as AWS EC2 • Experience with server-side Technologies such as Apache, Nginx, HAProxy, Redis, PGPool, Pgbouncer • Databases (MySQL, Postgres, MariaDB) administer experience • Database Clustering, DB replication , Database Backup and Restoring • Understanding of SAN/NAS storage technologies and protocols – (iSCSI, FC, FCoE, NFS, CIFS etc.) I have two Master Degrees, MS Information Security, MSc Electronics, and a 3 Year Diploma of Associate Engineering in Computer Tech. ➔ VCP DCV ➔ VCP DTM ➔ VCP NSX ➔ CompTIA Linux +. ➔ SUSE Certified Linux Admin. ➔ LPIC-1. ➔ CCNA R & S. ➔ CEH ➔ SDN ➔ Sangfor Certified Technical Prof – HCI
$100 USD Om 3 dagar
5,0 (8 omdömen)
3,4
3,4
Använd avatar
Hello, I am a well experienced database administrartor with skills in MySQL, PostgreSQL and MS SQL Server. I can install, configure and tune the server so that it can operate at full performance. Ready to get started now.
$120 USD Om 7 dagar
4,6 (5 omdömen)
3,5
3,5
Använd avatar
Expertise in databases / ETL for 10+ years in Oracle, SQL Server/T-SQL, Sybase, MySQL (MariaDB) Looking forward to hear more from you! Kind Regards
$100 USD Om 5 dagar
5,0 (1 omdöme)
2,5
2,5

Om kunden

Flagga för MALAYSIA
KUALA LUMPUR, Malaysia
5,0
132
Verifierad betalningsmetod
Medlem sedan feb. 7, 2010

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.