Tag: Cache

Feed: AWS Partner Network (APN) Blog. Author: AWS Admin. By Michael Moussa, APN Ambassador at RackspaceThis year’s AWS re:Invent was a nonstop, high-powered firehose of exciting new features and products. Native PHP support on Lambda wasn’t one of those features, but the new AWS Lambda runtime API and layers capabilities give us the ability to build a clean, supportable implementation of PHP on Lambda of our own. In this post, we’ll take a brief look at the overall workflow and runtime lifecycle, and then I’ll show you one way to build a PHP runtime to start powering your PHP applications on AWS Lambda ... Read More

Feed: AWS Big Data Blog. Whatever your industry, data is central to how organizations function. When we discuss data strategy with customers, it’s often in the context of how do they ingest, store, process, analyze, distribute, and ultimately secure data.Amazon EMR is a managed Hadoop framework that you use to process vast amounts of data. One of the reasons that customers choose Amazon EMR is its security features. For example, customers like FINRA in regulated industries such as financial services, and in healthcare, choose Amazon EMR as part of their data strategy. They do so to adhere to strict regulatory ... Read More

Feed: CDH – Cloudera Engineering Blog. Author: Tom Wheeler. For a user-facing system like Apache Impala, bad performance and downtime can have serious negative impacts on your business. Given the complexity of the system and all the moving parts, troubleshooting can be time-consuming and overwhelming. In this blog post series, we are going to show how the charts and metrics on Cloudera Manager (CM) can help troubleshoot Impala performance issues. They can also help to monitor the system to predict and prevent future outages. CM provides a comprehensive suite of time-series and pre-aggregated metrics and charts at varying levels of ... Read More

Feed: What's New. File Gateway enables on-premises applications to access objects in Amazon S3 as files, through a local gateway deployed on a virtual or a Hardware Appliance. You can now achieve write throughputs of up to 500 MB/s by following published best practices. You can now also do a selective cache refresh to update specific folders in the local File Gateway, further simplifying collaboration and content distribution workflows in geographically separated hybrid cloud environments. Additionally, you can now specify your own Domain Name Service (DNS) and Network Time Protocol (NTP) servers for File Gateways, simplifying integration with on-premises network and ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Allocating Work_mem Monday, December 10, 2018 I have already discussed the complexities of allocating shared_buffers, work_mem, and the remainder as kernel cache. However, even if these could be optimally configured, work_mem (and its related setting maintenance_work_mem) are configured per query, and potentially can be allocated multiple times if multiple query nodes require it. So, even if you know the optimal amount of work_mem to allocate for the entire cluster, you still ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Since its inception, the Azure SQL Database offering has been evolving in order to accommodate a wide range of needs of its customers. This has resulted in two separate deployment models and pricing models, each with distinct tiers of service, representing unique performance and functionality characteristics. Azure SQL Database Hyperscale is the latest manifestation of this trend, targeting scenarios where the storage requirements exceed the current database size limit of 4 TB. In this article, I will describe its architecture and primary benefits. Initial implementation of Azure SQL Database was geared towards ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. The Memory Resource Triad Friday, December 7, 2018 There are three resources that affect query performance: cpu, memory, and storage. Allocating cpu and storage for optimal query performance is straightforward, or at least linear. For cpu, for each query you must decide the optimal number of cpus to allocate for parallel query execution. Of course, only certain queries can benefit from parallelism, and the optimal number of cpu changes based on ... Read More

Feed: Planet MySQL; Author: Severalnines; Queries have to be cached in every heavily loaded database, there is simply no way for a database to handle all traffic with reasonable performance. There are various mechanisms in which a query cache can be implemented. Starting from the MySQL query cache, which used to work just fine for mostly read-only, low concurrency workloads and which has no place in high concurrent workloads (to the extent that Oracle removed it in MySQL 8.0), to external key-value stores like Redis, memcached or CouchBase. The main problem with using an external dedicated data store (as we ... Read More

Feed: Hazelcast Blog. Author: Dan Ortega. In response to market forces that are both broad and deep, IBM has been moving deliberately and systematically to a cloud-based model, with IBM Cloud Private being the leading edge of IBM’s offer to the enterprise market. IBM Cloud Private is built on open-source frameworks Kubernetes and Cloud Foundry, with common services for self-service deployment, monitoring, logging and security, as well as a portfolio of middleware, data and analytics. With IBM Cloud Private, development and administrative teams share a flexible cloud environment behind their firewalls to create new microservices-based applications. Hazelcast has been working ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Prerequisite With version 1.2.2 of MariaDB ColumnStore, there should be no version of MariaDB Server or MySQL installed on the OS before a MariaDB ColumnStore is installed on the system. If you have an installation of MariaDB Server or MySQL, uninstall it before proceeding. Configuration preparation Before installing MariaDB ColumnStore, there is some preparation necessary. You will need to determine the following. Please refer to the MariaDB ColumnStore Architecture Document for additional information. How many User Modules (UMs) will your system need? How many Performance Modules (PMs) will your system need? How ... Read More