MinervaDB Webinar – Building MySQL Database Infrastructure for Performance and Reliability

Recently I did a webinar on ” Building MySQL Database Infrastructure for Performance and Reliability ” , It was big success and thought will share the slides of webinar in this blog. I get lot of emails daily from Database Architects, DBAs, Database Engineers, Technical Managers and Developers worldwide on best practices and checklist to build MySQL for performance, scalability, high availability and database SRE, The objective of this webinar is to share with them a cockpit view of MySQL infrastructure operations from MinervaDB perspective. Database Systems are growing faster than ever, The modern datanomy businesses like Facebook, Uber, Airbnb, LinkedIn etc. are powered by Database Systems, This makes Database Infrastructure operationally complex and we can’t technically scale such systems with eyeballs. Building MySQL …

Today is a good day for me. Today I tweeted that MySQL after 25 years is still GPL and same for all important components: the server, the shell, the router, the clone plugin, workbench !

To be honest, Oracle has been a very good steward for MySQL so far, PZ and Kaj admitted it too. This exactly what I was thinking when I joined the MySQL family and I’m still convinced about it after 4 years… and never as much as now !

If you know me, you should know that for more than 20 years I always praised and defended Open Source! All kind, not only MySQL! I started of course with Linux and then a huge amount of projects where I dedicated time, docs, code, bug reports, chats… As you know I also worked for Stone-IT, X-tend, …

Percona Training Is Here for You!

Percona’s Training and Education Department wants you! For the past three years, Percona has quietly been delivering world-class training all over the globe, to companies large and small. We are in full force and ready to spread our knowledge directly to your organization to make your staff the absolute best they can become.

As you probably know, Percona has been one of the top leaders in the open source database space for over ten years. Our experts are exactly that: experts. Our MySQL and open source database training programs leverage the cumulative knowledge and best practices gained from our years of experience working on real-world issues and solving problems for our customers. When you enroll in our courses, we transfer our knowledge and experience to you and your team.

Why Should My Company Invest in Training?

In my interview with Shane Atherholt, Head of ISVs at MySQL, I asked him several questions: What is an ISV?  What is a SaaS application? How are ISVs using MySQL?

We also went over the recent data breaches and new government regulations. I asked how MySQL helps ISVs secure their data and comply with the new regulations. I also asked Shane what were ISV CEOs and CIOs top priorities and why they should consider a relationship with Oracle. In conclusion, we talked about what we should look forward to in the future with MySQL. Watch the interview below.

On May 27th, 2020, Shane Atherholt will hold a webinar focused on SaaS solutions for ISVs where he will go into more in depth detail about the MySQL offering for ISVs and SaaS. He will also cover the many MySQL Enterprise edition features that are designed to help ISVs with their SaaS applications so they can be more …

In my interview with Shane Atherholt, Head of ISVs at MySQL, I asked him several questions: What is an ISV? What is a SaaS application? How are ISVs using MySQL? We also went over the recent data breaches and new government regulations. I asked how MySQL helps ISVs secure their data and comply with ...

The purpose of this post if to show how you can automate the creation and pruning of partitioned tables. If you want to read about partitioning I recommend reading our manual.

In short partitioning makes it possible to spread your individual tables across a file system according to the partition rules you specify.

Reasons for partition your tables might be:
- Insert performance, smaller index trees for stable insert throughput.
- Select performance, only read data from selected (aka partitioning pruning) partitions.
- Delete performance, drop partitioning is must quicker than doing range deletes of old data.

Partitioning definitions is part for the CREATE/ALTER table statements, in …

This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success.

Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It became and continues to be the most popular open source database. Early this year it earned the DB-Engine award for most popular database.

The most successful applications and websites we all know and use today, such as Twitter, Facebook, Booking but also Uber, Airbnb and many more, started with MySQL, grew up with MySQL and now scale with MySQL.

Over the years it has become the database of choice for many of the most successful open source applications like WordPress, Drupal, Joomla, Magento, and many more.   

It has always been ranked the developers’ favorite …

This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success. Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It became and continues to be the most popular open source database. Early this year it earned the DB-Eng...

Dual-password capability makes it possible to seamlessly perform credential changes without downtime.

The post MySQL Security - Dual Password Support first appeared on dasini.net - Diary of a MySQL expert.