Percona

NOVEMBER 1, 2023

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 96

Servers Database Cache C++ 96

Dynatrace

JANUARY 16, 2023

Open-source software drives a vibrant Kubernetes ecosystem. On-premises data centers invest in higher capacity servers since they provide more flexibility in the long run, while the procurement price of hardware is only one of many cost factors. Open source software drives a vibrant Kubernetes ecosystem.

Open Source 345

Open Source Java Operating System Programming 345

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

Percona

DECEMBER 4, 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. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 79

Open Source Azure Servers Programming 79

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 A server restart is not required to add or adjust existing filtering rules. Install the plugin To install Audit Log Filter, proceed with the following steps: Locate the audit_log_filter_linux_install.sql script in the share directory of your Percona Server for MySQL installation.

Open Source 104

Open Source Database Servers Storage 104

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

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

Scalegrid

JULY 17, 2019

As organizations continue to modernize their legacy deployments and shift to open source from commercial database management systems like Oracle, DB2, and SQL Server, PostgreSQL has quickly become the database of choice for both cloud and on-premise deployments.

Azure 182

Azure AWS Open Source Database 182

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Advantages of migrating to open source For many reasons mentioned earlier, organizations are increasingly shifting towards open source databases for their data management needs.

Open Source 92

Open Source Database Hardware Strategy 92

Percona

JANUARY 3, 2024

PMM Dump is included in PMM server distribution, and you can try it straight away. PMM Dump menu is located in the bottom left corner, under the “Help” group: After you click “PMM Dump,” a new dashboard will be opened with a “Create dataset” button. . “Delete” will remove the dump file.

Monitoring 90

Monitoring Open Source Database Servers 90

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. Take a look. Percona Monitoring and Management 2.38.1 PMM) was released on July 13, 2023.

Open Source 73

Open Source Scalability Database Monitoring 73

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++ 93

C++ Open Source Servers Database 93

Percona

MARCH 10, 2023

Consider this: we define a capped collection of size 1GB, it will purge out the oldest document if the allocated size of the collection is full and we have to insert a new document. A capped collection guarantees that it will maintain the document’s insertion order. Create an index to avoid collection scan.

Open Source 103

Open Source Storage Speed Servers 103

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

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 261

Internet Internet Games Java 261

Percona

FEBRUARY 10, 2023

Please check Amazon’s Official Documentation for more information. Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server for MySQL and MySQL. Amazon instance profiles are used to pass IAM roles to an EC2 instance.

Storage 92

Storage Open Source AWS Servers 92

Percona Community

JANUARY 3, 2023

From the documentation: The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL®.

Open Source 58

Open Source Database Servers Systems 58

Percona

APRIL 19, 2023

The Performance Shema now has a Server Telemetry Traces service. We are directed to the Server telemetry traces service section in the MySQL Source Code documentation The SSL library has been updated to OpenSSL version 1.1.1t. Hopefully, UTF8MB4 is good enough. This work started in 2020 and hopefully will be done soon.

Open Source 92

Open Source Servers Scalability Database 92

Percona

JUNE 20, 2023

I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database. pg_config is required to build psycopg2 from source. You can read more about it in Django’s documentation. Django uses it to connect to the database. Interested?

Database 115

Database Open Source Engineering Efficiency 115

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

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 104

Database Open Source Monitoring Innovation 104

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

Testsigma

APRIL 4, 2022

Here are some of the possible quality attributes: Reliability Speed Usability Scalability Maintainability Testability Documentability Trainability Functionality Supportability. If you are new to no-code tools, you can check out Testsigma which is a popular open-source no-code tool Testsigma. Get Testsigma Open Source.

Testing 95

Testing Open Source IoT Programming 95

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 203

Metrics Infrastructure Open Source Database 203

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

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. Before JSON data types were introduced, it was possible to save a JSON document in a text string. JSON is popular. Very popular.

Database 91

Database Servers Processing Efficiency 91

Percona

AUGUST 24, 2023

Welcome to our guide on keeping your Percona Monitoring and Management (PMM) Server and Client up-to-date. Watchtower automates PMM Server updates, while cron jobs handle PMM Client updates. Let’s explore the steps to install, configure, and automate the update process for your PMM Server and Client.

Monitoring 74

Monitoring Servers Processing Database 74

Percona

NOVEMBER 9, 2023

With this data, we’ll be able to better understand and tune our Postgres servers. The main idea is to be able to easily detect what the server is doing at any point in time so we can better understand how it reacts to the workload and tune accordingly. You can search the blog for more information on this if needed.

Monitoring 90

Monitoring Tuning Metrics Servers 90

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. Now part of this stance in the open source world is that there was a lack of tooling for business logic in the past in the MySQL universe. This is in stark contrast to many commercial databases where this is a common practice.

Database 75

Database Open Source Servers Code 75

KeyCDN

JANUARY 14, 2021

React Created as an open source project and still utilized by Facebook, React is a popular JS framework that focuses on user experience. What makes React unique is that it can be rendered either server or client side. The learning curve for this framework is high, partially due to inconsistent project documentation.

Google 135

Google Mobile Open Source Website 135

Percona

MAY 9, 2023

Background story I recently worked with a company running a large four-shard MongoDB Enterprise Server database cluster on VMs on premises that decided to migrate to the Google Cloud Platform. This can be MongoDB Enterprise Server, MongoDB Community Edition, or Percona Server for MongoDB. Don’t start the server yet!

Storage 105

Storage Cloud Servers Google 105

SQL Server According to Bob

OCTOBER 26, 2017

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. Brk2051 sql server on linux and docker from Bob Ward. SQL Server 2017 Release Notes. SQL Server on Linux Release Notes. SQL Server on Linux.

Servers 40

Servers Azure Open Source Database 40

The Netflix TechBlog

OCTOBER 23, 2019

Jeremy Smith , Jonathan Indig , Faisal Siddiqi We are pleased to announce the open-source launch of Polynote : a new, polyglot notebook with first-class Scala support, Apache Spark integration, multi-language interoperability including Scala, Python, and SQL, as-you-type autocomplete, and more.

Open Source 233

Open Source Code Website Design 233

Percona

JULY 19, 2023

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. $ cd $HOME $ wget [link] $ tar -xvzf percona-server-8.0.32-24.tar.gz Next, we need to set up a location for our new plugin within the source tree. Plugin compiled.

C++ 80

C++ Servers Benchmarking Best Practices 80

The Netflix TechBlog

JULY 30, 2019

and beyond By Anoop Panicker and Kishore Banala Conductor is a workflow orchestration engine developed and open-sourced by Netflix. If you’re new to Conductor, this earlier blogpost and the documentation should help you get started and acclimatized to Conductor. and a brief introduction to Conductor API, UI and other modules.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

AUGUST 3, 2023

For further details, you can have a look at the documentation: [link] Generated Invisible Primary Keys This feature has been deployed in MySQL 8.0.30; it’s more recent. Rebuilding an index could require a lot of time and overloading the server, depending on the size of the table. Try Percona Distribution for MySQL today!

Best Practices 78

Best Practices Open Source Code Engineering 78