Configuring two servers for shared storage MySQL
In this recipe, we will set up a MySQL service running on two servers, node1 and node2, for sharing a iSCSI volume presented as /dev/sdb on both nodes for active/passive clustering. At the end of the recipe, you will see that it will be possible to manually fail over MySQL from one node to the other, but the process is extremely tedious. This recipe is designed as a stepping stone to the next recipe in which the failover process will be automated.
In this recipe, we will:
- Install the required packages for CentOS
- Create a logical volume on the shared storage
- Create a filesystem on this shared-storage logical volume
- Install MySQL
How to do it…
To follow this recipe, ensure that you have a clean install of ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
