Chris Ellis talks about "Protecting Your Customers With PostgreSQL" and Federico Campoli about "pg_chameleon, MySQL to PostgreSQL replica made easy".
This talk will take a practical look at how I used PostgreSQL to help protected customer's data whilst working on a large energy insights database. Covering some basics and using functional interfaces to strictly control access to data and allowing your database to fail safe.
Chris is a computing and electronics geek, who loves working with Open Source software. He is an independent PostgreSQL consultant, currently working on IoT and smart energy insights. As well as running the Bergamot Monitoring project.
pg_chameleon is a lightweight replication system written in python. The tool can connect to the mysql replication protocol and replicate the data changes in PostgreSQL. Whether the user should need a replica for business intelligence, aggregating data or migrate a database from MySQL to PostgreSQL, pg_chamaleon is the perfect tool for the job.
The talk will cover the history, the current implementation and the upcoming release. There will be also a live demo.
Federico works as data engineer at Transferwise. Previously he managed a multi-terabyte PostgreSQL installation for a well known social media monitoring company. He started his career as Oracle DBA in 2004 and fell in love with PostgreSQL in 2007. In 2015 he founded the Brighton PostgreSQL meetup.