In my infrastructure I have a SQL Server 2014 Standard standalone server.
As databases and applications which are using SQL Server are growing up, I want to upgrade to SQL Server 2016 Standard and install two nodes to get an highly available SQL Server infrastructure.
I know I could make a SQL Server Failover Cluster, but I need some shared storages for this, which could not be a problem because I have a production NAS/SAN available but it's very slow as it is for data purposes and not for application purposes.
As my virtualization nodes have some fast SSD local storage, I wish to use them to host SQL Server data, so I am wondering if there is a way to build a SQL Server HA cluster without a shared storage, but making a master-slave replication between two nodes on their own local storage, something like what I am already doing for MariaDB with MariaDB Galera Cluster.
I also have an HAProxy available.