Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 101

Database C++ Servers Open Source 101

Percona Community

APRIL 24, 2022

Author’s Note: Robert will be demoing Liquibase Data at Percona Live 2022 on Wednesday, May 18 at 11:50am. However, the usual Git workflow neglects the database. Add this presentation to your schedule. Git is an amazing tool for collaboration — developers can work together to build better software faster.

Database 52

Database Software Software Development 52

Percona

DECEMBER 12, 2022

Table modifications are a common task for database administrators. 2022-12-09T05:44:23 Dropping new table. 2022-12-09T05:44:23 Dropped new table OK. 2022-12-09T05:57:10 Creating triggers. 2022-12-09T05:57:10 Created triggers OK. 2022-12-09T05:57:10 Copying approximately 10023 rows. Dry run complete.

Database 60

Database Engineering Testing Processing 60

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more.

Artificial Intelligence 187

Artificial Intelligence Innovation Servers Speed 187

DZone

MARCH 13, 2023

The Southwest Airlines fiasco from December 2022 and the FAA Notam database fiasco from January 2023 had one thing in common: their respective root causes were mired in technical debt. At its most basic, technical debt represents some kind of technology mess that someone has to clean up.

Airlines 152

Airlines Engineering Database Technology 152

Dynatrace

APRIL 11, 2023

The CVE Program, which publishes vulnerabilities as they become known, reported a 25% increase in vulnerabilities between 2021 and 2022. 2022 CISO Report: Retail sector – report Dive deep into the state of runtime vulnerability management in retail and how to protect your brand. Learn more with the 2022 InfoSec guide.

Cloud 187

Cloud DevOps Open Source Retail 187

Dynatrace

JUNE 8, 2022

Rollout starts June 8, 2022. Added deeper insight into IBM DB2 database calls by fetching the full SQL statements from the DB2 catalog. The following operating systems will no longer be supported starting 01 July 2022. The following operating systems will no longer be supported starting 01 August 2022. Dynatrace news.

Java 156

Java Operating System Lambda Serverless 156

Percona

MARCH 3, 2023

Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. The person who tried to run this in production did not do the following: Run some previous backups of the rows to delete. Check if the table had referential integrity, child tables. Check the size of the table.

Testing 104

Testing Database Servers Open Source 104

Percona

JANUARY 9, 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. Today’s post includes those releases and updates that have come out since December 27, 2022. was released on December 28, 2022.

Open Source 88

Open Source Database Servers Software 88

Percona

JANUARY 5, 2023

Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 To begin with, we upgraded all the database nodes from 5.7.26 Physical backups are being taken using Percona XtraBackup (PXB) so it does not lock the database during the backup. With MySQL 5.7,

Database 76

Database Servers Open Source Engineering 76

Dynatrace

MARCH 22, 2022

In a presentation at the Perform 2022 conference, Huetter uses the IBM Z platform to expand on the benefits of using an observability platform to manage hybrid cloud infrastructure. The roadmap includes the following: Java Database Connectivity (JDBC) interface tracing. How to modernize for hybrid cloud.

Infrastructure 228

Infrastructure Cloud Java Azure 228

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 164

Traffic Java Network DevOps 164

HammerDB

DECEMBER 1, 2022

For example on Windows an example of opening a new database. Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB If disabled, the SQLite repository database is not opened, and it is not possible to query any jobs related data.

Virtualization 57

Virtualization C++ Storage Database 57

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

Percona

DECEMBER 5, 2022

The need to audit who is using a database and their activities is crucial in many environments. 22 Percona Server (GPL), Release '22', Revision '7e301439b65' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Commands end with ; or g.

Open Source 70

Open Source C++ Servers Database 70

Percona

DECEMBER 23, 2022

Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. This is one of the most used backup tool used for PostgreSQL databases. Pre-configured setup: Patroni configuration setup for two or more databases. Creating the Patroni replica using pgBackRest.

Open Source 64

Open Source Servers Database Availability 64

Percona

DECEMBER 2, 2022

Database-as-code service is a new concept and gaining some popularity in recent years. Now this concept is applied in the database domain as well, assuming SQL as a code to manage database changes (DDL, DML) the same way that applications handle code. To specifically list database changes in order, Liquibase employs a changelog.

Database 56

Database Java Open Source Code 56

Dynatrace

MARCH 28, 2022

While also identifying potential threats, their location, and the vulnerabilities they exploit, Dynatrace provides information about the entire attack path — from source IP to entry point, vulnerability type, and eventual database backend target.

Strategy 182

Strategy Cloud Speed Network 182

Dynatrace

FEBRUARY 2, 2023

