Travis Newman

Tag: proxysql

  • I got to learn some (more) High Availability things

    —

    by

    Travis Newman
    in

    In the spirit of continuous improvement, I made another HA setup. Same basic front-end with two webservers behind one HAProxy load balancer, but with way more fault tolerance behind them. I used the guide I mentioned in the previous HA post to create this new setup. Webservers look to 192.168.100.2 for a database connection.  This…

  • I got to learn some High Availability things

    —

    by

    Travis Newman
    in

    As part of a job opportunity, the interviewer assigned some homework.  The expectations were as follows: Redundant webservers Redundant database servers Read-write splitting between the webservers and the database servers And ~24 hours later, I have achieved this.  This is spread across six virtual machines: HAProxy server Apache server 1 Apache server 2 ProxySQL server…