Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [kubernetes]

Kubernetes is a system for running containerized applications across multiple hosts, providing basic mechanisms for deployment, maintenance, and scaling of applications.

Kubernetes is a system for managing containerized applications across multiple hosts, providing basic mechanisms for deployment, maintenance, and scaling of applications. Its APIs are intended to serve as the foundation for an open ecosystem of tools, automation systems, and higher-level API layers. Kubernetes can run on various cloud providers, on premises in VMs, or on bare metal machines.

Getting started

32 questions
2
votes
0 answers

Kubernetes: Influxdb 1.8.10 container can’t create users

I deployed on docker InfluxDB v 1.8.10 with command: docker run --name influxdb -t -e INFLUXDB_HTTP_AUTH_ENABLED=“true” -e INFLUXDB_DB=“mydatabase” -e INFLUXDB_USER=“user” -e INFLUXDB_USER_PASSWORD=“user” -e INFLUXDB_ADMIN_USER=“admin” -e…
Marco Ferrara
  • 121
  • 2
2
votes
0 answers

Running PostgreSQL as sidecar in Kubernetes Pod

I know there are several professional PostgreSQL Kubernetes Operators out there (crunchy, zalando, kubeDB, stackgres, percona). But my use case is small and simple. I thought about running PG in a sidecare together with my application image in a…
guettli
  • 1,591
  • 5
  • 25
  • 51
2
votes
1 answer

Cassandra cluster still trying to reach old IP

I've seen a strange behaviour since a node decommission; regularly some Cassandra nodes start massively outputting these logs: OutboundTcpConnection.java:570 - Cannot handshake version with /10.208.58.4 The issue is that that IP matches a non…
Aaron
  • 4,420
  • 3
  • 23
  • 36
1
vote
1 answer

GridDB via Kubernetes

I want to deploy application using Kubernetes, one of the used components will be a GridDb database, I used the following article to deploy it - https://griddb.net/en/blog/creating-a-kubernetes-application-using-griddb-and-go/, the deployment…
Jacob_P
  • 29
  • 1
1
vote
2 answers

Access a MySQL storage with two independent instances

I tried to deploy MySQL deployment with Kubernetes, having three replicas which are accessing the same storage(PVC). Here is the configuration apiVersion: v1 kind: PersistentVolume metadata: name: mysql-pv labels: type: local spec: …
Sivakajan
  • 23
  • 2
1
vote
3 answers

Need a Role that can CREATE USER but not allowed to GRANT Predefined Roles in PostgreSQL <16

We are administrating DB in kubernetes to our customers. For each new cluster, we create a new user with CREATE ROLE and CREATE DB roles given to them, so that they can create their own databases and new users with stricter roles. The problem is,…
imans77
  • 111
  • 6
1
vote
1 answer

Data inconsistent after restoring database using nodetool refresh in K8s Cassandra

ENV Details: GKE (Google Kubernetes cluster) Snitch Google cloud snitch. https://docs.datastax.com/en/cassandra-oss/3.0/cassandra/architecture/archSnitchGoogle.html 140 nodes with 4 RACKs (4 statefulsets in 4 AZ's in one region) Each node size is…
Sai
  • 39
  • 5
1
vote
1 answer

Why doesn't my PostgreSQL helm dependency database exist when I try to connect?

Previously when I using the Bitnami Helm chart by way of Terraform to deploy PostgreSQL, I would have a database created. Now I no longer have a database created. I'm using same connect string same usernname same password But I am getting this…
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
1
vote
0 answers

Sql profiler - result in profiler : "Audit Login" and immediately after "Audit Logout" without running the query

I have a service running on an Azure kubernetes (AKS) that is connecting to a DB running on a Virtual Machine (VM) on Azure. There is a failure to run the service. The result of SQL Profiler is: There is only a login and a logout without running a…
dexon
  • 67
  • 1
  • 6
1
vote
1 answer

Executing Cassandra pod CQL queries from shell script, using shell variables with kubectl exec

I have a repetitive task that I do while testing which entails connecting to a cassandra pod and running a couple of CQL queries. Here's the "manual" approach: On cluster controller node, I exec a shell on the pod using kubectl: kubectl exec…
James
  • 113
  • 4
0
votes
0 answers

Commit Log Corruption & Cluster Resilience in K8ssandra on GKE

I'm Eran Betzalel from ExposeBox. We're migrating our big data infrastructure from Hadoop/HDFS/HBase VMs to a modern stack using GKE, GCS, and K8ssandra. While the move is exciting, we're currently facing a critical issue that I hope to get some…
Eran Betzalel
  • 101
  • 2
0
votes
0 answers

How to failover in Oracle Kubernetes environment when primary pod deleted with Observer?

I am running my Oracle primary database instance on pod oracle-0(SID=ORCLP) and standby database instance on oracle-1 Kubernetes pod. They are connected with a headless service. data guard broker, fast_start failover all are enabled and configured…
Sayed
  • 1
  • 1
0
votes
1 answer

What is a viable low-cost DR option for a large cluster?

We have a Cassandra cluster running on GKE with a 32-CPU node pool and SSD disks. The current cluster size is nearly 1 PB, with each node utilizing an average of 5 TB on 10 TB allocated SSD disks. The cluster comprises 200 nodes, each with 10 TB…
Sai
  • 39
  • 5
0
votes
0 answers

Postgresql replication slot does not exist

I am trying to set up logical replication between two databases (deployed via kubernetes). On the origin database, I created a logical replication slot as follows: SELECT pg_create_logical_replication_slot('sub_test', 'pgoutput') and a…
jm22b
  • 101
  • 2
0
votes
1 answer

Kubernetes create cluster multimaster using bitnami/mariadb-galera

I'm trying to deploy mariadb-galera multimaster on kubernetes. But when I set external volume I receive this error: mkdir: cannot create directory '/bitnami/mariadb/data': Permission denied this is my yaml: # PersistentVolume apiVersion: v1 kind:…
Marco Ferrara
  • 121
  • 2
1
2 3