Scalegrid

AUGUST 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 299

Azure Benchmarking Database Latency 299

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 81

Servers Database Open Source Scalability 81

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 205

Infrastructure Database Monitoring Metrics 205

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Why not have this built it into the server?

Database 184

Database Open Source Storage Servers 184

Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

Servers 273

Servers Monitoring Availability Programming 273

DZone

NOVEMBER 2, 2023

In this blog, you’ll discover what a web app architecture is, how a web application architecture diagram looks, and how you can design the right architecture for web apps. It defines how the data is delivered through HTTP and ensures that the client-side server and the backend server can understand.

Architecture 262

Architecture Mobile Website Servers 262

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 93

Database C++ Servers Open Source 93

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. In this blog post, I will show how Percona Advisors work and demonstrate various checks in action. Day-2 operations for databases are complex.

Database 100

Database Open Source Monitoring Innovation 100

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular. Very popular.

Database 90

Database Servers Processing Efficiency 90

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

DECEMBER 9, 2019

Why exactly this happens is explained in full detail in the blog post by Jean-François Gagné (JF). However, discarding a server like this is expensive and inefficient. Default database: 'test'. Re-Slaving a Crashed #MySQL Master Server in Semisynchronous Replication Setup Click To Tweet. Want to give it a try?

Servers 160

Servers Database Processing Availability 160

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. In this blog post, we describe some best practices for setting up and managing MySQL error logs, general logs and slow query logs for your MySQL deployments. Setting Up MySQL Server Logging.

Servers 247

Servers Best Practices Efficiency Availability 247

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 266

Google Innovation Cloud Analytics 266

DZone

JUNE 30, 2023

Modern languages and frameworks often also abstract away the need to write raw queries, offering high-level interfaces around our database models. In this blog post, I show you how the misuse of a Golang ORM API introduced several SQL injections in Soko, a service deployed on the Gentoo Linux infrastructure.

Infrastructure 263

Infrastructure Database Servers Design 263

High Scalability

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

Servers 187

Servers Programming Monitoring Availability 187

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

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 71

Servers Database Testing Open Source 71

Percona

DECEMBER 8, 2023

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. The only value currently accepted is GroupReplication.

Servers 84

Servers Virtualization Open Source Scalability 84

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

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

Percona Community

APRIL 4, 2022

I love the Raspberry Pi, and I love Percona server. The combination of the two can provide a nice home database. I have been running a Percona Server database since 2019 to hold all the weather information, that I collect from several of my Weather Stations. I did a my first blog post on installing Percona Server 5.7

Servers 52

Servers Database 52

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 65

Database Storage Open Source AWS 65

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. DROP EVENT sqlserver. sql_batch_starting.

Azure 96

Azure Database Tuning Network 96

Percona

MARCH 18, 2024

supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL.In Percona XtraBackup (PXB) version 8.0.28

AWS 90

AWS Servers Database Software 90

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

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

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. In the following sections of this tutorial, we will help you through every step to successfully set […].

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

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. Your MySQL connection id is 256 Server version: 8.0.32-24.2 HaProxy was acting as a load balancer in front of the cluster.

Database 92

Database Performance C++ Engineering 92

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

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 We recommend checking out our products for Percona Server for MongoDB , Percona Backup for MongoDB , and Percona Operator for MongoDB. We also recommend checking out our blog MongoDB: Why Pay for Enterprise When Open Source Has You Covered? Starting from PSMDB 4.4,

Servers 78

Servers C++ Storage Best Practices 78

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more. An example of the self-healing web.

Artificial Intelligence 192

Artificial Intelligence Innovation Servers Database 192

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

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. It is also important to monitor your server’s memory usage regularly to ensure that it is not being exhausted by the buffer pool.

Social Media 119

Social Media Database Servers Cache 119

Scalegrid

SEPTEMBER 18, 2020

One option is purchasing your own CA-signed SSL certificates and configuring them on the MongoDB server. If your application connects to the production database over a public network, do reach out to support@scalegrid.io If you move your code to a new server, it can suddenly stop working. to learn more about this.

C++ 244

C++ Programming Servers Database 244

KeyCDN

OCTOBER 2, 2018

Reading and following the right web development blogs makes it much easier to get a solid education. That’s why in this post, we’ve compiled a list of the top web development blogs that will help you find your footing and acquire essential skills in modern web dev. Visit website 3. Visit website 6. Visit website 9.

Development 75

Development Website Design Code 75

Percona

JUNE 2, 2023

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source.

Open Source 92

Open Source Traffic Tuning Database 92