Expanding the Cloud: Docker Containers in Elastic Beanstalk

All Things Distributed

We launched Elastic Beanstalk in 2011 with support for Java web applications and Tomcat 6 in one region, and we''ve seen the service grow to 6 container types (Java/Tomcat, PHP, Ruby, Python,NET, and Node.js) supported in 8 AWS regions around the world.

AWS 79

How to Easily Deploy an IMDG in the Cloud

ScaleOut Software

With their tightly integrated client-side caching, IMDGs typically provide much faster access to this shared data than backing stores, such as blob stores, database servers, and NoSQL stores. Cloud-based applications enjoy the unique elasticity that cloud infrastructures provide.

Cloud 52

Document Model Support in DynamoDB: Flexibility, Availability, Performance, and Scale.Together at last

All Things Distributed

The original Dynamo paper inspired many database solutions, which are now popularly referred to as NoSQL databases. These databases trade off complex querying capabilities and consistency for scale and availability. For DynamoDB, our primary focus was to build a fully-managed highly available database service with seamless scalability and predictable performance. A trend in NoSQL and relational databases is the mainstream adoption of the document model.

AWS Pop-up Loft 2.0: Returning to San Francisco on October 1st

All Things Distributed

Topics include Introduction to AWS, Big Data, Compute & Networking, Architecture, Mobile & Gaming, Databases, Operations, Security, and more. When: October 1, 2014 at 6:30 -8:00 PM. It’s an exciting time in San Francisco as the return of the. AWS Loft. is fast approaching.

Games 62

Database Resolutions for 2018

VoltDB

So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB.

The CIO and M&A, Part II

The Agile Manager

at the database level) where legacy systems do not support modern architectural principles. Integrating businesses is no small task. Established workflows, systems and tools are vigorously defended yet poorly understood. Fearing for their jobs, people will equate systemic knowledge with job security. Many in the acquired business will cling to their legacy identity. Organizational politics - and power plays - will alter tactical integration plans.

Tech: From Owning to Renting - to Owning Again?

The Agile Manager

The Profit Impact of Market Strategy database produced by the Strategic Planning institute concluded that diverse & vertically integrated businesses were significantly more profitable than narrow and focused businesses (PIMS 1977, slide 67). In the 1970s, the predominant business strategy was vertical integration: own the value chain from raw materials to retail outlets. The research of the time supported this.

Weekend Reading: Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases.

All Things Distributed

In many, high-throughput, OLTP style applications the database plays a crucial role to achieve scale, reliability, high-performance and cost efficiency. For a long time, these requirements were almost exclusively served by commercial, proprietary databases.

Should You Use ClickHouse as a Main Operational Database?

Percona

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. how many messages was send for some time period and how much it cost) and a typical key/value queries like: “return 1 message by the message id” Using a columnar analytical database can be a big challenge here. 2014 ? 2014 ?

Designing Schemaless, Uber Engineering’s Scalable Datastore Using MySQL

Uber Engineering

The making of Schemaless, Uber Engineering’s custom designed datastore using MySQL, which has allowed us to scale from 2014 to beyond. Architecture Data Database Infra Mezzanine MySQLBy Jakob Holdgaard Thomsen. This is part one of a three-part series on Schemaless. In Project Mezzanine we described … The post Designing Schemaless, Uber Engineering’s Scalable Datastore Using MySQL appeared first on Uber Engineering Blog.

Which is the Best MongoDB GUI? — 2019 Update

Scalegrid

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. SQL Import/Export that supports major databases: Oracle, SQL Server, MySQL, and PostgreSQL.

Using Triggers On Schemaless, Uber Engineering’s Datastore Using MySQL

Uber Engineering

The details and examples of Schemaless triggers, a key feature of the datastore that’s kept Uber Engineering scaling since October 2014. Architecture Data Database Infra Mezzanine MySQLThis is the third installment of a three-part series on Schemaless; the first part is a design overview … The post Using Triggers On Schemaless, Uber Engineering’s Datastore Using MySQL appeared first on Uber Engineering Blog.

