Adamo joined Percona in 2015, after working as a MongoDB-MySQL Database Administrator for three years. As the main database administrator of a startup, he was responsible for suggesting the best architecture and data flows for a worldwide company in a 7-24 environment. Before that, he worked as a Microsoft SQL Server DBA in a large e-commerce company, mainly on performance tuning and automation. Adamo has almost eight years of experience working as a DBA. In the past three years, he has moved to NoSQL technologies without giving up relational databases. He likes to play videogames and to study everything that is related to engines. Adamo lives with his wife in São Paulo, Brazil.
In this talk we will cover the backup methods available on MongoDB, being from a simple mongodump to the hotbackup tool available on Percona Server for MongoDB.
Backups are important and more important is to be aware of the pros and cons of a backup method.
This is an intermediate topic for DBAs and SysAdmins who wants to learn a bit more about Backups.
Introduction about MongoDB Shards and their internals. How to configure and form design for the Shards. Including multiple DC setup, backup instance etc. Explaining about the shard key and choosing the right one - pros and cons. What to do with the Shards and what not to do. tips and tricks & troubleshooting Shard related issues like orphan documents, duplicate _id etc due to application logic.
In this tutorial, we will build a shard from scratch, starting from a single instance, then learning how the replica set works in detail. You will learn how to convert a single instance to a replica set and why a single instance is not a good fit for production. After understanding the replica-set concepts we will start a sharded cluster using best practices, learn how the shard works internally, what chunk and shard keys are, how to split data across different regions (geo-partitioning), how to perform an upgrade and also how to scale up and down the cluster. All of those steps will be performed in a secure environment with authentication enabled and monitoring by PMM.
Running MongoDB in production can be challenging.
In this tutorial, we will cover how to configure the database, and how to parse and interpret logs and metrics to make your day by day easier.
We will learn how to:
Interpret the MongoDB logs and server status output
Use "currentOp" command to check current queries running
Use the Database Profiler
Configure Linux for production, including OS parameters, network parameters, and disks configurations
Safely run maintenance in replica sets and shards
Create indexes without performance degradation
Pick the right shard key, and when and why to use shard tags
Use benchmark and load replaying tools
Choose the best backup method
Monitor your system with PMM
Evaluate if your application can take advantage of transactions in 4.0
Configure Change Streams and get notifications with a few lines
NoSQL databases and especially MongoDB fits in all kind of companies - from small Startups to Enterprise Companies-.
In this talk, we will discuss how MongoDB can be used in Enterprise environment and what features Percona Server for MongoDB offers to help those companies to integrate MongoDB with an existing environment and also to be compliant with security certifications.
We will demonstrate use cases, how to configure roles-based access, LDAP integration, auditing, encryption at rest.