Mysql on a separate server?

  • Resolved trident60

    (@trident60)


    8 years, 12 months ago

    I read through many posts about this issue but most seem old and not “exactly” the same config as I have.

    Currently running WP on a Microsoft Azure Virtual Machine with Ubuntu installed.

    My question is would there be a benefit to running mysql db on it’s, separate, server? Or on two separate server?

    Basically I’m looking for ways to optimize my site within the limits of my Azure credits – 3 different accounts at $100 per month each, and I can’t combine them 😉

    Already running W3 Cache (tried the others and not seeing tremendous improvement with any of them). I have a 400mb database with 27,000 posts and my performance isn’t horrible – about 4 seconds to load and 7-9 seconds to do a full search of title and content.

    I know it’s a broad question.
    Thank you.
    Tri

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    8 years, 12 months ago

    It really depends on far/fast you expect to grow.

    Running a database on the same server gives you simplicity and usually lower operating costs.

    Running a database on a separate server allows you to use custom hardware/software designed specifically for efficiently serving MySQL.

    Thread Starter trident60

    (@trident60)

    8 years, 11 months ago

    Thanks James – I didn’t get an email notification so just seeing this now. FYI – I switched to MariaDB and seeing a consistent 300% speed increase in dozens of tests over the last 2 days.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    8 years, 11 months ago

    Excellent, that’s great! 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Mysql on a separate server?’ is closed to new replies.