Just found out that the #Percona MySQL #Operator, which deploys a Percona XtraDB/Galera Cluster on #Kubernetes quite nicely and sets up #ProxySQL to be able to split traffic between read and write queries, does not, actually, loadbalance over the nodes. There's a bug open since May 2021 which just disables this feature by providing incorrect config in ProxySQL. So this killer feature, which is still advertised in the docs, simply does not work at all. And there's no way to fix it manually.

Are you leveraging #Docker? Have you explored the benefits of #Podman? Discover the simplicity of transitioning & enhancing your workflow with diverse #environments. Check out this #openSUSE #conference talk by #Percona to learn more! https://youtu.be/A_fbjz0RWeI

Friends in Belgrade! #Percona University is coming to you! 

With other amazing speakers, our CTO Alexey Palazhchenko will speak about the solutions we provide at #FerretDB.

Learn more about the event + RSVP -- https://blog.ferretdb.io/meet-ferretdb-percona-university-casablanca-belgrade/

#opensource #database #ferretdb

A leading provider of #OpenSource database solutions in on-premises and cloud environments, Percona is hiring professionals in database, security, marketing, and more. Browse all jobs now on #OSJobHub https://opensourcejobhub.com/company/339/ #jobs #career #database #security #marketing #PostgreSQL #MongoDB #MySQL #Percona

#Percona Xtrabackup for #MySQL 8.0.32 was released only 41 days after the upstream Oracle MySQL release! This is a new record. Very proud of the team that worked on this.

#opensource #databases #backup

https://docs.percona.com/percona-xtrabackup/8.0/release-notes/8.0/8.0.32-25.0.html

Feedback Wanted! We are considering changing the EXPLAIN statement in #Percona Server for #MySQL to require fewer privileges for providing execution plans for INSERT/UPDATE/DELETE statements (and possibly changing the behavior for EXPLAIN SELECT as well). What are your thoughts?

#opensource #databases #monitoring

https://www.percona.com/blog/feedback-wanted-making-explain-require-less-privileges-for-insert-update-delete-statements/

that thing sets you up with a web server, redis, mysql (or is it #mariadb? is that still a thing? why not #percona! knock yourself out), some office thing (#collabora?), an imaginary thing (presumably not literal), backups and AV. the full mounty. that's the Way.

Why isn't the way that the percona online schema change tool handles making schema changes the way that MySQL just does it by default? Seems like there's probably very little downside. Could always have a flag to lock the table if needed.
#MySQL #Percona

Why isn't the way that the percona online schema change tool handles making schema changes the way that MySQL just does it by default? Seems like there's probably very little downside. Could always have a flag to lock the table if needed.
#MySQL #Percona

#Percona Server and Distribution for #MySQL 8.0.31 have been released, including countless bug fixes and improvements.

#opensource #databases

https://docs.percona.com/percona-server/8.0/release-notes/8.0.31-23.html

#Percona XtraBackup 8.0.31-24 has been released, now supporting IAM instance profiles when running xbcloud from EC2 instances.

#opensource #databases #backup #mysql #aws #s3

https://docs.percona.com/percona-xtrabackup/8.0/release-notes/8.0/8.0.31-24.0.html

When running mysqldump to create a backup from a #MySQL, #Percona or #MariaDB database, the default output is a non-compressed data dump of the #database. By adding on-the-fly compression, the resulting dump file can be significantly reduced.
However finding the right #compression method isn't always easy.

In our latest #blog post we are comparing different compression methods - with a surprising (lesser known) winner.

https://www.claudiokuenzler.com/blog/1289/performance-comparison-different-compression-methods-mysqldump

If you have missed it, the #Percona website has received a long overdue remake and new branding. I like the new logo and product artwork! Kudos to the team that worked on this intensively over the last few months.

https://percona.com/

Peter Zaitsev is taking us for a Deep Dive Into Query #Performance at the completely packed #FOSDEM #PostgreSQL #devroom #database #opensource #postgres #PeterZaitsev #Percona

Controversial blog post by Peter Zaitsev from #Percona:

Why #PostgreSQL Needs Transparent #Database #Encryption (TDE)

#opensource

https://www.percona.com/blog/why-postgresql-needs-transparent-database-encryption-tde/

@mgorny honestly I’ll take #Galera multi-master backup over “hand-crafted” multi-master replication any day. That said, backups were slightly more difficult to setup. In my experience #Percona #Xtrabackup worked best — it can do full backups off of one node super fast and compressed for free. Ideally you’ve got three nodes and take one out from the cluster by setting wsrep thingies to desync it before backup is being performed 👌🏻

Percona’s Dave Stokes takes a look at MySQL 8.0.32 to see what is new, changed, and deprecated in this release.
https://www.percona.com/blog/quick-peek-at-mysql-8-0-32/

#MySQL #OpenSource #Percona #Databases

"The old myth that MySQL can’t handle large datasets is nothing but a myth. With hardware being more powerful and cheaper, and the technology evolving, now it is easier than ever to manage large tables in MySQL."

#mysql #opensource #databases #percona #blog #performance

https://www.percona.com/blog/why-mysql-could-be-slow-large-tables

Join us today at 15:30 UTC / 16:30 CET to learn more about securing your data using PostgreSQL!

Edith Puclla, Mario García, Ibrar Ahmed, and Kai Wagner will discuss database security at the monthly Percona Developer Meetup!

#opensource #databases #postgresql #security #percona #meetup

https://percona.community/events/streams-monthly-dev/2023-01-12-securing-data/

New on the Percona Community Blog: How To Generate Test Data for Your Database Project With Python by Mauro García

#opensource #databases #MongoDB #python #mysql #Percona #blog #community

https://percona.community/blog/2023/01/09/how-to-generate-test-data-for-your-database-project-with-python/