Nov
09
2020
--

Deep Dive Into PostgreSQL Indexes – Free Course at Percona University Online

Postgresql indexes percona

Postgresql indexes perconaPercona University Online has released its second free course, “A Deep Dive Into PostgreSQL Indexes” by Ibrar Ahmed, Senior Software Engineer at Percona.

Indexes are a basic feature of relational databases. PostgreSQL offers a rich collection of index options for developers and designers. But users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make the best decisions about index strategy and design. 

This course consists of 13 short videos. Pass a brief quiz afterward and receive a Certificate of Completion from Percona. Begin the course on Google Classroom here. If you’re prompted for a class identifier, enter code xk5k6fz. The lesson list:

  • Lesson 1: Overview
  • Lesson 2: Heap vs Index
  • Lesson 3: How to Create Indexes?
  • Lesson 4: How to create an Expression Index?
  • Lesson 5: Advantages of a Partial Index
  • Lesson 6: Index Types: B-Tree
  • Lesson 7: Index Types: What is the HASH Index?
  • Lesson 8: Index Types: What is the BRIN Index?
  • Lesson 9: Index Types: GIN and GIST
  • Lesson 10: How to use different types of Indexes?
  • Lesson 11: Index Only Scans
  • Lesson 12: How to Find Duplicate Indexes?
  • Lesson 13: Unused Indexes
  • Course Quiz & Certificate of Completion

You can view the lessons directly on YouTube but you’re eligible for the Certificate of Completion only by attending via Google Classroom. For questions or suggestions, visit the Percona Forum Training category.

In case you missed it, see our initial Percona University Online course How to Upgrade to MySQL 8.0.

PostgreSQL Indexes

Sep
12
2019
--

Percona University Istanbul on October 4

Percona University Istanbul 2019

Percona University Istanbul 2019The latest Percona University event will be held in Istanbul on Friday, October 4. These are free events featuring technical presentations from Percona and guest speakers. Talks are good for anyone who uses database technologies as part of their tech stack. In other words, for pretty much anyone working databases, devops, and development.

Agenda

Here’s a quick look at the talks, put together by local Perconian, Alkin Tezuysal:

  • HA MySQL on Kubernetes using Percona XtraDB Cluster and ProxySQL presented by Ananias Tsalouchidis, Senior MySQL DBA, Percona
  • Introduction to MySQL Query Tuning for Dev[Op]s presented by Sveta Smirnova, Principal Support Escalation Specialist, Percona
  • Ten Things Developers Should Know About Databases presented by Peter Zaitsev, CEO, Percona
  • 40X Database Response in a Nutshell presented by Sinan Alyuruk, Gittigidiyor / EbayTK
  • PMM Installation and Configuration for PostgreSQL and MongoDB presented by Michael Nosek and Dimitri Vanoverbeke, Solutions Engineering, Percona
  • Sharding MySQL with Vitess presented by Harun Küçük, Sahibinden.com

Find out more and register

You can see the full agenda with timings on the event page. This event is being hosted by iyzico and with the support of eBay. Thank you to both companies for helping us with Percona University Istanbul.

Places are limited, refreshments and snacks are included, so please register in advance.

Do it soon to avoid disappointment!

Percona Live Europe 2019…

Have you bought your tickets for Percona Live Europe yet? The conference takes place from September 30 – October 2 at the Hilton Schiphol. This venue is within easy reach of the airport making it feasible to just drop in for the day if that’s all the time you can spare. Take a look at the full agenda for Percona Live Europe 2019 and reserve your place soon!

Mar
27
2019
--

Percona University Travels to South America

Percona University April 2019

Percona University April 2019We started hosting Percona University a few years back with the aim of sharing knowledge with the open source database community. The events are held in cities across the world. The next Percona University days will visiting Uruguay, Argentina, and Brazil, in a lightning tour at the end of April.

  • Montevideo, Tuesday, April 23 2019 from 8.30am to 6.30pm
  • Buenos Aires, Thursday, April 25 2019 from 1.30pm to 10.3pm
  • São Paulo, Saturday, April 27 2019 from 9.30am to 7.30pm

What is Percona University?

It is a technical educational event. We encourage people to join us at any point during these talks – we understand that not everyone can take off a half a day from their work or studies. As long as you register – that’s essential.

What is on the agenda for each of the events?

Full agendas and registration forms for the Montevideo, Buenos Aires, and São Paulo events can be accessed at their respective links.

