Apr
20
2018
--

The Final Countdown: Are You Ready for Percona Live 2018?

Are you ready for Percona Live

Are you ready for Percona Live 2018It’s hard to believe Percona Live 2018 starts on Monday! We’re looking forward to seeing everyone in Santa Clara next week! Here are some quick highlights to remember:

  • In addition to all the amazing sessions and keynotes we’ve announced, we’ll be hosting the MySQL Community Awards and the Lightning Talks on Monday during the Opening Reception.
  • We’ve also got a great lineup of demos in the exhibit hall all day Tuesday and Wednesday – be sure to stop by and learn more about open source database products and tools.
  • On Monday, we have a special China Track now available from Alibaba Cloud, PingCAP and Shannon Systems. We’ve just put a $20.00 ticket on sale for that track, and if you have already purchased any of our other tickets, you are also welcome to attend those four sessions.
  • Don’t forget to make your reservation at the Community Dinner. It’s a great opportunity to socialize with everyone and Pythian is always a wonderful host!

Thanks to everyone who is sponsoring, presenting and attending! The community is who makes this event successful and so much fun to be a part of!

The post The Final Countdown: Are You Ready for Percona Live 2018? appeared first on Percona Database Performance Blog.

Apr
19
2018
--

Congratulations to Our Friends at Oracle with the MySQL 8.0 GA Release!

MySQL 8.0 GA

MySQL 8.0 GAIt is a great today for whole MySQL community: MySQL 8.0 was just released as GA!

Geir Høydalsvik has a great summary in his “What’s New in MySQL 8.0” blog post. You can find additional information about MySQL 8.0 Replication and MySQL 8.0 Document Store that is also worth reading.

If you can’t wait to upgrade to MySQL 8.0, please make sure to read the Upgrading to MySQL 8.0 section in the manual, and pay particular attention to changes to Connection Authentication. It requires special handling for most applications.

Also keep in mind that while MySQL 8.0 passed through an extensive QA process, this is the first GA release. It is not yet as mature and polished as MySQL 5.7. If you’re just now starting application development, however, you should definitely start with MySQL 8.0 — by the time you launch your application, 8.0 will be good. 

All of us at Percona – and me personally – are very excited about this release. You can learn more details about what we expect from it in our Why We’re Excited about MySQL 8.0 webinar recording.    

We also wrote extensively about MySQL 8.0 on our blog. Below are some posts on various features, as well as thoughts on the various RCs, that you might want to review:

The best way to learn about MySQL 8.0, though, is to attend the Percona Live Open Source Database Conference 2018, taking place in Santa Clara, CA next week. We have an outstanding selection of MySQL 8.0 focused talks both from the MySQL Engineering team and the community at large (myself included):

You can still get tickets to the conference. Come by and learn about MySQL 8.0. If you can’t make it, please check back later for slides.

Done reading? Go ahead go download  MySQL 8.0 and check it out!

The post Congratulations to Our Friends at Oracle with the MySQL 8.0 GA Release! appeared first on Percona Database Performance Blog.

Apr
12
2018
--

Percona Live 2018 Featured Talk: Containerizing Databases at New Relic (What We Learned) with Joshua Galbraith and Bryant Vinisky

Joshua Bryant Percona Live 2018 New Relic

Percona Live 2018 Featured TalkWelcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post highlights Joshua Galbraith, Senior Software Engineer and Bryant Vinisky, Site Reliability Engineer at New Relic. Their session talk is titled Containerizing Databases at New Relic: What We Learned. There are many trade-offs when containerizing databases, and there are many open source support options for database containers such as Kubernetes and Apache Mesos. In our conversation, we discussed what containers can bring to a database environment:

Percona: Who are you, and how did you get into databases? What was your path to your current responsibilities?

