MariaDB Solution
As discussed in Chapter 4 in regard to the initial deployment of their MariaDB solution at Financial Widgets Plus (FWP) and keeping with the KISS principle, the team chose to stand up a stand-alone environment with replication. Using this as the basis fo
- PDF / 177,592 Bytes
- 13 Pages / 439.37 x 666.142 pts Page_size
- 99 Downloads / 157 Views
MariaDB Solution As discussed in Chapter 4 in regard to the initial deployment of their MariaDB solution at Financial Widgets Plus (FWP) and keeping with the KISS principle, the team chose to stand up a stand-alone environment with replication. Using this as the basis for their proof of concept work turned out to enable them to get an active MariaDB environment deployed quickly and easily in order to validate what they had already perceived as a viable solution to their database solution alternative. Once the proof of concept was complete, the team then went on to deploy a much more robust high availability solution. Here we will get into detail on the setup and deployments as completed by Vernon’s team, to get them familiar with the database solution by enabling them to rapidly deploy and then extend their MariaDB footprint. Starting with a stand-alone install of the MariaDB database solution provided them a vehicle to prove their concepts and initial evaluation with a simple setup. The team then went on to evaluate Replication and ultimately to a full blown Galera Cluster. The use of a phased approach in their implementation minimized risk as well as allowing the team to increase their knowledge of the system from the basic setup to the much more advanced deployment. This approach was also tantamount to the project’s success, as they were able to maintain a simplified footprint for development and testing work while working on the more advanced solutions. This allowed for continuous integration and improvement throughout the migration process without interruption of the day to day operations. © William Wood 2019 W. Wood, Migrating to MariaDB, https://doi.org/10.1007/978-1-4842-3997-1_5
59
Chapter 5
MariaDB Solution
The team at FWP had migrated from the financial sector staple of HP-UX many years ago and had updated to RedHat Enterprise Linux (RHEL) as their companywide server class operating system. Therefore, all installation and configuration errata will be based on RHEL as the operating system of choice, which for completeness it should be noted that it is packaged with CentOS. One can easily apply the same database system setup and configurations across virtually any Linux distribution of choice. RedHat being an open source and community driven commercial variation of the Linux operating system also has a community release called Fedora that could be used freely in one’s proof of concept work in a sandbox environment. The only differences might be with the installation of the MariaDB libraries and code base as to whether one’s distributions leverage installation utilities such as yum, rpm, apt-get, and so on. Since we will be installing and configuring MariaDB software on RHEL version 7, the following documentation will be oriented towards that distribution and its libraries and utilities.
Preinstallation Considerations The setup, configuration, and deployment of the MariaDB solution by Vernon’s team, although kept in their simplest form, required some consideration. Being new to the technology and not
Data Loading...