Does the word “University” mean that we won’t cover any in-depth topics, and these events would only interest college/university students?

No, it doesn’t. We designed Percona University presentations for all kinds of “students,” including professionals with years of database industry experience. The word “University” means that this event series is about educating attendees on technical topics (it’s not a sales-oriented event, it’s about sharing knowledge with the community).

Does Percona University cover only Percona technology?

We will definitely mention Percona technology, but we will also focus on real-world technical issues and recommend solutions that work (regardless of whether Percona developed them).

Are there other Percona University events coming up besides these in South America?

We will hold more Percona University events in different locations in the future. Our newsletter is a good source of information about when and where they will occur. If you’d like to partner with Percona in organizing a Percona University event, contact Tom Basil who leads our community team… or Lorraine Pocklington our Community Manager. You can also check our list of technical webinars to get further educational insights.

These events are free and low-key! They aren’t meant to look like a full conference (like our Percona Live series). Percona University has a different format. We make it informal, so it’s designed to be perfect for learning and networking. This is an in-person database community gathering, so feel free to come with interesting cases and tricky questions!

Jun
16
2017
--

Peter Zaitsev’s Speaking Schedule: Percona University Belgium / PG Day / Meetups

Peter Zaitsev Speaking Schedule

This blog shows Peter Zaitsev’s speaking schedule for this summer.

Summer 2017 Speaking Engagements

This week I spoke at the DB Tech Showcase OSS conference in Japan and am now heading to Europe. I have a busy schedule in June and early July, but there are events and places where we can cross paths and have a quick conversation. Let’s meet at these events if you need anything from Percona (or me personally). 

Below is a full list of places I’ll be at this summer:

Amsterdam, Netherlands

On June 20 I am speaking at the In-Memory Computing Summit 2017 with Denis Magda (Product Manager, Gridgain Systems). Our talk “Accelerate MySQL® for Demanding OLAP and OLTP Use Cases with Apache® Ignite™” starts at 2:35 pm.

On the same day in Amsterdam, Denis and I will speak at the local MySQL User Group meetupI will share some how-tos for MySQL monitoring with Percona Monitoring and Management (PMM), along with a PMM demo.

Ghent, Belgium

On June 22 we are organizing a Percona University event in Ghent, Belgium, which is a widely known tech hub in the region. I will give several talks there on MySQL, MongoDB and PMM monitoring. Dimitri Vanoverbeke from Percona will discuss MySQL in the Cloud. We have also invited guest speakers: Frederic Descamps from Oracle, and Julien Pivotto from Inuits.

Percona University technical events are 100% free to attend, and so far we are getting very positive attendee feedback on them. To check the full agenda for the Belgium edition, and to register, please use this link.

St. Petersburg, Russia

Percona is sponsoring PG Day’17 Russia, the PostgreSQL conference. This year they added a track on open source databases (and I was happy to be their Committee member for the OSDB track). The conference starts on July 5, and on that day I will give a tutorial on InnoDB Architecture and Performance Optimization. Sveta Smirnova will also present a tutorial on MySQL Performance Troubleshooting.

On July 6-7, you can expect four more talks given by Perconians at PG Day. We invite you to stop by our booth (“Percona”) and ask us any tough questions you might have.

Moscow, Russia

On July 11 I will speak at a Moscow MySQL User Group meetup at the Mail.Ru Group office. While we’re still locking down the agenda, we always have a great selection of speakers at the MMUG meetups. Make sure you don’t miss this gathering!

Thank you, and I hope to see many of you at these events.

May
02
2017
--

Percona University in Europe May 9 and May 11

Percona University

Percona University in EuropeIn 2013 we started Percona University, which consists of technology discussion events held in different cities around the world. The next installments of Percona University in Europe are next week when I fly there for Percona University Berlin (May 9) and Percona University Budapest (May 11). Both events are free to attend, and you are very welcome to join us for either of them.

Below are some questions and answers about why you should attend a Percona University session:

What is Percona University? It is a half-day technical educational event, with a wider program when compared to a traditional meetup. Usually, we include about six hours of talks split with a 30-minute coffee break. We encourage people to join us at any point during these talks – we understand that not everyone can take off a half a day from their work or studies.

What is on the agenda for each of the events? Full agendas and registration forms for the Berlin and Budapest events are available at the indicated links.

