在RHEL7.4分离式应用/数据库服务器环境中，mariadb-devel等包应安装于哪台服务器？

Great question! Let’s break this down clearly so you know exactly where each package belongs in your RHEL 7.4 environment:

All three packages go on AppServer #

Here’s the reasoning for each:

• mariadb-devel: This package provides the header files and system libraries required to compile database drivers for Python. Since you’re installing mysqlclient (the Python driver that lets your code talk to MariaDB), you need these development files on the server running your Python code (AppServer) to successfully build and install the driver. The DBServer doesn’t need this—it only runs the MariaDB service, which doesn’t depend on Python development files.

• python34-mysql-debug: This is a debug-enabled MySQL module built specifically for Python 3.4. Since your application code is running on AppServer, this package (if you need debug capabilities for your database interactions) belongs there. The DBServer has no use for Python-specific modules.

• mysqlclient: This is the core Python driver that enables your code to connect to, query, and interact with the remote MariaDB instance on DBServer. It must be installed in the Python environment on AppServer—without it, your Python code can’t establish a connection to the database at all.

What DBServer Needs (Instead) #

You don’t need any of these Python-related packages on DBServer. Focus on these key tasks there:

• Ensure MariaDB 10.1 is running and configured correctly
• Set up database user permissions to allow connections from AppServer’s IP address (e.g., GRANT ALL PRIVILEGES ON your_database.* TO 'app_user'@'appserver_ip' IDENTIFIED BY 'secure_password';)
• Open port 3306 in the DBServer’s firewall to let traffic from AppServer reach the MariaDB service

内容的提问来源于stack exchange，提问作者jd80