Joshua: My name is Joshua Galbraith, and I’m a Senior Software Engineer and Technical Product Manager on the Database Engineering team at New Relic. I’ve been working with open-source databases for the past ten years. I started my software engineering career by writing scripts to load several years of high-resolution geophysical sensor data from flat files into a Postgres database. I’ve been writing software that interacts with databases and tools to make operating them easier ever since. I’ve run MySQL, MongoDB, ElasticSearch, Cassandra and Redis in a variety of production environments. A little over three years ago, I co-founded a DBaaS startup and built a container-based platform for Apache Cassandra. I’ve been containerizing databases ever since — most recently by working on a project called Megabase at New Relic.

Joshua Bryant Percona Live 2018 New RelicBryant: Hello, my name is Bryant Vinisky. I currently work on the Database Engineering team at New Relic as a Senior Site Reliability Engineer. My professional experience with databases and the open source ecosystem started over eight years ago when I joined the engineering team at NWEA and helped roll out a SaaS platform for delivering adaptive assessments to students over the web. That platform was backed by a number of different database and related technologies — namely PostgreSQL, MongoDB and Redis.

Though in the beginning, my role didn’t formally involve databases, they were clearly a very important part of the greater system. Armed with an unquenchable curiosity, I was never shy about crossing boundaries into DB land. On the development side, much of the tooling and side projects I worked on over the years frequently touched databases for a storage backend. As the assessment platform scaled out to support hundreds of thousands of concurrent users, my role shifted to a reliability focus, often involving pre-release load testing of the major system components as well as doing follow up for problems that occurred on the production system. Much of the work involved dealing with the databases as a scaling bottleneck.

Containers came into the picture for me over two years ago when I moved to New Relic, where they had been using containers for stateless services for years and largely skipped over VMs. It wasn’t long before we started exploring containers as a solution for stateful database services with our Megabase project, an area where I’ve spent a lot of my time since

Your tutorial is titled “Containerizing Databases at New Relic: What We Learned”. How did you decide on containers as your database solution?

Joshua/Bryant: At New Relic, we had already built a Container Fabric for our stateless services. We knew we needed to provide databases to our internal teams in a way that was fast, cost-efficient and repeatable. Using containers would get us most of the way towards those goals, but we didn’t have a proven pattern that we could follow to reach them. We heard about other companies succeeding in building similar solutions, and we knew that we were moving away from virtual machines. Containers seemed to fit the bill.

What are the benefits and drawbacks of containerizing databases?

Joshua/Bryant: Containers are great for packaging and deployment. They allow us to deploy a known version of configuration, code and environment in a deterministic way. Unfortunately, containers are not perfect mechanisms for resource isolation, especially when large amounts of persistent storage are required. The challenge of containerizing databases is to make the right trade-offs between portability and performance, complexity and ease-of-operation given the specific context and goals of your team and organization.

Were specific database software (MySQL, Redis, PostgreSQL) easier to containerize? Why?

Joshua/Bryant: In general, the databases that are easiest to containerize are the databases that manage their own state and make themselves effectively stateless from the point of the scheduler and container orchestration framework. Databases that provide cluster membership, fault-tolerance and data replication are easier to run with a traditional orchestration framework. Databases that do not do these things on their own require additional “sidecar” services and/or application-specific frameworks to operate reliably.

Why should people attend your talk? What do you hope people will take away from it?

Joshua/Bryant: As a team, we’ve learned a lot of lessons about what to do, and not to do, when running stateful applications in containers. We’d like to pass that knowledge on to our audience. We also want to send people away with enough information to make the right decisions about whether or not to containerize the databases they are responsible for, and how to do it in a way that is successful given their own goals and context. At the very least, we hope it will be entertaining — and maybe we’ll learn some things too.

What are you looking forward to at Percona Live (besides your talk)?

Joshua/Bryant: We’re very excited to hear about open-source tools like Vitess and ProxySQL. I’m also looking forward to hearing about the latest monitoring and performance analysis tools. I always love deep-dives into specific database problems faced by a company, and I love talking to people in the expo hall. I always come away from Percona Live events a little more excited about my day-to-day work and the future of open-source databases.

Want to find out more about this Percona Live 2018 featured talk, and containerizing stateful databases? Register for Percona Live 2018, and see Joshua and Bryant’s session talk Containerizing Databases at New Relic: What We Learned. Register now to get the best price! Use the discount code SeeMeSpeakPL18 for 10% off.

