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...
Codership is proud to announce the first Generally Available (GA) release of Galera Cluster 4 for MySQL 8 and improve MySQL High Availability a great deal. The current release comes with MySQL 8.0.19 and includes the Galera Replication Library 4.5 with wsrep API version 26. You can download it now (and note that we have packages for various Linux distributions).
Galera 4 and MySQL 8.0.19 have many new features, but here are some of the highlights:
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 database administration, and over the next four years and a bit, I got the chance to work around large parts of the corners of MySQL. One of the most interesting tasks was …
[Read more]