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.
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
3144
views
asked 2 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
176
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
208
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
650
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
744
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
104
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
407
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
143
views
asked 3 months agolg...
I have created partitions in my MySQL Aurora database and subsequently dropped old partitions. However, despite removing approximately 75% of the data, the table size remains unchanged at 3TB. Can...
1
answers
0
votes
164
views
asked 3 months agolg...
I have a Postgres RDS instance that is producing very strange behavior regarding system snapshots. Basically, when I manually create a snapshot and then restore it I am always able to connect to it...
1
answers
0
votes
168
views
asked 3 months agolg...
Hi AWS, I want to migrate data from existing SQL database to new Cassandra (NoSQL) database which we will be using for Enterprise HES application. Which is the best AWS service or in case I need to...
2
answers
0
votes
172
views
asked 3 months agolg...
We have 3 RDS MariaDB Databases (one 10.5.xx and two 10.4.xx respectively). Last Monday the databases were supposed to be updated automatically during the maintenance windows. The update did happen,...
0
answers
0
votes
98
views
asked 3 months agolg...