lookerFailover=loadbalance, lookerFailover=replication, lookerFailover=aurora에서도 동일한 작업을 수행할 수 있습니다.
lookerFailover가 포함되지 않은 경우 기본 동작은 jdbc:mysql:aurora:hostname...입니다.
호스트 이름에 cluster-ro가 있는 경우 기본 동작은 jdbc:mysql:hostname...입니다.
PDT용 Amazon Aurora MySQL 구성
Aurora에서 영구 파생 테이블(PDT)을 사용하려면 읽기 전용인 Amazon Aurora의 기본 복제가 아닌 MySQL 복제를 사용해야 합니다. RDS 및 임시 테이블에 설명된 대로 MySQL 복제본을 쓰기를 가능하게 하려면 read_only 매개변수를 0으로 설정해야 합니다.
데이터베이스에 대한 쓰기 액세스 권한을 부여하지 않으려면 다음과 같이 파생된 테이블 SQL을 복사하여 view 파일의 sql_table_name 매개변수에 붙여넣을 수 있습니다. 이렇게 하면 쿼리 시간에 사용되는 하위 쿼리가 생성됩니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-08-18(UTC)"],[],[],null,["# Amazon Aurora MySQL\n\nTo connect Looker to [Amazon Aurora MySQL](https://aws.amazon.com/rds/aurora/), follow the instructions found on the documentation page for connecting to [Amazon RDS for MySQL](/looker/docs/db-config-mysql-on-amazon-rds).\n\nIn addition to the steps in the [Amazon RDS instructions](/looker/docs/db-config-mysql-on-amazon-rds), Amazon Aurora may need further setup, depending on your configuration. If you have a redirected read-only endpoint for Amazon Aurora, or if you want to use [persistent derived tables (PDTs)](/looker/docs/derived-tables#persistent_derived_table), see the following sections.\n\nEncrypting network traffic\n--------------------------\n\nIt is a best practice to encrypt network traffic between the Looker application and your database. Consider one of the options described on the [Enabling secure database access](/looker/docs/enabling-secure-db-access) documentation page.\n\n\nAlternate failover and load balancing modes\n-------------------------------------------\n\nAmazon Aurora MySQL can be configured to use [alternate failover and load balancing modes](https://mariadb.com/kb/en/about-mariadb-connector-j/#failover-and-load-balancing-modes) to choose the appropriate JDBC connection behavior you want. Check the linked documentation to see how these alternative parameters change the behavior.\n\nYou can set the `lookerFailover` parameter in the **Additional JDBC parameters** field to control these modes.\n\nThe options can be used to change the JDBC string as follows:\n\n- `lookerFailover=false`: `jdbc:mysql:hostname...`\n- `lookerFailover=sequential`: `jdbc:mysql:sequential:hostname...`\n - You can do the same with `lookerFailover=loadbalance`, `lookerFailover=replication`, and `lookerFailover=aurora`\n- If `lookerFailover` is not included, the default behavior is: `jdbc:mysql:aurora:hostname...`\n- If `cluster-ro` is in the hostname, the default behavior is: `jdbc:mysql:hostname...`\n\nConfiguring Amazon Aurora MySQL for PDTs\n----------------------------------------\n\nIn order to use [persistent derived tables (PDTs)](/looker/docs/derived-tables#persistent_derived_table) with Aurora, you must use MySQL replication, not Amazon Aurora's default replication, which is read-only. You must set the `read_only` parameter to `0` to make the MySQL replica writable, as described in our documentation on [RDS and temporary tables](/looker/docs/db-config-mysql-on-amazon-rds#rds_&_temporary_tables).\n\nIf you *don't* want to grant write access to the database, you can copy and paste the derived table SQL into the `sql_table_name` parameter of a `view` file as shown here. This creates a subquery that is used at query time: \n\n view: my_name {\n sql_table_name: (sql_of_derived_table_goes_here) ;;\n }\n\nFor more details on Aurora replication, see [the AWS documentation](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Aurora.Replication.html).\n\n\nCreating the Looker connection to your database\n-----------------------------------------------\n\nIn the **Admin** section of Looker, select **Connections** , and then click **Add Connection**.\n\nFill out the connection details. The majority of the settings are common to most database dialects. See the [Connecting Looker to your database](/looker/docs/connecting-to-your-db) documentation page for information.\n\nTo verify that the connection is successful, click **Test** . See the [Testing database connectivity](/looker/docs/testing-db-connectivity) documentation page for troubleshooting information.\n\nTo save these settings, click **Connect**.\n\nFeature support\n---------------\n\nFor Looker to support some features, your database dialect must also support them.\n\nAmazon Aurora MySQL supports the following features as of Looker 25.14:"]]
