Open Source Databases Meetup #1

London Open Source Databases Meetup
London Open Source Databases Meetup
Public group

1 E Poultry Ave

1 East Poultry Avenue · London

How to find us

Innovation Warehouse 1 East Poultry Avenue London EC1A 9PT The venue is above Smithfield Market

Location image of event venue


First meetup for this group!

Several experts from Percona will be in London. They will come to the meetup and tell us about interesting news about some of the technologies they work on.


There may be small variations to the schedule on the night.

19.00: Arrival and networking

19:20 Group Introduction - Federico Razzoli

This is our first meetup, so let's talk a bit about who we are and what we want to do. Please propose ideas and suggestions: this is the best time to do so!

19:40 MongoDB® ReplicaSet and Sharding - Vinodh Krishnaswamy, Support Engineer

In this modern database world, it is important to support huge data sets to meet business needs. Data needs to be served quickly to the client on request and without delay. MongoDB is a NoSQL database which understands these requirements and provides features to support them.
In this session, we'll look at replicaSet and the sharding concepts: when to use replicaSet and when to use sharding. How can they be deployed to get the most out of that architecture? We'll also checklist some basic things that needs to be taken care of when planning for such architecture.

20:00 MySQL 8.0 architecture and Enhancements - Lalit Choudhary, Bug Reproduction Analyst

The release of MySQL 8.0 offers much more to users compared to previous releases. There are major changes in architecture as well adding differentiating features, and improvements to manage the database more efficiently.
In our talk will go through, MySQL 8.0 architecture
* On Disk
* In-memory
Examples and use cases will be shared showing the new features introduced in MySQL 8.0

20:20 Optimizer Histograms: When they Help and When Do Not?- Sveta Smirnova, Principal Bug Escalation Specialist

Last year I worked on several tickets where data follow the same pattern: millions of popular products fit into a couple of categories and the rest used the rest. We had a hard time finding a solution for retrieving goods fast.
MySQL 8.0 has a feature which resolves such issues: optimizer histograms, storing statistics of an exact number of values in each data bucket.
However, in real life histograms don't help with all queries: those accessing non-uniform data. How you write a query, the number of rows in the table, data distribution: all these may affect the use of histograms.
In this talk, I will discuss use cases for Optimizer Histograms and highlight situations or data distributions where Optimizer won't use them. I will provide examples, demonstrating how Optimizer makes decisions in each case.

20:40 Food offered by Percona... please register individually to help us judge numbers!

21:00 New and Maturing Built-in Features in PostgreSQL to Help Build Simple Shards - Jobin Augustine, Senior Support Engineer

In this talk, I'll be discussing how some of the core features of PostgreSQL that have matured over years, and how they can be leveraged for implementing simple shards. This talk Includes:
* PostgreSQL foreign data wrappers
* Predicate push down
* Aggregate push down.
* Table partitioning (both Inheritance and declarative)
* Partitions sitting in remote servers as shards
* How parallel execution helps.

21:20 Brothers in Arms: Using ProxySQL + PXC to Ensure Transparent High Availability for your Application - Vinicius Grippa, Support Engineer

Percona Xtradb Cluster (PXC) provides high availability (HA) in a cost-effective way. It improves scalability for reads and provides for zero data loss. With ProxySQL, load balancing for reads and writes are made in a totally transparent way for the application. If a node needs to be maintained, this can be done without any loss for the application. Plus: ProxySQL 2.0 supports PXC natively.

21:40 Wrap-up, networking