article thumbnail

PostgreSQL Database Security: External Server-Based Authentication

Percona

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121
article thumbnail

How to Deploy MySQL on Ubuntu and Fully Managed

Scalegrid

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.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

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
article thumbnail

Backup and Recovery for Databases: What You Should Know

Percona

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.

article thumbnail

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Percona

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.

article thumbnail

OneAgent release notes version 1.241

Dynatrace

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. Announcements. Linux: CentOS 8.x.

Java 151
article thumbnail

Crucial Redis Monitoring Metrics You Must Watch

Scalegrid

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