Author: MySQL Planet

Feed: Planet MySQL; Author: Percona Community; Cate Lawrence  | June 2, 2020 |  Posted In: DevOps, Kubernetes, MySQL, Open Source DatabasesThis session at Percona Live ONLINE was presented by Akshay Suryawanshi, Senior Production Engineer at Shopify, and Jeremy Cole, Senior Staff Production Engineer – Datastores at Shopify.Shopify is an online and on-premise commerce platform, founded in 2006. Shopify is used by more than a million merchants, and hundreds of billions of dollars of sales have happened on the platform since its inception. The company is a large user of MySQL, and the Black Friday and Cyber Monday weekends are their peak dates ... Read More

Feed: Planet MySQL; Author: Ted Wennmark; In this demo we are setting up InnDB Cluster on Kubernetes, we will use a StatefulSets and NFS as storage. This demo was created on Oracle Cloud (OCI) but vanilla Kubernetes and NFS was used so should work for any cloud or on-prem. More information on my github page here Setup NFS Server to act as your persistent volume. Setup a NFS Server for your persistent volumes, howto here If you are using a public cloud provider you can most likely use dynamic storage options for handling of PV. In bellow examples I have a NFS ... Read More

Feed: Planet MySQL; Author: Ted Wennmark; In this demo we are setting up one MySQL Server using k8s, we will use a deployment and NFS as storage. This demo was created on Oracle Cloud (OCI), standard Kubernetes and NFS was use so the setup should work for any cloud deployment or on-prem. More information on my github page here Persistent volumes Setup a NFS Server for your persistent volumes, howto here If you are using a public cloud provider you can most likely use dynamic storage options for PV. In bellow examples I have a NFS Server on IP: 10.0.0.50 The NFS ... Read More

Feed: Planet MySQL; Author: Percona Community; Mayank Sharma  | June 1, 2020 |  Posted In: MySQL, Open Source Databases, ToolsMySQL, arguably the most popular relational database, is used pretty extensively at the popular professional social network LinkedIn. At Percona Live ONLINE 2020, the company’s flagship event held online for the first time due to the Covid-19 pandemic, Karthik Appigatla from LinkedIN’s database SRE team discussed the company’s approach to securing their database deployment without introducing operational hiccups or adversely affecting performance.Instead of just performing admin duties, Karthik’s team builds automated tools to scale their infrastructure, and he talked about some of these ... Read More

Feed: Planet MySQL; Author: Shiv Iyer; Building database infrastructure for performance and reliability ? This is a definitive webinar for anyone who is interested in building data SRE, Join Shiv Iyer, Founder and Principal of MinervaDB on Friday, 5 June 2020 – 06:00 PM PDT to 06:45 PM PDT , as he discuss about Data SRE best practices and tools. During this webinar he will discus: How Data SRE can impact business. Most expensive database outages and how can you address those proactively. Data SRE tools and techniques. Checklist for building database infrastructure addressing performance, scalability, high availability, reliability, fault-tolerance and security. Data ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; In my previous post in this series I've commented on some interesting MySQL bug reports that were added during the second half of April. Time to move on to bugs reported in May, 2020, as we are quickly approaching MySQL Bug #100000 soon and I want to write a separate post for this great achievement :) Here is the list:Bug #99432 - "Improving memory barrier during rseg allocation". Nice contribution by my former colleague in Percona, Krunal Bauskar, who now works on making MySQL better for ARM processors. According to his findings, the use ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Join Peter Zaitsev, CEO at Percona, as he discusses eBFT. eBPF is one of the most powerful instrumentation frameworks in modern Linux Kernel. In this presentation, we will cover eBPF basics as well as usage of Interactive eBPF tools, showing practical examples when and how they can help to resolve performance problems. Finally, we will look into Cloudflare’s ebpf_exporter and show how you can integrate eBPF with Prometheus for Long Term Monitoring.Please join Peter Zaitsev, CEO at Percona, on Wednesday, June 10 at 11 am EDT for his webinar “Using eBPF for Linux ... Read More

Feed: Planet MySQL; Author: Continuent; Having just recently published our new website, we’d like to draw your attention to a section of it that we’re particularly proud of: the Tungsten Clustering product pages. Tungsten Clustering is our flagship solution - the complete High Availability, Disaster Recovery, and Geo-Clustering solution for MySQL and its variants - and so deserves its own dedicated section, which now comprehensively showcases its components, benefits, features, topologies and subscription plans. Accordingly, Tungsten Clustering makes up an important part in our new Tungsten Products section of the website, in which we also showcase Tungsten Replicator and Tungsten ... Read More

Feed: Planet MySQL; Author: Percona Community; Stacy Rostova  | May 29, 2020 |  Posted In: MySQL, Open Source Databases, ToolsLong months of the pandemic lockdown have brought to life many great online events enabling the MySQL community to get together and stay informed about the very recent developments and innovations available to MySQL users. It isn’t over yet! Next Thursday, June 4th, Percona & ProxySQL are co-hosting the ProxySQL Tech Talks with Percona virtual meetup covering ProxySQL, MySQL and Percona XtraDB Cluster.The attendees are invited to participate in the two-hour deep-dive event with plenty of time for questions and answers (we will ... Read More

Feed: Planet MySQL; Author: Krunal Bauskar; Managing global counters in a multi-threaded system has always been challenging. They pose serious scalability challenges. Introduction of NUMA just increased the complexity. Fortunately multiple options have been discovered with hardware lending support to help solve/ease some of these issues. In this blog we will go over how we can make Global Counter NUMA SMART and also see what performance impact each of this approach has. Note: a lot of this work is inspired from MySQL codebase that is continuously trying to evolve to solve this issue. Global Counters Most of the software (for ... Read More