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 81

Database Servers Innovation Open Source 81

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. It opens doors to support more exciting use-cases.

Storage 288

Storage Cache Metrics Database 288

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Percona

NOVEMBER 1, 2023

Percona Distribution for MySQL is the most complete, stable, scalable, and secure open source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use! x are all safe. MariaDB users must upgrade to 10.5.4

Servers 99

Servers Database Cache C++ 99

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 99

Database C++ Servers Open Source 99

High Scalability

APRIL 16, 2019

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability.

Availability 149

Availability Network Azure AWS 149

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. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Type 'help;' or 'h' for help.

Database 98

Database Performance C++ Engineering 98

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

The Netflix TechBlog

MARCH 5, 2019

The second approach is on the diagnosis side: data teams measure the impact of outages and expose patterns across their occurrence, as well as provide a connected view of micro-service-level availability. Can we adjust our auto-scaling policies to be more efficiency without risking our availability during traffic spikes?

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

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. This way, you will have a new instance with a small data directory, so you can use option DATA DIRECTORY without fear of exceeding available disk space.

Open Source 101

Open Source Servers Database Strategy 101

Dynatrace

SEPTEMBER 30, 2021

Cloud migration is the process of transferring some or all your data, software, and operations to a cloud-based computing environment that offers unlimited scale and high availability. Increased scalability. Improved performance and availability. The third big advantage of cloud migration is performance and availability.

Cloud 163

Cloud Traffic Best Practices Strategy 163

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 101

Monitoring Scalability Cache Database 101

Dynatrace

FEBRUARY 10, 2021

Dynatrace is redefining Application Security, applying the automation, AI, scalability, and enterprise-grade robustness of its platform to change the way security gets done. This complements similar drill-downs into applications, services, hosts, and databases. Use role-based permissions for secure access control. Next steps.

Java 240

Java Open Source Engineering Database 240

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 5. Visit website 9.

Development 75

Development Website Design Code 75

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 98

Open Source Traffic Tuning Database 98

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. The auditing plugin overview has been explained in the blog post Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price. How does it work? The drop events are listed below. The drop events are listed below.

Servers 86

Servers Database Open Source Scalability 86

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. Simply put, infrastructure monitoring is the oxygen to your infrastructure, collecting all the data for a complete picture of availability, performance, and resource efficiency.

Infrastructure 196

Infrastructure Monitoring Virtualization Serverless 196

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

Dynatrace

AUGUST 5, 2022

However, that assumes he or she is available and has time to talk. Without it, sending an email over a long distance would require the immediate availability of every node on the routing network to forward each message. As a result of persistent queues, a system benefits from improved performance, reliability, and scalability.

Monitoring 196

Monitoring Serverless Programming Speed 196

Dynatrace

AUGUST 5, 2022

However, that assumes he or she is available and has time to talk. Without it, sending an email over a long distance would require the immediate availability of every node on the routing network to forward each message. As a result of persistent queues, a system benefits from improved performance, reliability, and scalability.

Monitoring 195

Monitoring Serverless Programming Speed 195

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 96

Database Open Source Tuning Traffic 96

Percona

DECEMBER 7, 2023

When combined with the versatility of Docker containers, it becomes a dynamic duo, offering a scalable approach to data backup and recovery. Add data to the database Let’s add some data to the Percona Server database. Create a test database and add a table t1 inside with five rows. Similarly, Percona XtraBackup 8.0

C++ 95

C++ Open Source Servers Database 95

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

Dynatrace

JULY 21, 2020

Hiring mainframe programmers with COBOL skills is challenging nowadays as most of them have retired, whereas Java expertise is widely available. Dynatrace OneAgent automatically connects IBM technologies like CICS, CICS Transaction Gateway, IMS, IMS SOAP Gateway, MQ, as well as DB2 and DL/I databases without any additional configuration.

Java 176

Java Government Database Programming 176

Percona

OCTOBER 13, 2023

This blog will discuss how to debug the core file in VS code. Percona Distribution for MySQL is the most complete, stable, scalable, and secure open source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use!

Code 104

Code C++ Storage Programming 104

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 96

Storage Database Engineering Open Source 96

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 ). What is MariaDB? Elevate your MariaDB environment with Percona Support for MariaDB. Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

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. Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database.

Open Source 83

Open Source Programming Database Servers 83

The Netflix TechBlog

MARCH 10, 2023

Production Use Cases Real-Time APIs (backed by the Cassandra database) for asset metadata access don’t fit analytics use cases by data science or machine learning teams. Such clusters may have different configurations of thread pools to read and write data from database, logging levels and connection configuration with external dependencies.

Media 237

Media Traffic Processing Design 237

Percona

APRIL 10, 2023

In this blog post, I’m going to present a new functionality that is available in MyDumper and will be available in the next release: we added the possibility to build random data based on a format that the user defines. During export, mydumper sends SELECT statements to the database. How does it work?

Testing 108

Testing C++ Open Source Database 108

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. Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01 Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers 113

Servers Storage Database Open Source 113

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 60

Scalability Best Practices Servers Database 60

Dynatrace

APRIL 16, 2020

From figure 5 you can see how errors are impacting the user experience: The front-end UI was designed to not wait for the database activity to complete and would display other content in the UI. SaaS vendor RUM functionality is available for free for new users through September 19, 2020. Click here to learn more about this offer.

Traffic 198

Traffic Government Database Infrastructure 198

Percona

APRIL 11, 2023

Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. In this blog post, we’ll put ourselves to the test and see if we can identify duplicate and redundant indexes in MySQL. Could you identify all nine of them?

Database 93

Database Open Source Testing Design 93

Percona

APRIL 4, 2023

In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. The user attribute feature is available from MySQL 8.0.21, and it comes with a USER_ATTRIBUTES table from information_schema, which provides information about the user comments and user attributes. What is the user attribute?

Open Source 81

Open Source Database Mobile Scalability 81

Percona

APRIL 24, 2023

In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format only. Plain text passwords are extremely vulnerable to unauthorized access, as anyone with access to the database or configuration files can easily read them. These formats include plain text and hashed passwords.

Database 82

Database Best Practices Open Source Testing 82

Percona

MARCH 6, 2023

We will walk through how to figure that out in this blog. The first one has the formula I’ll mention in this blog, and the second has more details regarding Redo Logs. If you want an answer based on detailed information about your database usage and patterns, it’s recommended to use Percona Management and Monitoring.

Tuning 92

Tuning Open Source Database Engineering 92