Does the word “University” mean that we won’t cover any in-depth topics, and these events would only interest college/university students? No, it doesn’t. We designed Percona University presentations for all kinds of “students,” including professionals with years of database industry experience. The word “University” means that this event series is about educating attendees on technical topics (it’s not a sales-oriented event, it’s about educating the community).

Does Percona University cover only Percona technology? We will definitely mention Percona technology, but we will also focus on real-world technical issues and recommend solutions that work (regardless of whether Percona developed them).

Are there other Percona University events coming up besides Berlin and Budapest? We will hold more Percona University events in different locations in the future. Our events newsletter is a good source of information about when and where they will occur. If you want to partner with Percona in organizing a Percona University event, contact our team. You can also check our list of technical webinars to get further educational insights.

These events are free and low-key! We want them to remain easy to organize in any city of the world. They aren’t meant to look like a full conference (like our Percona Live series). Percona University has a different format – it’s purposefully informal, and designed to be perfect for learning and networking. This is an in-person database community gathering, so feel free to come with interesting cases and tricky questions!

I hope to see many of you at Percona University in Europe, Berlin and Budapest editions!

Jan
27
2015
--

Percona University: Back to school Feb. 12 in Raleigh, N.C.

Percona CEO Peter Zaitsev leads a track at the inaugural Percona University event in Raleigh, N.C. on Jan. 29, 2013.

Percona CEO Peter Zaitsev leads a track at the inaugural Percona University event in Raleigh, N.C. on Jan. 29, 2013.

About two years ago we held our first-ever Percona University event in Raleigh, N.C. It was a great success with high attendance and very positive feedback which led us to organize a number of similar educational events in different locations around the world.

And next month we’ll be back where it all started. On February 12, Percona University comes to Raleigh – and this time the full-day educational event will be much more cool. What have we changed? Take a look at the agenda.

First – this is no longer just a MySQL-focused event. While 10 years ago MySQL was the default, dominating choice for modern companies looking to store and process data effectively – this is no longer the case. And as such the event’s theme is “Smart Data.” In addition to MySQL, Percona and MariaDB technologies (which you would expect to be covered), we have talks about Hadoop, MongoDB, Cassandra, Redis, Kafka, SQLLite.

However the “core” data-store technologies is not the only thing successful data architects should know – one should also be well-versed in the modern approaches to the infrastructure and general data management. This is why we also have talks about Ansible and OpenStack, DBaaS and PaaS as well as a number of more talks about big-picture topics around architecture and technology management.

Second – this is our first multi-track Percona University event – we had so many great speakers interested in speaking that we could not fit them all into one track, so we have two tracks now with 25 sessions which makes that quite an educational experience!

Third – while we’re committed to having those events be very affordable, we decided to charge $10 per attendee. The reason for this is to encourage people to register who actually plan on attending – when hosting free events we found out that way too many registered and never showed up, which was causing the venues to rapidly fill past capacity and forcing us to turn away those who could actually be there. It was also causing us to order more food than needed, causing waste. We trust $10 will not prevent you from attending, but if it does cause hardship, just drop me a note and I’ll give you a free pass.

A few other things you need to know:

This is very much a technically focused event. I have encouraged all speakers to make it about technology rather than sales pitches or marketing presentations.

This is low-key educational event. Do not expect it to be very fancy. If you’re looking for the great conference experience consider attending the Percona Live MySQL Conference and Expo this April.

Although it’s a full-day event, you can come for just part of the day. We recognize many of you will not be able to take a full day from work and may be able to attend only in the morning or the afternoon. This is totally fine. The morning registration hours is when most people will register, however, there will be someone on the desk to get you your pass throughout the day.

Thinking of Attending? Take a look at the day’s sessions and then register as space is limited. The event will be held at North Carolina State University’s McKimmon Conference & Training Center. I hope to see you there!

The post Percona University: Back to school Feb. 12 in Raleigh, N.C. appeared first on MySQL Performance Blog.

Apr
21
2014
--

Percona University @Montevideo, FISL & São Paulo MySQL Meetup

Peter Zaitsev at last year's Percona University event in Montevideo

Peter Zaitsev at last year’s Percona University event in Montevideo

Later this week I’m excited to depart on a trip to South America. First I will stop in Montevideo, Uruguay, to meet with Percona’s team out there as well as to participate in our next Percona University event on April 29.

For those who do not know, Percona University events are free to attend and packed with technical presentations about MySQL and surrounding technologies, delivered by members of the Percona team and community speakers. Even though attendance is free, because space is limited you will need to register now to ensure that we have space for everyone.

