Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
About the Author
About the Reviewers

Restricting replications

You saw how easy it is to create a replication. However, you may not want to replicate all your databases. In your MariaDB configuration file, you can configure which databases or tables you want to replicate.

Changing this can drastically reduce the traffic load and CPU usage. For example, if you've got 1 TB of databases and you only need 20 GB from the databases on your slaves for read purposes, you don't have to replicate all the data.

Another point would be about security access. Let's say you've got MariaDB instances placed in DMZ and you don't want all your data to be replicated (such as credentials, credits card details, and confidential information). You wouldn't want to expose all your data, as they could be stolen if you're attacked and hacked. In this case, you can limit what you want to sync. Notice that it is best practice to reduce privilege restrictions if you want to add additional security.

If you take the output of a SHOW SLAVE STATUS command, you...