PDXPUG: June meeting

When: 6-8pm Thursday June 15, 2017
Where: iovation
Who: Kevin Jernigan, AWS
What: Amazon Aurora (PostgreSQL)

In 2014, AWS announced Amazon Aurora – a cloud-native, MySQL-compatible relational database. Features include fault-tolerant, self-healing storage that allows customers to scale from 10 GB all the way up to 64 TB without pre-provisioning. Aurora makes six copies of data across three Availability Zones and backs it up to Amazon Simple Storage Service (S3) without impacting performance or availability. Customers can create up to 15 low-latency read replicas that draw from common storage.

In response to repeated customer requests for the same capabilities for PostgreSQL, AWS announced the Amazon Aurora PostgreSQL-compatible edition in late 2016.

In this talk we’ll cover what makes Aurora (PostgreSQL) different from PostgreSQL, as well as what remains the same. We’ll discuss compatibility, scalability and performance. Please bring your scenarios, questions and requests!


Kevin Jernigan is a Senior Product Manager in the Amazon Relational Database Services (RDS) team. His deep database engine experience spans Oracle, Ingres, Informix, DB2, and PostgreSQL. He lives in San Francisco, and when not working on database engines loves to play squash and spend time with his wife and kids.


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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

Advertisements

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!