Scalegrid

MAY 13, 2020

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. High performance, query optimization, open source and polymorphic data storage are the major Greenplum advantages.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Percona

AUGUST 22, 2023

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. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 81

Availability Hardware Open Source Database 81

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 82

Servers C++ Storage Best Practices 82

The Netflix TechBlog

MAY 4, 2023

This blog series will examine the tools, techniques, and strategies we have utilized to achieve this goal. This blog post will provide a detailed analysis of replay traffic testing, a versatile technique we have applied in the preliminary validation phase for multiple migration initiatives.

Traffic 339

Traffic Latency Tuning Systems 339

Dynatrace

AUGUST 11, 2022

Cloud providers then manage physical hardware, virtual machines, and web server software management. This code is then executed on remote servers in response to an event, such as users interacting with functional web elements. Infrastructure as a service (IaaS) handles compute, storage, and network resources.

Development 250

Development Serverless Best Practices Lambda 250

Dynatrace

OCTOBER 7, 2021

Serverless architecture shifts application hosting functions away from local servers onto those managed by providers. This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. As data volumes rapidly increase, streamlined data storage is a top priority.

Serverless 279

Serverless AWS Lambda Storage 279

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. Storage reduction alone results in significant cost savings, and we can save more data in the same space. In this blog, we will discuss both data and network-level compression offered in MongoDB.

Storage 110

Storage Network Open Source Latency 110

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 127

Performance Hardware Tuning Storage 127

Dynatrace

OCTOBER 1, 2020

Applications and services are often slowed down by under-performing DNS communications or misconfigured DNS servers, which can result in frustrated customers uninstalling your application. Identify under-performing DNS servers. Slower response times can be a sign of a stressed DNS server or network communication issues.

Traffic 264

Traffic Network Infrastructure Artificial Intelligence 264

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

SQL Performance

JULY 19, 2022

Each log record has a fixed overhead so, sometimes, the Storage Engine breaks this rule by combining multiple changes into a single log record to reduce the total number of log records written to the log. There are between 70 and 100 log record types, depending on the version of SQL Server (there’s no documented list).

Servers 94

Servers Database Storage Engineering 94

Percona

APRIL 20, 2023

As for FDE, there are multiple options available for PostgreSQL. In this blog post, you will learn: how to leverage FDE on Kubernetes with Percona Operator for PostgreSQL how to start using encrypted storage for already running cluster Prepare In most public clouds, block storage is not encrypted by default.

Storage 121

Storage AWS Cloud Database 121

Percona

MARCH 28, 2023

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside.

Servers 84

Servers Azure AWS Cloud 84

Percona

FEBRUARY 24, 2023

Let’s take a look at how to get the benefits you need while spending less, based on the recommendations presented by Dani Guzmán Burgos, our Percona Monitoring and Management (PMM) Tech Lead, on this webinar (now available on demand) hosted in November last year. Marked in red in Figure 1 is a server with less than 30% of CPU usage.

Cloud 120

Cloud Serverless AWS Storage 120

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 shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

Infrastructure 199

Infrastructure Monitoring Virtualization Serverless 199

Scalegrid

JULY 8, 2019

In this post, we outline the best way to host MySQL on Azure , including managed solutions, instance types, high availability replication, backup, and disk types to use to optimize your cloud database performance. High Availability Deployment. So, how do we configure high availability for MySQL on Azure?

Azure 219

Azure Cloud Virtualization Database 219

Scalegrid

NOVEMBER 29, 2023

This blog post will explore some of the major challenges in database management that businesses can expect, especially when transitioning from traditional database servers. A DBaaS automates several processes, such as using, erasing, and spinning up storage without interventions from IT staff.

Healthcare 130

Healthcare Hardware Database Scalability 130

Dynatrace

SEPTEMBER 29, 2021

Prometheus components include client libraries for application code instrumentation, special-purpose exporters for popular services, and the optional Prometheus server for orchestrating service discovery and data storage. The Dynatrace AMP extension enables you to easily ingest Prometheus metrics into Dynatrace.

Technology 209

Technology Technology Monitoring AWS 209

Scalegrid

JULY 29, 2019

In this blog post, we’ll show you how to create your MySQL deployment at ScaleGrid while setting up your new WordPress site, and how to migrate to a ScaleGrid MySQL deployment for your existing WordPress deployment. High Availability. Test Connectivity Between Your WordPress Site & MySQL Server. Replication. Firewall Rules.

Database 166

Database Cloud Website Azure 166

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. However, simply deploying a monitoring tool is not enough; you need to know which Key Performance Indicators (KPIs) to monitor to gain insights into your MySQL server’s health and performance.

