search

moopless / stratum-mining-litecoin

This fork is no longer maintained. Please use https://github.com/ahmedbodi/stratum-mining
Other
38 stars 35 forks source link

Improve Database Performances #76

Open nodapio opened 10 years ago

nodapio commented 10 years ago

I'm running a pool with hundreds of miners and MySQL is cunsuming a lot of CPU. I would like to know if there's a built-in feature in stratum that allows me to load-balance the queries on multiple servers. Also, is the latency between stratum and the mysql server important ? Because I have a good server at home that would handle the requests pretty well but he's at 150ms from the stratum server...

TheSerapher commented 10 years ago

You don't load balance writes, you balance reads.

You should analyze your SQL - if you run MPOS it is most likely the live dashboard that is used.

Latency is always an issue for pools.

Cheers, Sebastian

On 11.12.2013, at 12:13, nodapio notifications@github.com wrote:

I'm running a pool with hundreds of miners and MySQL is cunsuming a lot of CPU. I would like to know if there's a built-in feature in stratum that allows me to load-balance the queries on multiple servers. Also, is the latency between stratum and the mysql server important ? Because I have a good server at home that would handle the requests pretty well but he's at 150ms from the stratum server...

— Reply to this email directly or view it on GitHub.

nodapio commented 10 years ago

Ok thank you, I will disable the live dashboard and see what's happening. After I will try load-balancing for read requests.