Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 112

Servers Best Practices Database Open Source 112

Dynatrace

NOVEMBER 18, 2021

Logs include critical information that can’t be found elsewhere, like details on transactions, processes, users, and environment changes. Automatic contextualization of log data works out-of-the-box for popular languages like Java,NET, Node.js, Go, and PHP, as well as for NGiNX and Apache Web servers. New to Dynatrace?

Analytics 217

Analytics Cloud Java Serverless 217

Percona

APRIL 4, 2023

There is a list of the new reserved words later in this document that you need to review. Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word.

Open Source 116

Open Source Database Servers Scalability 116

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.”

Open Source 89

Open Source Database Operating System Programming 89

Percona

DECEMBER 18, 2023

I’ve chosen to minimize the pgloader ETL process by opting to alter the source, MySQL, database’s columnar, and table definitions instead. TIP : O ne should ensure that any changes made to the source database are compatible with the existing application stack before proceeding with the migration. MySQL version 5.7

Open Source 121

Open Source Database Architecture Design 121

Percona

OCTOBER 11, 2023

There are a couple of third-party tools in the market to migrate data from Atlas to Pecona Server for MongoDB (PSMDB), like MongoPush, Hummingbird, and MongoShake. Once you have installed MongoShake, you need to configure it for the migration process. NOTE : These tools are not officially supported by Percona. cd MongoShake.

Database 86

Database Open Source Testing Servers 86

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. PHP is an open-source programming language that allows businesses to use it for free.

Development 98

Development Ecommerce Open Source Website 98

Percona

MARCH 29, 2023

Percona Server for MongoDB (PSMDB) supports all types of compression and enterprise-grade features for free. OS: CentOS Linux 7 I’ve used mgenerate command to insert a sample document. This can further reduce the amount of data that needs to be transmitted between server and client over the network. I am using PSMDB 6.0.4

Storage 108

Storage Network Open Source Latency 108

Percona

AUGUST 30, 2023

Hot backups vs. cold backups: A hot backup — used to minimize downtime and ensure data availability for critical applications — allows you to create a copy of a database while the system is still actively serving user requests and processing transactions. So let’s discuss some options that are open source.

Database 87

Database Hardware Open Source Strategy 87

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. respectively.

C++ 92

C++ Open Source Servers Database 92

Percona

JANUARY 3, 2024

Without the data, Percona experts may ask you multiple questions and request additional information, which can delay the resolution process and increase your frustration. PMM Dump is included in PMM server distribution, and you can try it straight away. However, gathering such information can be challenging and time-consuming.

Monitoring 89

Monitoring Open Source Database Servers 89

Percona

DECEMBER 14, 2023

This streamlined process reduces the risk of errors and simplifies the downgrade procedure. implemented improved data integrity checks during the downgrade process. introduced a simplified downgrade command, which provides a single command to initiate the downgrade process. In summary, the downgrade process in MongoDB 7.0

Database 86

Database Artificial Intelligence Servers Operating System 86

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. Percona has implemented a two-stage release process for each version. Take a look.

Open Source 72

Open Source Scalability Database Monitoring 72

Percona

JUNE 22, 2023

Load balancing : Requests are evenly distributed across multiple database servers, ensuring the system remains operational even if one server fails. Automated failover : To keep the database operational and minimize downtime, it automatically switches to a backup server if the primary server fails.

Availability 107

Availability Database Open Source Hardware 107

Dynatrace

DECEMBER 16, 2021

Since December 10, days after a critical vulnerability known as Log4Shell was discovered in servers supporting the game Minecraft, millions of exploit attempts have been made of the Log4j 2 Java library, according to one team tracking the impact, with potential threat to millions more applications and devices across the globe. Dynatrace news.

Internet 258

Internet Internet Games Java 258

The Netflix TechBlog

MAY 19, 2023

By Chris Wolfe , Joey Schorr , and Victor Roldán Betancort Introduction The authorization team at Netflix recently sponsored work to add Attribute Based Access Control (ABAC) support to AuthZed’s open source Google Zanzibar inspired authorization system, SpiceDB. A cleanup process to prune stale relationships from the database.

Cache 249

Cache Google Open Source Systems 249

Percona

FEBRUARY 20, 2023

This task proved to be quite challenging, as DigitalOcean’s documentation clearly states that “We do not currently support migrating databases from clusters inside of DigitalOcean to other clusters inside of DigitalOcean.” Logical replication may not be enabled if you migrate a database from an on-premises server.

Database 94

Database Open Source Servers Internet 94

Percona

JULY 19, 2023

In the world of modern DevOps, deployment automation tools have become essential for streamlining processes and ensuring consistent, reliable deployments. GitOps and ArgoCD are at the cutting edge of deployment automation, making it easy to deploy complex applications and reducing the risk of human error in the deployment process.

Servers 78

Servers Best Practices DevOps Open Source 78

Scalegrid

JANUARY 3, 2020

