Database

database.md

[Database] Replication vs Clustering

https://mangkyu.tistory.com/97

---

MyBatis Example

https://www.tutorialspoint.com/mybatis/mybatis_read_operation.htm https://www.tutorialspoint.com/mybatis/mybatis_update_operation.htm

Spring JDBC Template Example

https://www.tutorialspoint.com/springjdbc/springjdbc_read_query.htm https://www.tutorialspoint.com/springjdbc/springjdbc_update_query.htm

---

@Transactional

https://bluayer.com/54

---

MySQL SELECT FOR UPDATE

https://jinhokwon.github.io/mysql/mysql-select-for-update/

---

Replication JDBC URL Template

jdbc:mariadb:replication://db1:1307,db2:1307/blue?useUnicode=true&autoReconnect=true&serverTimezone=UTC&sessionVariables=character_set_client=utf8mb4,character_set_connection=utf8mb4,character_set_results=utf8mb4,collation_connection=utf8mb4_general_ci

---

Clustering vs Partition (NoSQL, Cassandra)

https://www.baeldung.com/cassandra-keys

PrimaryKeyType.CLUSTERED

Used for a column that is clustered key.

PrimaryKeyType.PARTITIONED

Used for a column that is part of the partition key.