Database backups are a fundamental requirement in almost every implementation, no matter the size of the company or the nature of the application. Taking a backup should be a simple task that can be automated to ensure it’s done consistently and on schedule. Percona has an enterprise-grade backup tool, Percona XtraBackup, that can be used to accomplish these tasks. Percona also has a Percona Kubernetes Operator for Percona XtraDB Cluster (PXC Operator), which has Percona XtraBackup built into it. Percona XtraBackup has the ability for both automated and on-demand backups. Today we will explore taking backups and restoring these backups using the PXC Operator deployed …
[Read more]
May
22
2020
May
22
2020
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 …
[Read more]
May
21
2020
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, …
[Read more]
May
21
2020
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?
…[Read more]
May
20
2020
May
20
2020
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 …
May
20
2020
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 ...
May
20
2020
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 …
May
19
2020
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 …
[Read more]
May
19
2020
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...