Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

Percona

APRIL 4, 2023

Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word. Instead, the server informs you that you have a syntax error. Yes, there is a workaround.

Open Source 118

Open Source Database Servers Scalability 118

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. It can perform ETL transforms from one database to another and, under certain special circumstances, can even be implemented as a poor man’s replication solution. MYSQL: OS: Ubuntu 16.04 MySQL version 5.7

Open Source 123

Open Source Database Architecture Design 123

Dynatrace

FEBRUARY 14, 2022

Among these, you can find essential elements of application and infrastructure stacks, from app gateways (like HAProxy), through app fabric (like RabbitMQ), to databases (like MongoDB) and storage systems (like NetApp, Consul, Memcached, and InfluxDB, just to name a few). Topology definition and entity extraction rules. documentation.

Technology 216

Technology Technology Metrics Infrastructure 216

SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. A transaction encompasses a change or a set of changes to a database. Logging, Log Records, and the SQL Server Transaction Log.

Servers 54

Servers Database Architecture Performance 54

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 104

Database Servers Open Source Tuning 104

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 87

Cache Benchmarking Servers Design 87

SQL Performance

SEPTEMBER 29, 2021

A common requirement in ETL and various reporting scenarios is to quietly load a SQL Server staging table in the background, so users querying the data aren’t impacted by the writes and vice-versa. Refreshing Tables in SQL Server. SQL Server Partition Switching Example. definition , 500 ) FROM sys. session_id , o.

Servers 55

Servers Games Database Processing 55

Percona

JULY 19, 2023

In the world of modern DevOps, deployment automation tools have become essential for streamlining processes and ensuring consistent, reliable deployments. GitOps and ArgoCD are at the cutting edge of deployment automation, making it easy to deploy complex applications and reducing the risk of human error in the deployment process.

Servers 80

Servers Best Practices DevOps Open Source 80

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. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup. If your application passes on the test dataset, it is definitely fit to deploy in production!

Analytics 185

Analytics Storage Database Systems 185

Dynatrace

NOVEMBER 3, 2021

Monitoring , by textbook definition, is the process of collecting, analyzing, and using information to track a program’s progress toward reaching its objectives and to guide management decisions. Experienced database administrators learn to spot patterns that can lead to common problems. Monitoring vs. observability.

Monitoring 219

Monitoring Metrics DevOps Scalability 219

Dynatrace

MARCH 17, 2021

A single OneAgent instance can handle the monitoring of many types of entities, including servers, applications, services, databases, and more. You want to optimize your Citrix landscape with insights into user load and screen latency per server? Dynatrace Extensions 2.0 We also give you more value than just metrics and events.

Metrics 169

Metrics Monitoring Network Technology 169

The Netflix TechBlog

JULY 30, 2019

Many of the Netflix Content and Studio Engineering services rely on Conductor for efficient processing of their business flows. The Netflix Media Database (NMDB) is one such example. Adoption As of writing this blog, Conductor orchestrates 600+ workflow definitions owned by 50+ teams across Netflix.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. looking out for MongoDB Inc.

Open Source 83

Open Source Programming Database Servers 83

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. If all is good, perform the upgrade removing the –check flag.

C++ 82

C++ Open Source Database Programming 82

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. The dynamic allocation might have flaws, but it’s definitely a good addition.

Metrics 103

Metrics C++ Storage Database 103

Percona

JANUARY 5, 2023

Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 To begin with, we upgraded all the database nodes from 5.7.26 Physical backups are being taken using Percona XtraBackup (PXB) so it does not lock the database during the backup. With MySQL 5.7, –lock-ddl.

Database 73

Database Servers Open Source Engineering 73

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. CAVEAT: You cannot perform UPDATE, DELETE operations on a columnar table.

Database 92

Database Analytics Storage Processing 92

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. Think about updating a table with millions of rows that refer to another table with another million rows.

Traffic 125

Traffic Scalability Database Servers 125

Percona

JANUARY 4, 2023

MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. Unused indexes are indexes that are created in a database but are not being used in any queries. How to find the duplicate MySQL indexes?

Storage 88

Storage Database Engineering Testing 88

Dynatrace

APRIL 21, 2022

If you still use the legacy version of Log Monitoring ( Log Monitoring v1 ), the Log Monitoring v1 documentation is still available, but we strongly encourage you to switch to the latest Dynatrace Log Monitoring version and gain direct access to the log content of all your mission-critical processes. Kubernetes/OpenShift workload/pod details.

Azure 215

Azure Metrics AWS Monitoring 215

SQL Performance

JULY 14, 2021

The code that I’ll be using in this article can be executed in any database, but in my demos, I’ll be using TSQLV5—the same sample database that I used in previous articles. When you create a view, SQL Server records metadata information in a number of catalog objects. Using SELECT * in the view’s inner query is a bad idea.

Code 117

Code Database Servers Availability 117

Percona

MAY 9, 2023

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. This can be MongoDB Enterprise Server, MongoDB Community Edition, or Percona Server for MongoDB. Don’t start the server yet!

Storage 106

Storage Cloud Servers Google 106

Percona

APRIL 26, 2023

Open source databases, like MySQL and PostgreSQL, are among the most widely used and popular databases for workloads large and small. WordPress, in fact, powers this blog and uses a MySQL database to store its content.) That’s just the most obvious example. Even longer? Open source software can reach its end of life too.

Open Source 85

Open Source Software Software Social Media 85

Dynatrace

MAY 28, 2020

Keptn uses SLO definitions to automatically configure Dynatrace or Prometheus alerting rules. While Google’s SRE Handbook mostly focuses on the production use case for SLIs/SLOs, Keptn is “Shifting-Left” this approach and using SLIs/SLOs to enforce Quality Gates as part of your progressive delivery process.

Engineering 191

Engineering Performance Metrics Best Practices 191

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! Make your job search O (1), not O ( n ). Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

Percona

DECEMBER 27, 2022

character_sets_dir | /usr/share/percona-server/charsets/ |. + --+ -+ Don’t be intimidated – I will simplify the purpose of these settings by grouping them and explaining them. To transfer/interpret during the processing of the character_set. . Server Character Set and Collation. Database Character Set and Collation.

Servers 88

Servers Database Testing Systems 88

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! Learn more here. Search like you mean it. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

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! Learn more here. Search like you mean it. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

Dotcom-Montior

NOVEMBER 24, 2021

Do you have a database? Do you have a web server? Was the database running? Is the web server running? The last item to check was if the web server was able to talk to the database? The last item to check was if the web server was able to talk to the database? Onto the next project.

Systems 74

Systems Monitoring Hardware Network 74

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. A Trigger in MySQL is a database object that plays a pivotal role in database management. What is a Trigger in MySQL?

Cache 62

Cache Database Games Healthcare 62

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. Then follow the instructions to either download the BOL or browse online.

Servers 40

Servers Cache Media Hardware 40

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. Compression: Compression is the process of restructuring the data by changing its encoding in order to store it in fewer bytes.

Open Source 90

Open Source Storage Database Big Data 90

High Scalability

FEBRUARY 1, 2022

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. Pinecone is a vector database that makes it easy to add semantic search to your applications. Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

AUGUST 24, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

DECEMBER 9, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. Pinecone is a vector database that makes it easy to add semantic search to your applications. Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100