Percona Live Open Source Database Conference 2018 is the premier open source event for the data performance ecosystem. It is the place to be for the open source community. Attendees include DBAs, sysadmins, developers, architects, CTOs, CEOs, and vendors from around the world.

The Percona Live Open Source Database Conference will be April 23-25, 2018 at the Hyatt Regency Santa Clara & The Santa Clara Convention Center.

The post Percona Live 2018 Featured Talk: Containerizing Databases at New Relic (What We Learned) with Joshua Galbraith and Bryant Vinisky appeared first on Percona Database Performance Blog.

Apr
11
2018
--

Calling All Polyglots: Percona Live 2018 Keynote Schedule Now Available!

Percona Live 2018 Keynotes

Percona Live 2018 KeynotesWe’ve posted the Percona Live 2018 keynote addresses for the seventh annual Percona Live Open Source Database Conference 2018, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, CA. 

This year’s keynotes explore topics ranging from how cloud and open source database adoption accelerates business growth, to leading-edge emerging technologies, to the importance of MySQL 8.0, to the growing popularity of PostgreSQL.

We’re excited by the great lineup of speakers, including our friends at Alibaba Cloud, Grafana, Microsoft, Oracle, Upwork and VividCortex, the innovative leaders on the Cool Technologies panel, and Brendan Gregg from Netflix, who will discuss how to get the most out of your database on a Linux OS, using his experiences at Netflix to highlight examples.  

With the theme of “Championing Open Source Databases,” the conference will feature multiple tracks, including MySQL, MongoDB, Cloud, PostgreSQL, Containers and Automation, Monitoring and Ops, and Database Security. Once again, Percona will be offering a low-cost database 101 track for beginning users who want to learn how to use and operate open source databases.

The Percona Live 2018 keynotes include:

Tuesday, April 24, 2018

  • Open Source for the Modern Business – Peter Zaitsev of Percona will discuss how open source database adoption continues to grow in enterprise organizations, the expectations and definitions of what constitutes success continue to change. A single technology for everything is no longer an option; welcome to the polyglot world. The talk will include several compelling open source projects and trends of interest to the open source database community and will be followed by a round of lightning talks taking a closer look at some of those projects.
  • Cool Technologies Showcase – Four industry leaders will introduce key emerging industry developments. Andy Pavlo of Carnegie Mellon University will discuss the requirements for enabling autonomous database optimizations. Nikolay Samokhvalov of PostgreSQL.org will discuss new PostgreSQL tools. Sugu Sougoumarane of PlanetScale Data will explore how Vitess became a high-performance, scalable and available MySQL clustering cloud solution in line with today’s NewSQL storage systems. Shuhao Wu of Shopify explains how to use Ghostferry as a data migration tool for incompatible cloud platforms.
  • State of the Dolphin 8.0 – Tomas Ulin of Oracle will discuss the focus, strategy, investments and innovations that are evolving MySQL to power next-generation web, mobile, cloud and embedded applications – and why MySQL 8.0 is the most significant MySQL release in its history.
  • Linux Performance 2018 – Brendan Gregg of Netflix will summarize recent performance features to help users get the most out of their Linux systems, whether they are databases or application servers. Topics include the KPTI patches for Meltdown, eBPF for performance observability, Kyber for disk I/O scheduling, BBR for TCP congestion control, and more.

Wednesday, April 25, 2018

  • Panel Discussion: Database Evolution in the Cloud – An expert panel of industry leaders, including Lixun Peng of Alibaba, Sunil Kamath of Microsoft, and Baron Schwartz of VividCortex, will discuss the rapid changes occurring with databases deployed in the cloud and what that means for the future of databases, management and monitoring and the role of the DBA and developer.
  • Future Perfect: The New Shape of the Data Tier – Baron Schwartz of VividCortex will discuss the impact of macro trends such as cloud computing, microservices, containerization, and serverless applications. He will explore where these trends are headed, touching on topics such as whether we are about to see basic administrative tasks become more automated, the role of open source and free software, and whether databases as we know them today are headed for extinction.
  • MongoDB at Upwork – Scott Simpson of Upwork, the largest freelancing website for connecting clients and freelancers, will discuss how MongoDB is used at Upwork, how the company chose the database, and how Percona helps make the company successful.

