Tag: cluster

Feed: AWS Big Data Blog. Amazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing business intelligence (BI) tools. Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS designed hardware and machine learning (ML) to deliver the best price-performance at any scale. Customers have reached out to us with a need to migrate their Amazon Redshift clusters from one AWS Region to another. Some of the common reasons include provisioning their clusters ... Read More

Feed: AWS Big Data Blog. During the past year, we’ve seen customers running self-managed Elasticsearch clusters on AWS who were running out of compute and storage capacity because of the non-elasticity of their clusters. They adopted Amazon OpenSearch Service (Successor To Amazon Elasticsearch Service) to benefit from better flexibility for their logs and enhanced retention periods. In this post, we discuss how to build a cost-effective extension to your Elasticsearch cluster with Amazon OpenSearch Service to extend the retention time of your data. In May 2021, we published the blog post Introducing Cold Storage for Amazon OpenSearch Service, which explained ... Read More

Feed: R-bloggers. Author: finnstats. The post Cluster Sampling in R With Examples appeared first on finnstats. If you want to read the original article, click here Cluster Sampling in R With Examples. Are you looking for the latest Data Science Job vacancies then click here finnstats. The post Cluster Sampling in R With Examples appeared first on finnstats. Cluster Sampling in R, as discussed in one of our old posts, researchers frequently gather samples from a population and use the findings to derive conclusions about the entire population. Subscribe to our newsletter! Cluster sampling, in which a population is divided ... Read More

Feed: Recent Announcements. Amazon Neptune now supports up to 128 TiB of storage per cluster (up from 64 TiB). With this change you can continue to use your graph applications without adding new clusters or making any changes to your application. The increased storage limit is available on engine releases 1.0.2.2 and above. Amazon Neptune is a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets. You can now build applications that connect knowledge, detect fraud, and link identities with larger data sets within the same Neptune cluster. The ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona XtraDB Cluster (PXC) offers a great deal of flexibility when it comes to the state transfer (SST) options (used when a new node is automatically provisioned with data). For many environments, on-the-fly compression capability gives great benefits of saving network bandwidth during the process of sending sometimes terabytes of data. The usual choice for compression here is a built-in Percona XtraBackup compress option (using qpress internally), or options compressor/decompressor for the compression tool of choice. In the second case, the popular option is the gzip or its multi-threaded version pigz, which offers ... Read More

Feed: Planet MySQL; Author: Codership; Recently we got a question about how one can perform a minor version upgrade of a Galera Cluster, and today we just want to say that it is reasonably straightforward. While upgrades are a feature of Galera Manager that we are most excited to see come soon, today, doing it manually on the command line is quite simple! In this post, we will go through upgrading a 9-node geographically spread cluster, from MySQL 8.0.23 to 8.0.26. We also have extensive documentation: Upgrading Galera Cluster. We have 3 nodes each in Singapore, London and San Francisco, ... Read More

Feed: The Information Lab. Author: Iwona Fredouelle. 19 January, 2022 | Iwona Fredouelle Restoring a backup from a regular Tableau environment to an external file store Tableau server/cluster If you don’t know how backup with external file store works, this page explains it quite well. This blog post describes how to restore a backup from a normal Tableau server without any add-ons to Tableau server with external file store (with Server Management Add-on). There is no official description on how this works, so this is based purely on my experience. Also this is a pg-only restore, which means it restores ... Read More

Feed: Planet MySQL; Author: Codership; There are plenty of articles on the Internet that tell you to setup a Galera Cluster by disabling an OS based firewall and also disabling SELinux. While we agree that this might be the fastest way to get your Galera Cluster setup, it is not necessarily good security hygiene, and we would prefer if you started 2022 with a bit more secure Galera Cluster! What is SELinux? Is is Security-Enhanced Linux that allows administrators to allow who has more control over the system. It has permissive and enforcing mode, and is turned on by default ... Read More

Feed: Planet PostgreSQL. Failover of the logical replication slot has always been the pain point while using the logical replication in PostgreSQL. This lack of feature undermined the use of logical replication and acted as one of the biggest deterrents. The stake and impact were so high that many organizations had to discard their plans around logical replication, and it affected many plans for migrations to PostgreSQL. It was painful to see that many had to opt for proprietary/vendor-specific solutions instead. At Percona, we have written about this in the past: Missing Piece: Failover of the Logical Replication Slot.  In ... Read More

Feed: Planet PostgreSQL. A customer recently asked if our Percona Distribution for PostgreSQL Operator supports the deployment of a standby cluster, which they need as part of their Disaster Recovery (DR) strategy. The answer is yes – as long as you are making use of an object storage system for backups, such as AWS S3 or GCP Cloud Storage buckets, that can be accessed by the standby cluster. In a nutshell, it works like this: The primary cluster is configured with pgBackRest to take backups and store them alongside archived WAL files in a remote repository; The standby cluster is ... Read More