RMOUG is going Hybrid - Register Today!! and attend our May 19th Spring Workshop In-person or Online

Recognizing that many RMOUG members are not able to attend In-Person events, our Spring Workshop is now a

 Hybrid Event

Select your option at registration, we look forward to seeing everyone either in person or online next week;

on

Thursday, May 19, 2022

Spring Educational Workshop and Annual Membership Meeting

at

ORACLE DTC Campus -- Building 3

Conference Rooms  "US-DENVER3-CONF-1100_Center"

7700 Technology Way, Denver, CO 80237

Educational Workshop Sponsors:

8:00 am – 8:15 am        Continental Breakfast / Registration

8:15 am – 8:35 am        Welcome/Annual Membership Meeting        

8:35 am - 8:45 am                  Break

8:45 am - 9:45 am        MySQL Heatwave – The Basics, Bobby Curtis

9:45 am -9:55 am                   Break

9:55 am - 10:00 am      May Workshop Sponsor - Datavail

10:00 am - 10:10 am               Break

10:10 am - 11:10 am    DevOps for DBA’s using Ansible and Liquibase - Part 1

                                           - Tim Mishek and Sebastian Samala

11:10 am - 11:20 am               Break

11:20 am - 12:20 pm    DevOps for DBA’s using Ansible and Liquibase - Part 2

                                          - Tim Mishek and Sebastian Samala

$15 visitor fee For non members, questions please e-mail Peggy at
mailto:peggy.king@rmoug.org

Presentation Details:

8:45 am - 9:45 am       "MySQL Heatwave – The Basics"- Bobby Curtis

Are you a MySQL DBA that has analytics requirements? If so, come and learn how MySQL Heatwave can minimize your data movement, keep data secure, and increase analytic query performance. This session will dive into how Oracle enables MySQL on OCI and extends its query performance with Heatwave clusters. Learn the basics of Heatwave and take your MySQL environment to the next level!  

Takeaways:

• What is OCI’s MySQL Database Service?
• How and why to use MySQL Heatwave?
• What are the next steps after MySQL Heatwave?

Presenter - Bobby Curtis, President, RheoData

Bobby Curtis is the president and senior consultant at RheoData, a global systems integrator based in Atlanta. As an Oracle ACE Director Alumni and published author, he has a wide range of knowledge from database technologies, data movement, and cloud architectures. Before running RheoData, Bobby worked for Oracle as the core product manager for Oracle GoldenGate and various consulting firms specializing in creating, maintaining, tuning, and integrating enterprise database solutions to help solve business problems.

10:10 am - 11:10 am       "DevOps for DBA’s using Ansible and Liquibase" (Part 1) - Sebastian Samala and Tim Mishek

11:20 am - 12:20 pm       "DevOps for DBA’s using Ansible and Liquibase" (Part 2) - Sebastian Samala and Tim Mishek

As part of the DevOps process, it is necessary to have an automated and a repeatable process defined in the CI/CD pipeline.  In order to run database deployments specifically in the pipeline, Ansible in conjunction with Liquibase can be used to accomplish this goal.  During the session, you will learn how to install and configure Ansible, learn how playbooks work with Yaml, use Ansible vault to encrypt a “Secrets” file, and incorporate Liquibase to automate database deployments. 

What will be covered in the session:

• What is Ansible?
• How can Ansible be used for database automation.
• Install Ansible
• Set up SSH equivalency
• Go over the basics of the Ansible Playbooks
• Looking at variables and when to use them at the command line
• Using the secrets file for passwords etc.
• Automation of DevOps tools including Liquibase
• Online demo of the integration of Ansible and Liquibase