In October 2022, Dynatrace and Microsoft extended their deep integration to include metrics and topology from Azure Monitor. This includes Azure services such as App Services & Functions, Azure Databases, Azure Load Balancers, Azure Storage, and many more (see the complete list of services ).

Azure 225

Azure Cloud Monitoring Metrics 225

Dynatrace

AUGUST 18, 2022

These Ansible automation routines can interact with the load balancer or dependent databases to the application server, providing a calculated rolling remediation that considers aspects of the infrastructure and customer experience, not just whether or not the application is responding.

Games 293

Games Monitoring Infrastructure DevOps 293

SQL Performance

OCTOBER 18, 2022

Before SQL Server 2022, there was a workaround that enabled relying on index order, but besides being quite ugly, it had its cost, and the tradeoff wasn’t always acceptable. SQL Server 2022 introduces new ways to apply time-based grouping using the DATE_BUCKET and DATETRUNC functions.

Servers 144

Servers Code Best Practices Database 144

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 88

Servers Systems Processing Database 88

Dynatrace

MAY 19, 2022

As the project matures, more robust sources for flag configuration could be used, perhaps a simple REST API, database, or structured configuration file. OpenFeature is under development, and as part of the industry consortium, we’re planning a general availability release for Fall 2022. What’s next?

Java 257

Java Cloud Code Architecture 257

Percona

MARCH 17, 2023

2022 was an exciting year for Percona Monitoring and Management (PMM). These updates are designed to keep databases running at peak performance and simplify database operations. If we talk about overall disk usage for the instance monitoring 1,000 Database services, the average disk usage per datapoint comes out to be roughly.25

Monitoring 104

Monitoring Scalability Database Cache 104

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 81

Open Source Healthcare Social Media Database 81

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.

Cloud 177

Cloud Infrastructure Innovation Monitoring 177

Dynatrace

OCTOBER 6, 2022

The demo has been in active development since the summer of 2022 with Dynatrace as one of its leading contributors. Both methods ingest data, but by using the Dynatrace OneAgent, users can automatically discover additional insights about their infrastructure, applications, processes, services and databases. OpenTelemetry?community

Open Source 173

Open Source Metrics Tuning Technology 173

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. 23 Web Performance Mistakes to Avoid in 2022 ”, Kashish Kumawat.

Performance 125

Performance Cache Servers Social Media 125

Percona

DECEMBER 19, 2022

Easily restore your MongoDB databases to a previous state. This upgrade addresses several critical and moderate vulnerabilities, including CVE-2022-39328, CVE-2022-39307, and CVE-2022-39306. Some of the key highlights of PMM V2.33 Updated Grafana to version 9.2.5 to fix critical security vulnerabilities. In PMM 2.33.0,

Metrics 52

Metrics Servers Monitoring Open Source 52

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. There hasn’t been any other visible progress, and most of the people I used to work with on sustainability have now left Amazon. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

Percona

JUNE 15, 2023

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. bullseye [112 MB] …… (Reading database. deb (Reading database.

Servers 86

Servers C++ Database Systems 86

HammerDB

NOVEMBER 30, 2022

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. You should already be aware that due to the Python GIL impacting multithreading performance it is not possible to drive a high-performance database workload directly from Python. Why Tcl is 700% faster than Python for database benchmarking.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Percona

DECEMBER 14, 2023

I don’t know, but certainly, the launching of ChatGPT at the end of 2022 sparked a huge hype explosion around that technology throughout this year. I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time.

Database 91

Database Artificial Intelligence Servers Operating System 91

Percona

JANUARY 5, 2023

In PostgreSQL, vacuuming is a maintenance task that helps to optimize database performance and reclaim space. PostgreSQL and other database management systems use MVCC to ensure consistent reads and prevent data loss from concurrent updates. It is essential to run a vacuum to keep the database running smoothly periodically.

Database 108

Database Performance C++ Storage 108

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 persist messages and queue configurations (see “Queues” section) in Redis as hashes. The values in parentheses indicate the offset in days.

Latency 212

Latency Systems Media Serverless 212

O'Reilly

AUGUST 8, 2023

I’m sure that nobody will be surprised that the number of searches for ChatGPT on the O’Reilly learning platform skyrocketed after its release in November, 2022. It’s a widely used platform for building applications that generate queries programmatically and that connects LLMs with each other, with databases, and with other software.

Artificial Intelligence 72

Artificial Intelligence Programming Games Open Source 72

High Scalability

JUNE 22, 2018

using them to respond to storage events on s3 or database events or auth events is super easy and powerful. . $40 million : Netflix monthly spend on cloud services; 5% : retention increase can increase profits 25%; 50+% : Facebook's IPv6 traffic from the U.S, ” at a journalist on the car radio before slamming it off.

Internet 113

Internet Internet Scalability Artificial Intelligence 113