Ditutup

Import 10 million records 2GB .csv (5 parts) every hour to MySQL

Import .csv files from here to MySQL database:

[url removed, login to view]

Must be fast, easy to run, cheap, complete the process in under 5mins. It updates the CSVs' every hour and makes note of the data that changes.

What kind of server/mysql setup is needed on AWS? Let me know your estimations so I can judge how suitable you are for the job.

Keahlian Data Besar, Excel, MySQL, PHP, Perancangan Perangkat Lunak

Lihat lebih lanjut: desktop software sort csv file million records, mysql csv import escape, import mysql csv perl, linux shell script mysql csv import, software write mq4, software write chip epson, useful software write book, import text mysql csv, unable add records mysql csv, software write web specs, perl mysql csv import, import csv access update records vbnet, mysql csv export import, vbnet import csv access existing records, free software write user guide, software write edid, free software write company profile, mysql csv import joomla, software write websites idea, mysql million records, mysql csv records, software write book images, software write books, mysql csv import perl, software write protection

Tentang Pemberi kerja:
( 31 ulasan ) London, United Kingdom

ID Proyek: #11724502

26 freelancer menawar pada rata-rata $164 untuk pekerjaan ini

richestuser

I am talented PHP , mySQL ,javescript ,AJAX, WORDpress developer. I have very reasonable rate .I do WORDPRESS PHP , MySQL programming more than 5 years and within this period I had been working as slave [url removed, login to view], I Lagi

$250 USD dalam 3 hari
(166 Ulasan)
6.9
wee493

A [url removed, login to view] should would for basic importing and everything . Would need to discuss how you'd be querying the data to get a more accurate guess on what EC2 server would be needed or if you'd need dedicated MySQL. I can Lagi

$250 USD dalam 3 hari
(123 Ulasan)
6.4
aaravsoft

Hello, I will provide you desktop application for window where it will download csv file from companieshouse website and update the changes on your mysql database which few minute. You set interval time manually ( Lagi

$150 USD dalam 2 hari
(55 Ulasan)
5.8
oda79

Hello! I am ready to help you with your task! Do you need an unattended script to do this import job? Please do not hesitate to contact me via messenger!

$250 USD dalam 20 hari
(18 Ulasan)
5.7
ausprofreelancer

Hello, I have extensive experience with MySQL and importing large datasets on set interval basis. From your information in the project, you mentioned that when the csv's are updated, there are notes of the data tha Lagi

$250 USD dalam 5 hari
(9 Ulasan)
5.2
stoyanovalexandr

Hello, I am a skilled unix and network engineer with 5 years of experience in unix based systems, virtualization like proxmox,esxi,xen,virsh, iptv,zimbra etc. I like to automate system working with additional shell scr Lagi

$111 USD dalam 1 hari
(58 Ulasan)
5.3
testotorko

Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details. I am an experienced Web Developer and Web Designer, and have worked with wide variety of s Lagi

$150 USD dalam 11 hari
(40 Ulasan)
5.0
$155 USD dalam 3 hari
(35 Ulasan)
5.0
kaippally

there could be easier ways to do this.

$111 USD dalam 5 hari
(1 Ulasan)
4.0
djcarras

hi, i can help you with your project. According to the site, notifies the date of the last update, so I do not see that you need to run a process every hour, but I can do. send me more information about via freelancer Lagi

$333 USD dalam 5 hari
(13 Ulasan)
3.7
infoRidge

Recent work [url removed, login to view] (A local service Website) Greetings from InfoRidge Technology!! Dear Employer, Maybe our cover letter is not much powerful as like others but our skills and expertise are overwhelming to o Lagi

$54 USD dalam 19 hari
(14 Ulasan)
3.9
$155 USD dalam 10 hari
(6 Ulasan)
3.5
shiva1888

Hi I have been in this industry for 5 years and such jobs are my daily practice.I can assure you that if you work with me once, you will always work with me for these kind of projects.

$250 USD dalam 3 hari
(5 Ulasan)
3.5
stescovich

Hello, Thanks for reading my propusal. First of all let me tell you that loading such amount of data won't be fast. Since you need to do it in steps to prevent problems in DB. Secondly I would suggest you to r Lagi

$100 USD dalam 20 hari
(3 Ulasan)
3.2
imran5757

Hi There, We can setup aws RDS instance which is highly available and the best performance database for mysql. Initially we would setup micro instance db if the queries are taking time to process then we can upgrade i Lagi

$60 USD dalam 2 hari
(5 Ulasan)
2.1
arator

I can build this script using Python. I need only credentials of your database (IP, username, password, DB name) and may be an access to your AWS. Because I am not a client of AWS, I can suggest two possible cases of u Lagi

$155 USD dalam 3 hari
(1 Ulasan)
1.4
vw1313054vw

I will deliver a satisfactory job that will impress you. I crave for a chance to prove to you my worth and abilities.

$100 USD dalam 2 hari
(0 Ulasan)
0.0
gototakuya

I am an expert of full-stack web development and have similar experience with your requirement. although I am new to here freelancer and earn achievements for future so i will bid reasonable price. My planning is b Lagi

$35 USD dalam 3 hari
(0 Ulasan)
0.0
davideschirinzi

I would recommend to use: an rds with mysql or aurora as database with 20.000 provisioned IOps ebs volume (r3 instance family or I family depending on the needs of computing power of the queries). To import the file ca Lagi

$250 USD dalam 3 hari
(0 Ulasan)
0.0
mephri

Hello. Assuming data integrity is good (fields consistency and no junks) this could be done fast. Standard MySQL setup is sufficient (we are not talking about data access and processing here, right?) as long as the AWS Lagi

$155 USD dalam 3 hari
(0 Ulasan)
0.0