Author: MySQL Planet

Feed: Planet MySQL; Author: Ahmed Bouchefra; In this tutorial, you'll learn how to easily add a complete authentication system to your Django application with login, logout and password change and reset functionalities. We'll be using Django with a MySQL database. We'll also be using django-crispy-forms and Bootstrap 4 for styling the application UI. Prerequisites Let's start with the prerequisites for this tutorial. In order to follow the tutorial step by step, you'll need a few requirements, such as: Basic knowledge of Python, Working knowledge of Django (django-admin.py and manage.py), A recent version of Python 3 installed on your system (the ... Read More

Feed: Planet MySQL; Author: Severalnines; ProxySQL is an intelligent and high-performance SQL proxy which supports MySQL, MariaDB and ClickHouse. Recently, ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera and MySQL Group Replication native support. It is relatively easy to run ProxySQL as Docker container. We have previously written about how to run ProxySQL on Kubernetes as a helper container or as a Kubernetes service, which is based on ProxySQL 1.x. In this blog post, we are going to use the new version ProxySQL 2.x which uses a different ... Read More

Feed: Planet MySQL; Author: Sveta Smirnova; PREVIOUS POST Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Register Now MySQL 8.0 Performance Schema is a mature tool, used by humans and monitoring products. It was born in 2010 as “a feature for monitoring server execution at a low level.” The tool has grown over the years with performance fixes and DBA-faced features. In this webinar, I will give an overview of Performance Schema, focusing on its tuning, ... Read More

Feed: Planet MySQL; Author: Giuseppe Maxia; I remember wanting to create MySQL Cluster sandboxes several years ago. By then, however, MySQL-Sandbox technology was not flexible enough to allow an easy inclusion, and the cluster software itself was not as easy to install as it is today. Thus, I kept postponing the implementation, until I started working with dbdeployer.I included the skeleton of support for MySQL Cluster since the beginning (by keeping a range of ports dedicated for this technology, but I didn’t do anything until June 2018, when I made public my intentions to add support for NDB in dbdeployer ... Read More

Feed: Planet MySQL; Author: Facebook Code Engineering; Facebook Reality Labs (FRL) is using groundbreaking 3D capture technology and AI systems to create lifelike virtual avatars. The technology could one day make social connections in virtual reality as natural and common as those in the real world. Facebook has worked on virtual avatars for several years. At F8 2016, Facebook Chief Technology Officer Mike Schroepfer introduced new avatars for Facebook Spaces, replacing the floating blue head in use at the time with an updated model featuring new facial features and lip movement. At F8 last year, he debuted Facebook’s efforts into ... Read More

Feed: Planet MySQL; Author: Scotch.io; Node, a run-time environment that makes it possible to write server-side JavaScript, has gained a lot of adoption since its release in 2011. Writing server-side JavaScript is incredible but can get messy as the codebase grows, owing to the nature of the JavaScript language; dynamic and weak typed. Table of ContentsDevelopers coming to JavaScript from other languages often complain about its lack of strong static typing; this is where TypeScript comes into the picture, to bridge this gap. TypeScript is a typed (optional) super-set of JavaScript that can make it easier to build and manage ... Read More

Feed: Planet MySQL; Author: Baron Schwartz (xaprb); Last week I “finished” a new medium-sized book (an ebook—that is, a PDF). But even as we downloaded the final PDF from Google Docs and uploaded it to our company website, I already had a file full of errata and omissions. Some of these are substantial problems, but my opinion remained almost unwavering: ship it. It was 20 years ago in college that I first heard a professor say, “a poem is never finished, only abandoned.” It was reinforced right away by studying some famous poems for which the original drafts and revisions ... Read More

Feed: Planet MySQL; Author: Baron Schwartz (xaprb); I’ve written a new 65-page ebook, titled DevOps for the Database. Drawn from what I’ve observed over the last 15 or so years in my own experience as well as that of many others, it tries to answer why and how some organizations deliver value to customers fast, run data-intensive applications with high quality, and have great engineering cultures—and why some don’t. My conclusions? It’s a combination of things, not a single difference. Different answers are appropriate for different teams. I identify about a dozen key capabilities and organize them into levels of ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 8.0.15-5 on March 15, 2019 (downloads are available here and from the Percona Software Repositories). This release includes fixes to bugs found in previous releases of Percona Server for MySQL 8.0. Incompatible changes In previous releases, the audit log used to produce time stamps inconsistent with the ISO 8601 standard. Release 8.0.15-5 of Percona Server for MySQL solves this problem. This change, however, may break programs that rely on the old time stamp format. Starting from release 8.0.15-5, Percona Server for MySQL uses the upstream implementation of binary log encryption. The variable encrypt_binlog is removed and the ... Read More

Feed: Planet MySQL; Author: FromDual; We had the problem today that a MySQL Galera Cluster node with the multi-tenancy pattern caused a lot of system time (sy 75%, load average about 30 (you really must read this article by Brendan Gregg, it is worth it!)) so we wanted to find what system calls are being used to see what could cause this issue (to verify if it is a TOC or a TDC problem: $ sudo strace -c -p $(pidof -s mysqld) -f -e trace=all Process 5171 attached with 41 threads Process 16697 attached ^C Process 5171 detached ... Process ... Read More