Percona

DECEMBER 27, 2022

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since December 12, 2022. was released on December 19, 2022.

Monitoring 52

Monitoring Open Source Database Servers 52

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 108

Availability Database Open Source Hardware 108

Dynatrace

FEBRUARY 16, 2023

To solve this problem, Dynatrace launched Grail, its causational data lakehouse , in 2022. This unified approach enables Grail to vault past the limitations of traditional databases. And without the encumbrances of traditional databases, Grail performs fast. “In Logs on Grail Log data is foundational for any IT analytics.

Analytics 195

Analytics Innovation Metrics Database 195

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 75

Open Source Database Storage Scalability 75

Enprowess

JANUARY 12, 2022

The Top web development trends in 2022. Let’s dive deep into the top website development trends to expect in 2022. To make it easier for you, in this blog, we will discuss the latest web development trends that will evolve in 2022. List of Top Web Development Trends to Track in 2022. Single Page Applications (SPAs).

Blockchain 59

Blockchain IoT Development Serverless 59

Dynatrace

AUGUST 18, 2022

According to the 2022 CISO Research Report , only 25% of respondents’ security teams “can access a fully accurate, continuously updated report of every application and code library running in production in real-time.” National Vulnerability Database (NVD) lists over 175,000 known vulnerabilities.

Traffic 171

Traffic Java Network DevOps 171

Percona

JULY 3, 2023

Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 83

Storage Database Performance Open Source 83

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. The sample row’s order date is 2022-01-11, so the first delimiter is 2022-01-09. Since this date doesn’t exist in the data, the actual first delimiter is the next existing date, 2022-01-10.

C++ 112

C++ Code Azure Database 112

Dynatrace

MAY 23, 2022

IDC predicted, by 2022, 90% of all applications will feature microservices architectures that improve the ability to design, debug, update, and use third-party code. Generally speaking, monolithic architecture is composed of three parts: Database. This is usually a relational database management system. Teams want efficiency.

Architecture 203

Architecture DevOps Monitoring Programming 203

The Netflix TechBlog

JANUARY 10, 2024

Moving away from the use of dedicated instances that were constrained in quantity, we tapped into Netflix’s internal trough created due to autoscaling microservices, leading to significant improvements in computation elasticity as well as resource utilization efficiency. The results are saved to a database so they can be reused.

Processing 229

Processing Media Latency Innovation 229

Percona

DECEMBER 2, 2022

2022-11-24 11:24:31.330 UTC [2323] ERROR: could not create file "/home/postgres/arch2/archtemp.00000001000000000000007B.2323.1669289071330": This drastically reduces the chance that a broken file in the archive destination can result in archive failures and sometimes even database recoverability. 00000001000000000000007B.2323.1669289071330":

Servers 86

Servers Systems Processing Database 86

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. While sorting may seem simple, it’s important to understand how to do it efficiently and effectively to ensure your queries are optimized and use better indexing.

Efficiency 103

Efficiency Database Open Source Performance 103

Dynatrace

APRIL 15, 2022

At Dynatrace Perform 2022 , David Catanoso, acting director of cloud and edge solutions at the U.S. VA also used Dynatrace to instrument its Consolidated Mail Outpatient Pharmacy Application, a mission-critical app with a heavily distributed database hosted in seven locations across the U.S. Operations teams can run more efficiently.

Cloud 185

Cloud Infrastructure Innovation Monitoring 185

Adrian Cockcroft

NOVEMBER 26, 2023

The Pantheon in Rome — Extremely sustainable architecture — photo by Adrian I wrote a medium post after AWS re:Invent 2022 summarizing the (lack of) news and all the talks related to Sustainability. This includes providing the efficient, resilient services AWS customers expect, while minimizing their environmental footprint.

AWS 52

AWS Energy IoT Best Practices 52

Dynatrace

NOVEMBER 10, 2022

Containers are portable, self-contained operating environments that include applications and the dependencies they need to run, such as databases, middleware, and frameworks. The effect is to turbocharge developer collaboration, efficiency, and productivity. Microservices. The post What is cloud-native architecture?

Cloud 162

Cloud Architecture Serverless Infrastructure 162

Percona

APRIL 10, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. This update includes a fix to the security vulnerability CVE-2022-25834 with PXB-2977. It’s time for the release roundup!

