Personal blog of Yzmir Ramirez

Experience a full day of deep-dive technical sessions and meet database experts and a community of open source database users, developers, and technologists at Percona University events!Percona University is a series of free, Percona-hosted events focused on open source databases and related technologies. Since 2013, we have held these events in cities across the world […]

Percona University Online has released a new free course, “MySQL 5.7 End of Life Options – Free Course at Percona University Online,” by Dave Stokes, Technical Evangelist at Percona. 

Dave is the author of MySQL & JSON – A Practical Programming Guide. He started to work with MySQL from the 3.29 version and was a part of the MySQL Community Team for over a decade.

MySQL 5.7 reaches its End of Life in October 2023. The Era of MySQL 5.x will be over, and only MySQL 8.0 will be officially supported. Learn how to keep your database secure and performant after that date and what real options you have if you decide to upgrade or stay on the current version. 

This course consists of eight short videos. Pass a brief quiz on Google Classroom afterward to receive a Certificate of Completion from Percona. The lesson list:

• Lesson 1: Introduction
• Lesson 2: What MySQL 5.7 EOL Really Means
• Lesson 3: What are the Real Upgrade Options?
• Lesson 4: Choosing Percona – Update to Enterprise Features at No Additional Cost
• Lesson 5: Upgrade Checker Part 1
• Lesson 6: Upgrade Checker Part 2
• Lesson 7: Upgrade Checker Part 3
• Lesson 8: Wrap Up

You can view the lessons directly on YouTube, but you’re eligible for the Certificate of Completion only when you complete the quiz on Google Classroom. You will need a Gmail account. If you join the class from Google Classroom directly, click “Join class” and enter the code of the class “xd36vr4”

For questions or suggestions, visit the Percona Forum Training category or contact us at community-team@percona.com.

Take the full course and pass the quiz in our Google class to get a certificate.

Take the course

Percona University is a series of free educational events focused on Open Source and Open Source Database Technology, in particular, run by Percona. We run those events worldwide, both in recognized tech hubs and in locations that do not have a lot of tech events taking place, as Open Source shall not know limits and boundaries.

Due to the Pandemic, we had to put this project on pause, but now we’re back! In early June, we had Percona University in Lima, Peru, in partnership with ESAN University, and the community response was outstanding, with almost 200 people signed up!

Next in line are:

Percona University, Casablanca, Morocco, on June 27, 2023

Percona University, Belgrade, Serbia, on July 5, 2023 

Are you interested in bringing Percona University to your city? We rely a lot on local support to make those events successful. In particular, we need help with the venue (an auditorium that sits 50-200 people with AV setup) and local event promotion.

Interested? Fill out this form, and we will get back to you!

Bring Percona University to your city!

Percona 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.

The 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!

We 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!

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 meetup. I 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.

In 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!

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.

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.