Hadoop and MySQL Integration -
we implement hadoop on our system improve performance.
the process works this: hadoop gather data mysql database process it. output exported mysql database.
is implementation? improve our system's overall performance? requirements , has been done before? tutorial help.
thanks
altough not regular hadoop usage. migh make sense in following scenario:
a) if have way partition data inputs (like existing partitioning).
b) processing of each partition relatively heavy. give number of @ least 10 seconds of cpu time per partition.
if both conditions met - able apply desired amount of cpu power make data processing.
if doing simple scan or aggregation - think not gain anything. on other hand - if going run cpu intensive algorithms on each partition - indeed gain can significant.
mention separate case- if processing require massive data sorting. not think mysql in sorting billions of records. hadoop it.
Comments
Post a Comment