Database management

Percona launches open source database management system • The Register

Percona live Open source database services company Percona has confirmed the general availability of a database management platform originally intended for PostgreSQL, MySQL and MongoDB.

Called Percona Platform, the company’s first product will be available as a subscription service aimed at consolidating the management of three open source databases under a single system.

These scripts run against the client’s database configurations and metadata, and determine things like “Shouldn’t an open network port be?” Is there an admin user that shouldn’t be there?

At the center of the platform is Percona Monitoring and Management (PMM), an open source management product that allows developers and database administrators to streamline their tasks across multiple platforms from one place. . These services, as well as the private DBaaS technical preview, are accessible through the Percona portal with a customer account.

Within the monitoring tool, “Advisors” gather recommendations and diagnoses of important security, performance, and configuration issues. The system uses a large set of scripts based on the combined expertise of Percona’s open source database consultants.

At Percona’s annual conference in Texas, Donnie Berkholz, senior vice president of product at Percona, said The register:

“These scripts run against the client’s database configurations and metadata, and determine things like ‘Is there a network port open that shouldn’t be? Is there an admin user that shouldn’t be there? is there a weak password? missing indexes that should be there to speed up performance?’ These are all problems that many DBAs detect the most, but they often overlook a few.”

Researchers from the Attack Surface Management team of Group-IB say they “identified 308,000 incidents of databases exposed to the open web” in 2021.

Percona’s tool is designed for developers who don’t necessarily have the database management expertise, as well as DBAs, who have the expertise, but not necessarily the time as they try to grow systems they manage.

While the platform can be used to manage MySQL, PostgreSQL and MongoDB (the systems supported by Percona services), the company encourages other open source database projects to create tools to provide management who could then connect to its management platform via APIs. .

“The information you might need includes things like current active connections, transactions per second, which can be different from database to database, especially those that don’t track SQL closely”, Berkholz said. The register.

“That’s why we’re investing in the community right now because we want to make it easier. It’s possible today because it’s open source but it’s not as easy as we want it to be. It is difficult for people in the community to get involved because it requires Percona to work closely with the people involved in building the software.

“We want it to be ‘here’s the documentation, here’s the instructions on how to build it, here’s the instructions on how to modify and extend it and now go and when you come back with some kind of connector, fantastic, we’d be happy to review it and accept it.'”

Omnia chief analyst Bradley Shimmin said The register that the management platform would help developers get familiar with their databases.

“What we’re starting to see is a homogenization of resources such that databases are no longer that Middle-earth-like realm where it’s completely alien to most people and populated by some DBAs. really nerdy people who spend all their time optimizing query plans and stuff like that. And it becomes a lot more of an IT department,” he said.

Considered a relatively neutral player in the world of open source databases, Percona was well positioned to consolidate the management of these systems onto a single platform.

“It’s the start of an open ecosystem where it’s not just going to be Percona providing the operators, but also the makers or the maintainers of the databases themselves could be in charge of some of that,” added Shimin. “If this kind of situation occurs and you get an active ecosystem, Percona will be really well placed to energize and help grow the participating databases.” ®