Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Arrow up icon
GO TO TOP
Mastering MariaDB

You're reading from   Mastering MariaDB Debug, secure, and back up your data for optimum server performance with MariaDB

Arrow left icon
Product type Paperback
Published in Sep 2014
Publisher
ISBN-13 9781783981540
Length 384 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
 Razzoli Razzoli
Author Profile Icon Razzoli
Razzoli
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

Mastering MariaDB
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Understanding the Essentials of MariaDB FREE CHAPTER 2. Debugging 3. Optimizing Queries 4. Transactions and Locks 5. Users and Connections 6. Caches 7. InnoDB Compressed Tables 8. Backup and Disaster Recovery 9. Replication 10. Table Partitioning 11. Data Sharding 12. MariaDB Galera Cluster Index

Setting up a cluster


This section discusses how to set up a cluster. However, let's first discuss the requirements of a cluster.

Requirements

As mentioned earlier, all cluster nodes must run on Linux systems.

There are no particular hardware requirements; in fact, if a server can smoothly run a standalone MariaDB server, it can also run on a Galera node. During normal operations, the additional amount of memory used for a Galera replication is minimal and wouldn't make much of a difference. The only exception is that the copying of the entire database from one node to another consumes a lot of memory. This happens when a new node joins the cluster, or when a disconnected node rejoins the cluster. However, when choosing the hardware of individual nodes, we should keep in mind that the cluster will be as slow as its slowest node.

The connection between nodes must be fast enough for the workload we are going to run. If possible, MariaDB Galera Cluster should run on a subnetwork that does not contain...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime
Visually different images