Thanks, it's really a nice article. Would like to ask question here ,
"application layer holds database connections while waiting for results. So connection starvation is likely to happen if the queries get expensive." so here how proxysql helps here ? as far as I know proxysql also maintain connection pool of db connection, so in case no application uses these then it also db connection present in proxy sql connection pool also become idle, so not able to understand how proxy sql help here, could you please help to understand it ?
Hey loved the simple explanation for each techniques, but is there a table comparison of which one to use under which circumstances. For example some common parameters around cost, effort, impact ?
Great lessons on scalability @systemdesignone
Now every time I read "thundering herd" I'll think of a flash sale and people running.
Good article, Neo!
Thanks, it's really a nice article. Would like to ask question here ,
"application layer holds database connections while waiting for results. So connection starvation is likely to happen if the queries get expensive." so here how proxysql helps here ? as far as I know proxysql also maintain connection pool of db connection, so in case no application uses these then it also db connection present in proxy sql connection pool also become idle, so not able to understand how proxy sql help here, could you please help to understand it ?
Hey loved the simple explanation for each techniques, but is there a table comparison of which one to use under which circumstances. For example some common parameters around cost, effort, impact ?