Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 81

Availability Open Source Architecture Database 81

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2017: MongoDB goes public, trading as MDB.

Open Source 79

Open Source Programming Database Servers 79

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. It also enables geographically distributed databases for disaster recovery.

Servers 52

Servers Database Availability Traffic 52

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 130

Internet Internet AWS Performance 130

Percona Community

JUNE 8, 2018

Since summer 2017, Amazon RDS supports encryption at rest using AWS Key Management Service (KMS) for db.t2.small medium database instances, making the feature now available to virtually every instance class and type. small and db.t2.medium micro, every other instance class now supports native encryption at rest using KMS.

Virtualization 40

Virtualization AWS Database Availability 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Database architects working with MongoDB encounter specific challenges related to database systems and system growth.

Best Practices 70

Best Practices Traffic Database Servers 70

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. TPC-H Benchmark Results with SQL Server 2017. HPE has already submitted a new official TPC-H result on SQL Server 2017 for a single-socket, HPE Proliant DL325 Gen10 1U server that was 743,750 QphH@1000GB. TPC-E Benchmark Results with SQL Server 2017. More total PCIe lanes and bandwidth.

Servers 52

Servers Benchmarking Virtualization Architecture 52

All Things Distributed

JUNE 30, 2017

So much so, that in March 2017, we announced Amazon Connect, which is the result of nearly ten years of work to build cloud-based contact centers at scale to power customer service for more than 50 Amazon teams and subsidiaries, including Amazon.com, Zappos, and Audible. For instance, Zillow trains and retrains 7.5

Artificial Intelligence 130

Artificial Intelligence Lambda AWS Virtualization 130

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. This was much worse many years ago on Xen virtual machine guests.

Speed 40

Speed Java AWS Virtualization 40

SQL Performance

JULY 8, 2020

In my examples I’ll use sample databases called TSQLV5 and PerformanceV5. The outer query then filters from those three orders only those that were placed on or after July 8 th , 2017. This query generates the following output: orderid orderdate -- - 10250 2017-07-08 (1 row affected). Example for performance reasons.

Servers 110

Servers Code Processing Performance 110

SQL Server According to Bob

APRIL 24, 2018

I also started my career developing on UNIX systems with C++ and databases like Ingres. Last October we released SQL Server 2017 including support for Linux and Docker Containers. docker pull microsoft/mssql-server-linux:2017-latest. As I moved to other jobs, the PC was becoming very popular as was the Windows Operating System.

Servers 40

Servers Internet Internet Open Source 40

Abhishek Tiwari

DECEMBER 1, 2017

At re:Invent 2017, Amazon Web Services (AWS) announced Amazon Time Sync Service which provides a highly accurate and reliable global time reference. TrueTime was introduced to support Spanner - Google’s globally distributed, and synchronously-replicated database. Spanner: Google’s Globally Distributed Database ??.

AWS 55

AWS Google Database Virtualization 55

O'Reilly

FEBRUARY 18, 2020

Up until 2017, the ML+AI topic had been amongst the fastest growing topics on the platform. After several years of steady climbing—and after outstripping Java in 2017—Python-related interactions now comprise almost 10% of all usage. there’s a Python library for virtually anything a developer or data scientist might need to do.

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ A utility would issue the dbcc freeze to stop the I/O activity for the database. ​​ When the utility attempted to issue the thaw command the command would be queued, and the database could not return to an operational state until SQL Server was restarted.

Servers 40

Servers Availability Transportation Database 40

Alex Russell

APRIL 29, 2021

WebGL 2 launched for other platforms on Chrome and Firefox in 2017. Now in development in WebKit after years of radio silence, WebXR APIs provide Augmented Reality and Virtual Reality input and scene information to web applications. The underlying graphics capabilities from OpenGL ES 3.0

Media 145

Media Games Education Engineering 145

Smashing Magazine

DECEMBER 22, 2021

Their design tools database features tools for everything from UI design and prototyping, to user flow and handoff, design systems and versioning. To help us do better, UX Planet published a four-part article series on streamlining the checkout experience back in 2017 which is still gold for everyone working on a checkout flow today.

Airlines 128

Airlines Mobile Design Strategy 128