We will also present the Percona Live 2018 Community Awards and Lightning Talks on Monday, April 23, 2018, during the Opening Night Reception. Don’t miss the first day of tutorials and Opening Night Reception!

Register for the conference on the Percona Live Open Source Database Conference 2018 website.

Sponsorships

Limited Sponsorship opportunities for Percona Live 2018 Open Source Database Conference are still available, and offer the opportunity to interact with the DBAs, sysadmins, developers, CTOs, CEOs, business managers, technology evangelists, solution vendors, and entrepreneurs who typically attend the event. Contact live@percona.com for sponsorship details.

  • Diamond Sponsors – Percona, VividCortex
  • Platinum – Alibaba Cloud, Microsoft
  • Gold Sponsors – Facebook, Grafana
  • Bronze Sponsors – Altinity, BlazingDB, Box, Dynimize, ObjectRocket, Pingcap, Shannon Systems, SolarWinds, TimescaleDB, TwinDB, Yelp
  • Contributing Sponsors – cPanel, Github, Google Cloud, NaviCat
  • Media Sponsors – Database Trends & Applications, Datanami, EnterpriseTech, HPCWire, ODBMS.org, Packt

The post Calling All Polyglots: Percona Live 2018 Keynote Schedule Now Available! appeared first on Percona Database Performance Blog.

Apr
05
2018
--

Percona Live Europe 2018 – Save the Date!

Percona Live Europe 2018

Percona Live Europe 2018We’ve been searching for a great venue for Percona Live Europe 2018, and I am thrilled to announce we’ll be hosting it in Frankfurt, Germany! Please block November 5-7, 2018 on your calendar now and plan to join us at the Radisson Blu Frankfurt for the premier open source database conference.

We’re in the final days of organizing for the Percona Live 2018 in Santa Clara. You can still purchase tickets for an amazing lineup of keynote speakers, tutorials and sessions. We have ten tracks, including MySQL, MongoDB, Cloud, PostgreSQL, Containers and Automation, Monitoring and Ops, and Database Security. Major areas of focus at the conference will include:

  • Database operations and automation at scale, featuring speakers from Facebook, Slack, Github and more
  • Databases in the cloud – how database-as-a-service (DBaaS) is changing the DB landscape, featuring speakers from AWS, Microsoft, Alibaba and more
  • Security and compliance – how GDPR and other government regulations are changing the way we manage databases, featuring speakers from Fastly, Facebook, Pythian, Percona and more
  • Bridging the gap between developers and DBAs – finding common ground, featuring speakers from Square, Oracle, Percona and more

The Call for Papers for Percona Live Europe will open soon. We look forward to seeing you in Santa Clara!

The post Percona Live Europe 2018 – Save the Date! appeared first on Percona Database Performance Blog.

Apr
05
2018
--

Percona Live 2018 Featured Talk: The Accidental DBA with Jenni Snyder

Jenni Snyder Yelp Percona Live 2018 (2)

Percona Live 2018 Featured TalkWelcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post highlights Jenni Snyder, Engineering Manager – Operations at Yelp. Her tutorial talk is titled The Accidental DBA. Open source relational databases like MySQL and PostgreSQL power some of the world’s largest websites. They can be used out of the box with few adjustments, and rarely require a dedicated Database Administrator (DBA) right away. This means that System Administrators, Site Reliability Engineers or Developers are usually the first to respond to some of the more interesting issues that can arise as you scale your databases. In our conversation, we discussed how people become “accidental” DBAs:

Percona: Who are you, and how did you get into databases? What was your path to your current responsibilities?

I’m Jenni Snyder and currently work as Manager of the Database Reliability Engineering (DRE) Team at Yelp. And, I got into databases by accident. After graduating from college, my first job was as a software engineer. As I remember it, I got a desk in the corner, and under that desk was another computer. I hit a power strip switch as I went to plug in my workstation on my first day. This cut power to the other machine, which turned out to be the database host for their development environment (running Sybase). My new boss came over and walked me through starting it back up.