Next stop will be Brazil, where I’ll be speaking at the local São Paulo MySQL Meetup group on May 6 and then on to Porto Alegre where I’ll speak at FISL (the International Free Software Forum) (May 9 14:00) about the “Practical Optimization of MySQL.”

If you’re also attending FISL and would like to connect at the show drop me a note at ceo AT percona.com.

The post Percona University @Montevideo, FISL & São Paulo MySQL Meetup appeared first on MySQL Performance Blog.

Sep
09
2013
--

September: A busy month for MySQL events

September 2013 MySQL eventsNow with summer winding down and school back in session, we get into a very busy time with many great opportunities to discover more about MySQL with several excellent MySQL events.

At first I wanted to cover all autumn events here but if I did that this post would be far too long. So instead I’m focusing on a few wonderful MySQL events that I’m going to be involved with in September.

In a few short days we’re running Percona University at Washington, D.C. This free event on September 12 provides a great opportunity to learn about latest developments in the MySQL ecosystem as we at Percona see it. I personally will be speaking about Percona XtraDB Cluster, MariaDB 10.0 and Percona Server 5.6, and MySQL 5.6. We also have other great speakers talking about Continent Tungsten, Hadoop, MySQL Cluster, Percona Toolkit as well as insights on using MySQL with Go and best DBA Practices.

On September 18 I’m going to the MySQL Meetup in San Francisco where Ryan Lowe will be speaking about Running MySQL 5.6 on Amazon RDS. The space for these events is limited and they often can’t accommodate everyone, so do not delay and register if you can make it to either one.

In Europe we have Frederic Descamps speaking at the Open Source For Business conference in Prato, Italy September 19-20.  Fred will talk about Percona XtraDB Cluster as well as installing and managing MySQL like a true devops. I especially wish I could attend this talk as Fred has a lot of insights and practical experience with applying a DevOps approach to MySQL installations.

September 21-23 I’ll be at MySQL Connect in San Francisco. This is a great MySQL event that Oracle puts together as part of Oracle Open World Week, which presents great opportunities to talk with Oracle’s MySQL engineering team and learn about new products and the MySQL roadmap. There will also be many great community speakers this year as well, sharing their insights and war stories from MySQL’s front lines. I personally will deliver two presentations, “MySQL Indexing: Best Practices for MySQL 5.6” and “Optimizing MySQL Configuration in MySQL 5.6.” These are great talks for both for MySQL beginners and more advanced users which I have updated to cover MySQL 5.6

At Percona we talk and exhibit at many shows throughout the year so we have created an Events page to keep you up to date. You can also subscribe to our Events newsletter for the latest news and updates on this front.

Have a wonderful September!

The post September: A busy month for MySQL events appeared first on MySQL Performance Blog.

Aug
14
2013
--

Percona University at Washington, D.C. – Sept. 12

Percona University at Washington, D.C. - Sept. 12Following our events earlier this year in Raleigh, Montevideo, Buenos Aires, Toronto and Portland, we bring Percona University to Washington, D.C. on September 12.

This free one-day technical education event will cover many MySQL ecosystem technologies, including: Percona Server, MariaDB, MySQL 5.6, Percona XtraDB Cluster, Tungsten Replicator, Percona XtraBackup, MySQL Cluster and Percona Toolkit. We also will learn about Apache Hadoop and how it can be most successfully used with MySQL environments.

Matt Yonkovit, VP of Percona MySQL Consulting, will give his great talk on the “5 minute DBA,” drawing from a wealth of practical DBA tips for developers and system administrators – professionals who must step up to the plate on occasion and perform DBA tasks.

Ryan Huddleston, director of Percona Remote DBA, will talk about “MySQL Backups in the Real World,” sharing best practices you’ll want to follow if you never want to lose your data again – as well as being able to recover from various data incidents as quickly as possible.

Our special guest for this event is Baron Schwartz, co-Founder and CEO of VividCortex, who will be speaking about Using MySQL with Go. Go Programming language is quickly gaining popularity and we’re excited to bring the most up to date information about using Go with MySQL database.

If you will be in the Washington, D.C. area on September 12, I’d love to see you at this event – space is limited though, so please register now.  And if you’re interested in Percona University events and would like to bring one to your city, please fill out this form to let us know – especially if you can help us by hosting or promoting the event.

The post Percona University at Washington, D.C. – Sept. 12 appeared first on MySQL Performance Blog.

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