database:aurora

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- database:aurora [2023/06/16 09:08]
kwon37xi [Replica(reader instance) history length 줄이기]
+++ database:aurora [2024/04/03 10:54] (현재)
kwon37xi [aws-advanced-jdbc-wrapper - Read/Write Cluster]
@@ 줄 4: / 줄 4: @@
 ===== JDBC =====
   * [[https://github.com/awslabs/aws-mysql-jdbc|aws-mysql-jdbc]] : AWS 에서 직접 만들고 있는 JDBC 드라이버.
-    * [[https://awslabs.github.io/aws-mysql-jdbc/|Amazon Web Services (AWS) JDBC Driver for MySQL]]  (Public Preview)
+    * [[https://awslabs.github.io/aws-mysql-jdbc/|Amazon Web Services (AWS) JDBC Driver for MySQL]]
   * [[https://github.com/awslabs/aws-postgresql-jdbc|awslabs/aws-postgresql-jdbc]]
   * [[https://docs.aws.amazon.com/ko_kr/AmazonRDS/latest/AuroraUserGuide/Aurora.Connecting.html#Aurora.Connecting.AuroraMySQL|Amazon Aurora DB 클러스터에 연결 - Amazon Aurora]]
   * [[https://hoing.io/archives/1285|AWS JDBC Driver for Amazon Aurora MySQL | Hoing]]
   * [[database:aurora:aurora_mariadb|Aurora MariaDB]]
+==== aws-advanced-jdbc-wrapper - Read/Write Cluster ====
+  * https://github.com/awslabs/aws-advanced-jdbc-wrapper : 다른 JDBC 드라이버를 감싸서 Aurora Cluster read/write split 지원.
+  * [[https://github.com/awslabs/aws-advanced-jdbc-wrapper/blob/main/docs/Documentation.md|aws-advanced-jdbc-wrapper 문서]]
+  * [[https://github.com/awslabs/aws-advanced-jdbc-wrapper/blob/main/docs/using-the-jdbc-driver/using-plugins/UsingTheReadWriteSplittingPlugin.md#limitations-when-using-spring-bootframework|Limitations when using Spring Boot/Framework]]
+    * ''@Transactional(readOnly = true)'' 를 사용하고자 한다면 별도의 커넥션풀을 사용하면 안 되고 wrapper 의 내장 connection pool 만 사용해야한다. 관련해서 문서 잘 읽어봐야함.
+<note warning>
+The use of read/write splitting with the annotation @Transactional(readOnly = True) is only recommended for configurations using an internal connection pool. Using the annotation with any other configurations will cause a significant performance degradation.
+</note>
 ===== 서버 설정 =====
@@ 줄 54: / 줄 61: @@
   * [[https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.MySQL80.html#AuroraMySQL.mysql80-bugs-fixed|Aurora MySQL version 3 compatible with MySQL 8.0 - Amazon Aurora]]
+===== 비용 절감 =====
+  * [[https://aws.amazon.com/ko/blogs/tech/costsaving-sktelecom-awsgraviton-auroraiooptimized/|SK텔레콤의 AWS Graviton과 Aurora I/O-Optimized를 이용한 Amazon Aurora 비용 절감 사례 | AWS 기술 블로그]]
 ===== 참고 =====

database/aurora.1686874105.txt.gz · 마지막으로 수정됨: 2023/06/16 09:08 저자 kwon37xi