Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Percona

MARCH 7, 2023

The goal is to simplify the provisioning and management of database capacity. One approach is to separate compute and storage to allow for independent scaling. By separating storage and compute, Neon replaces the PostgreSQL storage layer with data nodes, and compute nodes are distributed across a cluster of nodes.

Serverless 110

Serverless Storage Open Source Architecture 110

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Unfortunately, my excitement was short lived for a couple of reasons.

Azure 96

Azure Database Tuning Network 96

Testsigma

DECEMBER 4, 2020

To ensure quality, mobile app testing is essential. In this blog, we will discuss a step-by-step mobile app testing checklist. This is where cross-platform testing comes into the picture. These may include screen resolution, orientation, different versions of operating systems, camera, motion sensor, etc.

Mobile 65

Mobile Testing Operating System Storage 65

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 104

Performance Monitoring Traffic Database 104

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 98

Monitoring Scalability Cache Database 98

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

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 78

Open Source Healthcare Social Media Database 78

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

AUGUST 5, 2022

A message queue is a form of middleware used in software development to enable communications between services, programs, and dissimilar components, such as operating systems and communication protocols. A message queue enables the smooth flow of information to make complex systems work.

Monitoring 200

Monitoring Serverless Programming Speed 200

Dynatrace

AUGUST 5, 2022

A message queue is a form of middleware used in software development to enable communications between services, programs, and dissimilar components, such as operating systems and communication protocols. A message queue enables the smooth flow of information to make complex systems work.

Monitoring 199

Monitoring Serverless Programming Speed 199

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54

Testsigma

MAY 7, 2020

IBM Big Data and Analytics Hub website cited a case study, where a US insurance company was estimating 15% of their testing efforts to be just test data collection for the backend system and the frontend system. The test data management for the company had become a big problem and had to be solved.

Testing 60

Testing Storage Database Processing 60

Percona

AUGUST 1, 2023

In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, After changing the VARCHAR column size to 200, the following is the storage requirement. Try ALGORITHM=COPY.

Storage 79

Storage Database Open Source Engineering 79

O'Reilly Software

JUNE 12, 2018

The benefits of modeling data as events as a mechanism to evolve our software systems. Data is all-important—vital for the continued success of our businesses—but has also been seen as a massive constraint in how we design and evolve our systems. For as long as we’ve been talking about microservices, we’ve been talking about data.

Database 72

Database Cache Architecture Latency 72

SQL Server According to Bob

DECEMBER 3, 2019

I have previously tested and blogged about the NTFS, sparse, file system limitation error 665: [link] when running DBCC or using Snapshot databases with SQL Server. This paper details XFS storage format and structures: [link] – Specifically the theoretical limits table section. filefrag -v test.dat.

Servers 45

Servers Systems Storage Database 45

Dynatrace

AUGUST 26, 2020

Optimal metric storage management strategy. Dynatrace Managed metric storage management is reliable and delivers high performance. Our new solution for managing metric storage doesn’t reclaim disk space by data compaction. Unlike our competition, Dynatrace Managed processes all the data sent by OneAgent without sampling.

Performance 150

Performance Hardware Java Storage 150

Percona

AUGUST 18, 2023

uses the Aria engine for system tables. I tried the in-place upgrade on my test VM for my own curiosity and got some redo log format errors/Data Dictionary errors. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. to test the binlog compatibility. to MySQL 8.x to MySQL 5.7

Open Source 66

Open Source Database Storage Engineering 66

Percona

DECEMBER 4, 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 Percona Distribution for MySQL (PS- based variant) 8.1.0 Percona Server for MySQL 8.1.0-1

Open Source 79

Open Source Azure Servers Programming 79

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. 29 will let you set up redo log directory while performing a backup.

C++ 104

C++ Servers Storage Speed 104

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. in the directory storage/innobase/ut the following section has UT_RELAX_CPU defined to call the PAUSE instruction on x86.

Testing 48

