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

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

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 There are other options available too when using commitQuorum: “Voting Members” – This is the default behavior when an index will be created on all data-bearing voting replica set members (Default). . PSMDB), the best practice to create an index was doing it in a rolling manner.

Servers 79

Servers C++ Storage Best Practices 79

The Netflix TechBlog

JUNE 12, 2023

They can also facilitate automations that require information available only in the “login window” context, such as the provided username and password. In its typical configuration the Crypt agent enforces FileVault upon login and escrows the resulting recovery key to a corresponding Crypt server. We call this new tool Escrow Buddy.

Open Source 194

Open Source Database Servers Storage 194

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. On-premises data centers invest in higher capacity servers since they provide more flexibility in the long run, while the procurement price of hardware is only one of many cost factors. Databases : Among databases, Redis is the most used at 60%.

Open Source 343

Open Source Java Operating System Programming 343

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 26 , the Audit Log Filter is available in a technical preview mode. You can filter events based on a user account, audit event class name, audit event subclass name, and audit event fields (database name, table name, operation status, and so on).

Open Source 103

Open Source Database Servers Storage 103

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. You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

APRIL 20, 2023

TDE is a database encryption technique that encrypts data at the column or table level, as opposed to full-disk encryption (FDE), which encrypts the entire database. As for FDE, there are multiple options available for PostgreSQL. The configuration of the storage class depends on your storage plugin.

Storage 119

Storage AWS Cloud Database 119

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. PMM monitors the MySQL uptime: show global status like 'uptime'; Indicates the amount of time (seconds) the MySQL server has been running since the last restart.

Performance 104

Performance Monitoring Traffic Database 104

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This ensures your organization has a compressive look at performance and availability across your entire IT ecosystem. What is infrastructure monitoring? .

Infrastructure 200

Infrastructure Monitoring Virtualization Serverless 200

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

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

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 103

Servers C++ Storage Systems 103

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. Understanding distributed storage is imperative as data volumes and the need for robust storage solutions rise.

Storage 130

Storage Systems Big Data Azure 130

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

SQL Server According to Bob

SEPTEMBER 9, 2019

A handful of lock types (Database, Metadata, LOGIN_STATS, …) are eligible for lock partitioning. For example: When ‘use database’ takes place the session acquires a shared lock on database. Only distinct changes require an exclusive database lock, for example a drop database.

Servers 103

Servers Database Scalability Tuning 103

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. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 79

Open Source Azure Servers Programming 79

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Note: ScaleGrid implements follower clusters using storage snapshots. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup.

Analytics 185

Analytics Storage Database Systems 185

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. this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. Compared to MySQL 5.7,

Servers 110

Servers Storage Database Open Source 110

Percona

OCTOBER 13, 2023

MySQL writes a.sdi file to accommodate the serialized dictionary information for storage engines that lack support for this functionality. Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. sdi -rw-r --.

Storage 93

Storage Database Engineering Open Source 93

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

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

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

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. How-to documentation is readily available.

Open Source 78

Open Source Healthcare Social Media Database 78

Percona

APRIL 24, 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. Percona XtraDB Cluster is based on Percona Server for MySQL. 24 (2023-03-20) release notes.

Open Source 77

Open Source Storage Servers Database 77

Percona

MARCH 21, 2023

In that situation, implementing the upstream changes in a more constrained security context is beneficial to organizations needing privilege-controlled aggregate data from multiple separate databases. If REQUIRE ROW FORMAT is enabled, row-based binary logging (binlog format=ROW) is required on the source server.

Storage 86

Storage Open Source Database Engineering 86

Percona

FEBRUARY 10, 2023

Percona XtraBackup is an open source hot backup utility for MySQL-based servers. To take consistent and hot backup, it uses various locking methods, especially for non-transactional storage engine tables. This feature is available in Percona Server for MySQL 5.6+. So for Percona Server for MySQL 5.7

Storage 100

Storage Engineering Servers Open Source 100

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. It can help us to save costs on storage and backup times. It is available under a paid subscription.

Open Source 87

Open Source Storage Database Big Data 87

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

AUGUST 18, 2023

2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. It also shows the importance of thorough testing in complex database upgrades. /ib_logfile0 which has format (v104) and is stored outside #innodb_redo. to MySQL 8.x x until we are ready for migration to the MySQL 8.x and MySQL 8.0.

Open Source 66

Open Source Database Storage Engineering 66

Dynatrace

FEBRUARY 1, 2024

Maintaining optimal application performance is crucial for businesses, and fast databases are vital in achieving this goal. For an effective approach to database performance, it’s crucial to have a comprehensive overview of all databases, including server-side DBs.

Database 184

Database Monitoring Games Metrics 184

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. 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.

Cache 85

Cache Benchmarking Servers Design 85

SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. Organizations are taking advantage of having managed backups, lots of built-in security features, an uptime SLA of 99.99%, and an always up-to-date environment where they are no longer responsible for patching SQL Server or the operating system.

Azure 63

Azure Performance Storage Latency 63

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. IT professionals are familiar with scoping the size of VMs with regards to vCPU, memory, and storage capacity. The various types are: General purpose – Balanced CPU-to-memory ratio, small to medium databases.

Azure 76

Azure Benchmarking Storage Virtualization 76

Percona

DECEMBER 27, 2023

of respondents are currently utilizing databases in Kubernetes (k8s). These indicators suggest that the adoption of databases on k8s is in its early stages and is likely to continue growing in the future. According to the Dynatrace Kubernetes in the Wild 2023 report , a significant 71% (with 48% year-over-year growth!)

Cloud 79

Cloud Open Source Strategy Best Practices 79

Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL interface where you can view all of the data.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321