Questions tagged [google-cloud-platform]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

Database encryption and security [on hold]

In order to secure the data in the database, what are the strategies and what is usually supplied by standard DB (e.g. MySql/Postgres) and cloud providers (e.g. AWS/GCP)? from what I understood, all ...
0
votes
0answers
9 views

Is necessary to backup Google Firestore DB?

Im working a production app in Google's Firebase Firestore platform, have been development from a very long time (year and a half ago) and now that its in production I'm worried about backing up and ...
0
votes
1answer
38 views

High CPU usage on fresh new install of MongoDB

I read a lot of post about high CPU usage of Mongo but almost all relates to queries. I just did a fresh install of MongoDB 4. I have no other databases than the default one. As soon as I start the ...
0
votes
0answers
27 views

Connect google cloud storage bucket in MSSQL(2016)

I host a SQL Server Enterprise 2016 + Windows Server 2016 DataCenter on google compute engine. I'm going to use .bak file on my google cloud storage (GCS) bucket, to restore database on other folder ...
0
votes
0answers
128 views

MongoDB 3.4.10 queries getting very slow after couple hours/days of running

We have a MongoDB pod running on CGP Kubernates with 2 replicas. Microservices are written in Java and use Mophia to access MongoDB. The database only has 6 million data. One collection, in particular,...
0
votes
2answers
98 views

Why is an instance forced to reboot?

This is My SQL Project instance log. I set the instance not to shut down automatically. But why does the instance automatically shut down irregularly? 2019-03-28 08:58:13.100 JST 2019-03-27 23:58:13 ...
0
votes
0answers
52 views

How can I complete a full export and import of Google BigTable

!/bin/bash BigTable_ExportTest.sh Edited original source script with new bucket and jar file. This script will backup BigTable Data Table by table and store it into a destination location as ...
2
votes
1answer
202 views

Using mariabackup/xtrabackup vs block level snapshots

I am running a mariadb 10.1 instance with all innodb tables and a replication slave in a k8s cluster on Google Cloud's GKE. I have a scheduled mysqldump that runs every night. But for additional ...
1
vote
1answer
58 views

Google Cloud SQL lacks raster2pgsql

Google Cloud SQL supports the PostGIS extension, but I haven't seen any documentation regarding how to work with raster data on it. To load raster data into a table, we have to use raster2pgsql driver....
1
vote
0answers
40 views

How to backup a local database to cloud database?

I am about to start developing a POS software as my new project with python and electron js. It is going to be a desktop application. However, my concern is it should work in both cases when desktop ...
1
vote
0answers
29 views

Why use Failover replica on Google Cloud RDS?

we are thinking of migrating our MySQL database from our dedicated server to a Google Cloud RDS instance. However I would like to clarify the below: 1) What is the purpose of creating a failover ...
2
votes
1answer
289 views

Mongodb replica set primary and secondary node conf fail when one slave is down

In my env, I had created MongoDB replica set conf for high availability so one server fails should be handled by other also in my conf I have 3 DB server and 1 arbiter too but, my slave's server ...
2
votes
0answers
61 views

Google datastore and materialized paths

Folks from MongoDB have documented a very nice approach of using a data model for tree-like structures: they call it Materialized Paths. Consider following: If I populate this hierarchy using ...
0
votes
1answer
7 views

How do you make manual/one-off log-based queries?

My app engine instances are logging incoming requests and I'd like to be able to run manual/one-off queries for data analysis. As an example, I would like to be able to determine how many requests ...
1
vote
3answers
813 views

Google Cloud SQL Replication Delay

We have a project which does write data on a second generation MySQL 5.6 The master's write behaviour: Average 70 write operations per second. The thing is 2 times a day, application writes data ...
3
votes
1answer
605 views

MongoDB crashes with out-of-memory or is being killed by oom-killer

A two shards MongoDB database regularly crashes with out-of-memory error or is being killed by the oom-killer. The system runs on GCE Debian 9.4 with MongoDB v3.6.5, WiredTiger storage engine and ...
1
vote
1answer
271 views

How to query for certain text in log messages from Google App Engine that are exported to BigQuery?

I have used the 'Create Export' in the Logging section of Google Cloud Platform to export log entries into Big Query for analysis Here is part of the structure of the table in BigQuery that logs the ...
2
votes
2answers
876 views

Sync MongoDB Replica set with Remote Replica Set

I'm wondering if it is possible (within reason) to sync a new MongoDB Replica Set(RS) with an RS currently in production. The Problem We have a site running on AWS that has its own MongoDB Replica ...
0
votes
1answer
402 views

MySQL compression on Google Cloud SQL

As the Google Cloud SQL is a managed instance of MySQL under the hood, limited to an absolute max on 2nd generation machines of 100GB of RAM, should I be compressing some of my table and index data ? ...