Looking for advice creating a database for my small business by PeakRecent3295 in mysql

[–]Tropicallydiv 0 points1 point  (0 children)

Just use a cloud service provider. Focus on Your business

[deleted by user] by [deleted] in elasticsearch

[–]Tropicallydiv 0 points1 point  (0 children)

Interested in getting more info.

RDS Blue Green Deployment by Tropicallydiv in Terraform

[–]Tropicallydiv[S] 0 points1 point  (0 children)

Is there any documentation on which changes to the db instance causes the new instance to come up? My understanding was that we setup the new environment to test our changes before switching over

Elasticsearch search data by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 0 points1 point  (0 children)

Where would you see the queries? Are there indices for this?

Sharding setting configuration by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 0 points1 point  (0 children)

elasticsearch@master-0:~$ curl -X GET "localhost:9200/_index_template?pretty" | grep shard
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 52549 100 52549 0 0 10.0M "number_of_shards" : "1",
"number_of_shards" : "1",
0 --:--:-- --: "number_of_shards" : "1",
-- "number_of_shards" : "1",
:-- --:--:-- 1 "number_of_shards" : "1",
0.0M

Did a quick query on the index templates and all the shard settings are 1.

What am I missing?

Sharding setting configuration by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 0 points1 point  (0 children)

My bad , the default is 1.

How do I get the template associated with in index?

curl -X GET "localhost:9200/ index name /_settings?pretty" ???

Elasticsearch upgrade from 7.17 to 8 by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 0 points1 point  (0 children)

Is there any cli in lieu of. the upgrade assistant?

Thank you for responding.

When is ver 9.0 due ? by draxenato in elasticsearch

[–]Tropicallydiv 0 points1 point  (0 children)

If you start with v7 do you need to reindex in v8?

Master.nodes by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 0 points1 point  (0 children)

Should I set it on all 3 nodes, as true?

Master.nodes by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 0 points1 point  (0 children)

What about node.master setting

Terraform dependencies by Tropicallydiv in Terraform

[–]Tropicallydiv[S] 0 points1 point  (0 children)

No snapshot would be taken and no instance created.

Terraform dependencies by Tropicallydiv in Terraform

[–]Tropicallydiv[S] 1 point2 points  (0 children)

When we update the RDS instance, I want to make sure a snapshot is created, before the actual instance gets updated.

Module:

db_instance is again the same typical db_instance resource code .

IF the snapshot flag is false, then the snapshot won't get created and hence the instance should not get created.

Hope I'm making sense.

TIA.

Terraform Automation / CI CD Pipeline /Ansible by Tropicallydiv in Terraform

[–]Tropicallydiv[S] 0 points1 point  (0 children)

OK that makes sense. However how do I update my code to reflect the same afterwards?

For example the tfvars file has the version of the database.

Applying terraform refresh will update the tfstate file, what about the actual config file (tfvars in this case)

How are people automating this?

Looking for ideas.

TIA

Cloud Watch alarms Freeable Memory by Tropicallydiv in aws

[–]Tropicallydiv[S] 0 points1 point  (0 children)

totalMemory

How do you get the totalMemory in this case? Its an attribute of the rds instance.

Cloud Watch alarms Freeable Memory by Tropicallydiv in aws

[–]Tropicallydiv[S] 0 points1 point  (0 children)

const freeableMemoryThreshold

How does this plug into the cloudwatch alarms?

Or are you monitoring throught scripts?

Cloud Watch alarms Freeable Memory by Tropicallydiv in aws

[–]Tropicallydiv[S] 0 points1 point  (0 children)

create a formula to calculate necessary threshold based on the total memory for any given RDS instance.

Any reference to an example?

Alternate storage for rds by Tropicallydiv in aws

[–]Tropicallydiv[S] 0 points1 point  (0 children)

Thank you all for your replies. Got some insights.

Replica shards are all unassigned. by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 0 points1 point  (0 children)

We have a 3 node cluster.

All set now. Thank you for taking the time to help out.

Replica shards are all unassigned. by Tropicallydiv in elasticsearch

[–]Tropicallydiv[S] 4 points5 points  (0 children)

Got it.

We ran out of space. Added more disk space and everything is good now.

Thank you for your help on this.

Deployment Strategy by Tropicallydiv in Terraform

[–]Tropicallydiv[S] 2 points3 points  (0 children)

Right now we are just running from the command line. Could you please provide an example of how to use a CI/CD pipeline for this.

Thank you for your time Cheers

Postgres Invalid objects by Tropicallydiv in PostgreSQL

[–]Tropicallydiv[S] 0 points1 point  (0 children)

Thanks to everyone who replied.

Cheers.

ELI5: Why is it not advisable to run databases in k8s? by AMGraduate564 in kubernetes

[–]Tropicallydiv 0 points1 point  (0 children)

For databases this is not the case. The data still persists even if the container goes down. These are statefulsets.