Django - balancing MySQL master-slave?

Question

SQL Server

Previously, django-replicated was used for this purpose, but this project has not been supported for a long time.
How do you live with it? Do you use any other libraries or custom solutions everywhere? Or maybe balancing is not at the application level like mysql-proxy?

Answer 1

The request should return me multiple counts depending on the ActionTypeId

And will return:

SELECT 
(SELECT COUNT(ActionTypeId) FROM MatchupLog WHERE (ActionTypeId = 3)) AS FGmade,
(SELECT COUNT(ActionTypeId) FROM MatchupLog WHERE (ActionTypeId = 4)) AS FGMissed

Answer 2

subqueries should be named
and it's better to use the style:
[name] = (select ...)