Tag: cluster

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

Feed: Planet PostgreSQL. Co-authored by Brian PaceI was excited to hear that Kubernetes 1.22 was recently released with better support for cgroup-v2 and has support for Linux swap. These changes potentially resolve two of my chief complaints about running Postgres under Kubernetes. Obviously it will take some time before we see uptake in the wild on these features, but I wanted to become familiar with them ... Read More

Feed: Recent Announcements. Starting today, customers can use Amazon EC2 On-Demand Capacity Reservations to reserve capacity for cluster placement groups. With cluster placement groups, customers can launch EC2 instances into logical groups within a segment of the network with high bisection bandwidth, thus getting low latency and high throughput between instances inside the cluster. Cluster placement groups are beneficial for customers with workloads that require tightly coupled node-to-node communication, such as high-performance computing (HPC) workloads or in-memory databases like SAP HANA. With the addition of On-Demand Capacity Reservations for cluster placement groups, customers can get the assurance of reserved capacity ... Read More

Feed: AWS Big Data Blog. Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. With Amazon Redshift, you can analyze all your data to derive holistic insights about your business and your customers. One of the best practices of modern application design is to have centralized logging. Troubleshooting application problems is easy when you can correlate all your data together. When you enable audit logging, Amazon Redshift logs information about connections and user activities in the database. These logs help you monitor the database for security and troubleshooting purposes, a process called database auditing. The logs ... Read More

Feed: Planet MySQL; Author: ProxySQL; Aurora cluster promises a high availability solution and seamless failover procedure. However, how much is actually the downtime when a failover happens? And how proxySQL can help in minimizing the downtime ? A little sneak peek on the results ProxySQL achieves up to 25x less downtime and the impressive up to ~9800x less errors during unplanned failovers. How proxySQL achieves this:  Less downtime “Queueing” feature when an instance in a hostgroup becomes unavailable. So what is ProxySQL? ProxySQL is a middle layer between the database and the application. ProxySQL protects databases from high traffic spikes, ... Read More

Feed: Recent Announcements. Amazon EMR now supports using multiple custom Amazon Machine Images (AMI) when you mix Arm-based AWS Graviton2-based instances with non-Graviton2 based instances in a single cluster. This capability allows you to diversify across more instance types when using custom AMIs, helping improve your access to EC2 capacity for large clusters. Prior to this release, you could still mix multiple instance types within a cluster, but could not do so when using Custom AMIs. Custom AMIs enable you to preload additional software and libraries required by your applications, customize cluster and node configurations, and encrypt the EBS root ... Read More

Feed: Planet MySQL; Author: Marco Tusa; Percona XtraDB Cluster 8.0.25 has introduced a new option to perform online schema modifications: NBO (Non Blocking Operation). When using PXC the cluster relies on wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to replicate DDL statements.   Until now we normally have 3 options: Use Total Isolation Order (TOI, the default) Use Rolling Schema Upgrade (RSU) Use Percona’s online schema change tool (TOI + PTOSC) Each method has some positive and negative aspects. TOI will lock the whole cluster from being able to accept data modifications for ... Read More