After that, it became pretty clear to me that I preferred systems administration over development and was put in charge of our database migration scripts. I figured out query and server tuning and later configured and deployed a more complicated environment using Oracle. I got my first official MySQL Database Administrator (DBA) job about four years later.

My degrees are in Sociology as well as Computer Science, so I have always been interested in social networks and media. I have worked for Tribe.net and the Cisco Media Solutions Group, and have been with Yelp now for almost seven years.

Percona: Your tutorial is titled The Accidental DBA. What do you mean by this term, and how did you arrive at it?

Jenni Snyder Yelp Percona Live 2018 (2)I explained this a bit above: few people seek out a career in database administration early in their career. One of the benefits of MySQL and other open source relational databases is that they’re relatively easy to get started with. You don’t need a DBA, DRE, or another owner right away. However, with success comes growth, and any open source databases with default configuration can quickly become slow if not tuned for your workload.

As a result, I think that many DBAs and DREs end up in their position by being the right person at the right time, being curious, and loving it.

Percona: What are some of the most important things an “Accidental DBA” needs to know right away?

I’d say that they are how to make sure that MySQL is running, interpreting any errors found in the client or server logs, and how to monitor MySQL.

This is going to be a very interactive talk and I’m hoping for lots of questions and a discussion. Everyone’s experience is different, and if I don’t include something in my slides, that doesn’t mean we can’t cover it!

Percona: What are three important database management lessons a good DBA needs to master?

    1. Put information in the hands of your developers so that they can learn about the database themselves

    2. Use automation early and often

    3. Use open source tools and contribute back to the community

Percona: Why should people attend your tutorial? What do you hope people will take away from it?

People should come if they’re interested in a broad overview of running MySQL. They should want to learn where they can make the most impact while tuning MySQL, how to avoid common problems, and discover some great open source tools that will make their jobs easier.

Percona: What are you looking forward to at Percona Live (besides your talk)?

Unfortunately, Percona chose to schedule Shlomi Noach’s Orchestrator High Availability Tutorial at the time of my talk, so I’m going to miss out on the number one tutorial I wanted to see!

Want to find out more about this Percona Live 2018 featured talk, and becoming an accidental DBA? Register for Percona Live 2018, and see Jenni’s tutorial talk The Accidental DBA. Register now to get the best price! Use the discount code SeeMeSpeakPL18 for 10% off.

Percona Live Open Source Database Conference 2018 is the premier open source event for the data performance ecosystem. It is the place to be for the open source community. Attendees include DBAs, sysadmins, developers, architects, CTOs, CEOs, and vendors from around the world.

The Percona Live Open Source Database Conference will be April 23-25, 2018 at the Hyatt Regency Santa Clara & The Santa Clara Convention Center.

The post Percona Live 2018 Featured Talk: The Accidental DBA with Jenni Snyder appeared first on Percona Database Performance Blog.

Mar
28
2018
--

Percona Live 2018 Featured Talk: Databases Have Forgotten About Single Node Performance, A Wrongheaded Trade-Off with Mat Arye

Mat Ayre TimeScale Percona Live 18

Percona Live 2018 Featured TalkWelcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post highlights Mat Arye, Core Database Engineer at Timescale. His talk is titled Databases Have Forgotten About Single Node Performance, A Wrongheaded Trade-Off. Distributed systems were built to scale out for ballooning user bases and operations. As more and more companies vied to be the next Google, Amazon or Facebook, they too “required” horizontal scalability. But in a real way, NoSQL and even NewSQL have forgotten single node performance, where scaling out isn’t an option. And single node performance is important because it allows you to do more with much less.  In our conversation, we discussed why you shouldn’t forget to focus on single-node performance:

Percona: Who are you, and how did you get into databases? What was your path to your current responsibilities?

