Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. More in the following sub-section.)

Availability 109

Availability Database Open Source Hardware 109

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 117

Database Open Source Traffic Small Business 117

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 106

Database Benchmarking Latency C++ 106

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. We help you configure your MySQL deployment to optimize your performance based on the size of your databases.

Database 166

Database Cloud Website Azure 166

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 89

Database Hardware Open Source Strategy 89

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 98

Database C++ Servers Open Source 98

Dynatrace

AUGUST 12, 2019

With OneAgent installed on an application server, Davis, the Dynatrace AI causation engine, continuously analyzes all database statements within the context of your applications. Now, with Oracle database insights, we’re going even deeper, giving you visibility into what’s going on in the database layer.

Database 127

Database Metrics Cache Servers 127

Dotcom-Montior

NOVEMBER 24, 2021

Web developers or administrators did not have to worry or even consider the complexity of distributed systems of today. Do you have a database? Do you have a web server? Great, your system was ready to be deployed. Was the database running? Is the web server running? Is the web server running?

Systems 74

Systems Monitoring Hardware Network 74

Dynatrace

MARCH 29, 2024

Check out the following related resources to learn more: Enhancing Duet AI for Developers through our partner ecosystem – Google blog Learn more about the powerful synergy that revolutionizes the cloud landscape when integrating Dynatrace observability with Vertex and Duet AI.

Google 254

Google Innovation Cloud Analytics 254

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

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. In this blog post, we’ll guide you through understanding the PostgreSQL hostname, setting it up correctly, and utilizing it effectively in SQL queries. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections.

Database 130

Database Servers Storage Network 130

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

Scalegrid

MAY 5, 2022

In this blog post, we will show you a step-by-step guide on how to install and set up a MySQL server both manually on the Ubuntu 20.04 operating system, as well as by using ScaleGrid’s managed database service.

Operating System 305

Operating System Database Servers Systems 305

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

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

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

DECEMBER 6, 2022

Percona Server for MySQL 8.0.30-22 22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. Because of this, using the simple plugin with an SSL connection between the MySQL server and client should be preferred over the SASL plugin where possible.

Servers 68

Servers Open Source Scalability Availability 68

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. Enter the New SQL Server Profiler. Legacy Profiler "Standard" trace events.

Azure 96

Azure Database Tuning Network 96

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. In this blog post, you will learn: How to back up and restore from storage snapshots using Percona Operators What the risks and limitations are of such backups Overview Volume Snapshots went GA in Kubernetes 1.20. AWS EBS Snapshots). AWS EBS Snapshots).

Database 68

Database Storage Open Source AWS 68

Dynatrace

MAY 27, 2022

As a result, many IT teams are turning to artificial intelligence for IT operations (AIOps) , which integrates AI into operations to automate systems across the development lifecycle. An IT organization is often unaware a critical server has gone down until a user reports it. An example of the self-healing web.

Artificial Intelligence 180

Artificial Intelligence Innovation Servers Database 180

SQL Performance

JULY 19, 2022

Previously I’ve talked about why logging is required and the architecture and circular nature of the log, so now it’s time to look at the real heart of the logging system—the log records themselves. The simplest definition of a log record: it describes a single change to a database. What Are Log Records? Log Record Contents.

Servers 94

Servers Database Storage Engineering 94

Speed Curve

FEBRUARY 5, 2024

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 57

Servers Cache Retail Benchmarking 57

Dynatrace

JANUARY 31, 2024

This blog post explores how AI observability enables organizations to predict and control costs, performance, and data reliability. GenAI is prone to erratic behavior due to unforeseen data scenarios or underlying system issues. million AI server units annually by 2027, consuming 75.4+

Cache 199

Cache Azure Infrastructure Monitoring 199

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 ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Dynatrace

DECEMBER 12, 2021

The National Vulnerability Database describes the exploit here. This means that an attacker with control over a string that gets passed to the log4j 2 logger can trick the application into requesting a resource from a server under the attacker’s control, then load it, and then execute it. Public Internet Exposure.

Java 236

Java Internet Internet Database 236

Percona

JUNE 2, 2023

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. MySQL was the database for phpWebLog, for example, way back in 2000.

Open Source 97

Open Source Traffic Tuning Database 97

Dynatrace

FEBRUARY 9, 2023

While memory allocation analysis can show wasteful or inefficient code, it can also reveal different problems, one of which we’ll examine in this blog post. In Memory profiling view, we would normally expect to see allocations for protocols and database calls at the top of the list of allocation hotspots.

Java 201

Java Metrics Servers Code 201

Dynatrace

AUGUST 18, 2022

Whether deployment of a new system, a new release, or a rolling patch update, I wanted it done consistently and successfully every time. Because of the quantity of “proper noun solutions” I experienced in my System Administrator career, I wasn’t previously aware of the full spectrum of capabilities in Dynatrace.

Games 287

Games Monitoring Infrastructure DevOps 287

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. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 105

Performance Monitoring Traffic Database 105

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. Assuming that there is already a Secrets object holding all system user passwords, the concept is really simple.

Database 97

Database Performance C++ Engineering 97

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. Recently a customer asked me if they would encounter the same limitation if they moved to Linux.

Servers 45

Servers Systems Storage Database 45

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. However, as the size of your database grows, it can become challenging to manage and optimize its performance. In this blog post, we will explore the benefits of using pgpool-II for PostgreSQL.

Cache 115

Cache Open Source Benchmarking Database 115

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 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. Serverless architecture: A primer. Application integration.

Serverless 273

Serverless AWS Lambda Storage 273

Percona

OCTOBER 17, 2023

This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. MySQL Clone plugin simplifies new replica provisioning but does not simplify server restore after failure unless you are ready to re-install your MySQL instance from scratch.

Open Source 99

Open Source Servers Database Strategy 99

Dynatrace

JUNE 8, 2022

Added deeper insight into IBM DB2 database calls by fetching the full SQL statements from the DB2 catalog. Operating systems. Future Dynatrace OneAgent operating systems support changes. The following operating systems will no longer be supported starting 01 July 2022. Windows: Windows Server 2004. Announcements.

Java 152

Java Operating System Lambda Serverless 152