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 173

Performance Database Strategy Efficiency 173

Dynatrace

MARCH 29, 2024

As organizations continue to expand within cloud-native environments using Google Cloud, ensuring scalability becomes a top priority. Visit Dynatrace booth #1141 during the event to explore how its real-time insights and optimization capabilities ensure seamless scalability and performance.

Google 250

Google Innovation Cloud Analytics 250

InfoQ

MAY 13, 2022

In this article, I want to present a simple cloud architecture that can allow an organization to take monolithic applications to the cloud incrementally without a dramatic change in the architecture. We will discuss the minimal requirements and basic components to take advantage of the scalability of the cloud. By Luciano Mammino.

Cloud 67

Cloud Architecture Scalability Network 67

DZone

APRIL 11, 2023

Data processing in the cloud has become increasingly popular due to its scalability, flexibility, and cost-effectiveness. This article will explore how these technologies can be used together to create an optimized data pipeline for data processing in the cloud.

Azure 246

Azure Analytics Storage Cloud 246

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. Exploring artificial intelligence in cloud computing reveals a game-changing synergy.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. This article cuts through the complexity to showcase the tangible benefits of DBMS, equipping you with the knowledge to make informed decisions about your data management strategies.

Efficiency 147

Efficiency Storage Database Scalability 147

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. In this article, we will explain Redis sharding, explore its pros and cons, and how to apply it. What is Redis Sharding?

Scalability 130

Scalability Efficiency Java Database 130

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

DZone

JULY 3, 2023

However, with the emergence of Infrastructure as Code (IaC) practices, data engineers can now automate infrastructure provisioning, deployment, and management, ensuring reliability, scalability, and reproducibility.

Data Engineering 150

Data Engineering Infrastructure Code Engineering 150

High Scalability

JUNE 29, 2018

kellabyte : Recently I got to work on a project that really stressed Amazon AWS scalability. karmakaze : The key difference is that NoSQL was being developed and used to solve specific issues with using traditional databases. smidgie82 : This article totally ignores the devops side of Docker. You want to talk scale?

Scalability 131

Scalability Internet Internet Wireless 131

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

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

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

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

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

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. This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Dynatrace

JULY 18, 2023

With these tools, agency leaders can empower IT teams to understand how citizens are using digital touchpoints, the obstacles they encounter as they’re using them, and how to eliminate those points of friction, whether in the app, database, or the infrastructure that hosts them. Ready to learn more? Download white paper now!

Government 207

Government Infrastructure Monitoring Database 207

Scalegrid

MARCH 14, 2024

This approach allows companies to combine the security and control of private clouds with public clouds’ scalability and innovation potential. This article will explore hybrid cloud benefits and steps to craft a plan that aligns with your unique business challenges. A hybrid cloud strategy could be your answer.

Strategy 130

Strategy Cloud Artificial Intelligence Infrastructure 130

Scalegrid

MARCH 22, 2024

In this article, we will explain the multi-cloud challenges and explain how using multiple cloud services can make your business more adaptable, ensure that your operations continue without interruption, and help you control your spending. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions?

Strategy 130

Strategy Cloud Government Innovation 130

Percona

NOVEMBER 2, 2023

Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker. ” We intend to show how to bring up PostgreSQL instance(s) into Docker containers.

Database 69

Database Open Source Scalability Virtualization 69

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions.

Benchmarking 308

Benchmarking Latency C++ Database 308

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. I wrote this article based on the Docker-maintained repository. What are MongoDB Docker Containers?

Scalability 58

Scalability Best Practices Servers Database 58

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. In this article, we take a closer look at Prometheus metrics and how we can ingest this data into Dynatrace.

Metrics 169

Metrics Engineering Energy Tuning 169

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. First, some stage-setting for this blog article. The popularity of MongoDB MongoDB has emerged as a popular database platform. It ranks No.

Open Source 75

Open Source Database Scalability Software 75

Percona

SEPTEMBER 28, 2023

Therefore, disabling Transparent Huge Pages for database servers is advisable to avoid this situation. It’s one of the most straightforward tasks we have, but it will give us a lot of performance for our powerful disks, which keeps our databases healthy and durable. You can verify it by executing the same check above.

Servers 109

Servers Best Practices Database Open Source 109

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. As said, the last one is probably the most powerful, scalable, and difficult to design, and unfortunately, it represents probably less than 5% of the solution currently deployed.

Traffic 122

Traffic Scalability Database Servers 122

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

Scalegrid

JANUARY 9, 2024

This article delivers direct insights on solid security frameworks, agile defensive tactics, and compliance adherence, providing the blueprint to reinforce your enterprise against the rigors of the cloud. This ensures the highest level of protection for data stored in these databases on the cloud.

Strategy 130

Strategy Cloud Best Practices Government 130

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Pagination is beneficial in splitting such collections of information, including products, users, articles, etc., So in effect, our page size is 10. The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Smashing Magazine

JULY 16, 2019

The Ultimate Guide To Building Scalable Web Scrapers With Scrapy. The Ultimate Guide To Building Scalable Web Scrapers With Scrapy. Web scraping is a way to grab data from websites without needing access to APIs or the website’s database. 2019-07-16T14:30:59+02:00. 2019-07-16T14:35:52+00:00. Large preview ). extract().

Scalability 87

Scalability Website C++ Servers 87

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. In this article, we will look into this enhancement, compare MySQL 5.7 Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01

Servers 108

Servers Storage Database Open Source 108

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 91

C++ Database Servers Open Source 91

Percona

AUGUST 3, 2023

In this article, I want to discuss a couple of pretty new features in MySQL 8.0 — and an older one. As an experienced database developer, you should know that these kinds of queries should not exist in any production code. Maybe these are minor features you are not aware of, and maybe not so relevant, to be honest.

Best Practices 77

Best Practices Open Source Code Engineering 77

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 78

Availability Hardware Open Source Database 78

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction.

Open Source 81

Open Source Programming Database Servers 81

Tech News Gather

MARCH 30, 2022

It also controls the scalability and the overall cost of the project. In this article, we will see what technology stack to choose for your project? Back-end web development predominantly consists of three parts: a server, an application, and a database. There are numerous options available. But what is a tech stack?

Technology 96

Technology Technology C++ Java 96