Testing Tuning Latency Storage 48

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). In addition, there are fewer resources, plugins, libraries, third-party tools, and sources of support available than for other, more established database systems.

Open Source 52

Open Source Servers Storage Scalability 52

The Netflix TechBlog

JULY 30, 2019

The Netflix Media Database (NMDB) is one such example. This allows us to proactively push changes to the open source version while ensuring that the changes are fully functional and well-tested. The workflow status listener provides hooks to connect to any notification system of your choice.

Lambda 189

Lambda Media Open Source Metrics 189

HammerDB

DECEMBER 1, 2022

In particular, after a running a test it would be ideal to have a repository where we could verify the configuration of the workload that was run, the results and any timing or transaction count data generated to bring all the log output into a central location. Jobs Configuration and Storage. HammerDB v4.6 Use a different Browser.

Virtualization 57

Virtualization C++ Storage Database 57

Percona

MAY 9, 2023

Many MongoDB clusters use storage-level snapshots to provide fast and reliable backups. Background story I recently worked with a company running a large four-shard MongoDB Enterprise Server database cluster on VMs on premises that decided to migrate to the Google Cloud Platform.

Storage 104

Storage Cloud Servers Google 104

The Morning Paper

AUGUST 29, 2019

We focused on OLAP-oriented parallel data warehouse products available for AWS and restricted our attention to commercially available systems. As it is infeasible to test every OLAP system runnable on AWS, we chose widely-used systems that represented a variety of architectures and cost models. Key findings. Key findings.

Architecture 76

Architecture Cloud Storage Serverless 76

Dynatrace

SEPTEMBER 30, 2021

AWS Certified SysOps Administrator – Associate: Do you already deploy, manage, and operate AWS system resources and want to learn how to perform those duties even more effectively? Take a trial test at Linux Academy if it’s applicable to the cert you have in mind. Then this one’s for you. Machine learning.

AWS 209

AWS Best Practices Analytics Cloud 209

Percona

JULY 25, 2023

Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. ibd in the test directory. For example, mysql datadir/test/t1.ibd. ibd2sdi data/test/t1.ibd CREATE TABLE test.t1(a

Cache 85

Cache Benchmarking Servers Design 85

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 87

Database Hardware Open Source Strategy 87

The Agile Manager

NOVEMBER 30, 2015

[T]he aim of such systems is ultimately to produce themselves: their own organization and identity is their most important product. -- Gareth Morgan, Images of Organization , p. They are self-referential because a system cannot enter into interactions that are not specified in the pattern of relations that define its organization. -- Ibid, p.

Systems 45

Systems Storage Programming Infrastructure 45

Percona

MARCH 13, 2023

In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 First, let’s try streaming copy from mysql57 to mysql8 server as this does not need additional storage. for this database. 2023-03-01T04:28:38.397836Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-23)

Servers 103

Servers C++ Storage Systems 103

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 91

Open Source Database Hardware Strategy 91

Scalegrid

FEBRUARY 1, 2024

MySQL is a popular open-source relational database management system for online applications and data warehousing. However, data loss is always possible due to hardware malfunction, software defects, or other unforeseen circumstances, just like with any computer system.

Best Practices 130

Best Practices Storage Strategy Database 130

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. It is important to begin with a thorough database backup to prepare for such situations.

Database 162

Database Strategy Servers Best Practices 162

Dynatrace

JANUARY 24, 2020

The sensitive information in each credential, be it a user ID/password or certificate, is stored in Advanced Encryption Standard (AES) encrypted form in the database on the Dynatrace Cluster. You can access the credential vault by API, which lets you integrate it with external credential storage systems.

Monitoring 152

Monitoring Storage Availability Mobile 152

Tasktop

JANUARY 9, 2020

Even better, we can glean valuable end-to-end system data that can be used for higher-level business-centric Flow Metrics , empowering you to generate more business value through your software delivery. . Furthermore, many SaaS vendors purge data periodically to save on storage, limiting your access to historical data.

Software 59

Software Software Metrics Database 59