Percona

AUGUST 9, 2023

This upgrade has vastly improved the management and storage of metadata, resulting in better reliability and scalability for various database objects. In this blog post, we will explore the intricacies of MySQL 8’s Transaction Data Dictionary, its advantages, and its real-life application using practical examples.

Database 75

Database Storage Scalability Games 75

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. It opens doors to support more exciting use-cases.

Storage 288

Storage Cache Metrics Database 288

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 73

Open Source Database Storage Scalability 73

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 73

Database Open Source Servers Code 73

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. DBMS enhances data security with encryption, implements various access controls, and enables improved data sharing and concurrent access, thus facilitating quick response to changes and maintaining consistent database accuracy.

Efficiency 147

Efficiency Storage Database Scalability 147

Percona

NOVEMBER 1, 2023

Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00 MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23.

Servers 93

Servers Database Cache C++ 93

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 93

Database C++ Servers Open Source 93

High Scalability

JANUARY 11, 2022

We will use a graph database such as Neo4j to store the information. Additionally, we can use columnar databases like Cassandra to store information like user feeds, activities, and counters. Sample Queries supported by Graph Database. System Components. Component Design. Posting on Instagram. API Design. Data Models.

Design 334

Design Media Storage Logistics 334

Scalegrid

JANUARY 8, 2024

Key Takeaways Multi-cloud involves using services from multiple cloud providers to gain flexibility and reduce vendor lock-in, while hybrid cloud combines private and public cloud resources to balance control and scalability. The reason lies in the unique advantages that come from utilizing a hybrid cloud.

Strategy 147

Strategy Cloud Scalability Artificial Intelligence 147

Scalegrid

FEBRUARY 8, 2024

Key Takeaways Distributed storage systems benefit organizations by enhancing data availability, fault tolerance, and system scalability, leading to cost savings from reduced hardware needs, energy consumption, and personnel. Variations within these storage systems are called distributed file systems.

Storage 130

Storage Systems Big Data Azure 130

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Examples include associations with Google Docs, Facebook chat group interactions, streaming live forex market feeds, and managing trading notices.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Highly Scalable

SEPTEMBER 18, 2012

Scalability is one of the main drivers of the NoSQL movement. These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases.

Database 213

Database Latency C++ Scalability 213

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc.

AWS 52

AWS Database Serverless Storage 52

Percona

FEBRUARY 1, 2023

PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This post will look at using The Oversized-Attribute Storage Technique (TOAST) to improve performance and scalability.

Storage 87

Storage Scalability Strategy Performance 87

Dynatrace

MAY 13, 2022

Apache Cassandra is an open-source, distributed, NoSQL database. Because of its scalability and distributed architecture, thousands of companies trust it to run their cloud and hybrid-based workloads at high availability without compromising performance. Microsoft Azure offers multiple ways to manage Apache Cassandra databases.

Azure 239

Azure Latency Metrics Infrastructure 239

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

High Scalability

JUNE 29, 2018

And if you know anyone looking for a simple book that uses lots of pictures and lots of examples to explain the cloud, then please recommend my new book: Explain the Cloud Like I'm 10. kellabyte : Recently I got to work on a project that really stressed Amazon AWS scalability. Do you like this sort of Stuff? They'll love you even more.

Scalability 131

Scalability Internet Internet Wireless 131

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

High Scalability

JUNE 15, 2018

And if you know anyone looking for a simple book that uses lots of pictures and lots of examples to explain the cloud, then please recommend my new book: Explain the Cloud Like I'm 10. They'll love you even more. Domain Specific Architectures are getting 20x and 40x improvements, not just 5-10%. Hungry for more?

Internet 113

Internet Internet Scalability Blockchain 113

High Scalability

JULY 26, 2018

And if you know anyone looking for a simple book that uses lots of pictures and lots of examples to explain the cloud, then please recommend my new book: Explain the Cloud Like I'm 10. Lance Gutteridge : The reason why almost no one encrypts their databases is one of the dirty secrets of IT. Do you like this sort of Stuff?

Internet 124

Internet Internet Scalability Serverless 124

High Scalability

AUGUST 3, 2018

It was the first use of a todo list as an example. And if you know anyone looking for a simple book that uses lots of pictures and lots of examples to explain the cloud, then please recommend my new book: Explain the Cloud Like I'm 10. Use Multi-AZ deployments for High Availability and Read Replica for read scalability.

Internet 113

Internet Internet Scalability Blockchain 113

The Morning Paper

JUNE 16, 2019

