vk26 / social-network Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

homework project for course Highload Architect (OTUS)

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 62 Commits
db		db
devops/development		devops/development
frontend		frontend
load_testing		load_testing
models		models
reports		reports
.gitignore		.gitignore
Procfile		Procfile
go.mod		go.mod
go.sum		go.sum
heroku.yml		heroku.yml
main.go		main.go
readme.md		readme.md

Repository files navigation

About

This project is homework project of course - Highload Architect by OTUS

https://warm-chamber-70708.herokuapp.com/

HW1 Social-Network MVP

Write MVP of social network with user's pages. Don't use ORM, indexes, patterns of Highload/High availability

HW2 Using indexes

Write searching users with sql LIKE % condition. Select an efficient index, inspect via EXPALIN. Do load testing before and after using indexes.

Report

HW3 Setup master/slave replication

Setup replication master/slave. Redirect some requests to slave-node. Do load testing before and after separation requests by master/slave.

Report

HW4 Promote slave to master

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.

Report