Introduction
Oracle Linux 10 ships with a stable, security-hardened base that makes deploying configure mysql primary-replica replication on oracle linux 10 both straightforward and auditable. This tutorial covers the complete procedure for how to Configure MySQL Primary-Replica Replication on Oracle Linux 10, including dnf module streams where applicable, systemd unit management, and the firewalld rules required for network-facing services.
Prerequisites
You will need: a registered Oracle Linux 10 host with sudo access; an internet connection or a local Red Hat mirror; familiarity with the dnf package manager and systemd; basic networking knowledge so you can adjust firewalld rules. If you are running inside a virtual machine, allocate at least 2 vCPUs and 4 GB of memory to avoid out-of-memory errors during compilation or service start.
Step 1: Update Oracle Linux 10 and Enable Repositories
Ensure your Oracle Linux 10 system is fully patched before installing new software. The AppStream repository is enabled by default on registered systems and provides the modular packages needed for most modern workloads. On Oracle Linux 10 this step benefits from the modular AppStream design, which lets you pin to a specific stream and avoid surprise major-version upgrades during routine patching.
sudo dnf upgrade -y
sudo dnf repolist enabledStep 2: Install Required Packages
Install the mysql-server package along with any supporting dependencies from the standard Oracle Linux 10 repositories. dnf will automatically resolve and pull in libraries, language runtimes, and configuration files. If you are running this inside a Kickstart automation or an Ansible role, capture every command into version control so the deployment can be re-run from scratch against a fresh VM at any time.
sudo dnf install -y mysql-serverStep 3: Apply the Initial Configuration
Now configure the component for your environment. Always keep a backup copy of the original configuration file so you can roll back quickly if something goes wrong, and prefer editing files in /etc/ over modifying the package defaults inside /usr/share/. If you are running this inside a Kickstart automation or an Ansible role, capture every command into version control so the deployment can be re-run from scratch against a fresh VM at any time.
sudo cp /etc/mysqld/mysqld.conf /etc/mysqld/mysqld.conf.bak
sudo nano /etc/mysqld/mysqld.conf # edit settings as requiredStep 4: Enable and Start the mysqld Service
systemd is responsible for service lifecycle on Oracle Linux 10. The enable --now flag both starts the service immediately and configures it to launch automatically at every boot, which is the behavior you almost always want for a server-side component. Pay attention to file ownership and permissions here — a service that is misconfigured at the file-system level will fail in subtle, hard-to-diagnose ways even though dnf reports a clean install.
sudo systemctl enable --now mysqld
sudo systemctl status mysqld --no-pagerStep 5: Open the Required Firewalld Port
firewalld is the default firewall on Oracle Linux 10 and uses nftables under the hood. Open only the specific port required for this service, and prefer named services over raw port numbers where they exist because they survive port-number changes upstream. Pay attention to file ownership and permissions here — a service that is misconfigured at the file-system level will fail in subtle, hard-to-diagnose ways even though dnf reports a clean install.
sudo firewall-cmd --permanent --add-service=mysql
sudo firewall-cmd --reloadStep 6: SELinux Considerations
SELinux runs in enforcing mode by default on Oracle Linux 10. If your service needs to write outside its default directories, bind to non-standard ports, or connect outbound to other services, you will need to set the appropriate boolean or label the files. The commands below are a typical starting point. If you are running this inside a Kickstart automation or an Ansible role, capture every command into version control so the deployment can be re-run from scratch against a fresh VM at any time.
sudo semanage port -a -t http_port_t -p tcp 3306
# only if you change the listening port
sudo ausearch -m AVC -ts recentStep 7: Inspect Service Logs
All systemd-managed services on Oracle Linux 10 stream their output to the journal, which is searchable, indexed, and persists across reboots once you create /var/log/journal. Use journalctl to follow logs in real time and to investigate startup failures. If you are running this inside a Kickstart automation or an Ansible role, capture every command into version control so the deployment can be re-run from scratch against a fresh VM at any time.
sudo journalctl -u mysqld -e --no-pager
sudo journalctl -u mysqld -fTroubleshooting Common Issues
If the service refuses to start, the first place to look is the systemd journal — every service on Oracle Linux 10 logs there by default. Filter to the last boot to avoid wading through historical entries. The second most common class of problem on a fresh install is SELinux denials, especially when a service tries to read from or write to a directory that is not labelled with its expected type. Use ausearch -m AVC -ts recent to look for denials, and either set the correct file context with semanage fcontext + restorecon or flip the relevant boolean. Finally, if the service starts but is unreachable, double-check firewalld with firewall-cmd --list-all and confirm the runtime configuration matches the permanent one.
sudo journalctl -b --priority=err
sudo ausearch -m AVC -ts recent
sudo firewall-cmd --list-allBest Practices and Hardening
For any production deployment on Oracle Linux 10 you should track configuration in a version control system, apply security errata regularly with dnf-automatic, and centralise log collection so that a compromised host cannot quietly erase its own audit trail. Run periodic OpenSCAP compliance scans against the CIS or DISA STIG profile to catch drift. If the service exposes a network port, place it behind a reverse proxy or VPN where possible and rotate any credentials it uses on a schedule. Snapshot the system (using Stratis, LVM, or your hypervisor) before every major change so you have a fast rollback path.
sudo dnf install -y dnf-automatic
sudo systemctl enable --now dnf-automatic.timer
sudo oscap xccdf eval --profile xccdf_org.ssgproject.content_profile_cis /usr/share/xml/scap/ssg/content/ssg-oraclelinux10-ds.xmlVerification
After completing every step, run a quick set of checks to confirm the deployment is healthy on Oracle Linux 10. Examine the systemd unit state to make sure no units have failed, look for any SELinux denials in the audit log, inspect the listening sockets to confirm the service is bound to the expected interface and port, and finally make a real client request to validate end-to-end functionality. If any of those four checks fail, return to the troubleshooting section before treating the deployment as complete.
sudo systemctl --failed
sudo ausearch -m AVC -ts recent || true
sudo ss -tulpn
sudo journalctl --since "10 minutes ago" --priority=warningConclusion
That completes the walk-through of how to Configure MySQL Primary-Replica Replication on Oracle Linux 10 on Oracle Linux 10. The end result is a reproducible deployment that you can encode in Ansible or Tekton pipelines, and that benefits from the long-term support and security errata Red Hat provides. Consider exporting your final configuration files to a Git repository so you can version them.
Looking forward, consider encoding the steps above as an Ansible role so the procedure becomes reproducible across your entire fleet, and add a Prometheus scrape config (or a Zabbix template) so the service is monitored from the moment it starts. Pair the deployment with a backup strategy — restic, borgbackup, or rsnapshot all work well on Oracle Linux 10 — so that recovery from data loss is a matter of minutes rather than hours.
