Find Jobs
Hire Freelancers

Restore 12 MB databases and optimize linux SQL server

$30-120 USD

Closed
Posted over 2 years ago

$30-120 USD

Paid on delivery
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

About the project

10 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $94 USD for this job
User Avatar
Hello. I would like to help you with creating 3 databases. I have experience. Please read my feedbacks. Thank you.
$30 USD in 1 day
4.9 (1143 reviews)
7.7
7.7
User 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 in 3 days
5.0 (7 reviews)
4.2
4.2
User 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 in 10 days
4.9 (6 reviews)
4.0
4.0
User 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 in 3 days
5.0 (11 reviews)
3.8
3.8
User 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 in 3 days
5.0 (8 reviews)
3.4
3.4
User 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 in 7 days
4.6 (5 reviews)
3.5
3.5
User 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 in 5 days
5.0 (1 review)
2.5
2.5

About the client

Flag of MALAYSIA
KUALA LUMPUR, Malaysia
5.0
132
Payment method verified
Member since Feb 7, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.