Questions tagged with Database
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
We had a rather bizarre outage on the evening of March 9, 2024 (around 7pm mountain). The RDS clusters in two regions (us-east-1, us-west-1) on two different AWS accounts stopped responding. One of...
3
answers
0
votes
432
views
asked 3 months agolg...
Current MySQL Engine: 5.7.44
Using the master user with the following query "ALTER TABLE `sys_config` ROW_FORMAT=DYNAMIC;" we're getting the following error: Access denied for user 'master'@'%' to...
1
answers
1
votes
136
views
asked 3 months agolg...
Hi,
I am trying to establish a connection from the EKS cluster to an RDS MYSQL instance.
For business needs, the cluster is located in one account and the database in another account. The database...
2
answers
1
votes
244
views
asked 3 months agolg...
I want to create a database with this 2 CPU Cores / 2GB RAM / 60GB SSD configuration but in Lightsail there is an 80GB SSD can we reduce this is it possible? if possible then how?
if not is there any...
2
answers
0
votes
144
views
asked 3 months agolg...
Hi ,
We have deployed the RDS SQL Server with time zone UTC +1:00 using terraform but when we ran the time zone of SQL Server using T-SQL ( SELECT SYSDATETIMEOFFSET()) then we can use UTC 0:00 , why...
0
answers
0
votes
3240
views
asked 3 months agolg...
I moved a client from a shared Dreamhost VPS to a Lightsails VPS with 4GB memory because they were experiencing site timeouts due to maxing out resources. I used Duplicator Pro to move as the site is...
1
answers
0
votes
190
views
asked 3 months agolg...
Hello team,
So, I built an ETL in python using pyspark. I have a bastion EC2 mysql database that is a copy of a production environment.
Every day it is copying the prod at round 2 oclock, and my...
1
answers
0
votes
234
views
asked 3 months agolg...
Good day,
I am setting up zero etl to redshift serverless for rds mysql & rds postgresql,
i want to use the ZeroEtl functionality for RDS MS-SQL & S3
Please tell me it's not far off from being...
2
answers
0
votes
658
views
asked 3 months agolg...
RDS Failover Testinglg...
Hi
I need to plan, design and test failover for some RDS oracle production servers running in multi-az environment.
Is there any documents or videos that discuss details for doing that?
Would you...
2
answers
0
votes
774
views
asked 3 months agolg...
Hi!
I run migrations (add columns, add tables, change restrictions) using prisma migrations in my CI/CD flow.
I used to run using a superUser and everything were working well.
Due to security reasons...
0
answers
9
votes
107
views
asked 3 months agolg...
Good day,
1. We setting up Redshiift serverless, due to not having impact on production RDS sources we looking at zeroetl or fdw with CDC, does zeroetl replication incur cost on serverless as a...
3
answers
0
votes
417
views
asked 3 months agolg...
After renaming of my MSSQL database instance I can't see it in the Management Console
I don't know if the renaming is the reason or not, but now I can't manage my database.
But I can still connect to...
3
answers
0
votes
151
views
asked 3 months agolg...