Mat: My name is Mat Arye. I started working on database infrastructure as part of my graduate studies in distributed systems at Princeton University, with Timescale’s CTO Mike Freedman. My first project was developing the data streaming infrastructure for a cross-continental data analysis system called Jetstream. I was first introduced to working with PostgreSQL as an intern at CloudFlare, where I worked on their request-analysis system. I started working on the precursor to what would become TimescaleDB while working on a data analysis system for an IoT device cloud platform.

Note: Mike Freedman will also be speaking on Wednesday at 12:50 pm in Room M2, giving the talk TimescaleDB: Re-engineering PostgreSQL as a Time-Series Database.

Percona: Your talk is titled Databases Have Forgotten About Single Node Performance, A Wrongheaded Trade-Off. How have people gotten away from single-node performance?

Mat: Well, when the Internet became a thing, people saw the deluge of data that was coming. They realized that a single-node data system would no longer suffice for many data applications. Thus, the focus of a lot of data infrastructure work shifted to creating scale-out systems. For multi-node systems, performance often comes from making the system “scale linearly” (i.e., increase performance by adding nodes). Thus, a “scalable” system meant it could scale-out across multiple servers. The performance of any single node became less important and less optimized. I do think that, as a community, we have now learned a lot about building scale-out systems and that we need to switch back to concentrating on single-node performance for reasons having to do with cost and operational efficiency.

Percona: How does single-node performance fit in with time-series data?

Mat Ayre TimeScale Percona Live 18Mat: You can think of time-series data as “live” data. This data is often analyzed on dashboards and near-real-time analysis systems that have very different analysis latency requirements from the BI analytical use cases that data lakes were designed for. Single-node efficiency is important for creating systems that can provide the low-latency results necessary for these live applications. Also, many time-series data settings, especially for IoT related use cases, are remote or at the “edge” (e.g., mining sites, factory floors, satellites, gateways). Single-node performance is important for getting the most out of these smaller footprint or resource-constrained environments.

Percona: Why should people worry about single-node architecture in cloud deployments?

Mat: There are many applications in cloud deployments where the single-node data architecture that systems like TimescaleDB provides is sufficient for their data needs. In such applications, using a single-node cloud deployment can save costs (i.e., easier to use, easier to maintain, especially compared to smaller multi-node instances). It can also decrease the latency for getting query results compared to alternate multi-node systems.

Percona:  Why should people attend your talk? What do you hope people will take away from it?

Mat: I hope that people learn two things: (1) that it is often possible (and desirable) to use efficient single-node data analysis systems for many important real-life applications, and (2) as a community, we should start concentrating on single-node efficiency even in multi-node systems. It sort of goes along with the whole “use the right tool for the job” approach that most people tend to aspire to.

Percona: What are you looking forward to at Percona Live (besides your talk)?

Mat: I always like learning about data analysis systems that take new approaches. The diversity of talks and topics at Percona always gives me the opportunity to learn something new. And of course, meeting new people is fun and educational, and Percona Live gives you a great opportunity for that!

Want to find out more about this Percona Live 2018 featured talk, and single-node database performance? Register for Percona Live 2018, and see Mat’s talk Databases Have Forgotten About Single Node Performance, A Wrongheaded Trade-Off. Register now to get the best price! Use the discount code SeeMeSpeakPL18 for 10% off.

Percona Live Open Source Database Conference 2018 is the premier open source event for the data performance ecosystem. It is the place to be for the open source community. Attendees include DBAs, sysadmins, developers, architects, CTOs, CEOs, and vendors from around the world.

The Percona Live Open Source Database Conference will be April 23-25, 2018 at the Hyatt Regency Santa Clara & The Santa Clara Convention Center.

The post Percona Live 2018 Featured Talk: Databases Have Forgotten About Single Node Performance, A Wrongheaded Trade-Off with Mat Arye appeared first on Percona Database Performance Blog.

Mar
23
2018
--

This Week in Data with Colin Charles 33: Reporting from FOSSASIA 2018 and Azure Announces Database Services for MySQL and PostgreSQL

Colin Charles

Colin CharlesJoin Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

