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?
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
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP