Hi everybody,
I am developing a web platform using Yii2-mySql and need your technical advice.
The platform will be used by psychologists and their clients.
The number of psychologists could be between 1 and 10.000 (at the beginning, I would expect - in my wildest dreams - around 500).
Psychologists will interact with the platform for manipulating clients data (eg., load new clients, update clients info, set up administering sessions, download reports and so forth).
Each psychologist could have between 1 and 1.000 clients. Clients will have few interactions with the platform: the administration of the personality test will be done via a backbone app which calls the server twice: at the beginning (getting data) and at the end (putting data) of the administration process.
-
First question: Given the above figures, should I care about data replication for scaling out?
-
Second question: iIf I indeed need data replication, should I be worried about slaves lags (I read somewhere that mysql performs asynchronous replications and that slaves may be not updated instantly)?
Let me thank for your support.