Writing to you on the ground from FOSSASIA 2018, where I gave a track introduction yesterday since we have a pretty awesome database track most Saturday, and generally, all MySQL focused on Sunday. There’s even a list of talks by Oracle MySQL’ers (yes, there’s more than just Oracle folk, but for that, you got to get the schedule).

The Percona Live Community Dinner happens again this year during Percona Live 2018, at Pedro’s on 24 April 2018. It starts at 7 pm, and I highly recommend you purchase the $30 ticket. It usually sells out, so don’t wait till it’s too late.

Some big news from a MySQL in the cloud perspective: Announcing general availability of Azure database services for MySQL and PostgreSQL. There’s also a quick guide: Create an Azure Database for MySQL server by using the Azure portal. Note that next comes MariaDB Server too.

Releases

Link List

Upcoming appearances

The post This Week in Data with Colin Charles 33: Reporting from FOSSASIA 2018 and Azure Announces Database Services for MySQL and PostgreSQL appeared first on Percona Database Performance Blog.

Mar
21
2018
--

Percona Live 2018 Featured Talk: Deep Dive into the RDS PostgreSQL Universe with Jignesh Shah

Percona Live 2018 Jignesh AWS

Percona Live 2018 Featured TalkWelcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post highlights Jignesh Shah, Senior Product Manager at Amazon Web Services. His talk is titled Deep Dive into the RDS PostgreSQL Universe. PostgreSQL is a very popular relational database gaining traction in Amazon’s RDS cloud environment. In our conversation, we discussed the features, uses, and benchmarks for PostgreSQL in AWS RDS:

Percona: Who are you, and how did you get into databases? What was your path to your current responsibilities?

I am a Senior Product Manager for Amazon Relational Database Service. I first started learning about databases with dBase III in 1994, followed by FoxPro, Progress 4GL, IBM DB2. I started learning about open source databases in the 2000s including PostgreSQL and MySQL, with a focus on database performance tuning on Sun Solaris Systems, and got closely involved in PostgreSQL-related benchmarks. One thing led to another, and I ended up building databases, virtual machines, and application lifecycle management products.

Percona: Your talk is titled “Deep Dive into the RDS PostgreSQL Universe”. How popular is PostgreSQL in Amazon RDS? 

PostgreSQL engines – including Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility – are very popular and fast growing. Customers love the flexibility of PostgreSQL and ease of operations provided by Amazon RDS. Customers are excited by the innovations happening here, and love to give feedback on features and capabilities we can add to PostgreSQL in Amazon RDS. Most of our features are driven by customer requests, and customers are excited when they see their requested features available in the service.

Percona Live 2018 Jignesh AWSPercona: Why would you use PostgreSQL in Amazon RDS as opposed to other databases?

PostgreSQL offers good performance out of the box, with transactional semantics very similar to those of Oracle and SQL Server. PostgreSQL is object-oriented and ANSI SQL:2008 compatible, which makes it easy for customers to migrate applications from other relational database platforms. PostgreSQL also has very strong support for geospatial capabilities with the PostGIS extension and supports stored procedures in many languages, including PL/pgSQL (which is very similar to Oracle’s PL/SQL).

Percona: What PostgreSQL features are especially useful?

Every major release of PostgreSQL comes with new interesting features. Features like JSONB to handle JSON data types, spatial features with PostGIS for developing location-based services, foreign database wrappers to do federated queries, and replication features to replicate data are very useful. Especially for modern application development where speed and operational readiness are required for startups and enterprises.

Percona: Why should people attend your talk? What do you hope people will take away from it?

PostgreSQL and Amazon RDS together solve many developer needs and make operational lives easier for administrators – saving them time, resources and cost. Come and learn what is new in Amazon RDS for PostgreSQL, and look under the hood of how some of the capabilities work behind the scenes!

Percona: What are you looking forward to at Percona Live (besides your talk)?

I look forward to hearing from customers about their experiences with PostgreSQL, and learning more about the latest developments in open source databases at Percona Live.

