This is the recording of the pg_chameleon presentation I gave at the Brighton PostgreSQL Meetup
The slides are available here
http://www.slideshare.net/FedericoCampoli/pg-chameleon-mysql-to-postgresql-replica
Showing posts with label meetup. Show all posts
Showing posts with label meetup. Show all posts
Monday, 21 November 2016
Saturday, 12 November 2016
presenting pg chameleon at the brighton postgresql meetup
Back from Estonia after the amazing European PGConf 2016 I'm about to give a talk on the MySQL to PostgreSQL replication project I'm developing.
But first things first. I want to thank all the organisers of the PGConf Europe. The talks were super interesting the location absolutely stunning and the old and new friends I met, remembered me how amazing is the PostgreSQL community. Unfortunately I missed the social events (did somebody said a DBA can have social life? :P).
The meetup will be in Brighton UK Friday 18th of November. There will be a chat starting at 19.00 with pizza and beer offered by our sponsor.
The talk will start around 19.30 and will be streamed on youtube here.
Here's the talk description.
pg_chameleon is a lightweight replication system written in python. The tool connects to the mysql replication protocol and replicates the data in PostgreSQL.
The author's tool will talk about the history, the logic behind the functions available and will give an interactive usage example.
If you are in Brighton and want to join us please RSVP here.
But first things first. I want to thank all the organisers of the PGConf Europe. The talks were super interesting the location absolutely stunning and the old and new friends I met, remembered me how amazing is the PostgreSQL community. Unfortunately I missed the social events (did somebody said a DBA can have social life? :P).
The meetup will be in Brighton UK Friday 18th of November. There will be a chat starting at 19.00 with pizza and beer offered by our sponsor.The talk will start around 19.30 and will be streamed on youtube here.
Here's the talk description.
pg_chameleon is a lightweight replication system written in python. The tool connects to the mysql replication protocol and replicates the data in PostgreSQL.
The author's tool will talk about the history, the logic behind the functions available and will give an interactive usage example.
If you are in Brighton and want to join us please RSVP here.
Wednesday, 5 October 2016
An evening with Psycopg2
The next meetup at Brighton will be Friday 14th October at 19.30.
Daniele Varrazzo will kindly talk about the most popular PostgreSQL driver in the python universe.
Psycopg is the most used PostgreSQL driver for the Python programming language.
As a driver it stays at a relatively low level, allowing to use all the features offered by the database. Behind the scenes, it does its best to convert the rich Python data model into the likewise rich PostgreSQL data model:
we will take a look at the adaptation mechanism and how to customize it to add new data types or change the default behaviour.
We will also take a look at how psycopg allows Python to tap into the PostgreSQL publish/subscribe mechanism and how this can be used to build reactive and distributed applications.
The presentation's live stream will be available at this link
http://www.youtube.com/channel/UCgr5Iv9eJYN2Piy9oYkn6jw/live
Please RSVP here.
See you in Brighton!
Daniele Varrazzo will kindly talk about the most popular PostgreSQL driver in the python universe.
Psycopg is the most used PostgreSQL driver for the Python programming language.
As a driver it stays at a relatively low level, allowing to use all the features offered by the database. Behind the scenes, it does its best to convert the rich Python data model into the likewise rich PostgreSQL data model:
we will take a look at the adaptation mechanism and how to customize it to add new data types or change the default behaviour.
We will also take a look at how psycopg allows Python to tap into the PostgreSQL publish/subscribe mechanism and how this can be used to build reactive and distributed applications.
The presentation's live stream will be available at this link
http://www.youtube.com/channel/UCgr5Iv9eJYN2Piy9oYkn6jw/live
Please RSVP here.
See you in Brighton!
Friday, 2 September 2016
News from the outer ring
After the summer break the Brighton PostgreSQL meetup restarts with the monthly technical talks.
This time is my round again. I'll speak on how to scale the backup and recovery on large postgres installations.
Actually this is the talk I've submitted to the european pgconf.
I made the talk in a storytelling form in order to avoid to bore the audience to the death. The talk should be quite entertaining with explanation of the issues solved by the DBA over the years.
As google is removing the hangouts on air I'm using youtube live and OBS to stream this event. It's the first time I try and I cannot guarantee it will work.
I'll record the presentation just in case the stream is broken.
Event details
Location: Brandwatch - 1st Floor Sovereign House, Church St, Brighton, East Sussex BN1 1UJ, Brighton
Description:
Dealing with large databases is always a challenge.
The backups and the HA procedures evolve meanwhile the database installation grow up over the time.
The talk will cover the problems solved by the DBA in four years of working with large databases, which size increased from 1.7 TB single cluster, up to 40 TB in a multi shard environment.
The talk will cover either the disaster recovery with pg_dump and the high availability with the log shipping/streaming replication.
The presentation is based on a real story. The names are changed in order to protect the innocents.
RSVP here
Live stream (hopefully) here
This time is my round again. I'll speak on how to scale the backup and recovery on large postgres installations.
Actually this is the talk I've submitted to the european pgconf.
I made the talk in a storytelling form in order to avoid to bore the audience to the death. The talk should be quite entertaining with explanation of the issues solved by the DBA over the years.
As google is removing the hangouts on air I'm using youtube live and OBS to stream this event. It's the first time I try and I cannot guarantee it will work.
I'll record the presentation just in case the stream is broken.
Event details
PostgreSQL - backup and recovery with large databases
Friday 9th September 19.00 London Time Zone
Location: Brandwatch - 1st Floor Sovereign House, Church St, Brighton, East Sussex BN1 1UJ, Brighton
Description:
Dealing with large databases is always a challenge.
The backups and the HA procedures evolve meanwhile the database installation grow up over the time.
The talk will cover the problems solved by the DBA in four years of working with large databases, which size increased from 1.7 TB single cluster, up to 40 TB in a multi shard environment.
The talk will cover either the disaster recovery with pg_dump and the high availability with the log shipping/streaming replication.
The presentation is based on a real story. The names are changed in order to protect the innocents.
RSVP here
Live stream (hopefully) here
Thursday, 11 February 2016
Brigthton PostgreSQL Meetup news
I've been busy recently and I failed to update on the last meetup news.
I apologise for that.
We had a very interesting meetup in January.
Alexey Bashtanov explained how the grouping works in postgres and how to improve or even re implement in C the grouping functions.
On the meetup page there are the pictures from the meeting .
The presentation's recording is available there and the slides are free to download on slideshare there.
We are already preparing the next meetup announced for 18th of March.
That's the abstract.
The next postgresql meetup will be a technical talk on the ways in which PostgreSQL can communicate with the outside world.
This talk will cover PostgreSQL Foreign Data Wrappers which are tables that
can read and write to external services.
Efficient ways to run queries from applications will also be covered.
About the speaker.
Matthew Franglen works as a team lead in Brandwatch. He has a long history
of development, with over 10 years of experience.
As usual the talk will be preceded by pizza and a nice chat. We'll also do a recording.
If you are in Brighton please join us here.
http://www.meetup.com/
I apologise for that.
We had a very interesting meetup in January.
Alexey Bashtanov explained how the grouping works in postgres and how to improve or even re implement in C the grouping functions.
On the meetup page there are the pictures from the meeting .
The presentation's recording is available there and the slides are free to download on slideshare there.
We are already preparing the next meetup announced for 18th of March.
That's the abstract.
The next postgresql meetup will be a technical talk on the ways in which PostgreSQL can communicate with the outside world.
This talk will cover PostgreSQL Foreign Data Wrappers which are tables that
can read and write to external services.
Efficient ways to run queries from applications will also be covered.
About the speaker.
Matthew Franglen works as a team lead in Brandwatch. He has a long history
of development, with over 10 years of experience.
As usual the talk will be preceded by pizza and a nice chat. We'll also do a recording.
If you are in Brighton please join us here.
http://www.meetup.com/
Sunday, 29 November 2015
Meetup wrap up
This second meetup went very well. The audience was interested and we had fun time thanks to the beer and pizzas offered alongside with the venue by our sponsor brandwatch.
Here a couple of pictures from the meetup.
The recording worked much better than the previous time, here's the presentation's video. We'll meet again shortly for a nice beer. Next technical talk will be probably in January.
Here a couple of pictures from the meetup.
The recording worked much better than the previous time, here's the presentation's video. We'll meet again shortly for a nice beer. Next technical talk will be probably in January.
Tuesday, 24 November 2015
Meetup live hangout
Three days to go for the next Brighton PostgreSQL meetup.
I'll run a live hangout of the talk.
You can join the event there.
https://plus.google.com/events/cge4691km5qm8euj4erkcp7jecs
The record will become available on youtube shortly after the talk's end.
I'll run a live hangout of the talk.
You can join the event there.
https://plus.google.com/events/cge4691km5qm8euj4erkcp7jecs
The record will become available on youtube shortly after the talk's end.
Thursday, 10 September 2015
The next meetup - PostgreSQL query planning
Like previously said, the next Brighton PostgreSQL meetup will be September 25th at 7 pm BST. The topic chosen by the member is the query planning and execution in PostgreSQL.
I will do the presentation exploring the various steps a query passes through from the client to the execution. I'll also explain how to read the execution plan and why sometimes the executor seems to ignore the indices put in place for speeding up the operations.
The meetup is hosted kindly by Brandwatch
There are limited places so you want to join us secure your seat here
I will do the presentation exploring the various steps a query passes through from the client to the execution. I'll also explain how to read the execution plan and why sometimes the executor seems to ignore the indices put in place for speeding up the operations.
The meetup is hosted kindly by Brandwatch
There are limited places so you want to join us secure your seat here
Subscribe to:
Posts (Atom)