Ours.Do vps come with server.lu IP or frantech IP range?
It'll take a bit but SWIP will mark things as Luxembourg.
Francisco
Ours.Do vps come with server.lu IP or frantech IP range?
As am IJust to mention as well, loving the new site design
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.
I've toyed with this and it works great...BUT the latency between different physical locations kills the ability to handle writes as quickly. If your 3 nodes are within a few ms of it the overhead is basically non-existent, but when split up in my testing, performance was pretty terrible and slowed down a large set of queries I was trying to run. Not sure how it would be in day to day performance of a website or something as I never got that far in testing once I realize how much the latency killed my big initial stuff.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
Which makes sense. You'd be adding 100ms+ to every query and if you have 10 of them that's a second just in network time, nevermind query time.I've toyed with this and it works great...BUT the latency between different physical locations kills the ability to handle writes as quickly. If your 3 nodes are within a few ms of it the overhead is basically non-existent, but when split up in my testing, performance was pretty terrible and slowed down a large set of queries I was trying to run. Not sure how it would be in day to day performance of a website or something as I never got that far in testing once I realize how much the latency killed my big initial stuff.
I dunno about mysql but MongoDB and Redis both have modes where they send updates to the slave and keep going without waiting for synchronization. This gains speed by creating a small window for losing a few data items, that might or might not be tolerable depending on the application.Which makes sense. You'd be adding 100ms+ to every query and if you have 10 of them that's a second just in network time, nevermind query time.
So... You're saying... BuyVM Euro trip?Since people have been asking I figured I'd add a comment on here as well.
We expect the EU servers to ship tomorrow/Tuesday. We were waiting on DHL to get back to us for a quote but it seems they're against working with anyone that isn't a large shipper. It took 2 - 3 attempts to get an account with them, as well as a few days of my time wasted.
UPS was way over priced so we're likely shipping FEDEX. Their quote was pretty good considering the weight of everything being shipped.
We can pad that figure by a week to actually get there then a few days for me to get everything installed, configured, & tested.
Francisco
Christ could you imagine the guys in the red light district?So... You're saying... BuyVM Euro trip?
If you wan to act silly in Europe, go to Hamburg and reeperbahn.Christ could you imagine the guys in the red light district?
We'd get kicked off the continent.
Francisco
Europe may still be a bit miffed from the last time my kind were in the area >_>Christ could you imagine the guys in the red light district?
We'd get kicked off the continent.
Francisco
Luxembourg will probably be online by end of next week.What's the latest estimate on the Anycast and LUX public availability?
Assuming you buy a 128MB in all 3 locations, yesSorry if i've missed this anywhere - but will anycast be available for the 128mb plans?
What about the shared hosting plans? It almost makes more sense with them than with vps's.Assuming you buy a 128MB in all 3 locations, yes
Doing it on shared would be a complete pain in the butt for us since cPanel isn't really 'cluster' aware, nor is the entire platform 'anycasted'. This means that we'd have to manually configure syncing of files & SQL between all locations. There's also the bigger issue of cPanel having a trillion flat file databases everywhere that we'd also have to manually sync.What about the shared hosting plans? It almost makes more sense with them than with vps's.