[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-08-18。"],[],[],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:"]]
