(Matthew Boehm) Sysbench has long been established as the de facto standard when it comes to benchmarking MySQL performance. Percona relies on it daily, and even Oracle uses it when blogging about new features in MySQL 8.
Tag: Open Source
How to Perform a Failback Operation for MySQL Replication Setup
(Ashraf Sharif) MySQL master-slave replication is pretty easy and straightforward to set up. This is the main reason why people choose this technology as the first step to achieve better database availability.
Getting started with the MySQL Operator for Kubernetes
(Hassan Ajan) Kubernetes Operators are amazing and they are already playing an important role for those who are managing large scale applications.
How To Connect Golang With MySQL
(Parvez) Today, I will describe MySQL database connectivity with golang. MySQL is most popular open source relational database.
MySQL-python: Adding caching_sha2_password and TLSv1.2 Support
(Ceri Williams) Python 2 reaches EOL on 2020-01-01 and one of its commonly used third-party packages is MySQL-python. If you have not yet migrated away from both of these, since MySQL-python does not support Python 3, then you may have come across some issues if you are using more recent versions of
MySQL High Availability Framework Explained – Part III: Failure Scenarios
In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II.
Exporting Masked and De-Identified Data from MySQL
(Mike Frank) In all likelihood your MySQL database contains valuable and sensitive information. Within that database, MySQL protects that data using features such as encryption, access controls, auditing, views, and more. However in many cases you may need to share some of this data, but must at the
How to implement a database job queue using SKIP LOCKED
(Vlad Mihalcea) In this article, we are going to see how we can implement a database job queue using SKIP LOCKED.
PHP JWT & REST API Authentication Tutorial: Login and Signup
(Ahmed Bouchefra) In this tutorial, we’ll learn how to add JWT authentication to our REST API PHP application.
MariaDB Prepared Statements, Transactions and Multi-Row Inserts
(Shinguz) Last week at the MariaDB/MySQL Developer Training we had one participant asking some tricky questions I did not know the answer by heart.