MongoDB Security vs. Five ‘Bad Guys’

MongoDB Security

Most any commercially mature DBMS provides the following five ways to secure the data you keep inside it:

Authentication of user connections (== Identity)
Authorization (== DB command permissions) (a.k.a. Role-based access control)
Network Encryption (a.k.a. Transport encryption)
Storage Encryption (a.k.a. Encryption-at-rest)
Auditing (MongoDB Enterprise or Percona Server for MongoDB only)

MongoDB is no exception. All of these have been […]

Read more

Percona XtraBackup 2.4.15 Is Now Available

Percona XtraBackup 8.0

Percona is glad to announce the release of Percona XtraBackup 2.4.15 on July 10, 2019. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. […]

Read more

PostgreSQL WAL Retention and Clean Up: pg_archivecleanup

WAL retention is a very important topic for PostgreSQL database management. But very often we come across DBAs getting into surprise situations such as:
1. Several TBs of WALs piled up in archive destination
2. WALs filling up pg_wal/pg_xlog directory due to failing archive
3. Necessary WALs are no longer preserved
External backup projects for PostgreSQL are good […]

Read more

Upcoming Webinar 7/10: Learn how to run MongoDB Inside of a Containerized Environment

MongoDB Inside of a Containerized Environment

Please join Percona Consultant Doug Duncan as he presents his talk “Building Kubernetes Operator for Percona Server for MongoDB” on Wednesday, July 10th, 2019 at 10:00 AM PDT (UTC-7).
Register Now
Doug will discuss the basic knowledge needed to understand the complications of running MongoDB inside of a containerized environment and then to go over the […]

Read more

MongoDB Disaster, Snapshot Restore and Point-in-time Replay

MongoDB update schema disaster

Mistakes can happen. If only we could go back in time to the very second before that mistake was made.
Act 1: The Disaster

Plain text version for those who cannot run the asciicast above:

Shell

akira@perc01:/data$ #OK, let’s get this party started!
akira@perc01:/data$ # The frontend has been shut down for 20 mins so they can
akira@perc01:/data$ # update […]

Read more

Percona Server for MySQL Highlights – binlog_space_limit

Percona Server for MySQL

I think it is often confusing to compare upstream MySQL and Percona Server for MySQL, and some helpful information can be found in the introductory notes. But what does that really mean for an ordinary DBA, especially if none of the known big extra features are important in a particular use case?
In this article, […]

Read more