PDXPUG: April meeting in two weeks

When: 6-8pm Thursday April 21, 2016
Where: Iovation
Who: Eric Ferreira, Database Engineer, Amazon Web Services
What: How to hide a petabyte-scale Data warehouse inside a small OLTP database

You may have heard that Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse. You’ve heard that it’s a shared-nothing cluster architecture, that it scales to hundreds of nodes and terabytes, and that it’s “based on Postgres”. How is that combination possible, and how much of Postgres survived that transformation? Eric Ferreira, who was the first engineer to work on Redshift, will discuss the design, tradeoffs and modifications made to make Redshift the scalable system it is today. Bring your questions!

We will also talk about ways to mix and match Postgres (OLTP) tables and Redshift (DW) tables on a single connection using pgboucer-rr and Postgres external data sources.

Eric started in the database world 26 years ago in Brazil and has implemented most flavors of RDBMS thought his career. He joined Amazon on 2003 and while on AWS/RDS worked on bringing various databases engines into the service. 5 years ago he ventured to start the project that would become Redshift.

—
If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.
—

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 5:45 and building security closes access to the floor at 6:30.

When you arrive at the Iovation office, please sign in on the iPad at the reception desk.

See you there!

(You can RSVP on our meetup group, if you like.)

PDXPUG February Meeting Recap

Mark & I left David Wheeler in charge of the PDXPUG February meeting while we were at SCALE last week.

Here’s David’s report:
—
This week Dave Kerr discussed using Bucardo mutli-master replication to gradually migrate a production database from EC2 to RDS. This work allowed his team to switch back and forth between the two systems with the assurance that the data would be the same on both. It also allowed them a fallback in case the RDS database didn’t work out: the S3 system would still be there. The discussion allowed those present to complain about Bucardo, EC2, RDS, and the French.
—
Thanks!

PDXPUG: February meeting in two weeks

When: 6-8pm Thu Feb 19, 2015
Where: Iovation
Who: David Kerr
What: Using Bucardo to Migrate your Pg database to RDS with minimal downtime

As a followup to January’s RDS discussion, Dave Kerr works through strategies to move your existing Postgres database into RDS.

Using Bucardo and Master/Master Replication we can achieve a migration to RDS with minimal or no downtime.

Dave will show some tools and techniques so help facilitate this transition as well as go over the idiosyncrasies of using Bucardo with RDS.

—

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 5:45 and building security closes access to the floor at 6:30.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

See you there!

PDXPUG: January meeting next week

When: 6-8pm Thu Jan 15, 2015
Where: Iovation
Who: Gabrielle Roth
What: RDS Postgres

Amazon integrated Postgres into their general Relational Database Services (RDS) offerings July 1, 2014. RDS offers automatic failover, scalability, and easy configuration, plus Amazon handles all the patching and upgrades for you! Their SDK supports many languages and includes a robust CLI, if you want to automate management of your deployments. They also support several popular Postgres extensions.

Of course, since it’s a managed service, you can’t do everything you might expect or want to. In this talk, I’ll discuss the fun, the quirky, and the downright maddening features I’ve discovered working with production RDS deployments. Come find out what it’s like to use RDS Postgres day-to-day.

—

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 5:45 and building security closes access to the floor at 6:30.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

We’ll go to Huber’s for after-meeting socializing.

See you there!

February meeting recap

18 people came to our February meeting! Welcome to all the new folks & we hope to see you again. John entertained us with “Locking War Stories”; his slides are here. We took a large group over to Huber’s for the post-meeting meeting where we continued the discussion.

Thanks to Iovation for providing sandwiches, and thanks to John for speaking on such short notice.