Percona

AUGUST 21, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since August 7, 2023.

Open Source 81

Open Source AWS Servers Database 81

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. Cloud-based development and deployment One of the main advantages of cloud-based development and deployment is scalability. The main benefits of serverless architecture are cost savings and scalability.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Percona

JULY 10, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since June 26, 2023.

Monitoring 75

Monitoring Open Source Scalability Database 75

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

Percona

MAY 29, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since May 8, 2023.

Open Source 75

Open Source Servers Scalability Database 75

Percona

JULY 24, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since July 10, 2023.

Open Source 71

Open Source Scalability Database Monitoring 71

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 89

Open Source Database Hardware Strategy 89

Percona

OCTOBER 10, 2023

Assuming that there is already a Secrets object holding all system user passwords, the concept is really simple. Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02

Database 92

Database Performance C++ Engineering 92

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 110

Open Source Database Software Software 110

Dynatrace

JUNE 5, 2023

Organizations are increasingly moving to multicloud environments and adopting microservices to increase the efficiency, reliability, and scalability of their applications and services. In the era of in-house, internal-facing databases, manual monitoring and oversight were possible with minimal errors. Information on next steps.

Engineering 193

Engineering Speed Monitoring Efficiency 193

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. In this blog post, we dig into the steps to track down the DROP statements in our database server. sec) We will narrow down the events to log only the drop events for the database-related objects. How does it work?

Servers 81

Servers Database Open Source Scalability 81

Dynatrace

DECEMBER 21, 2023

You might optimize your cooling system or move your data center to a colder region with reduced cooling demands. Reduce the volume of data volumes requested from databases (for example, request all, filter in memory). Next, we consider possible energy savings in the data center. Reduce inter-process communications overhead.

Cloud 214

Cloud Energy Best Practices Cache 214

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52

Tuning Database Performance Hardware 52

The Netflix TechBlog

JANUARY 10, 2024

This architecture shift greatly reduced the processing latency and increased system resiliency. By integrating with studio content systems, we enabled the pipeline to leverage rich metadata from the creative side and create more engaging member experiences like interactive storytelling.

Processing 229

Processing Media Latency Innovation 229

Percona

DECEMBER 12, 2023

sec) mysql> select * from test_tab; select * from test_tab_log; + -+ --+ + | id | test_data | op_time | + -+ --+ + | 1 | lt1 | 2023-11-26 09:59:19 | + -+ --+ + 1 row in set (0.00 sec) + -+ --+ -+ + | id | test_data | op_user | op_time | + -+ --+ -+ + | 1 | lt1 | root@localhost | 2023-11-26 09:59:19 | + -+ --+ -+ + 1 row in set (0.00

Servers 88

Servers Database Testing Open Source 88

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. The popularity of MongoDB MongoDB has emerged as a popular database platform. 5 among all database management systems and No. It ranks No.

Open Source 74

Open Source Database Scalability Software 74

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 is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 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 are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs).

Cloud 77

Cloud Open Source Strategy Best Practices 77

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases. Help systems meet SLAs. Increase system uptime.

DevOps 225

DevOps Efficiency Monitoring Infrastructure 225

Percona

JUNE 15, 2023

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. 2023-06-05T23:31:46.511283Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.28-20)

Servers 82

Servers C++ Database Systems 82

Percona

DECEMBER 20, 2023

we have been able to resize the InnoDB buffer pool online, which allows administrators to adjust the buffer pool size dynamically without requiring a server restart, offering a flexible solution for optimizing system resources. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool.

Monitoring 84

Monitoring Code Open Source Cache 84

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

Dynatrace

MAY 17, 2023

Think about items such as general system metrics (for example, CPU utilization, free memory, number of services), the connectivity status, details of our web server, or even more granular in-application tasks like database queries. Database monitoring Once more, under Applications & Microservices, we’ll also find Databases.

Metrics 176

Metrics Monitoring Database Network 176

Official Blog - World Web Technology

JUNE 13, 2023

A WordPress developer should also be good at various content management systems such as Joomla and Drupal. It includes downloading and setting up the software on a server, database configuration, and theme and plugin installation. In that case, the developer should be able to build scalable WordPress themes and plugins.

Development 52

Development Website Ecommerce Code 52

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. As well, very few cases are in need to have a full system/solution to provide scalability with sharding. The POC Why this POC?

Traffic 121

Traffic Scalability Database Servers 121

Official Blog - World Web Technology

APRIL 12, 2023

Because WordPress is one of the most preferred content management systems to develop highly user-friendly, competitive, and dynamic websites. WordPress is a comprehensive content management system with thousands of free and paid themes and plugins to develop a full-fledged website or web app. Why WordPress?

Development 52

Development Website Ecommerce Programming 52

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. What is PostgreSQL used for? Is PostgreSQL enterprise-ready?

Open Source 76

Open Source Healthcare Social Media Database 76

Percona

AUGUST 18, 2023

uses the Aria engine for system tables. 2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. It also shows the importance of thorough testing in complex database upgrades.

Open Source 65

Open Source Database Storage Engineering 65

Percona

JUNE 2, 2023

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. The project signaled intent to support other databases as early as the 0.7.1 or later or MariaDB 10.3

Open Source 92

Open Source Traffic Tuning Database 92

Percona

NOVEMBER 2, 2023

This blog was originally published in Sept 2021 and was updated in November 2023. Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker.

Database 69

Database Open Source Scalability Virtualization 69

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. What is Prometheus?

Metrics 183

Metrics Engineering Energy Tuning 183

Percona

JULY 27, 2023

on July 17th, 2023. MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. is in October of 2023. The sync_relay_log_info, binlog_format, and group_replication_recovery_complete_at system variables are deprecated and will be removed. Tempus Fugit!

Servers 81

Servers Open Source Tuning Cache 81

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. The definition looks strange, but everything should be more clear, providing a real use case for this feature. Suppose you have SELECT * queries in your application code. Let’s see how it works.

Best Practices 76

Best Practices Open Source Code Engineering 76

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.

Scalability 57

Scalability Best Practices Servers Database 57

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Sharding is a preferred approach for database systems facing substantial growth and needing high availability.

Best Practices 70

Best Practices Traffic Database Servers 70

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. What is the Recovery Time Objective? ” What is the Recovery Point Objective?

Best Practices 78

Best Practices Storage Strategy Database 78