Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to change character_set_server in Amazon's Aurora DB?

Currently using Amazon's Aurora DB and in our Jira we are seeing some names with question marks (???) due to their characters.

After further looking into this it seems that I need to change the character_set_server from latin1 to utf8.

In Aurora DB I looked in the parameter groups and cluster group settings but I don't see character_set_server, or anything similar.

Thank you.

like image 853
Wolverine313 Avatar asked Jun 08 '16 16:06

Wolverine313


People also ask

Is Amazon Aurora Auto Scaling?

Based on the policy, Aurora Auto Scaling adjusts the number of Aurora Replicas up or down in response to actual workloads, determined by using Amazon CloudWatch metrics and target values. You can use the AWS Management Console to apply a scaling policy based on a predefined metric.

Is Amazon Aurora region specific?

Aurora doesn't support Local Zones.

Is AWS Aurora multi region?

An Amazon Aurora Global Database is a single database that spans multiple AWS regions, enabling low latency global reads and disaster recovery from region-wide outages.

Is Amazon Aurora cheaper than RDS?

Aurora is generally more expensive than RDS for the same workloads. It is priced based on the type and size of the instance and EBS volume. Aurora pricing is mainly based on instance size and storage is billed according to actual usage.


1 Answers

As Mark B said, you can easily change it on "Parameter groups" page,

enter image description here

Open your cluster group settings for edit and enter "character_set_ser" in the filter and you should see it.

enter image description here

For more information read the following page: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html

https://aws.amazon.com/premiumsupport/knowledge-center/rds-modify-parameter-group-values/

like image 181
Reza Mousavi Avatar answered Sep 18 '22 17:09

Reza Mousavi