Want to find out more about this Percona Live 2018 featured talk, and PostgreSQL in AWS RDS? Register for Percona Live 2018, and see Jignesh’s talk Deep Dive into the RDS PostgreSQL Universe. Register now to get the best price! Use the discount code SeeMeSpeakPL18 for 10% off.

Percona Live Open Source Database Conference 2018 is the premier open source event for the data performance ecosystem. It is the place to be for the open source community. Attendees include DBAs, sysadmins, developers, architects, CTOs, CEOs, and vendors from around the world.

The Percona Live Open Source Database Conference will be April 23-25, 2018 at the Hyatt Regency Santa Clara & The Santa Clara Convention Center.

The post Percona Live 2018 Featured Talk: Deep Dive into the RDS PostgreSQL Universe with Jignesh Shah appeared first on Percona Database Performance Blog.

Mar
15
2018
--

Percona Live 2018 Featured Talk: MongoDB for a High Volume Logistics Application with Eric Potvin

Eric Potvin Shipwire

Percona Live 2018 Featured TalkWelcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post highlights Eric Potvin, Software Engineer at Shipwire. His talk is titled MongoDB for a High Volume Logistics Application. Leveraging old technology with modern solutions can help improve and optimize documents manipulation. In our conversation, we discussed how Eric worked with MongoDB to achieve this end:

Percona: Who are you, and how did you get into databases? What was your path to your current responsibilities?

Eric: I was introduced to databases with Oracle back in college. I was fascinated by how we can store data and retrieve it instantly. After college, I worked as a back-end and front-end developer in many companies that used RDMSs. Most of these companies couldn’t afford the cost of an Oracle database, so (back in 2003), I started with MySQL version 3. Over the years, MySQL improved, and I had to keep up. This lead to my decision to get my MySQL 5 Developer Certification in 2009 (https://www.greenways.us/About/candidates.php?exam=3).

Percona: Your talk is titled “MongoDB for a High Volume Logistics Application”. What high volume logistics application are you working with, and what issue were you facing that required a database solution?

Eric Potvin ShipwireEric: We are not using any third-party software, we built in-house software that accommodated our specific needs. We are working with multiple companies (if you prefer, warehouses), and each of them has their own specific standards and formats.

Storing data into MySQL might seem like a good idea at first, but querying data turned out to be painful and very slow. This is why we chose MongoDB. We can simply import all these documents without constantly “ALTER” our schema. This gives us the flexibility we need when we need to process any information we received.

Percona: Why a non-relation instead of a relational database?

Eric: MySQL is great, don’t get me wrong there. But MongoDB offers manageability and a Dynamic schema that fit our needs. Every business is different, and have their own format. We cannot enforce a specific data structure, so we need a solution that can be adapted instantly without frequently updating our database schema. This is why MongoDB provides the perfect solution to store any information or documents our clients and customers are sending to us.

Percona: Why should people attend your talk? What do you hope people will take away from it?

Eric: This session talks about what we did to improve our system. The important thing here is this session can be applied to any situation or any type of business. People who attend this session will understand how MongoDB can efficiently store, retrieve and manage document-oriented information. In addition, they will learn — and more importantly, understand — how to manage document-oriented data and how it is a solution that can enrich their application potentials.

Percona: What are you looking forward to at Percona Live (besides your talk)?

Eric: I am looking forward to a very exciting Percona Live this year. When I saw the schedule, I wasn’t sure what to attend. There are so many great talks about scaling, optimization, monitoring and security. These are my “go to” keywords, and they are everywhere this year!

Want to find out more about this Percona Live 2018 featured talk, and MongoDB? Register for Percona Live 2018, and see his talk MongoDB for a High Volume Logistics Application. Register now to get the best price! Use the discount code SeeMeSpeakPL18 for 10% off.

Percona Live Open Source Database Conference 2018 is the premier open source event for the data performance ecosystem. It is the place to be for the open source community. Attendees include DBAs, sysadmins, developers, architects, CTOs, CEOs, and vendors from around the world.

The Percona Live Open Source Database Conference will be April 23-25, 2018 at the Hyatt Regency Santa Clara & The Santa Clara Convention Center.

 

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com