Percona

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Also, it is a helpful method for version upgrades since the target database can run on a different (minor or major) PostgreSQL version. to PostgreSQL v15.4.

Database 74

Database Traffic C++ Servers 74

Dynatrace

DECEMBER 10, 2020

During the recent pandemic, organizations that lack processes and systems to scale and adapt to remote workforces and increased online shopping are feeling the pressure even more. Company brands are now measured by the “app” and “app experience” and expect every application to be as fast as Google.

Strategy 177

Strategy Performance Logistics Monitoring 177

Percona

JULY 3, 2023

With Enterprise Linux 7 nearing its end-of-life date, the Percona Monitoring and Management (PMM) team has done a significant update to the base operating system we build our images on top of. we’re making PMM publicly available on a newer base operating system based on Enterprise Linux 9 (EL9), specifically Oracle Linux 9.

Open Source 75

Open Source Metrics Monitoring Operating System 75

Dynatrace

SEPTEMBER 30, 2021

Hosted and moderated by Amazon, AWS GameDay is a hands-on, collaborative, gamified learning exercise for applying AWS services and cloud skills to real-world scenarios. As an AWS Advanced Technology Partner , this was a great opportunity for Dynatrace developers to sharpen their AWS skills and pursue or up-level their Amazon certifications.

AWS 209

AWS Best Practices Analytics Cloud 209

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. Operating System: Ubuntu 22.04 TB)) for storage of database tablespaces and logging.

Performance 54

Performance Benchmarking Cache Storage 54

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

O'Reilly

JUNE 27, 2023

When a person clicked “submit,” the website would pass that form data through some backend code to process it—thereby sending an e-mail, creating an order, or storing a record in a database. With a SQL injection attack, you can “escape” certain characters so that the database doesn’t give them special treatment.

Social Media 90

Social Media Media Website Database 90

HammerDB

JULY 16, 2021

One of the most important concepts in analysing database performance is that of understanding scalability. When a system ‘scales’ it is able to deliver higher levels of performance proportional to the system resources available to it. In this example, we will compare MySQL 5.7.33 and MySQL 8.0.25 and MySQL 8.0.25

Virtualization 57

Virtualization Performance C++ Database 57

Dynatrace

APRIL 21, 2022

Once you have and understand this data, you can identify issues, find opportunities for improvement, and eliminate risks before you go through a costly migration exercise. To optimize your back-end systems, you can use the service flow view within Dynatrace to identify layers of application architecture.

Azure 187

Azure Monitoring Virtualization Metrics 187

Dynatrace

JUNE 1, 2021

Practitioners use APM to ensure system availability, optimize service performance and response times, and improve user experiences. Causes can run the gamut — from coding errors to database slowdowns to hosting or network performance issues. Mobile apps, websites, and business applications are typical use cases for monitoring.

Monitoring 148

Monitoring Mobile Social Media Artificial Intelligence 148

O'Reilly

DECEMBER 12, 2023

This ruling in itself raises many questions: how much creativity is needed, and is that the same kind of creativity that an artist exercises with a paintbrush? The simple RAG pattern, with one prompt orchestrator, one content database, and one language model, will no doubt become more complex.

Artificial Intelligence 101

Artificial Intelligence Media Google Processing 101

J. Paul Reed

AUGUST 7, 2023

In practice (and I’ve done this exercise with teams), this spectrum can provide useful insight. This creates a feedback loop for engineers about the accuracy of their own perceptions of various parts of the socio-technical system in which they work. The Action League: determining the action items since 1995!

Engineering 52

Engineering Hardware Games Infrastructure 52

Dynatrace

SEPTEMBER 20, 2019

Both use the same database back-end and app configuration. The alert comes with the full context of the issue, including errors caused, impacted systems, and level of severity. Step 5 — xMatters Slackbot pulls the on-call database. xMatters Slackbot pulls the on-call database.

Systems 26

Systems Traffic DevOps Database 26

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. One of the most effective ways to tackle performance improvement is having the proper indexes for the table columns.

Best Practices 87

Best Practices Tuning Database Testing 87

The Morning Paper

AUGUST 27, 2019

I am so pleased to see a database systems paper addressing the concerns of the application developer! To the developer, a strongly consistent system behaves exactly like a single-threaded system running on a single node, so reasoning about the behaviour of the system is simple 1. VLDB’19.

Programming 59

Programming Processing Database Systems 59

Adrian Cockcroft

NOVEMBER 11, 2019

A resilient system continues to operate successfully in the presence of failures. There are many possible failure modes, and each exercises a different aspect of resilience. Hence, one way to reduce risk is to make systems more observable. This discussion focuses on hardware, software and operational failure modes.

Latency 52

Latency Engineering Systems Hardware 52

Adrian Cockcroft

NOVEMBER 11, 2019

A resilient system continues to operate successfully in the presence of failures. There are many possible failure modes, and each exercises a different aspect of resilience. Hence, one way to reduce risk is to make systems more observable. This discussion focuses on hardware, software and operational failure modes.