Prometheus is an open-source software application used for event monitoring and alerting. The MySQL Exporter tool can be installed locally on a MySQL server or centrally on the Prometheus server. Remember to edit the line: Environment=”GOMAXPROCS=1 by replacing 1 with the number of **vcpus** on your server.

Monitoring 164

Monitoring Metrics Servers Database 164

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources. there cannot be high availability.

Availability 83

Availability Open Source Architecture Database 83

Dynatrace

NOVEMBER 29, 2021

Workloads using multi-threading and multi-processing, or performing many I/O operations, can experience lower execution time and, consequently, even lower costs based on execution time and configured memory size. Analyzing data for fast troubleshooting can be very complex due to the large amounts of data and variety of data sources.

Lambda 206

Lambda AWS Serverless Metrics 206

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 84

Programming Servers Database Hardware 84

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. It has evolved steadily, however, during 25 years as an open source project. Another reason for PostgreSQL popularity (perhaps the biggest): It’s open source and free to use, distribute, and modify. What is PostgreSQL used for?

Open Source 78

Open Source Healthcare Social Media Database 78

Dynatrace

NOVEMBER 16, 2021

Prometheus is an open-source software toolkit used for event monitoring and alerting. This means Dynatrace isn’t collecting the metrics on the Prometheus server, but directly at the source of truth – the exporters. We highly recommend reading the documentation of your exporter to get the right path.

Metrics 193

Metrics Infrastructure Open Source Database 193

Percona

AUGUST 24, 2023

Welcome to our guide on keeping your Percona Monitoring and Management (PMM) Server and Client up-to-date. However, the update process can be complex and time-consuming. Watchtower automates PMM Server updates, while cron jobs handle PMM Client updates. PMM Server installation Installing PMM is a straightforward process.

Monitoring 73

Monitoring Servers Processing Database 73

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JANUARY 17, 2023

Percona Advisors is an open source framework, meaning you can create your own checks by following our documentation. Install PMM by following the documentation. The process of registering PMM in the Platform is described in the documentation. So it is only for debugging and testing purposes. Preparation.

Database 103

Database Open Source Monitoring Innovation 103

Official Blog - World Web Technology

NOVEMBER 24, 2023

It is a JavaScript library that is open-source and popularly used to construct user interfaces (UIs) for the development of web applications. Virtual DOM It means Document Object Model. ReactJS generates a virtual document object model instead of manipulating changes directly. for server-side development.

Development 52

Development Virtualization Open Source Architecture 52

Percona

DECEMBER 15, 2022

For some, the ability to encapsulate a JSON document in a row is a necessity. And if you try to put in a string to that column of integers the server will refuse to accept that row of data. The actual process has a lot more intricacies than that and of course, larger tables take more time to alter. JSON is popular. Very popular.

Database 91

Database Servers Processing Efficiency 91

Percona

MARCH 27, 2023

‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. I created a collection book with four documents with a unique compound index. Below we have already inserted four docs, and now, we will update one of the below documents. sort({$natural:-1}).limit(1)

Games 94

Games Database Open Source C++ 94

Percona

JUNE 27, 2023

GF_SMTP_HOST: Host address of your SMTP server. GF_SMTP_PASSWORD: Password for SMTP authentication GF_SMTP_SKIP_VERIFY: When true, verifies SSL for the SMTP server. NB: Using the default root credentials is not recommended in production environments, and you can find details on setting up a user for PMM in the Percona documentation.

Monitoring 76

Monitoring Open Source Database Servers 76

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. As with any database, developers and DBAs working with MongoDB should look at how to optimize the performance of their database, especially nowadays with cloud services, where each byte processed, transmitted, and stored costs money.

Database 79

Database Servers Storage Strategy 79

Testsigma

APRIL 4, 2022

Automation is defined by Wikipedia as a wide range of technologies that reduce human involvement in processes. Here are some of the possible quality attributes: Reliability Speed Usability Scalability Maintainability Testability Documentability Trainability Functionality Supportability. Get Testsigma Open Source.

Testing 95

Testing Open Source IoT Programming 95

Percona

DECEMBER 29, 2022

The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running. The process using pg_upgrade is well documented , and you can easily find the instructions with little googling. If all is good, perform the upgrade removing the –check flag.

C++ 82

C++ Open Source Database Programming 82

Percona

FEBRUARY 24, 2023

Usage reduction is a continuous process. In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage.

Cloud 118

Cloud Serverless AWS Storage 118

The Netflix TechBlog

DECEMBER 11, 2020

We partnered with Netflix’s Developer Experience (DevEx) team to build out documentation, training materials, and tutorials for developers. The DGS framework is planned to be open-sourced in early 2021. Schema Design Workflow The collaborative design process involves feedback and reviews across team boundaries.

Architecture 249

Architecture Best Practices Engineering Open Source 249

Enprowess

SEPTEMBER 7, 2021

Software Developers got to use JavaScript CLI tools to create the back-end part of web applications or server-side. allows creating web application’s server-side or back-end components. is a server-side, open-source, JavaScript runtime environment that allows developers to write JavaScript on the client and the server-side.

Open Source 52

Open Source Virtualization Programming Servers 52