This project is homework project of course - Highload Architect by OTUS
https://warm-chamber-70708.herokuapp.com/
Write MVP of social network with user's pages. Don't use ORM, indexes, patterns of Highload/High availability
Write searching users with sql LIKE % condition. Select an efficient index, inspect via EXPALIN. Do load testing before and after using indexes.
Setup replication master/slave. Redirect some requests to slave-node. Do load testing before and after separation requests by master/slave.
Add new slave2. Setup ROW-based replication. Turn on GTID. Config semi-sync replication. Start DB seed application with counting success insertions. Kill master. Promote slave1 to master. Switch replication slave2 from slave1(new master). Check that we didn't lose transactions.