Find Jobs
Hire Freelancers

Restore 12 MB databases and optimize linux SQL server

$30-120 USD

Imefungwa
Imechapishwa over 2 years ago

$30-120 USD

Kulipwa wakati wa kufikishwa
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 :)
Kitambulisho cha mradi: 32148753

Kuhusu mradi

10 mapendekezo
Mradi wa mbali
Inatumika 2 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
10 wafanyakazi huru wana zabuni kwa wastani $94 USD kwa kazi hii
Picha ya Mtumiaji
Hello. I would like to help you with creating 3 databases. I have experience. Please read my feedbacks. Thank you.
$30 USD ndani ya siku 1
4.9 (1143 hakiki)
7.7
7.7
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (7 hakiki)
4.2
4.2
Picha ya Mtumiaji
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 ndani ya siku 10
4.9 (6 hakiki)
4.0
4.0
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (11 hakiki)
3.8
3.8
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (8 hakiki)
3.4
3.4
Picha ya Mtumiaji
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 ndani ya siku 7
4.6 (5 hakiki)
3.5
3.5
Picha ya Mtumiaji
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 ndani ya siku 5
5.0 (1 hakiki)
2.5
2.5

Kuhusu mteja

Bedera ya MALAYSIA
KUALA LUMPUR, Malaysia
5.0
132
Njia ya malipo imethibitishwa
Mwanachama tangu Feb 7, 2010

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.