1

I am having MySQL 5.6 database with PST time format in on-premises server. Now we are willing to migrate the database to RDS.

For this, we have taken backup from physical server and restored in RDS and setup replication to sync the data.

But found the time is getting changed to UTC. We found the time format in RDS is UTC, so we changed the time format of time_zone to PST in parameter group. But we are not able to change the default time_zone parameter.

Due to this, the time which is coming from master server is getting updated to UTC and storing in database which is 8hrs more than actual time.

Due to constraints, we are not able to use AWS DMS for replicating data. How can we change the default time_zone or fix the time zone issue in RDS.

0

I was using MySQL replication with Mixed mode replication which captures the data with timestamp and timezone.

Later, I changed the MySQL replication to Row based replication which captures the data with time. So what ever the time format it is, it just send the insert/update statements with time, which solved my problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.