Open Source 78

Open Source Servers AWS Database 78

Smashing Magazine

SEPTEMBER 28, 2022

2022-09-27T14:00:00+00:00. 2022-09-27T16:33:12+00:00. Server caches help lower the latency between a Frontend and Backend; since key-value databases are faster than traditional relational SQL databases, it will significantly increase an API’s response time. Five Data-Loading Patterns To Improve Frontend Performance.

Cache 126

Cache Performance Servers Social Media 126

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. What is PostgreSQL used for? Is PostgreSQL enterprise-ready?

Open Source 78

Open Source Healthcare Social Media Database 78

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. What is an Index?

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

MARCH 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. Take a look!

Open Source 78

Open Source Servers Scalability Cache 78

Dynatrace

SEPTEMBER 23, 2021

They predicted this figure would jump to 75% by 2022. Secrets, such as database credentials, API keys, SSL keys or encryption keys, need to be managed to protect them from discovery. Containers have become hugely popular. In 2019, Gartner reported that 30% of organizations worldwide were running containerized applications.

Open Source 258

Open Source Benchmarking Best Practices Network 258

The Netflix TechBlog

SEPTEMBER 29, 2022

Inside the database, we represent each queue with a sorted set where we rank message IDs (see “Message” section) according to priority. 1661990400000 for 9/1/2022 midnight UTC). We are switching to lexicographical ordering on sorted sets to drop the number of indexes by half, and handle metadata in a more cost-efficient manner.

Latency 212

Latency Systems Media Serverless 212

Smashing Magazine

OCTOBER 11, 2022

2022-10-11T15:30:00+00:00. 2022-10-11T19:03:55+00:00. For example, changing our database architecture to be more efficient could save on server costs. Sustainable Web Development Strategies Within An Organization. Sustainable Web Development Strategies Within An Organization. Michelle Barker.

Strategy 124

Strategy Development Energy Website 124

SQL Performance

JUNE 8, 2022

As in previous parts, code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo. This could be unsafe in case-sensitive databases. For example, the expression DATEFROMPARTS(2022, 07, 11) can be evaluated early to the date value 11 July 2022.

Cache 54

Cache Servers Database Processing 54

Smashing Magazine

MAY 12, 2022

2022-05-12T09:30:00+00:00. 2022-05-12T10:16:36+00:00. CrUX is a cloud-based database into which Real User Measurements (RUM) are collected from live Chrome browser sessions. _developit) February 11, 2022. Gatsby and NextJS are both efficient in terms of the amount of the downloaded image data. Dan Shappir.

Google 128

Google Performance Website Mobile 128

Tasktop

JANUARY 9, 2020

billion by 2022 and growing at a respectable 13.7% Moreover, unique (and unpublished) database schemas per tool require in-depth exploration that steals a lot of precious time from software delivery specialists who should be focusing on their job, not on wading through endless data lakes. Data is the currency of business. .

Software 59

Software Software Metrics Database 59

Dotcom-Montior

FEBRUARY 19, 2022

For that reason, the tools and platforms that an SRE uses can vary greatly from organization to organization, especially in 2022. Additionally, containerization technology lends itself to CI/CD, allowing developers to continuously update code and deploy applications quicker and more efficiently. Kubernetes.

Engineering 52

Engineering Open Source Programming Monitoring 52

O'Reilly

OCTOBER 11, 2022

Gartner has anointed “Hyperautomation” one of the top 10 trends for 2022. However, one thing should be obvious: to fill a prescription, you need to access many different kinds of data, in many different databases. But the gain in efficiency would be relatively small. Should it be? Most are subject to privacy regulations.

Games 114

Games Healthcare Processing Retail 114

O'Reilly

MARCH 23, 2023

ChatGPT, or something built on ChatGPT, or something that’s like ChatGPT, has been in the news almost constantly since ChatGPT was opened to the public in November 2022. 2 However, you don’t need to know how Transformers work to use large language models effectively, any more than you need to know how a database works to use a database.

Google 103

Google Open Source Programming Code 103

O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” ChatGPT was opened to the public on November 30, 2022, roughly a year ago; the art generators, such as Stable Diffusion and DALL-E, are somewhat older.

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106