Planet MariaDB

March 1, 2016, was my first day of working for MariaDB Corporation. It means that I worked for them full 5 years in a row! It's the longest period I've ever spent working in the same company. I worked for more than 7 years in MySQL Bugs Verification team of MySQL Support, but formally it was for 3 different companies over that period, MySQL AB, Sun and Oracle. So tonight, after 2 weekend on-call shifts in a row I want to summarize what I lost over that 5 years and what I won.I never planned to leave Percona after just… Read more

I mostly edit my Verilog files for basic Xilinx CPLD devices in vim, so it is a pain to launch the entire Xilinx IDE just to compile the thing. After doing a bit of research I managed to figure out how to compile from the command line too. You need three things to make this […]… Read more

For a while I was using GCC as a cross-compiler to write software for Amigas. This was familiar territory for me having used GCC for Linux applications for many years. Unfortunately I hit a very strange bug which appears to be something to do with the compiler output. So I decided it was time for […]… Read more

Yes, this post is about connection queueing, not just pooling. Because “connection pooling” – pre-created connections as a pool – is a much-celebrated feature. Almost every discussion on connection pool/pgBouncer starts with the overhead of establishing a new connection to PostgreSQL… and how pre-created connections in the pool can save the world. But there is […]… Read more

Join Rick Vasquez, Percona Technical Expert, as he discusses the pros and cons of moving your database to the cloud. Flexibility, performance, and cost management are three things that make cloud database environments an easy choice for many businesses. If you are thinking of moving your database to the cloud you need to know the […]… Read more

We see quite often customers complaining that their Galera Cluster is not stable and "crashes" from time to time. As always one has to investigate before rating. What comes out quite often is that the customer (or better their developers) are running huge transactions. In general transactional database do NOT like huge transactions because of various reasons (MVCC, ROLLBACK, UNDO, Locking etc.). They can do it. But they are not quite good in doing it and they do not like it. Instead you should better do many smaller transactions which you can run in parallel to keep the throughput. But:… Read more

MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “show” and “watch”. Both commands are very useful to monitor the MySQL process. It provides more insights into the foreground and background threads as well.  Overview “show” and “watch” are the […]… Read more

Here at Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might […]… Read more

The Problem HELP, HELP! My Percona XtraDB Cluster version: 5.7.31-31. Single Node is stuck in a joined state. I recently had the privilege to help a client with a fascinating issue. NODE-B dropped out of the 3 node PXC cluster. It looked to be DISK IO that caused NODE-B to fall far behind and eventually […] The post How To Speed Up Re-sync of Dropped Percona XtraDB Cluster Node appeared first on Percona Community Blog…. Read more

Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) added support for PITR in version 1.7, […]… Read more

Great news!  Percona’s Community-focused podcast, hosted by none other than the HOSS (Head of Open Source Software) himself (yeah, that is me), is now available on almost all podcast platforms. What? You didn’t know we had a podcast? We do, and we’ve had some great episodes since we started in January. In fact, we just […]… Read more

Technology consumers and users have embraced cloud computing ever since its boom.  It implicates a very beneficial part nowadays to the technology on how humans use and interact with technology, especially the advent of IoT (Internet of Things) and IoE (Internet of Everything). Both technologies conceptualize how it will interconnect a variety of devices (including smartphones, home appliances, sensors, and other network devices), people, data, and processes and allow them to communicate with each other seamlessly.    Although IoT or IoE is not our focus on this blog post, both are using cloud computing to facilitate the system that underlies… Read more

How do we configure PostgreSQL for performance ? We work for some of the largest PostgreSQL database infrastructure globally, Often we get query on how to configure PostgreSQL for performance, scalability and reliability so thought […] The post How do we configure PostgreSQL for performance ? appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

Vettabase is a MariaDB Foundation partner. We contributed documentation about automating MariaDB deployments and configuration management. Continue reading Vettabase is now a MariaDB Foundation Technology Partner→ The post Vettabase is now a MariaDB Foundation Technology Partner appeared first on Vettabase…. Read more

Federico Razzoli, Vettabase director and consultant, and well-known member of the MariaDB community, has contributed a new section to the MariaDB documentation, on Automated MariaDB Deployment and Administration. […] The post Automated MariaDB deployment and administration appeared first on MariaDB.org…. Read more