Best practices with Amazon Aurora MySQL
This topic includes information on best practices and options for using or migrating data to an Amazon Aurora MySQL DB cluster. The information in this topic summarizes and reiterates some of the guidelines and procedures that you can find in Managing an Amazon Aurora DB cluster.
Contents
Determining which DB instance you are connected to
To determine which DB instance in an Aurora MySQL DB cluster a connection is
connected to, check the innodb_read_only
global variable, as shown in
the following example.
SHOW GLOBAL VARIABLES LIKE 'innodb_read_only';
The innodb_read_only
variable is set to ON
if you are
connected to a reader DB instance. This setting is OFF
if you are connected to a writer DB
instance, such as primary instance in a provisioned cluster.
This approach can be helpful if you want to add logic to your application code to balance the workload or to ensure that a write operation is using the correct connection.