stratum-mining-litecoin
stratum-mining-litecoin copied to clipboard
moopless
Improve Database Performances
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...
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 [email protected] 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.
Ok thank you, I will disable the live dashboard and see what's happening. After I will try load-balancing for read requests.