Towards multiverse databases Marzoev et al., The central idea behind multiverse databases is to push the data access and privacy rules into the database itself. With multiverse databases, each user sees a consistent “parallel universe” database containing only the data that user is allowed to see.

Database 90

Database Cache Benchmarking Efficiency 90

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

DECEMBER 21, 2023

And while these examples were resolved by just asking a few questions, in many cases, the answers are more elusive, requiring real-time and historical drill-downs into the processes and dependencies specific to each host. A few examples: Reduce roundtrips between services (for example, the N+1 query pattern).

Cloud 214

Cloud Energy Best Practices Cache 214

Dynatrace

JULY 18, 2023

For example, Real User Monitoring (RUM) can provide an accurate picture of employee or citizen experience with an app. Ensure IT teams have actionable and scalable data to support the agency and its mission The challenges agencies face in accelerating digital transformation are obvious, but meaningful answers are hard to come by.

Government 223

Government Infrastructure Monitoring Database 223

High Scalability

JUNE 22, 2018

And if you know anyone looking for a simple book that uses lots of pictures and lots of examples to explain the cloud, then please recommend my new book: Explain the Cloud Like I'm 10. using them to respond to storage events on s3 or database events or auth events is super easy and powerful. Do you like this sort of Stuff?

Internet 113

Internet Internet Scalability Artificial Intelligence 113

Dynatrace

NOVEMBER 3, 2021

For example, we can actively watch a single metric for changes that indicate a problem — this is monitoring. For example, when monitoring a database, you’ll want to know about any latency when writing data to a disk or average query response time.

Monitoring 226

Monitoring Metrics DevOps Scalability 226

HammerDB

DECEMBER 8, 2020

Additionally these type of displays on devices such as PixelSense on Microsoft Surface Book were popular for presentations and demos and therefore the task was to update the HammerDB display to support scalable graphics. Similarly it was necessary to use scalable fonts to ensure that the text scaled alongside the graphics.

Scalability 52

Scalability Metrics Tuning C++ 52

Scalegrid

DECEMBER 21, 2023

Redis® Monitoring Essentials Ensuring the performance, reliability, and safety of a Redis® database requires active monitoring. With these essential support systems in place, you can effectively monitor your databases with up-to-date data about their health and functioning status at all times.

Strategy 130

Strategy Monitoring Latency DevOps 130

Dynatrace

JANUARY 11, 2023

Database monitoring. This ensures the database queries are performant, while also identifying host problems. For example, uptime detection can identify database instability and help to improve mean time to restoration. APM provides real-time visibility into the status and performance of applications. Website monitoring.

Cloud 227

Cloud Monitoring Best Practices Infrastructure 227

Dynatrace

MAY 17, 2023

Think about items such as general system metrics (for example, CPU utilization, free memory, number of services), the connectivity status, details of our web server, or even more granular in-application tasks like database queries. Let’s take our previous screenshot as an example.

Metrics 175

Metrics Monitoring Database Network 175

Dynatrace

MAY 1, 2023

This operational data could be gathered from live running infrastructures using software agents, hypervisors, or network logs, for example. Identify data use cases and develop a scalable delivery model with documentation. NoSQL database. Automate analytics tools and processes. Establish data governance. Apache Spark.

Analytics 193

Analytics Artificial Intelligence Big Data Open Source 193

Dynatrace

APRIL 20, 2023

With the extent of observability data going beyond human capacity to manage, Grail is the first purpose-built causational data lakehouse that allows for immediate answers with cost-efficient, scalable storage. ” In many cases, indexed databases only provide access to a sample of statistical data summaries.

Analytics 192

Analytics Infrastructure Storage Efficiency 192

VoltDB

JULY 10, 2018

Real-World Example Problem. But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. If the data is common between multiple services, the database layer gets extricated out of microservices in favor of the creation of a common shared data layer.

Architecture 40

Architecture Scalability Ecommerce Latency 40

VoltDB

JULY 10, 2018

Real-World Example Problem. But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. If the data is common between multiple services, the database layer gets extricated out of microservices in favor of the creation of a common shared data layer.

Architecture 40

Architecture Scalability Ecommerce Latency 40

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 95

Monitoring Scalability Cache Database 95

Percona

NOVEMBER 9, 2023

If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. But for those who are not so familiar, in this post, we will discuss how Kubernetes has emerged as the unsung hero in an industry where agility and scalability are critical success factors. have adopted Kubernetes.

Efficiency 99

Efficiency Cloud Healthcare Open Source 99