Find Jobs
Hire Freelancers

Restore 12 MB databases and optimize linux SQL server

$30-120 USD

Geschlossen
Veröffentlicht vor mehr als 2 Jahren

$30-120 USD

Bezahlt bei Lieferung
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 :)
Projekt-ID: 32148753

Über das Projekt

10 Vorschläge
Remote Projekt
Aktiv vor 2 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
10 Freelancer bieten im Durchschnitt $94 USD für diesen Auftrag
Avatar des Nutzers
Hello. I would like to help you with creating 3 databases. I have experience. Please read my feedbacks. Thank you.
$30 USD in 1 Tag
4,9 (1143 Bewertungen)
7,7
7,7
Avatar des Nutzers
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 Tagen
5,0 (7 Bewertungen)
4,2
4,2
Avatar des Nutzers
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 Tagen
4,9 (6 Bewertungen)
4,0
4,0
Avatar des Nutzers
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 Tagen
5,0 (11 Bewertungen)
3,8
3,8
Avatar des Nutzers
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 Tagen
5,0 (8 Bewertungen)
3,4
3,4
Avatar des Nutzers
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 Tagen
4,6 (5 Bewertungen)
3,5
3,5
Avatar des Nutzers
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 Tagen
5,0 (1 Bewertung)
2,5
2,5

Über den Kunden

Flagge von MALAYSIA
KUALA LUMPUR, Malaysia
5,0
132
Zahlungsmethode verifiziert
Mitglied seit Feb. 7, 2010

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.