MongoDB has its own commands and function structures to ask the database to do work. In this talk, we will discuss how queries, updates, deletes and inserts work. However, we will go beyond these actions and also review what operators you should and shouldn’t use, and how they might actually drive your schema choices. Then we will talk about operationally sound ways for bulk deleting and inserting when you want to limit the impact on...
Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data centers, and span multiple cloud providers as well a plethora of heterogeneous environments. We need bulletproof backups and impeccable recovery processes. This talk aims to answer the question "How should I backup my MySQL databases?" by providing 3-2-1 backup designs, best practices and real-world solutions...
MongoDB security breaches have regularly been in the news. What isn’t mentioned, however, is that it’s all been avoidable. Simple mistakes add up to giant headaches, and loss of management and customer confidence in you (the DBA). We will cut through the marketing hype and give you a real-world playbook on what to do and how to do it when securing your system. This includes enabling authentications, understand and building custom roles...
Clients require strong security measures for PCI, HIPAA or PHI. These standards require data managed by MySQL to be encrypted "at rest." InnoDB’s built-in encryption features work, but there are some caveats to that solution.
In this talk, you'll see how to encrypt your entire disk to protect everything from data, redo logs and binary logs.
In the case of a failure, do you know how long it will take to restore your database? Do you know how old the backup will be? In this presentation, we will cover the basics of best practices for backup, restoration and business continuity. Don’t put your company on the line due to bad data retention and backup policies.
MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning what new features exist and how to use them. This webinar will teach you about new features such as multi-source replication, global transaction IDs (GTIDs), security improvements and more.
We’ll also discuss logical decoding. Logical decoding is one of the features under the BDR implementation, allowing...
MongoDB has 12 index types. Do you know how each works, or when each should be used? This talk will arm you with this knowledge, and help you understand how indexes impact performance, storage and even the sharding of your data. We will also discuss some solid index operational practices, as well as some settings for things like TTL you might not know exist. The contents of this webinar will make you a Rock Star!
This webinar will discuss the features of MySQL/MariaDB that when enabled and used improve the default usage of MySQL.
Many cloud-based applications fail to:
- Use appropriate filesystem permissions
- Use TLS/SSL for connections
- Use TLS/SSL with MySQL replication
- Use external authentication plugins (LDAP, PAM, Kerberos)
- Encrypt all your data at rest
- Monitor your database with the audit...
MySQL and MariaDB Server are providing many new features that help with security and encryption, things that are becoming extremely important in today's world. Learn how to use these features, from roles to at-rest-encryption, to increase security. At the end of the webinar, you should understand how to have a securely configured MySQL instance!
Proper indexing is key to database performance. Find out how MySQL uses indexes for query execution, then how to come up with an optimal index strategy. In this session you’ll also learn how to know when you need an index, and also how to get rid of indexes that you don’t need to speed up queries.
For general inquiries, please send us your question and someone will contact you.
