Pythian Blog: Technical Track

Join Pythian for Percona Live Europe 2019 Amsterdam

Percona Live is always a great opportunity to learn from the best and brightest in the open-source database community. This time, Percona Live Europe is being held at the Hilton Amsterdam Airport Schiphol, The Netherlands from September 30 to October 2, 2019. Pythian will be present, as has been the case for the past few years, with some of our technical experts speaking on a variety of subjects and technologies. Feel free to ping any of us during the conference breaks or community events, as we’ll be happy to answer any questions you have about anything open source, cloud, or data-related. Here are some sessions you won’t want to miss: Wednesday, October 2 9:00 AM - 10:00 AM Maintenance for MongoDB Replica Sets Room 10 Redundancy and high availability are the basis for all production deployments. With MongoDB, high availability is achieved with replica sets which provide automatic failover in case the primary goes down. In this session, we will review multiple maintenance scenarios that will include the proper steps for keeping the high availability while we perform the maintenance steps without causing downtime. This session will cover database upgrades, OS server patching, hardware upgrades, network maintenance and more.
  • How MongoDB HA works
  • Replica sets components / deployment typologies
  • Database upgrades
  • System patching / upgrade
  • Network maintenance
  • Add / remove members to the replica set
  • Reconfiguring replica set members
  • Building indexes
  • Backups and restores
Speaker: Igor Donchovski
11:30 AM - 12:00 PM Securing MySQL with Vault and Table Level Encryption Room A With all the personal information leaks, it is very important to make sure that your data is secure and protected. In this talk, I will go into, and demonstrate, how to secure your MySQL user accounts with Hashicorp Vault to do MySQL user account rotation and expiration. You can then integrate it with LDAP. There are a lot of users that do not use command line interface that may want to access these environments. This can all be done with Vaults' built-in GUI interface. Finally, I will demonstrate how to encrypt your tables and store the key in Vault by base encoding your key and placing it into a KV store, or by just using the Percona keyring_vault plugin. Speaker: Kevin Markwardt
2:30 PM - 3:30 PM The DB is Broken. Now What? Room 09 Sometimes the only piece of information you are given is that the database is not working correctly. What do you do now? Panic? Call Mom? But you're the DBA. What you do next is crucial. In this talk, we'll cover the tools that you'll use to determine what other agents may be working against the database performance. We'll share our own experiences with crazy scenarios that stumped us, and the tools that we used to figure out the root cause. Some examples include how systemd can ruin your day, NUMA imbalance, and issues unique to AWS, and GCP. Speakers: Carmen Mason, Allan Mason, Ivan Groenewold
We look forward to seeing you at the show! Haven't registered yet? Use CMESPEAK-IVAN code to get 20% off the registration fee.

No Comments Yet

Let us know what you think

Subscribe by email