Hey I am a fresher devOps Engineer. These days I am working on database's connectivity issues and scaling problems. One month before I migrated my RDS database to aurora cluster for scaling and high availability but unfortunately I found it with no benefits cuz I am not sure where in my application writer endpoint will be used and where reader. Nobody is sure about, the database should forward the traffic accordingly but I am unable to find the way. I found that on aurora only reader replicas can be used for load balancing, which is just waste of resources in my case. Even I used custom endpoint but it didnt worked, it says read access only in logs. Now I want to know if the problem I am facing can be solved on existing aurora or I should migrate back to RDS and use 3 instances or clone of it. If so then how will I balance load between these 3 RDS instances. Don't suggest to not to use multi writers because My application has 99% writer work.
Is there anyway possible to have multi writer instance and load balance between them?
19 Views Asked by Sultan Muhammad At
0
There are 0 best solutions below
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in AMAZON-WEB-SERVICES
- S3 integration testing
- How to get content of BLOCK types LAYOUT_TITLE, LAYOUT_SECTION_HEADER and LAYOUT_xx in Textract
- Error **net::ERR_CONNECTION_RESET** error while uploading files to AWS S3 using multipart upload and Pre-Signed URL
- Failed to connect to your instance after deploying mern app on aws ec2 instance when i try to access frontend
- AWS - Tab Schema Conversion don't show up after creating a Migration Project
- Unable to run Bash Script using AWS Custom Lambda Runtime
- Using Amazon managed Prometheus to get EC2 metrics data in Grafana
- AWS Dns record A not navigate to elb
- Connection timed out error with smtp.gmail.com
- AWS Cognito Multi-tenant Integration | Ok to use Client’s Idp?
- Elasticbeanstalk FastAPI application is intermittently not responding to https requests
- Call an External API from AWS Lambda
- Why my mail service api spring isnt working?
- export 'AWSIoTProvider' (imported as 'AWSIoTProvider') was not found in '@aws-amplify/pubsub'
- How to take first x seconds of Audio from a wav file read from AWS S3 as binary stream using Python?
Related Questions in AMAZON-RDS
- I'm trying to connect AWS RDS to "looker studio", but I keep getting errors... I can connect to tableau and other places
- rds.extensions parameter is not available on RDS for Postgres 16
- Aurora read replica writer instance
- Issue using aws sagemaker InvokeEndpoint inside of Postgres
- Getting error while connecting to MSSQL with AWS RDS
- backing up RDS to non AWS backup solution
- Bulk/batch UPDATE on Postgres table is considerable slow
- Using AWS RDS mysql Read Instances for Analytics work. Is there an affect on the Database?
- AWS managed Grafana can not connect RDS Postgres DB as datasource with ssl enabled
- Define custom variables instead of setting them in a function invoked on each session startup
- Lambda function cannot "translate" RDS endpoint despite pointing directly at it?
- Unable to Dynamically Retrieve RDS Cluster Endpoint in Terraform Provider Configuration
- How to launch Amazon RDS Multi_AZ DB Cluster Deployment (Instance with 2 standby Instances) using Terraform?
- AWS Beanstalk RDS ERROR While Running Migrations
- MySQL Replication Error on AWS RDS: Access Denied for SUPER or REPLICATION_SLAVE_ADMIN Privileges
Related Questions in AMAZON-AURORA
- Cannot connect to the aurora postgres database through RDS proxy
- Aurora read replica writer instance
- Using AWS RDS mysql Read Instances for Analytics work. Is there an affect on the Database?
- How do I know, how long Aurora Auto-Scaling instances had been run for a specific time?
- Automatic migrations EF Core Postgres Aurora DB
- Postgres duplicate indexes
- Is there anyway possible to have multi writer instance and load balance between them?
- How to push or pull data from AWS to Google Big Query
- Can't connect Windows 10 client to AWS Aurora MySQL database after major version upgrade 2 - 3
- Amazon Aurora rejects operations from a specific application on a specific computer
- Change user password in AWS Babelfish
- Amazon Aurora Hierarchy
- Amazon Aurora Spatial Query Returning Duplicate Results Despite Unique Index
- Cannot connect (TimeOut) to MySQL using nodejs mysql2 via ssh tunnel
- How do I create an aws rds aurora database with some tables with python aws cdk?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?