Questions tagged [read-only-database]

The tag has no usage guidance.

20 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
539 views

Table queries locked during long insert SQL server

Everyday runs a sql job that loads data from bulk files and load them in auxiliary tables, to adapt and then copy to the destination table where applications read (and only read) the data. I am ...
3
votes
0answers
931 views

Optimizing a single table, write-once, read-many PostgreSQL database

I've just finished constructing a table of ~835 million rows using Google's ngram dataset, aggregated on the years in which they occurred so that each 2-,3-,4-, and 5-gram is represented by a single ...
2
votes
0answers
688 views

Secondary Replica Read-Only Routing via Linked Server working from one server, but not the other

I have been given the task of setting up a read-only linked server on ServerA to Availability Group listener ListnerX. ListnerX points to ServerY or ServerZ (ServerY is usually the primary). Read-only ...
2
votes
0answers
455 views

Basic PostgreSQL 9.x Performance Optimization Strategies for Reads/Analysis

Postgres comes, out of the box, configured as a general purpose database for both OLTP and OLAP types of loads. My need is to do use Postgres, in this case, purely as an OLAP running aggregate queries ...
1
vote
0answers
94 views

How do read queries against Postgres's JSONB type compare to Couchbase?

I'm working on a small project which would involve running queries against deeply-nested (up to 5 layers) keys in dictionaries. This would be specifically a read-heavy environment, with only one large ...
1
vote
1answer
166 views

Are there security-issues with a read-only-account on Oracle-DBs?

I am currently working as IT-maintenance-guy for a classic MVC-system(oracle-db/jboss) at public sector. The newest feature should be the shutdown of my oracle-db-readOnly-Account cause of "security ...
0
votes
1answer
19 views

Set MySql read-only from K8s cluster

I have a Kubernetes cluster running with MySQL app (5.7.32 MySQL version). I'm trying to make MySQL app be in a consistency mode, using this command: FLUSH TABLES WITH READ LOCK; SET_GLOBAL read_only =...
0
votes
0answers
20 views

Is it possible to Auto Archive Old Data into ReadOnly partitions on a large table with existing PS/PF and auto drop old read only partitions

Is it possible to Auto Archive Old Data into Read Only partitions on a very large table with existing PS/PF but then also allow continued automatic pruning/dropping of those read only partitions i.e. ...
0
votes
0answers
69 views

Clear performance schema on read-only MySQL instance

I am using AWS Aurora MySQL with Writer and reader instances in replication. Both instance are used by two separate applications. I want to clear the performance schema on the read replica server but ...
0
votes
1answer
158 views

PostgreSQL 9.3, set database (or all) to read only mode

Is any simple function/command for PostgreSQL 9.3 to set whole database to read only mode and then back to RW mode? For example same as for MySQL: FLUSH TABLES WITH READ LOCK; LOCK TABLES customers ...
0
votes
0answers
13 views

I have a question : coming from my latest interview: On Always on readable secondary

I was asked that if a user has to be connected to secondary replica of always on 2 node environment how will we access to read only requests to secondary and we don't want to let the user access ...
0
votes
0answers
41 views

Sql server error message “the database is read only” in a remotely server - availability database

I have a failover cluster with a high availability sql server service, the problem is that I cannot create a table, update, delete remotely even if I already give specific permissions and i had ...
0
votes
0answers
31 views

Read only database for time series event data

I have a time-series dataset (around 500 million rows, 4 columns) that stores public transport ticket validations. Not sure if it matters, but it's an event driven dataset, without constant timestamp ...
0
votes
0answers
2k views

The MySQL server is running with the --read-only option so it cannot execute this statement

I am using amazon aurora RDS in my application. I have created cluster endpoint by selecting both read and write instance. Then I used that instance in my application. Whenever I am executing update ...
0
votes
1answer
111 views

Does a read replica help if the problem are heavy queries?

The application that our team is responsible for is having ever more often DB performance problems. The application querying it doesn't throw lots of concurrent queries, the problem we have are rather ...
0
votes
1answer
74 views

Configure mongo for one shot full db read

I have a kubernetes cluster on bare metal with 3 machines having 8Gb of ram each. All my apps and a mongodb 4.0.9 replicaset runs on it. There is an import program that: Download a 8Gb mongo dump ...
0
votes
1answer
109 views

How to set mariadb read_write for some specific tables while starting as read_only=1

I am trying to set a mariadb slave which is exact replica of master db. As per the suggestion I start my slave with command --relay-log=mysql-relay-bin" "--log-slave-updates=1" "--read-only=1" . But ...
0
votes
1answer
258 views

How do I truncate performance_schema tables on a read replica?

On occasion, you have to truncate events_statements_summary_by_digest, when it's hit the row limit. On a write master, this is easy, but on a read replica, there doesn't seem to be a way to do it. The ...
0
votes
1answer
1k views

Worry to delete Read replica RDS

I created a read replica from RDS , and I do want to delete it. I am so worry about affecting the origin RDS which is in PROD . Is it recommended to take snapshots before deletion of read replica ...
0
votes
1answer
204 views

intel p3600 SSD no increase in read speed - postgres rdbms vs hdd

We run a custom application that produces analyzable data-sets for medical research. the amount of data we have is about 600GB in form 3Billion rows distributed in 600+ tables it is hosted in ...