Latency 53

Latency Engineering Systems Hardware 53

The Agile Manager

AUGUST 31, 2020

I've worked with quite a few companies for which long-lived software assets remain critical to day-to-day operations, ranging from 20-year-old ERP systems to custom software products that first processed a transaction way back in the 1960s. The first and most obvious is that they are long on how to start, but short on how to finish.

Architecture 52

Architecture Code Strategy Programming 52

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency. Msg 230, Level 14, State 1.

C++ 109

C++ Database Servers Code 109

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency. Msg 230, Level 14, State 1.

C++ 93

C++ Database Servers Code 93

SQL Server According to Bob

JANUARY 26, 2017

Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 40

SQL Server According to Bob

FEBRUARY 10, 2019

Several event types are included in the health session, some of which include predicates to remove noise from the system health session. The events logged in the system health show a non-yield beginning, then a login timeout occurring and the non-yield ending. I started with a cmd file script exercising the connection path.

Servers 40

Servers Network Database Systems 40

The Morning Paper

NOVEMBER 14, 2019

The deployment of connection-aware routing reduced query-load on backend databases by 17%, compared to a baseline implementation using Social Hash alone. This safety guard ensures larger changes happen in stages, giving caching systems etc. We looked at this before when we studied Facebook’s Social Hashing algorithm.

Traffic 42

Traffic Internet Internet Latency 42

O'Reilly Software

MARCH 7, 2018

Build a more scalable, composable, and functional architecture for interconnecting systems and applications. In addition to that, software is increasingly dependent on other software to provide its functionality, be it WebServices, HTTP APIs, databases, or even external devices such as sensors.

Transportation 72

Transportation Java Programming Architecture 72

The Agile Manager

FEBRUARY 28, 2017

For example, ghost code - code that is not commented out but will conditionally never be executed - is likely to be confused for real code in a reverse-engineering exercise. There are people behind the systems to which we're bound today. Ten years ago, I was leading an inception for a company replacing their fleet maintenance systems.

Strategy 40

Strategy Java Code Systems 40

SQL Performance

SEPTEMBER 25, 2020

Here’s the only item I’ve found that made it to the new feedback system.). errors = [ System.Collections.Generic.List [ Microsoft.SqlServer.TransactSql.ScriptDom.ParseError ] ] ::New ( ) ; # this ultimately won't come from a constant - think file, folder, database. # now we need to try parsing. . {

Code 42

Code C++ Database Servers 42

O'Reilly

JANUARY 17, 2023

You might say that the outcome of this exercise is a performant predictive model. Second, this exercise in model-building was … rather tedious? This person is comfortable talking to databases to pull data, then calling Pandas to transform it. That’s sort of true. And it’s available to everyone. Your Job Has Changed.

Tuning 130

Tuning Open Source AWS Software 130

The Agile Manager

NOVEMBER 26, 2008

User Interface, middle tier, server side, database, specialists in things like ERP systems) or by component (e.g., This means that lots of development tasks may be flagged as “complete” but they’re complete only by assertion of a developer, not by “fact” of somebody who has exercised the code from end-to-end.

Code 40

Code Servers Engineering Programming 40

O'Reilly

OCTOBER 19, 2021

The applications must be integrated to the surrounding business systems so ideas can be tested and validated in the real world in a controlled manner. but to reference concrete tooling used today in order to ground what could otherwise be a somewhat abstract exercise. Why did something break? Who did what and when?

DevOps 138

DevOps Software Engineering Infrastructure Open Source 138

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

All Things Distributed

NOVEMBER 21, 2017

Amazon ElastiCache embodies much of what makes fast data a reality for customers looking to process high volume data at incredible rates, faster than traditional databases can manage. The system is more robust. Redis's microsecond latency has made it a de facto choice for caching. We have also made other enhancements along the way.

Games 113

Games Retail Latency Education 113

All Things Distributed

NOVEMBER 15, 2010

Werner Vogels weblog on building scalable and robust distributed systems. Now that our ability to generate higher and higher clock rates has stalled and CPU architectural improvements have shifted focus towards multiple cores, we see that it is becoming harder to efficiently use these computer systems. All Things Distributed.

AWS 136

AWS Latency Programming Architecture 136

Strategic Tech

DECEMBER 12, 2019

If someone from a different culture with a different naming convention cannot be served by a system, it’s not good business or publicity. Transactional & Invariant Business Rules To enforce business rules in software systems, transactional boundaries need to be identified: which business rules must succeed or fail together.

Healthcare 10

Healthcare Software Architecture Database Software 10

The Netflix TechBlog

MARCH 6, 2019

Mounting object storage in Netflix’s media processing platform By Barak Alon (on behalf of Netflix’s Media Cloud Engineering team) MezzFS (short for “Mezzanine File System”) is a tool we’ve developed at Netflix that mounts cloud objects as local files via FUSE. in Atlas , Netflix’s in-memory dimensional time series database.

Media 214

Media Storage Processing Cache 214