Percona

AUGUST 4, 2023

For MySQL, both releases are made by the same company (Oracle), follow the same version numbering, and the Enterprise version is a superset of what is available in Community. in 2017; after that, major releases came every one to two years, with MariaDB 10.6 It is worth noting that MariaDB 5.2 and MariaDB 5.3 MariaDB 10.1 operates now).

Database 98

Database Servers Innovation Open Source 98

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. Not necessarily: Java-related searches increased by 5% between 2017 and 2018. Coincidence?

Software Architecture 145

Software Architecture DevOps Data Engineering Architecture 145

SQL Server According to Bob

SEPTEMBER 25, 2017

Scott Guthrie and Rohan Kumar officially made the announcement today at Ignite that SQL Server 2017 will be generally available on October 2nd, 2017. Andrew Brust also wrote a very nice article detailing out all the great new features that come with SQL Server 2017. Check out ScottGu’s blog post at: [link].

Servers 40

Servers Availability Tuning Database 40

All Things Distributed

OCTOBER 17, 2016

It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14. In the remainder of 2016 and inq 2017, we will launch another four AWS regions in Canada, China, the United Kingdom, and France, adding another nine AZs to our global infrastructure footprint.

AWS 109

AWS Cloud Infrastructure Storage 109

SQL Server According to Bob

OCTOBER 26, 2017

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. To find out what’s different and new about SQL Server 2017, go to this documentation page: What’s new in SQL Server 2017. SQL Server on Linux.

Servers 40

Servers Azure Open Source Database 40

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 111

Internet Internet AWS Performance 111

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. Finally, I cover missing standard features related to NULL handling in T-SQL and suggest alternatives that are available in T-SQL. NULL as a marker for a missing value.

Best Practices 117

Best Practices C++ Database Code 117

SQL Performance

AUGUST 11, 2021

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. In my examples, I’ll use the sample database TSQLV5.

Azure 139

Azure Code Database Servers 139

SQL Performance

FEBRUARY 12, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. Unfortunately, this clause is not yet available in T-SQL. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12.

C++ 120

C++ Code Servers Database 120

The Morning Paper

NOVEMBER 8, 2020

USENIX is a nonprofit organisation committed to making content and research freely available – both conference proceedings and the recorded presentations of their events. Back in 2017 the engineering team at Facebook had a problem. Once the database was restored to five replicas, we reconfigured back. Every little helps!

Virtualization 126

Virtualization Latency Storage Systems 126

SQL Performance

JULY 9, 2019

This feature is currently not available in T-SQL. At the date of this writing, there's not much information available out there about the true standard nested window functions. 2 2017-09-18 88.80 10248 85 2017-07-04 440.00 180.000000 10249 79 2017-07-05 1863.40 10248 85 2017-07-04 440.00 1 2018-10-03 878.00

Servers 83

Servers Availability Database Code 83

All Things Distributed

JUNE 30, 2017

When you call for customer assistance, you often need to wait for an agent to become available after navigating a set of menus. Once connected, the systems that power call centers generally don't do a good job of using and sharing available information. " Jeff: "No, actually." Does that work? Virginia) region.

Artificial Intelligence 115

Artificial Intelligence Lambda AWS Virtualization 115

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ).

Open Source 98

Open Source Healthcare Social Media Database 98

SQL Performance

JANUARY 23, 2020

Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. There is a single SQL Server database at the heart of every SentryOne monitoring environment, and this customer was monitoring around 600 servers with our software. Query Store 2017 to the Rescue. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. The first was c3.

Virtualization 40

Virtualization AWS Hardware Storage 40

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments.

Open Source 98

Open Source Programming Database Servers 98

The Symphonia

DECEMBER 6, 2017

Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available. there’s no inline debugging available in the Lambda Console.) Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. We plan to test this out when we get the chance.

Serverless 40

Serverless Lambda AWS Traffic 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. In a sharded cluster, each shard acts as an independent database responsible for storing and managing specific data.

Best Practices 98

Best Practices Traffic Database Servers 98

Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. To update our global baseline from 2017, we want to update our priors on a few dimensions: The evolved device landscape. Modern network performance and availability. The Moto G4 , for example. Hard Reset.

Performance 127

Performance Network Mobile Metrics 127

VoltDB

JANUARY 12, 2018

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. Create Better, Real-Time Customer Experiences.

Database 40

Database Blockchain Healthcare Transportation 40

VoltDB

JANUARY 12, 2018

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. Create Better, Real-Time Customer Experiences.

Database 40

Database Blockchain Healthcare Transportation 40

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. A Query Execution Plan is the way a database chooses to run a specific query. Currently, the optimizer hint for the flag ‘ prefer_ordering_index’ is not yet available till version 8.2.0.

Efficiency 126

Efficiency Database Open Source Performance 126

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. These can be invisible to top(8).

Speed 103

Speed Java AWS Virtualization 103

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). With faster disks (i.e. AWS Aurora (based on MySQL 5.6) MySQL on ec2.

Cache 72

Cache C++ AWS Airlines 72

SQL Performance

MARCH 17, 2020

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

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. This service is immediately available in all AWS regions. TrueTime was introduced to support Spanner - Google’s globally distributed, and synchronously-replicated database.

AWS 55

AWS Google Database Virtualization 55

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. The information it captures is, however, available going back somewhat further, providing a fuller picture of the trend lines of engine completeness. Count of APIs available from JavaScript by Web Confluence.

Media 145

Media Games Education Engineering 145

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

FEBRUARY 3, 2020

I was smart and took a backup of the original source, and created a procedure to revert the database back to its initial state. The downside to the latter is that, in SQL Server 2017, you cannot run this online… but you will be able to in 2019. If you want more details on any aspect of this, just ask.

Speed 113

Speed Processing Servers Storage 113

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. Like any hash join, an adaptive join reads all rows available on its build input and copies the required data into a hash table.

Servers 98

Servers Design Database Code 98

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

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. Preferred AMD EPYC Processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

O'Reilly Software

APRIL 4, 2018

Google was among the pioneers that created “web scale” architectures to analyze the massive data sets that resulted from “crawling” the web that gave birth to Apache Hadoop, MapReduce, and NoSQL databases. We usually relate SQL to querying tables in relational databases. Leverage your SQL knowledge. But what is a table?

Architecture 80

Architecture Scalability Google Operating System 80

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB? Elevate your MariaDB environment with Percona Support for MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

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

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

O'Reilly

MARCH 23, 2023

An API for ChatGPT is available. GPT-3 and GPT-4 are not open source, but are available for free and paid access. Poe is a chat app based on Claude, and available through Quora; there is a waiting list for access to the Claude API. LLaMA Developed by Facebook/Meta, and available to researchers by application.

Google 139

Google Open Source Programming Code 139