In the penultimate Deno article, I wrote on how to build REST APIs with Deno and Oak. In that tutorial, we used an array as a dummy storage placeholder to not overwhelm ourselves with database connection and other stuff. For this article, we are going to take that example one …
The post Using MySQL with Deno appeared first on Geeky Hacker.
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 Performance Analyses”.
If you can’t attend, sign up anyway and we’ll …
[Read more]We’ve created a new space on our website for our flagship product Tungsten Clustering. This blog invites you to take a tour of the new product section and to get in touch with us for your MySQL MySQL High Availability, Disaster Recovery and/or Geo-Clustering needs.
Tags: MySQL mysql clustering tungsten clustering High Availability Disaster Recovery geo-clustering
Long 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 have two 40-minute sessions + 20 minutes allocated for Q&A). Get prepared, come with your burning questions and true war stories – we’ll have our speakers answer and comment on them! And here come the speakers:
Here in Percona’s Training department, we like to think that we instruct our learners on the best practices for all things MySQL-related. In addition to performance tuning, query optimization, and replication configurations, another important topic is backups. Let’s dive in and discuss some of the basics and best practices around backups for MySQL.
Logical MySQL Backups
In MySQL, it is possible to take backups in two different forms. The first form, logical, is the most universal. Essentially, you create all of the necessary INSERT statements to repopulate your table data. The two most popular tools in the area are mysqldump and mydumper.
mysqldump
This tool has been around since the beginning and supports a slew of different options, too numerous to discuss in this post.
Here is a simple example for taking a logical backup of the …
[Read more]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 example: database, web-server, etc…) needs to maintain some global counters. Being global, there is one copy of these counters and multiple worker threads try to update it. Of-course this invites a need of coordination while updating these copies and in turn it becomes scalability hotspots.
Alternative is to loosely maintain these …
[Read more]Join Alkin Tezusal, Percona Technical Expert, as he covers the past, present, and future of MySQL as an Open Source Database. During this webinar he will discuss: * Use cases of MySQL as well as edge cases of MySQL topologies using real-life examples and “war” stories * How scalability and proxy wars make MySQL topologies more robust to serve webscale shops * Open-source tools, utilities, and surrounding MySQL Ecosystem
Please join Alkin Tezusal of Percona, on Thursday, June 4 at 10 am EDT for his webinar “MySQL Ecosystem in 2020”.
If you can’t attend, sign up anyway and we’ll send you the slides and recording afterward.
Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020.
The post MySQL 8.0.20 New Features Summary first appeared on dasini.net - Diary of a MySQL expert.
Day: Wednesday, June 3, 2020
Time: 10:00am – 12:00pm PST
Register: https://go.oracle.com/LP=92944?elqCampaignId=247342
Join our virtual conference organized by WePay, a JP Morgan and Chase company, and MySQL.
Learn about Waltz - a distributed write-ahead log, some great high availability architectures, Microservices and the power of using NoSQL and SQL with the same database.
Talk 1: Introduction to Waltz: A Distributed Write-Ahead Log
Talk 2: MySQL High Availability Architectures
Talk 3: MySQL Clusters for Microservices at Wepay
Talk 4: Discover the Power of NoSQL + SQL with MySQL
Speakers:
…
[Read more]Day: Wednesday, June 3, 2020 Time: 10:00am – 12:00pm PST Register: https://go.oracle.com/LP=92944?elqCampaignId=247342 Join our virtual conference organized by WePay, a JP Morgan and Chase company, and MySQL. Learn about Waltz - a distributed write-ahead log, some great high availability architectur...