TransWikia.com

Why is it not a good idea to use MariaDB's extra_port for replication?

Database Administrators Asked on December 8, 2021

MariaDB has an extra_port for administrative access that helps in cases the thread pool or main port is locked up.

MariaDB’s documentation says it’s use case is primarily administrative access and it can be used to make sure monitoring systems always have access.

To me "always have access" sounds like something you want for replication but it’s not mentioned and I could not find anyone writing about using the extra port for replication.

The paragraph When to Use the Thread Pool in the documentation says:

Thread pools are most efficient in situations where queries are
relatively short and the load is CPU-bound

Replication runs forever (fingers crossed) and is IO-bound. This sounds like another indication to use the extra port (although replication is not a query).

My Questions:
Can you explain me why it’s not a good idea to use the extra port for replication?
If it actually is a good idea, why is it not widespread (as indicated by not finding anything substantial when googling for "mariadb extra_port replication")?
Do replication connections get some special treatment and/or priority?

One Answer

Replication do not need some special ports and can use the common 3306. An extra port is a port that can be used by root as back door if there is no access through the common port.

Say if you have max_connections = 100 and your app is already used all that 100 connections, only one extra connection can be used by user with ALL PRIVILEGES granted. If someone is already connected as DBA you have no chance to connect to the server. But you still can connect via extra_port cause it has no max_connections limit. And that is the reason why you should not use it for any other tasks except an emergency access. With no max_connections set to the reasonable value you can easily exhaust your host's RAM that can hang your DB or even a host in a pretty bad way.

Answered by Kondybas on December 8, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP