--- On Wed, 22/7/09, Kelvin Quee <[email protected]> wrote:
> I need advise on this.
>
> I have a db which is being constantly updated and queried
> by a few
> computers. We are doing datamining. The machine is running
> on a
> moderately powered machine and processors constantly hit
> 90%.
>
> At the same time, we need to present these data on a web
> interface.
> The performance for the web interface is now very sluggish
> as most of
> the power is occupied by the mining process.
>
> I have thought of a few ways out of this -
>
> 1) Buy a mega powered machine (temporal solution, quick
> fix)
> 2) Do a master-slave configuration
> 3) Separate the DB into 2 - One for pure mining purposes,
> the other
> purely for web serving
>
> For (2), I do not know if it will be very effective since
> the master
> will probably have many changes at any moment. I do not
> understand how
> the changes will be propagated from the master to the slave
> and how it
> will impact the slave's performance. Anyone with more
> experience here?
i would plump for (2) if i have the choice. Have 2 different boxes, do an
active-passive pairing. The online transactions will be performed against the
active. Data replicated asynchronously over to the passive. Data mining queries
done against the passive.
And you get HA with it as well!
Regards,
Edwin
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/sg/
_______________________________________________
Slugnet mailing list
[email protected]
http://wiki.lugs.org.sg/LugsMailingListFaq
http://www.lugs.org.sg/mailman/listinfo/slugnet
