Just finished my last talk. Slides are downloadable here, and also embedded after the break.
MySQL Conf – Managing Terabytes
Own it: Working with a changing open source community
The floor show is closed, so no more booth work tomorrow. I’ve had a great time here talking with people and seeing my colleagues in the PostgreSQL and MySQL community.
Looking forward to getting some hacking time in tomorrow and enjoying an evening connecting with people instead of working on slides. 🙂
Today is the first day of regular sessions at MySQL Users Conference.
I’m particularly excited this year because we have 12 PostgreSQL talks, including a Plenary talk at 9:40am this morning about the state of PostgreSQL.
Today’s talks include Building Data Warehouses, An Introduction to PostGIS, Securing PostgreSQL from external attack, and Introduction to PostgreSQL configuration.
MySQL Users Conference is the largest open source database conference in the world. When so many changes are occurring inside the MySQL database community, our presence is critically important. Particularly that we have Bruce Momjian, Robert Haas, Jeff Davis, Josh Berkus and many others here. Thank you to everyone that’s contributing to the booth, the talks and engaging in conversations here.
We’re also having a PostgreSQL BoF this evening, in Ballroom B at 7pm! Please stop by.
Back in February, I blogged about all the sessions related to PostgreSQL at MySQL Users Conference this year.
My stickers just arrived:
Stop by the PostgreSQL booth during the MySQL Expo, or come to one of my talks if you’d like one.
I’m giving two – one is about Emma’s database systems and the problems with scaling huge schemas. And the other is a community talk about managing competing business and community interests inside of the Postgres community, and lessons that other open source communities can learn from our successes and failures.
We’re having a free Birds of a Feather session Tuesday, April 12 at 7pm at the Santa Clara Convention Center. Please stop by!
You’ve probably seen a few posts about this – from the CFP, to Baron’s recent pointer to the release of the schedule. And now Josh Berkus just posted a Meetup for the event, so that spurred me on for this post…
So, just to make things even easier for you, I thought I’d summarize the awesome talks we’re having at the O’Reilly MySQL Users Conference this year related to PostgreSQL.
- Building Data Warehouses with PostgreSQL, Josh Berkus (PostgreSQL Experts, Inc.)
Has your database grown to hundreds of gigabytes in size, with no limit in sight? Are you considering moving to an expensive proprietary database system do deal with your huge database? PostgreSQL is an excellent database for small to medium sized data warehouses in the 0.5 to 5 terabyte range.
- Bottom-up Database Benchmarking, Greg Smith (2ndQuadrant US)
While databases are increasingly being distributed across multiple nodes, the performance of every node still matters–especially if you’re considering virtualized or cloud deployments that have their own specific trade-offs. Memory performance scaling as core count changes, all aspects of disk performance, and using sysbench to benchmark both MySQL and PostgreSQL are all topics covered here.
- An Introduction to PostGIS – the PostgreSQL spatial extension, Ragi Burhum (Burhum LLC – GIS Consulting)
PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. It includes support for spatial indexes, and functions for analysis and processing of GIS objects.
- Securing PostgreSQL From External Attack, Bruce Momjian (EnterpriseDB)
This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. Postgres supports features to eliminate all of these threats, but administrators must understand the attack vulnerabilities to protect against them.
- Introduction to PostgreSQL Configuration, Robert Haas (EnterpriseDB)
PostgreSQL is highly customizable, but which settings are most important and what values are most appropriate for a typical installation? This talk will explain the basics of how to configure PostgreSQL for reliability and good performance.
- Mixed MySQL/PostgreSQL environments, Jeff Davis (Aster Data)
Mixed SQL system environments are a reality for most organizations. MySQL and PostgreSQL are a natural combination — both are open source, and they complement each other nicely. See how to improve data consolidation, increase confidence in query results, and analyze data across applications.
- Maintaining Terabytes: 10 Things to Watch Out For When PostgresSQL Bets Big, Selena Deckelmann (PostgreSQL)
Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow, and find out what new features in 9.0 have made life easier for administrators and application developers working with big data.
- Openstreetmap -> (PostGIS|MySQL|SpatiaLite) -> OpenLayers: From Map to Web, Hartmut Holzgraefe (…???…)
OpenStreetMap raw data for any non-trivial area comes as a massive amount of XML data. Processing that XML data directly is possible, importing it into into a spatial database provides for much more interesting processing options though, especially when it comes to producing on demand map data for web applications with acceptable performance.
- War Stories and Solutions: Operational Fun with PostgreSQL and PostGIS in the Cloud, Andy Parsons (Obikosh.com)
As CTO of Outside.in, and in my new stealth company, I’ve seen my share of challenging scenarios keeping a very busy PostgreSQL-based startup online and responsive during tremendous growth. EC2 + PostgreSQL + PostGIS + no downtime. Others can probably learn from my battle scars!
- Replace phpMyAdmin with Something Better, Jakub Vrana (Self-employed)
phpMyAdmin is a well-known PHP application for managing MySQL database. What’s wrong with it? It is big, slow and it misses support for many advanced features like stored procedures or triggers. Its free alternative Adminer provides user-friendly interface, requires no setup, is lightning fast and highly customizable. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
We’re also having a Birds of a Feather session, and staffing a booth on the exhibit floor!
If you’re planning to attend, you can use my code & save 25% in addition to early registration savings: mys11fsd: http://oreil.ly/goaqst
Hope to see you there!