multiserver bandwidth

  • I have a wp site, hosting in digitalocean,divide into 4 server. (one for mysql only, other 3 with different sub-domain). I noticed the bandwidth usage is very heavy. (every 10000 ips need about 120GB bandwidth)

    Any idea to reduce mysql query? Or can i copy wp database into 3 server, only
    when user register, copy user info to another 2 server and shared cookies?

    Thanks and regards.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Depends on where you’re seeing the bandwidth be heavy.

    However moving things between servers isn’t going to change the fact that, y’know, people are hitting your site and using bandwidth. They’ll still need to connect

    Thread Starter youlichika

    (@youlichika)

    @ipstenu, thanks for your reply. so when i open one wp page, how many queries would be sent?

    query
    wp_usermeta
    wp_users
    wp_posts
    wp_postmeta
    wp_options
    …

    If I install other plugin, it should be more queries. So is there any cache plugin for user info? like cookies, if a customer open my site in the first time, he do all the queries from wp database, then the cache remember his status (has been loggined or just a visiter) then if he continue open other pages, it would read the cache instead queries from wp database.

    Thanks.

    If it takes that much amount of your resources then sure there is some code that should be doing this , Is your site have heavy traffic , Or have you used Memcache and other tools like minified your js and css etc ,

    Thread Starter youlichika

    (@youlichika)

    hi @jhaba, I have already moved my css,js,background image to google driver. Can Memcache cached wordpress database queries?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    so when i open one wp page, how many queries would be sent?

    I don’t know. I’m not on your site and I’m not watching your queries. It’s different per site.

    Which is a bit of my point. If you’re making X number of queries, the NUMBER doesn’t change if you split the site up.

    Can Memcache cached wordpress database queries?

    It can.

    https://github.com/tollmanz/wordpress-pecl-memcached-object-cache

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘multiserver bandwidth’ is closed to new replies.