O'Reilly logo

MariaDB High Performance by Pierre MAVRO

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required