The Architecture of Schemaless, Uber Engineering’s Trip Datastore Using MySQL

Uber Engineering

How Uber’s infrastructure works with Schemaless, the datastore using MySQL that’s kept Uber Engineering scaling since October 2014. Architecture Data Database Infra Mezzanine MySQLThis is part two of a three- part series on Schemaless; part one is on designing Schemaless. In Project Mezzanine: … The post The Architecture of Schemaless, Uber Engineering’s Trip Datastore Using MySQL appeared first on Uber Engineering Blog.

Common SQL Server Mishaps

SQL Performance

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database.

Minimal Logging with INSERT…SELECT into Heap Tables

SQL Performance

The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model. For SQL Server 2014 and later , the transition point is 950 rows for this table. For example, with row versioning turned off for the database: SELECT.

Analyzing "death by a thousand cuts" workloads

SQL Performance

In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it. [ dbid ] ) AS [ Database Name ] , REPLACE ( REPLACE ( LEFT ( t. [

C++ 52

Webinar Tuesday, 8/28: Forking or Branching – Lessons from the MySQL Community

Percona

5000 named Percona to their list in 2013, 2014, 2015 and 2016. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog.

Interactive checks for coordination avoidance

The Morning Paper

I am so pleased to see a database systems paper addressing the concerns of the application developer! A example class of application invariants is database integrity constraints. See Coordination avoidance in database systems for more details.

AMD EPYC Processors in Azure Virtual Machines

SQL Performance

Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The older Intel Xeon E5-26xx v3 (Haswell) series which was introduced in Q3 of 2014, had a maximum memory bandwidth of 2133MHz.

Minimal Logging with INSERT…SELECT into Empty Clustered Tables

SQL Performance

For SQL Server 2014 and later, the uniquifier is correctly omitted for unique indexes, but the one extra byte for the internal bit flag is retained. Introduction.

Cache 70

Stuff The Internet Says On Scalability For June 22nd, 2018

High Scalability

using them to respond to storage events on s3 or database events or auth events is super easy and powerful. Ultimately, Netflix did end up paying Comcast in 2014 and, surprise surprise, the throttling stopped. Hey, it's HighScalability time: 4 th of July may never be the same.

The ANY Aggregate is Broken

SQL Performance

Nevertheless, if you run this query yourself, you are quite likely to see the same result I do: The execution plan depends on the version of SQL Server used, and does not depend on database compatibility level. The ANY aggregate is not something we can write directly in Transact SQL.

Is Intel Doomed in the Server CPU Space?

SQL Performance

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. You might be asking why you should care about all of this as a SQL Server Database professional?

AWS EC2 Virtualization 2017: Introducing Nitro

Brendan Gregg

It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5.

Introduction to Wait Statistics

SQL Performance

Back in 2014, I started a series of blog posts here to talk about specific wait types and what they do and don’t mean. That gave me the idea to create the wait and latches libraries that I maintain (more on these later). If you’re reading this and thinking “what is he talking about?”

Data Mining Problems in Retail

Highly Scalable

Retail is one of the most important business domains for data science and data mining applications because of its prolific data and numerous optimization problems such as optimal prices, discounts, recommendations, and stock levels that can be solved using data analysis methods.

Retail 175

Grouped Aggregate Pushdown

SQL Performance

SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. The scripts that follow assume there is a table called dbo.Numbers in the current database that contains integers from 1 to at least 16,384. Introduction.

Minimal Logging with INSERT…SELECT and Fast Load Context

SQL Performance

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The test table schema is such that 130 rows can fit on a single 8KB page when row versioning is off for the database. This post provides new information about the preconditions for minimally logged bulk load when using INSERT.SELECT into indexed tables. The internal facility that enables these cases is called FastLoadContext.

Välkommen till Stockholm – An AWS Region is coming to the Nordics

All Things Distributed

In 2014 and 2015 respectively, AWS opened offices in Stockholm and Espoo, Finland. After migrating, database queries that took six seconds now take three seconds in their AWS infrastructure. Today, I am very excited to announce our plans to open a new AWS Region in the Nordics!