Scalegrid

MARCH 12, 2019

Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL – Part I , we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. Replication Manager (repmgr).

Availability 147

Availability Servers Open Source Database 147

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 82

Servers Database Open Source Scalability 82

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 94

Servers Database Cache C++ 94

Percona

JULY 27, 2023

Today, we know from Oracle’s official blog post what to expect, as well as what the cadence and scope of the upcoming releases will be. The key word is “drop-in,” which means that over the years, we have made an effort to keep Percona Server for MySQL fully compatible with its upstream counterpart from Oracle.

Innovation 70

Innovation Servers Open Source Software 70

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 85

Servers Virtualization Open Source Scalability 85

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. For MySQL, both releases are made by the same company (Oracle), follow the same version numbering, and the Enterprise version is a superset of what is available in Community.

Database 78

Database Servers Innovation Open Source 78

Dynatrace

JULY 29, 2021

The complexity of such deployments has accelerated with the adoption of emerging, open-source technologies that generate telemetry data, which is exploding in terms of volume, speed, and cardinality. Extend your topology mapping to include open-source observability data. Next steps.

Analytics 246

Analytics Open Source Serverless Architecture 246

Dynatrace

OCTOBER 7, 2020

Open-source metric sources automatically map to our Smartscape model for AI analytics. Stay tuned for an upcoming blog series where we’ll give you a more hands-on walkthrough of how to ingest any kind of data from StatsD, Telegraf, Prometheus, scripting languages, or our integrated REST API.

Open Source 250

Open Source Metrics Analytics Tuning 250

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 96

Open Source Servers Database Strategy 96

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 72

Servers Database Testing Open Source 72

Dynatrace

SEPTEMBER 29, 2021

Prometheus is an open-source monitoring and alerting toolkit for services and applications that run in containers. Prometheus components include client libraries for application code instrumentation, special-purpose exporters for popular services, and the optional Prometheus server for orchestrating service discovery and data storage.

Technology 203

Technology Technology Monitoring AWS 203

Percona

JANUARY 3, 2024

That blog introduced a command-line interface. This blog post will show you how to use this feature and what kind of data it collects. PMM Dump is included in PMM server distribution, and you can try it straight away. Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Monitoring 88

Monitoring Open Source Database Servers 88

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

Scalegrid

NOVEMBER 12, 2019

There are many things I love about it – PL/ PG SQL, smart defaults, replication (that actually works out of the box), and an active and vibrant open source community. In this blog post, we will detail some of these operational challenges with PostgreSQL. Why not have this built it into the server?

Database 184

Database Open Source Servers Storage 184

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. Hint Hint, ProxySQL helps.

Performance 103

Performance Monitoring Traffic Database 103

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 There are other options available too when using commitQuorum: “Voting Members” – This is the default behavior when an index will be created on all data-bearing voting replica set members (Default). . PSMDB), the best practice to create an index was doing it in a rolling manner.

Servers 79

Servers C++ Storage Best Practices 79

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

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 88

Open Source Best Practices Servers Database 88

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

Scalegrid

APRIL 28, 2020

DigitalOcean provides many advantages for database hosting, and you can learn more about them in our The Best Way to Host MongoDB on DigitalOcean blog post. Is my database cluster still highly available? DigitalOcean does not have the concept of availability zones (AZ), so we distribute the nodes across different regions.

Azure 344

Azure AWS Database Latency 344

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

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

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

C++ Open Source Servers Database 91

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. Also deprecated is the use of % by the server as a synonym for localhost when checking privileges. In the cases of MySQL servers 8.0.35 Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2.

Open Source 108

Open Source Database Servers Scalability 108

Dynatrace

APRIL 14, 2022

Spring is a widely used open source Java-based framework for building web applications with the Java Enterprise Edition platform. Further, the report lists Tomcat as the most popular Java application server. Figure 2: Spring Controller that maps the DemoObject to requests received at the server. DIRECTORY_OF_CHOICE.

Java 209

Java Servers Code Open Source 209

Official Blog - World Web Technology

NOVEMBER 9, 2023

PHP is a popular server-side programming language due to its simplicity of use, vast functionality, and robust community support. Regarding command-line and server-side scripts, PHP is easy for users to understand and use. PHP can work perfectly on shared hosting and private servers, making it an excellent choice for building websites.

Website 59

Website Development Open Source Database 59

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 90

Open Source Servers Scalability Database 90

Percona

SEPTEMBER 12, 2023

this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. This counter value is stored in memory and is not persistent across server restarts. Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00 Trying to reconnect.

Servers 109

Servers Storage Database Open Source 109

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. The post How to collect Prometheus metrics in Dynatrace appeared first on Dynatrace blog.

Metrics 194

Metrics Infrastructure Open Source Database 194

Scalegrid

AUGUST 26, 2020

MySQL is the number one open source database that’s commonly hosted through Azure instances. While Microsoft offers their own Azure Database product, there are other alternatives available that may be able to help you improve your MySQL performance. MySQL Server Configuration. Sysbench version 1.0.20. Standard_Ds2_v2.

Azure 299

Azure Benchmarking Database Latency 299

Percona

APRIL 26, 2023

Even though open source software is firmly in the mainstream, used widely by businesses, governments, and everyone who owns a cell phone or computer, the question repeatedly arises: “Is open source software safe?” Is open source software as stable as other software? Our bar is higher than that.

Open Source 83

Open Source Software Software Social Media 83

Dynatrace

NOVEMBER 23, 2020

Fortunately, monitoring solutions are available to analyze and display such data, provide deep insights, and take automated actions based on those insights (for example, alerting or remediation). 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.

Virtualization 159

Virtualization Infrastructure Monitoring Cloud 159

Percona

OCTOBER 4, 2023

This blog post covers the main changes in this release. Fix for PT-2168 adds checks for these situations and, depending on the option -- fail - on - stopped - replication , either dies or continues waiting when the replica is available again. Percona Toolkit 3.5.5 was released on October 3, 2023. Download Percona Toolkit

Open Source 98

Open Source Code Testing Systems 98

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 100

Cache Hardware Servers Benchmarking 100

Percona

DECEMBER 13, 2023

In this blog post, we will explore one of the two error filtering methods, specifically focusing on priority-based error log filtering. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing administrators to focus on the most critical issues. Try Percona Distribution for MySQL today!

Database 92

Database Open Source Tuning Traffic 92

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

Percona

DECEMBER 23, 2022

Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. It uses a Distributed Configuration Store (DCS) to keep the configuration in a centralized location available for all nodes making it an easy-to-use and reliable HA solution available in the market today.

Open Source 61

Open Source Servers Database Availability 61