Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 118

Database Open Source Traffic Small Business 118

Percona

FEBRUARY 9, 2023

Now it is time to get your databases ready for the rest of the year. If you replicate from one server to the next, are you replicating what you need? Take some to check how the server is being accessed, as you do not want a project to use the root access for all queries. Welcome to 2023! First, how are your backups?

Database 93

Database Open Source Hardware Operating System 93

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. For this, best practices would be to segregate commands from data, use parameterized SQL queries, and eliminate the interpreter by using a safe application program interface, if possible.

Open Source 194

Open Source Artificial Intelligence Internet Internet 194

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool?

Open Source 262

Open Source Database Azure Cloud 262

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 76

Database Open Source Servers Code 76

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. Redis Revealed: An Overview Redis, a renowned open-source, in-memory remote dictionary server, stands out for its diverse data structures and advanced features. Data transfer technology.

Cache 130

Cache Storage Scalability Architecture 130

Percona

NOVEMBER 13, 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. Participation in the anonymous program is optional. 26 was released.

Innovation 89

Innovation Open Source Scalability Database 89

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. of enterprise organizations on average.

Strategy 182

Strategy Cloud Java Open Source 182

Percona

SEPTEMBER 21, 2023

You can show your support for open source software by participating in an event next March in Pasadena, California – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America. How does someone learn to program in JavaScript/Go/Rust?

Open Source 113

Open Source Programming Software Software 113

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. Participation in the anonymous program is optional.

Open Source 82

Open Source Azure Servers Programming 82

Percona

DECEMBER 18, 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. Participation in the anonymous program is optional. 1 is based on MySQL 8.2

Monitoring 89

Monitoring Open Source Servers Scalability 89

Official Blog - World Web Technology

AUGUST 27, 2023

Similarly, using the best programming language for your website is also crucial. When it comes to programming languages, you will find many options, but PHP is the most viable option to choose. It is one of the most preferred programming languages used by developers across the globe for website development. What is PHP?

Development 98

Development Ecommerce Open Source Website 98

Dynatrace

JULY 7, 2022

Then, they can split these services into functional application programming interfaces (APIs), rather than shipping applications as one large, collective unit. Microservice design patterns allow developers to use their preferred programming language or framework, which helps to prevent employee churn and the need for outsourced talent.

Architecture 196

Architecture Serverless Azure Programming 196

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 91

Open Source Database Operating System Programming 91

Percona

DECEMBER 27, 2023

of respondents are currently utilizing databases in Kubernetes (k8s). These indicators suggest that the adoption of databases on k8s is in its early stages and is likely to continue growing in the future. The newly formed Open Source AI Alliance , led by META and IBM, promises to support open-source AI.

Cloud 82

Cloud Open Source Strategy Best Practices 82

Official Blog - World Web Technology

NOVEMBER 9, 2023

Choosing the correct programming language for web development is critical for producing outstanding websites. PHP is a popular server-side programming language due to its simplicity of use, vast functionality, and robust community support. What Good Things Does PHP Web Development Do for Your Business?

Website 59

Website Development Open Source Database 59

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

Percona

NOVEMBER 9, 2023

If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. At its core, Kubernetes (often abbreviated as K8s) is an open source tool that automates the deployment, scaling, and management of containerized applications.

Efficiency 105

Efficiency Cloud Healthcare Open Source 105

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? Why not just create another database on the same instance? 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. ln -s /usr/local/Percona-Server-8.0.19-10-Linux.x86_64.ssl101/

Programming 86

Programming Servers Database Hardware 86

Percona

OCTOBER 3, 2023

In database management, job scheduling has always played an important role. However, there is another job scheduler called pg_timetable, which is completely database-driven and provides a couple of advanced concepts. Create a new job to refresh the materialized view each night at 12:00 Postgres server time zone.

Open Source 80

Open Source Database Servers Programming 80

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

Scalegrid

AUGUST 30, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker. Redis Strings.

Cache 232

Cache Ecommerce Social Media Database 232

Percona

APRIL 10, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona Distribution for MySQL (Percona Server for MySQL-based variation) 8.0.32 It’s time for the release roundup!

Open Source 79

Open Source Servers AWS Database 79

HammerDB

MAY 26, 2022

WHY build from source? If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. What programming languages does HammerDB use and why does it matter?

C++ 113

C++ Database Open Source Servers 113

Dynatrace

MAY 23, 2022

Generally speaking, monolithic architecture is composed of three parts: Database. This is usually a relational database management system. Server-side application. Additionally, it will populate HTML views directed to the browser and retrieve, update, and modify data from the associated database. Easier to develop.

Architecture 192

Architecture DevOps Monitoring Programming 192

Scalegrid

MARCH 12, 2019

In Part II, we’re introducing you to an alternative open source tool, Replication Manager from 2ndQuadrant, to be closely followed by Part III where we dive into our third alternative, Patroni by Zalando. When a server is configured, it needs to be registered with repmgr using repmgr primary/standby register command.

Availability 147

Availability Servers Open Source Database 147

Percona

JUNE 20, 2023

Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database.

Database 117

Database Open Source Engineering Efficiency 117

Dynatrace

APRIL 5, 2021

Azure is a large and growing cloud computing ecosystem that empowers its users to access databases, launch virtual servers, create websites or mobile applications, run a Kubernetes cluster, and train machine learning models, to name a few examples. The growth of Azure cloud computing.

Azure 136

Azure Serverless IoT Lambda 136

Dynatrace

JULY 21, 2020

Whether you need to make sure that your SQL database is listening on port 1433 even when there is no traffic, that your switch is responding to a ping or that your DNS server is up and running, the more devices you proactively monitor, the quicker you can react to unforeseen events. Platform extensions.

Infrastructure 152

Infrastructure Monitoring Open Source Traffic 152

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. If all is good, perform the upgrade removing the –check flag.

C++ 83

C++ Open Source Database Programming 83

Dotcom-Montior

OCTOBER 19, 2021

A typical SRE is busy automating, cleaning up code, upgrading servers, and continually monitoring dashboards for performance, etc., Programming Languages. Let us look at some of the most common programming languages an SRE group will encounter, like Python, Golang, and Ruby. so they are going to see more tools in that toolbelt.

Engineering 86

Engineering Open Source Programming Monitoring 86

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 105

Database Servers Open Source Tuning 105

The Polyglot Developer

AUGUST 5, 2016

Not too long ago I wrote an article regarding how to create a RESTful API using the Go programming language , but in it I only used mock data rather than an actual database. What happens if we want to use a database with Golang? What database, or more importantly, what kind of database should be used?

Servers 52

Servers Open Source Programming Database 52

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Inadequate application-side pooling: Suboptimal application-side pooling can lead to opening a large number of connections, and they may remain open and unused, consuming valuable resources. App-Dev often demands unrestricted, uncontrolled access to the database.

Servers 82

Servers Database C++ Airlines 82

Percona

DECEMBER 5, 2022

The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL.

Open Source 69

Open Source C++ Servers Database 69

Dynatrace

APRIL 5, 2021

The 2014 launch of AWS Lambda marked a milestone in how organizations use cloud services to deliver their applications more efficiently, by running functions at the edge of the cloud without the cost and operational overhead of on-premises servers. A new record entering a database table. What is AWS Lambda? Data entering a stream.

Lambda 178

Lambda AWS Serverless Hardware 178