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 80

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 85

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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.

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

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.

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.

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.

Upcoming Webinar Tuesday, 7/31: Using MySQL for Distributed Database Architectures

Percona

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). 5000 named Percona to their list in 2013, 2014, 2015 and 2016.

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.

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.

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.

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.

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.

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 ?

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.

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.

Finding Distinct Values Quickly

SQL Performance

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do.

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++ 82

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.

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

As we moved towards SQL Server 2014, the pace of hardware accelerated. Our design for SQL Server 2012 and SQL Server 2014 is still proven and meets the demands for many of our customers. The yellow line represents throughput results for SQL Server 2014 with a single sync replica.

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 80

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.

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.

DBCC Trace Flags 2562 and 2549

SQL Server According to Bob

For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. Trace flag 2549 is used to change how DBCC sees the volume layout of the database. Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace flags 2562 and 2549 behavior. Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements.

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

The following chart shows the same 1TB database testing. Use SQL Server Management Studio (SSMS) or your favorite query editor to connect to a SQL Server 2012 or 2014 instance. SQL Server 2014.

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.

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.

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?

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. The new column store engine and query processing technology could increase query performance up to 100X and the new In-memory OLTP engine can process 1.25million batches/sec on a single 4 socket server, which is more than 3X of SQL 2014. “ – Rohan Kumar, Director of SQL Software Engineering.

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.

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!

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.

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?”