Performance 106

Performance Monitoring Traffic Database 106

Dynatrace

JULY 29, 2021

Smartscape®, our topology-mapping technology, is available out-of-the-box for more than 560 technologies, enabling seamless navigation and analysis. Operations teams can leverage the same approach to improve analytics and insights into data storage, network devices, or even the room temperatures of specific server rooms.

Analytics 246

Analytics Open Source Serverless Architecture 246

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. on, you can use mysqlbinlog to stream binary logs from a remote server.

Best Practices 79

Best Practices Storage Strategy Database 79

Dynatrace

DECEMBER 16, 2021

Since December 10, days after a critical vulnerability known as Log4Shell was discovered in servers supporting the game Minecraft, millions of exploit attempts have been made of the Log4j 2 Java library, according to one team tracking the impact, with potential threat to millions more applications and devices across the globe. Dynatrace news.

Internet 260

Internet Internet Games Java 260

Scalegrid

APRIL 28, 2020

Since database hosting is more dependent on memory (RAM) than storage, we are going to compare various instance sizes ranging from just 1GB of RAM up to 64GB of RAM so you can see how costs vary across different application workloads. Is my database cluster still highly available? DigitalOcean using the below instance types: AWS.

Azure 344

Azure AWS Database Latency 344

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

Percona

SEPTEMBER 12, 2023

this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. This counter value is stored in memory and is not persistent across server restarts. Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00 Trying to reconnect.

Servers 112

Servers Storage Database Open Source 112

Dynatrace

JUNE 16, 2020

One key requirement of a microservices architecture is the ability to make information of all kinds available wherever and whenever it’s needed, without putting undue traffic on corporate and public networks. Apply Davis AI to your TIBCO EMS servers. Synchronous storage size. Async storage size. Storage read size rate.

Storage 133

Storage Metrics Java Architecture 133

Dynatrace

JUNE 8, 2020

However, providing insight into a certain portion of Mission Control health monitoring of Dynatrace Managed deployments has to-date only been available to Dynatrace ONE Premium customers. CPU usage and suspension rates for cluster node processes (namely Server, Cassandra, (embedded) ActiveGate, and Elasticsearch) are also visualized.

Software 165

Software Software Programming Metrics 165

Percona

OCTOBER 13, 2023

MySQL writes a.sdi file to accommodate the serialized dictionary information for storage engines that lack support for this functionality. Storage engine compatibility Different MySQL storage engines handle.sdi files in various ways. Storage engine compatibility Different MySQL storage engines handle.sdi files in various ways.

Storage 95

Storage Database Engineering Open Source 95

Scalegrid

JANUARY 25, 2024

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. This blog post lists the important database metrics to monitor. Connected_slaves provides information about replication status while Used_memory tracks utilized amount of server’s total capacity.

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

DECEMBER 16, 2020

All steps are fully automated, from source code being compiled to binaries, to the upload of the binaries to the AWS infrastructure where they are available for customers to download. Every storage location involving data at rest is encrypted as well. No manual, error-prone steps are involved. Continuous improvements.

Software 232

Software Software Development AWS 232

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 160

Virtualization Infrastructure Monitoring Cloud 160

Percona

JUNE 12, 2023

Read more about this release in the accompanying blog addressing the CVE. Percona Distribution for MySQL is the most stable, scalable, and secure open-source MySQL distribution, with two download options: one based on Percona Server for MySQL and one based on Percona XtraDB Cluster. Percona Server for MySQL 5.7.42-46

Open Source 85

Open Source Servers Database Scalability 85

Percona

AUGUST 30, 2023

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. An incremental backup, which is faster and requires less storage than a full backup, captures changes made since the previous backup.

Database 89

Database Hardware Open Source Strategy 89

Scalegrid

NOVEMBER 12, 2019

In this blog post, we will detail some of these operational challenges with PostgreSQL. In order to work around this, administrators have to deploy a proxy layer on the server-side. When a PostgreSQL master fails, one of the standby servers needs to be elected to master. Why not have this built it into the server?

Database 184

Database Open Source Storage Servers 184

Percona

MAY 8, 2023

For more in-depth information, check out Roma Novikov’s blog covering all things Percona Monitoring and Management 2.37. A freely available MongoDB database alternative, it gives you a single solution that combines enterprise components from the open source community, designed and tested to work together. 14 was released.

Monitoring 79

Monitoring Open Source Database Servers 79

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5.

Open Source 52

Open Source Servers Storage Scalability 52