DZone

FEBRUARY 12, 2024

Optimizing complex MySQL queries is crucial when dealing with large datasets, such as fetching data from a database containing one million records or more. Poorly optimized queries can lead to slow response times and increased load on the database server, negatively impacting user experience and system performance.

Performance 161

Performance Database Strategy Efficiency 161

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 113

Database Open Source Traffic Small Business 113

Dynatrace

MARCH 6, 2024

IBM i, formerly known as iSeries, is an operating system developed by IBM for its line of IBM i Power Systems servers. It is based on the IBM AS/400 system and is known for its reliability, scalability, and security features. The extension runs remotely from your Dynatrace ActiveGates and connects to your IBM i system.

Monitoring 240

Monitoring Infrastructure Metrics Analytics 240

Scalegrid

JANUARY 8, 2024

This article delves into the specifics of how AI optimizes cloud efficiency, ensures scalability, and reinforces security, providing a glimpse at its transformative role without giving away extensive details. AI models integrated into cloud systems offer flexibility, enable agile methodologies, and ensure secure systems.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 89

Open Source Database Hardware Strategy 89

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

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

Scalegrid

MARCH 28, 2024

In this comparison of Redis vs Memcached, we strip away the complexity, focusing on each in-memory data store’s performance, scalability, and unique features. can enhance Redis by handling management tasks, backups, and scalability, facilitating global reach and easy cloud integration for global businesses.

Cache 130

Cache Storage Scalability Architecture 130

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Percona

OCTOBER 20, 2023

You can read part one here: Scalable Solutions With Percona Distribution for PostgreSQL: Set Up Three PostgreSQL Database Instances. Citus is an open-source extension for PostgreSQL that expands its capacity to manage databases of varying scales, ranging from individual nodes to extensively distributed database clusters.

Scalability 89

Scalability Database Open Source Systems 89

Percona

AUGUST 9, 2023

MySQL 8 brought a significant architectural transformation by replacing the traditional MyISAM-based system tables with the Transaction Data Dictionary (TDD), a more efficient and reliable approach. The primary goal of the Transaction Data Dictionary (TDD) is to enhance the overall performance, stability, and scalability of MySQL databases.

Database 75

Database Storage Scalability Games 75

InfoQ

MAY 15, 2023

A horizontally scalable exabyte-scale blob storage system which operates out of multiple regions, Magic Pocket is used to store all of Dropbox’s data. Adopting SMR technology and erasure codes, the system has extremely high durability guarantees but is cheaper than operating in the cloud. By Facundo Agriel

Storage 110

Storage Systems Scalability Cloud 110

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 110

Open Source Database Software Software 110

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Instead of worrying about infrastructure management functions, such as capacity provisioning and hardware maintenance, teams can focus on application design, deployment, and delivery. Scalability.

Serverless 286

Serverless AWS Lambda Storage 286

Scalegrid

MARCH 22, 2024

This process thoroughly assesses factors like cost-effectiveness, security measures, control levels, scalability options, customization possibilities, performance standards, and availability expectations. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions?

Strategy 130

Strategy Cloud Government Innovation 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. Such demanding use cases place a great value on systems capable of fast and reliable execution, a need that spans across various industry segments.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 85

Database Hardware Open Source Strategy 85

High Scalability

DECEMBER 21, 2018

It's HighScalability time: Have a very scalable Xmas everyone! odrotbohm : I’ve seen microservice based systems more deranged after 2 years than any 1,5 decades old monolith could ever have been. Whether it’s database or message queues it’s a really weird combo of licenses and features for hostage.

Internet 137

Internet Internet Scalability Serverless 137

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

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

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

Scalegrid

MARCH 14, 2024

This approach allows companies to combine the security and control of private clouds with public clouds’ scalability and innovation potential. Understanding Hybrid Cloud Strategy A hybrid cloud merges the capabilities of public and private clouds into a singular, coherent system. A hybrid cloud strategy could be your answer.

Strategy 130

Strategy Cloud Artificial Intelligence Infrastructure 130

Scalegrid

JANUARY 8, 2024

Discover key insights and strategic advice in our article, designed to steer you toward the best cloud solution that fits your company’s priorities. On the other hand, a hybrid model combines at least one private cloud solution with one or more public clouds to strike an optimal balance between security controls and scalability.

Strategy 147

Strategy Cloud Scalability Artificial Intelligence 147

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

High Scalability

JUNE 15, 2018

1.6x : better deep learning cluster scheduling on k8s; 100,000 : Large-scale Diverse Driving Video Database; 3rd : reddit popularity in the US; 50% : increase in Neural Information Processing System papers, AI bubble? Dave Snowden ~ A key principle of complex design is shift a system to an adjacent possible.

Internet 113

Internet Internet Scalability Blockchain 113

Dynatrace

OCTOBER 10, 2023

Process Improvements (50%) The allocation for process improvements is devoted to automation and continuous improvement SREs help to ensure that systems are scalable, reliable, and efficient. SREs invest significant effort in enhancing software reliability, scalability, and dependability.

Engineering 231

Engineering DevOps Innovation Strategy 231

The Morning Paper

DECEMBER 5, 2019

Benchmarking spreadsheet systems Rahman et al., With increasing data sizes… spreadsheets have started to break down to the point of being unusable, displaying a number of scalability problems. They often freeze during computation, and are unable to import datasets well below the size limits posed by current spreadsheet systems.

Benchmarking 56

Benchmarking Systems Google Scalability 56

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. Such a design rules out an entire class of application errors, protecting private data from accidentally leaking. HotOS’19. Managing universes.

Database 90

Database Cache Benchmarking Efficiency 90

Highly Scalable

SEPTEMBER 18, 2012

Scalability is one of the main drivers of the NoSQL movement. As such, it encompasses distributed system coordination, failover, resource management and many other capabilities. These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. System Coordination.

Database 213

Database Latency C++ Scalability 213

High Scalability

JULY 18, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! has hours of system design content. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MAY 4, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! has hours of system design content. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

Dynatrace

DECEMBER 21, 2023

Options at each level offer significant potential benefits, especially when complemented by practices that influence the design and purchase decisions made by IT leaders and individual contributors. You might optimize your cooling system or move your data center to a colder region with reduced cooling demands.

Cloud 214

Cloud Energy Best Practices Cache 214

High Scalability

JUNE 10, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! has hours of system design content. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

Percona

NOVEMBER 13, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download the Updated Release of Percona Distribution for PostgreSQL 16.0 26 was released.

Innovation 83

Innovation Open Source Scalability Database 83

Dynatrace

JULY 7, 2022

Monolithic software systems employ one large codebase, which includes collections of tools, software development kits, and associated development dependencies. Because monolithic software systems employ one large codebase repository, the service becomes a massive piece of software that is labor-intensive to manage.

Architecture 205

Architecture Serverless Azure Programming 205

Percona

MAY 2, 2023

As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? mongodump --host=mongodb1.example.net

Best Practices 52

Best Practices Database Storage Servers 52

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