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 90

Servers Virtualization Open Source Scalability 90

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 76

Servers Database Testing Open Source 76

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

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

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 101

Open Source Servers Database Strategy 101

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 102

Monitoring Scalability Cache Database 102

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 98

Database Performance C++ Engineering 98

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. Percona XtraBackup 8.1

C++ 96

C++ Open Source Servers Database 96

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 99

Open Source Traffic Tuning Database 99

Percona

NOVEMBER 6, 2023

This blog post is a quick look at the release notes to see what these new versions bring to the community. localhost The use of the characters % and _ as wildcards in database-level grants is now deprecated. TO dave will grant user dave access to all the tables in database dave_ but not dave1, davex, or davey. and MySQL 8.2.

Open Source 113

Open Source Database Servers Scalability 113

The Netflix TechBlog

MARCH 5, 2019

Other Relevant Readings More infrastructure-related post from the Netflix Tech Blog How Netflix Works? Authors: Sebastien de Larquier (S&A), Jitender Aswani (DEI) Contributors: Sui Huang (S&A) is partnering on reimagining People initiatives.

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. Compared to MySQL 5.7,

Servers 113

Servers Storage Database Open Source 113

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

Infrastructure 198

Infrastructure Monitoring Virtualization Serverless 198

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.

Open Source 93

Open Source Best Practices Servers Database 93

Percona

JUNE 20, 2023

Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. In this blog post, we’ll explore what it takes to run Django on Kubernetes with Percona Operator. Django uses it to connect to the database.

Database 118

Database Open Source Engineering Efficiency 118

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 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

DECEMBER 13, 2023

Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. In this blog post, we will explore one of the two error filtering methods, specifically focusing on priority-based error log filtering.

Database 97

Database Open Source Tuning Traffic 97

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Results for Percona Server for MySQL 5.7

Cache 105

Cache Hardware Servers Benchmarking 105

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. docker-entrypoint."

Scalability 61

Scalability Best Practices Servers Database 61

Dynatrace

SEPTEMBER 30, 2021

The breadth of fully-featured services, the pay-as-you-go scalability, and the agility of cloud platforms enable organizations to expand their modern approaches to building and managing digital services in a way they can’t with on-premises apps and infrastructure. Increased scalability. Migrate databases intelligently.

Cloud 164

Cloud Traffic Best Practices Strategy 164

Dynatrace

JULY 21, 2020

The Dynatrace Software Intelligence Platform supports you on your way to the enterprise cloud with deep insights into containerized, scalable microservices on cutting-edge technologies like Red Hat OpenShift or Kubernetes. The IMS service flow traverses the IMS SOAP Gateway and different IMS regions, finally hitting a DL/I database.

Java 178

Java Government Database Programming 178

Percona

APRIL 19, 2023

This blog post is a quick review of the release notes looking for the exciting items, and comments in italics are solely my own. The Performance Shema now has a Server Telemetry Traces service. Now instead of upgrading to MySQL Community Server 8.0.33, you might want to look at Percona Server for MySQL.

Open Source 95

Open Source Servers Scalability Database 95

All Things Distributed

FEBRUARY 23, 2011

Werner Vogels weblog on building scalable and robust distributed systems. Free at Last - A Fully Self-Sustained Blog Running in Amazon S3. In a follow up to the last blog post I have removed the last two dependencies this blog had on running a server somewhere: comments are now served by Disqus and search is now handled by Bing.

AWS 78

AWS Storage Big Data Servers 78

Official Blog - World Web Technology

AUGUST 27, 2023

It is a server-side scripting language that is highly secure, open-source, and versatile. Mostly, web servers are created with PHP. In PHP, code is directly executed on the server and generates HTML to send to the client. You can integrate PHP with many technologies, such as databases, web servers, CMS, etc.

Development 98

Development Ecommerce Open Source Website 98

Percona

OCTOBER 13, 2023

Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01 mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 97

Storage Database Engineering Open Source 97

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction.

Open Source 85

Open Source Programming Database Servers 85

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. It also shows the importance of thorough testing in complex database upgrades. to MySQL 8.0, to MySQL 8.x

Open Source 69

Open Source Database Storage Engineering 69

All Things Distributed

AUGUST 17, 2011

Werner Vogels weblog on building scalable and robust distributed systems. No Server Required - Jekyll & Amazon S3. If you have a largely static site you can rely on the enormous power of S3 to make serving your content highly scalable and storing it extremely durable. All Things Distributed. Comments (). at 30,000 feet).

Servers 126

Servers Social Media AWS Website 126

Percona

JULY 19, 2023

In this blog post, you’ll learn how to set up a build environment for compiling your own MySQL plugin to be loaded into MySQL as a function. Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ mkdir ~/percona-server-8.0.32-24/plugin/ulid/

C++ 84

C++ Servers Benchmarking Best Practices 84

Percona

SEPTEMBER 20, 2023

Here’s a brief story of how this could happen, to make it clearer: You’re a DBA managing a few MySQL servers. One of those tools is pt-config-diff ; this tool can show differences within MySQL configuration files and server variables. See more in this blog post: Using MySQL 8 Persisted System Variables.

Open Source 94

Open Source Servers Scalability Database 94

Dynatrace

APRIL 5, 2021

The 2014 launch of AWS Lambda marked a milestone in how organizations use cloud services to deliver their applications more efficiently, by running functions at the edge of the cloud without the cost and operational overhead of on-premises servers. A new record entering a database table. What is AWS Lambda? Data entering a stream.

Lambda 179

Lambda AWS Serverless Hardware 179

Dynatrace

NOVEMBER 23, 2020

After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes. When designing and running modern, scalable, and distributed applications, Kubernetes seems to be the solution for all your needs. What does observability mean for Kubernetes?

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

Percona

DECEMBER 12, 2023

Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’ s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make the replica in sync with the primary.

Servers 94

Servers Database Testing Open Source 94

Percona

MARCH 21, 2023

In this blog, I’ll discuss the use case for replication. In that situation, implementing the upstream changes in a more constrained security context is beneficial to organizations needing privilege-controlled aggregate data from multiple separate databases. It does this to carry out all instructions from its upstream.

Storage 90

Storage Open Source Database Engineering 90

Percona

APRIL 4, 2023

In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. If the server was started with the –skip-grant-tables option. allows database administrators to assign custom key-value pairs to MySQL user accounts. What is the user attribute? sec) Conclusion The user attribute feature in MySQL 8.0.21

Open Source 82

Open Source Database Mobile Scalability 82

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54