Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Some level of planning is expected when migrating to open source.

Open Source 88

Open Source Database Best Practices Strategy 88

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Database migration is almost always time-consuming, tedious, and full of potential pitfalls. Database migration is complex Let’s start here. What’s your documentation plan?

Database 83

Database Open Source Benchmarking Strategy 83

High Scalability

SEPTEMBER 1, 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 137

Azure Database Benchmarking Performance 137

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 105

Database Open Source Monitoring Innovation 105

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. Feature-wise, it is up there with the best, if not the best.

Database 184

Database Open Source Storage Servers 184

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

Percona Community

FEBRUARY 9, 2022

If you write technical content or just want to become an author, this blog is open to you! We accept any technical articles about databases and open source technologies. In this post, I will explain step by step how to publish a post in our Community Blog. Also, we have no requirements for the uniqueness of the article.

Open Source 52

Open Source Database Technology Technology 52

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. The MariaDB 11 series did not yet have any long-term supported (LTS) releases, which are the releases most would consider for running mission-critical databases in production.

Database 78

Database Servers Innovation Open Source 78

Percona Community

FEBRUARY 22, 2023

In this blog, we will explore databases on containers. We will use Docker as a container engine tool and Percona Server for MySQL as a database administration tool. MySQL is a relational database management system that stores data on disk. Both are open source tools.

Database 89

Database Servers Open Source Engineering 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 97

Database C++ Servers Open Source 97

High Scalability

JANUARY 4, 2019

This post was written by Wendy Dessler of The Blog Frog. Database-as-a-Service (DBaaS) is quickly gaining in popularity across the tech world. These software platform solutions helps users easily manage their database operations without having to really understand any of the abstractions.

DevOps 207

DevOps Database Development Scalability 207

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 92

Database Servers Processing Efficiency 92

Percona

JANUARY 17, 2023

This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The Ultimate Guide to Database Corruption: Part 1 – An Overview. This blog focuses on B-tree indexes and various corruption-related issues that occur with them. Introduction. B-tree index structure.

Database 118

Database Hardware Storage Programming 118

Percona

NOVEMBER 1, 2023

Percona Distribution for MySQL is the most complete, stable, scalable, and secure open source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use! Users of all three major Percona Server for MySQL series – 5.6.38+, 5.7.20+, and 8.0.x

Servers 97

Servers Database Cache C++ 97

Simform

MAY 19, 2022

With so many offerings available, it's a challenge for mobile app developers to select the right database for the right application. This blog consists of general criteria and some use cases based criteria to help developers to build scalable and fast mobile apps.

Mobile 98

Mobile Database Scalability Technology 98

Percona

JUNE 13, 2023

As I wrote in my invitation blog post , we got fortunate this year – Percona Live 2023 took place right after the Denver Marathon, which assembled us to put together a fantastic Database Runs event right before the conference.

Database 83

Database 83

Simform

MAY 9, 2022

Database administrators are responsible for ensuring an application’s availability, its performance, and incorporating changes that developers usually introduce to modify an application. The post Database DevOps: Extending the Power of DevOps for Database Management appeared first on Insights on Latest Technologies - Simform Blog.

DevOps 52

DevOps Database Technology Technology 52

High Scalability

JUNE 8, 2018

Severalnines has spent the last several years writing blogs and crafting content to help make your open source database solutions highly available. Top HA Resources for MySQL & MariaDB.

Open Source 130

Open Source Database Scalability Availability 130

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

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 66

Database Storage Open Source AWS 66

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

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. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Type 'help;' or 'h' for help.

Database 96

Database Performance C++ Engineering 96

DZone

JULY 6, 2023

Azure Cosmos DB is a highly scalable and globally distributed NoSQL database service offered by Microsoft. In this blog post, we will explore best practices and tips for optimizing performance in Azure Cosmos DB. Indexing Strategy As with the other databases, indexing is the first go-to option to improve query performance.

Azure 258

Azure Performance Best Practices Strategy 258

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 262

Google Innovation Cloud Analytics 262

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. ALTER EVENT SESSION [ ADS_Standard_Azure ] ON DATABASE. DROP EVENT sqlserver.

Azure 96

Azure Database Tuning Network 96

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 5. Visit website 9.

Development 75

Development Website Design Technology 75

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’s an underlying web application architecture that makes this process possible.

Architecture 262

Architecture Mobile Website Servers 262

Simform

FEBRUARY 16, 2020

Database Migration is one of those. If you are planning a migration, what are the challenges involved during database migration? Let me walk you through the essentialities before performing database migration. Adopting emerging technologies have helped businesses in leveraging their overall performance.

Database 52

Database Processing Technology Technology 52

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

Percona Community

MARCH 29, 2023

Recently, I’ve noticed several posts on the Percona Community blog about test data generation. This is a great trend, as such data enables us to test applications more easily and efficiently and detect problems before they appear in production.

Testing 98

Testing Database Efficiency 98

Percona

MARCH 22, 2024

PostgreSQL configuration file parameters are very important when managing a PostgreSQL database, and this blog post will discuss the importance of backing those files up. This file contains a range […]

Database 110

Database 110

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. The internals here are outside the scope of this blog post.

Storage 288

Storage Cache Metrics Database 288

Simform

SEPTEMBER 7, 2022

Both Amazon RDS and EC2 can be a great fit for hosting MySQL databases. This blog post compares both services based on various factors to help you choose the best solution depending on your application and business requirements. While RDS is easier to manage and maintain, EC2 gives you more control and flexibility.

Database 52

Database AWS Cloud Development 52

Percona Community

JANUARY 15, 2023

If you’re a Linux user, check the blog post I wrote on Setting up PMM for monitoring MySQL in a local environment. Since many developers and DBAs have Windows desktops, I wanted to demonstrate how to set up PMM on Windows for an easy test environment. In this post, I’ll walk you through setting up PMM with Docker and WSL.

Monitoring 86

Monitoring Database Testing Development 86

Simform

MAY 15, 2020

Database Migration is one of those trends whose charm does not fade and need to be adopted by the existing applications sooner or later. If you are planning for database migration, then you would be keen to know about the actual process involved. Let us explore how database migration work.

Database 52

Database Technology Technology Processing 52

DZone

JULY 3, 2022

This is the second in a series of blogs discussing unified observability with microservices and the Oracle database. This second blog will take a deeper dive into the Metrics, Logs, and Tracing exporters (which can be found at [link] ), describing them and showing how to configure them, Grafana, alerts, etc.

Metrics 246

Metrics DevOps Database Code 246

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