amuck-landowner

BuyVM announces Europe, Anycast IP's, Floating IP's, & Bandwidth pooling!

Francisco

Francisco

Company Lube
Verified Provider
SQL replication will probably be the more annoying part of it :)

Does MySQL allow master/master/master replication? Or would you have to go master>slaves in that case? I'm guessing you could use something like mysqlproxy to send writes back to the master and reads come off the local slave.

Francisco
 
Last edited by a moderator:
Francisco

Francisco

Company Lube
Verified Provider
HalfEatenPie said:
I totally want Anycast right now.

So... PHP+MySQL Server would require MySQL Replication from one location to the other right?

It might be time for someone to look into and get some tutorials up on MySQL Replication and whatnot ;) (wink wink anyone who makes good tutorials wink wink)

Coming back on topic though...  Seriously super excited about the Anycast + DDoS Protection.  Just love it!
Click to expand...
You know, the more I think on this, Curtis could use mysqlproxy with a VM in each DC and finally get his proper CDN vpsboard going. He keeps moaning about wanting faster EU load speeds but that wouldn't do a hell of a lot if it still has to jump to the US to pull SQL/etc, unless he's just doing heavy caching.

With a mysqlproxy setup + 3 - 4 VM's spread over each DC, he could mysqlproxy, etc, and be set. File syncing could be handled with syncthing or something like that on a faster recheck timer.

I actually have a staff member that has syncthing setup for one of our side projects and has a dozen or so nodes clustering together in a master/slave replication and it makes his life so easy when he has to sync new templates/archives globally.

Francisco
 
MannDude

MannDude

Just a dude
vpsBoard Founder
Moderator
Francisco said:
You know, the more I think on this, Curtis could use mysqlproxy with a VM in each DC and finally get his proper CDN vpsboard going. He keeps moaning about wanting faster EU load speeds but that wouldn't do a hell of a lot if it still has to jump to the US to pull SQL/etc, unless he's just doing heavy caching.


With a mysqlproxy setup + 3 - 4 VM's spread over each DC, he could mysqlproxy, etc, and be set. File syncing could be handled with syncthing or something like that on a faster recheck timer.
Click to expand...
Oh boy, looks like vpsBoard will soon have it's own cluster™.
 
Last edited by a moderator:
trewq

trewq

Active Member
Verified Provider
Francisco said:
With a mysqlproxy setup + 3 - 4 VM's spread over each DC, he could mysqlproxy, etc, and be set. File syncing could be handled with syncthing or something like that on a faster recheck timer.


Francisco
Click to expand...
@MannDude Does VPSBoard actually have enough load to justify this or is it more a "look what we can do" thing?
 
MannDude

MannDude

Just a dude
vpsBoard Founder
Moderator
total used free shared buffers cached
Mem: 1009 922 86 0 20 702
-/+ buffers/cache: 200 809
Swap: 2044 0 2044


This is on a 1024MB KVM VPS from BuyVM. Nginx, PHP and MySQL on the same box. Plenty of free space.
 

Keep in mind things like the ad server, analytic server, img server, etc, etc are all hosted on different VMs.
 
Francisco

Francisco

Company Lube
Verified Provider
trewq said:
We need to get some more traffic in here ;)
Click to expand...
/ Offtopic

If you got guides in mind write them ;)

Since the sites on lighttpd/nginx, it isn't going to really jump in RAM, even if traffic spiked a lot. If Dudemann has memcache in place it might go up some but wouldn't be by much.

Francisco
 
HalfEatenPie

HalfEatenPie

The Irrational One
Retired Staff
Francisco said:
You know, the more I think on this, Curtis could use mysqlproxy with a VM in each DC and finally get his proper CDN vpsboard going. He keeps moaning about wanting faster EU load speeds but that wouldn't do a hell of a lot if it still has to jump to the US to pull SQL/etc, unless he's just doing heavy caching.


With a mysqlproxy setup + 3 - 4 VM's spread over each DC, he could mysqlproxy, etc, and be set. File syncing could be handled with syncthing or something like that on a faster recheck timer.


I actually have a staff member that has syncthing setup for one of our side projects and has a dozen or so nodes clustering together in a master/slave replication and it makes his life so easy when he has to sync new templates/archives globally.


Francisco
Click to expand...
Haha yeah.  I've just been thinking it would also be incredibly useful in general for you guys as the cheaper alternative to a CDN ;) 

Now if only you guys would also expand to Asia...
 
fisle

fisle

Active Member
Francisco said:
SQL replication will probably be the more annoying part of it :)


Does MySQL allow master/master/master replication? Or would you have to go master>slaves in that case? I'm guessing you could use something like mysqlproxy to send writes back to the master and reads come off the local slave.


Francisco
Click to expand...

How about MariaDB Galera? ( https://mariadb.com/kb/en/mariadb/documentation/replication/galera/what-is-mariadb-galera-cluster/ )

I've never tried it but it sounds good to me.
 
Francisco

Francisco

Company Lube
Verified Provider
fisle said:
How about MariaDB Galera? ( https://mariadb.com/kb/en/mariadb/documentation/replication/galera/what-is-mariadb-galera-cluster/ )

I've never tried it but it sounds good to me.
Click to expand...
It sounds like that'd work as well :)

I'm curious how it deals with split brain, or how it handles auto_increment locking.

For sure worth some tinkering!

EDIT - looks like they recommend a minimum of 3 nodes for the sake of quorum anyway. I'm assuming the nodes that can talk keep things going and the node left out would simply come back and resync changes?

Francisco
 
Last edited by a moderator:
MonsterKiller

MonsterKiller

New Member
Can't wait for LU

WIll be buying that shizz up straight away :D

What hardware will LU have? Will it have RAID SSD's like LV?
 
Last edited by a moderator:
You must log in or register to reply here.
Top
amuck-landowner