Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying MariaDB High Performance
  • Table Of Contents Toc
  • Feedback & Rating feedback
MariaDB High Performance

MariaDB High Performance

By : Pierre Mavro
4.3 (13)
close
close
MariaDB High Performance

MariaDB High Performance

4.3 (13)
By: Pierre Mavro

Overview of this book

This book is aimed at system administrators/architects or DBAs who want to learn more about how to grow their current infrastructure to support larger traffic. Before beginning with this book, we expect you to be well-practiced with MySQL/MariaDB for common usage. You will be able to get a grasp quickly if you are comfortable with learning and building large infrastructures for MariaDB using Linux.
Table of Contents (13 chapters)
close
close
12
Index

Galera backup


Backup of Galera is not a complicated task; it just requires organization. This is simply because when you're doing a backup, your node goes in Donor mode. Using Xtrabackup will reduce the Donor mode time as compared to a classical dump and helps in quickly integrating a new node.

If you want to back up a Galera node with mysqldump, it is strongly recommended to use a load balancer (such as HAProxy) to move out the cluster node that provides data for backups. If you put in place what has been seen in Chapter 8, Galera Cluster – Multimaster Replication, there won't be any problem. When a node is in Donor mode, it will automatically be removed from the load balancer and will automatically be reintegrated while it gets finished and synced.

If you have no special constraints and can use Xtrabackup, it's better. To create a backup, you need to add a new option dedicated for Galera Cluster, which will create a xtrabackup_galera_info file with Galera information inside. If you do not...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
MariaDB High Performance
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon