GTID-based replication makes managing replication topology easy: just CHANGE MASTER to any node and voilà. It doesn’t always work, but for the most part it does. That’s great, but it can hide a serious problem: missing writes. Even when MySQL GTID-based replication says, “OK, sure!”, which is most of the time, you should double check it.
May
31
2020
May
31
2020
GTID-based replication makes managing replication topology easy: just CHANGE MASTER to any node and voilà. It doesn’t always work, but for the most part it does. That’s great, but it can hide a serious problem: missing writes. Even when MySQL GTID-based replication says, “OK, sure!”, which is most of the time, you should double check it.
May
30
2020
Today’s article is again related to WordPress and MySQL 8.0. We will see how we can setup MySQL InnoDB ReplicaSet and configure WordPress to split the load using both MySQL Instances: we will split reads and writes between the Primary and the Secondary member of our ReplicaSet.
This will be the first part of our journey to achieve HA for our WordPress site on OCI and using all MySQL Servers we have deployed. We don’t want to have a server idle just waiting to take over in case of an incident.
MySQL InnoDB ReplicaSet
First some words about MySQL InnoDB ReplicaSet.
The ease of use of …
May
29
2020
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.
May
29
2020
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]
May
29
2020
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:
- René Cannaò, ProxySQL author and CEO of ProxySQL …
May
27
2020
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]
May
26
2020
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.
May
26
2020
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.
May
23
2020
Today 23 May 2020, it is 25 years since the first release of MySQL. So, I would like to take the opportunity to wish MySQL – and Sakila – a happy birthday.
My own MySQL journey started in 2006 when I at a job interview was told that if I got the job, I would need to learn MySQL before starting. Since the job involved PHP coding, I got the book Web Database Applications with PHP and MySQL as well as Managing and Using MySQL. Around a week later, I started in my first job involving MySQL at Noggin Pty Ltd.
The two first MySQL books, I studied.
This was in the days of MySQL 5.0 when stored functions, procedures, and triggers were new, and statement based replication was the only binary log format around. The job evolved into including …
[Read more]