May 04, 2020 |
Insight for DBAs, MySQL, Percona Software
In the light of support for Percona XtraDB Cluster (PXC), the DBdeployer anniversary, and the newly released Percona XtraDB Cluster 8.0, I’m happy to announce that Giuseppe Maxia has recently updated DBdeployer to support Percona XtraDB Cluster 8.0. We at Percona, with my colleague Ramesh Sivaraman, have tested and deployed Percona XtraDB Cluster (PXC) 8.0.18 […]
Feb 20, 2020 |
Insight for DBAs, MariaDB, MySQL, Storage Engine
In this blog post, we will share some experiences with the hidden gem in MySQL called MyRocks, a storage engine for MySQL’s famous pluggable storage engine system. MyRocks is based on RocksDB which is a fork of LevelDB. In short, it’s another key-value store based on LSM-tree, thus granting it some distinctive features compared with […]
Jan 15, 2020 |
Cloud, Insight for DBAs, MySQL
In this blog post, we will continue to explore Vitess and test an example database provided in its repository. This is Part III of the previously discussed installation of Vitess on minikube environment, so please make sure to follow those steps to bring the cluster up to the following level.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
$ kubectl get pods,jobs NAME READY STATUS RESTARTS AGE po/etcd-global-kbbcqlgvp9 1/1 Running 0 43m po/etcd-zone1-lpc5zmdxxn 1/1 Running 0 43m po/my-release-etcd-operator-etcd-backup-operator-6684dd6d8c-pr4n4 1/1 Running 0 1h po/my-release-etcd-operator-etcd-operator-86d94989d6-w9lpx 1/1 Running 0 1h po/my-release-etcd-operator-etcd-restore-operator-c655d757c-9nsnz 1/1 Running 0 1h po/vtctld-757df48d4-c2gp9 1/1 Running 3 43m po/vtgate-zone1-5cb4fcddcb-k2zsn 1/1 Running 3 43m po/zone1-commerce-0-rdonly-0 6/6 Running 0 43m po/zone1-commerce-0-replica-0 6/6 Running 0 43m po/zone1-commerce-0-replica-1 6/6 Running 0 43m NAME DESIRED SUCCESSFUL AGE jobs/commerce-apply-schema-initial 1 1 43m jobs/commerce-apply-vschema-initial 1 1 43m jobs/zone1-commerce-0-init-shard-master 1 1 43m |
Copy local files to […]
Jan 14, 2020 |
Cloud, Insight for DBAs, MySQL
In this blog post, I’d like to share some experiences in setting up a Vitess environment for local tests and development on OSX/macOS. As previously, I have presented How To Test and Deploy Kubernetes Operator for MySQL(PXC) in OSX/macOS, this time I will be showing how to Run Vitess on Kubernetes. Since running Kubernetes on […]
Jan 13, 2020 |
Cloud, Database Trends, Insight for DBAs, MySQL
In this blog post series, we will discuss an overview of Vitess technology. Vitess is a database clustering solution for horizontal scaling of data sets currently suitable to 250Gb – 300Gb in sizes*. It’s a proven technology used by several web-scale companies including YouTube. PlanetScale is the company behind developing and supporting this open-sourced project. […]
Sep 27, 2019 |
MySQL, ProxySQL
Multiplexing Background Historically it’s a technique used in networking to integrate multiple analog and digital signals via a shared medium. The goal of multiplexing over the network was to enable signals to be transmitted more efficiently for a given communication channel, thus achieving cost efficiency. Since the term Multiplexing comes from telecommunications, the industry has […]
Apr 26, 2019 |
MySQL, Percona Events, Percona Live, Percona Software
This year we’re having a different concept for Percona Live conferences, which started at Percona Live Europe 2018 last fall. This is an approach practiced by many other organizations by having separate track for MySQL®, MongoDB®, MariaDB®, or PostgreSQL and more. Having many tracks in this big Open Source Database Conference meant that one track […]
Mar 19, 2019 |
MySQL, Percona Software
In this blog post, I’m going to show you how to test Kubernetes locally on OSX/macOS. Testing Kubernetes without having access to a cloud operator in a local lab is not as easy as it sounds. I’d like to share some of my experiences in this adventure. For those who have already experienced in Virtualbox […]
Jan 28, 2019 |
Insight for DBAs, MySQL, Percona Software, Webinars
Please join Percona’s Senior Technical Manager, Alkin Tezuysal, and Percona’s Percona XtraDB Cluster Lead, Krunal Bauskar as they present their talk, Percona XtraDB Cluster: Failure Scenarios and their Recovery on Wednesday, January 30th, 2019, at 8:00 AM PST (UTC-8) / 11:00 AM EST (UTC-5). View the Recording Percona XtraDB Cluster (a.k.a PXC) is an open […]
Jan 22, 2019 |
Cloud, Insight for DBAs, Insight for Developers, Webinars
Please join Percona’s Senior Technical Manager, Alkin Tezuysal, as he presents Databases Gone Serverless? on Thursday, January 24th, at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). View the Recording Serverless computing is becoming more popular with developers. For instance, it enables them to build and run applications without needing to operate and manage servers. […]
May 02, 2018 |
Insight for DBAs, Insight for Developers, MySQL, ProxySQL
In this blog post, I’m going to revisit the ProxySQL Query Rewrite feature. You may have seen me talking about possible use case scenarios in the past few conferences, but the reason I’m starting with this is that query rewriting was the original intention for building ProxySQL. Why would you need to rewrite a query? […]
Mar 09, 2018 |
Benchmarks, MySQL, ProxySQL
In this blog post, I’ll be looking at a new tool Proxytop for managing MySQL topologies using ProxySQL. Proxytop is a self-contained, real-time monitoring tool for ProxySQL. As some of you already know ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQL and its forks (Percona and MariaDB). My lab […]