|
#1
|
|||
|
|||
|
A few Qs before I make the switch
Greetings all, I'm currently in the market for a top notch DA reseller account as my current host is suffering badly and its really starting to trickle down...
Cheers! PS: very nice website and assortment of emoticons you have going on |
|
#2
|
|||||
|
|||||
|
Quote:
Quote:
Quote:
Quote:
. We don't want to force extra fees on you by upgrading when we think it's necessary, it's up to you.Quote:
I got your emails though and will reply to those as well. |
|
#3
|
|||
|
|||
|
Quote:
Quote:
Quote:
|
|
#4
|
|||
|
|||
|
Quote:
thanks, DH |
|
#5
|
|||
|
|||
|
Quote:
|
|
#6
|
|||
|
|||
|
Hi,
Thanks for your interest in Idologic. ![]() Quote:
If you run out of one or the other, we can upgrade you within an hour or so of receiving your ticket and sort out the billing within 24-48 hours. That way, clients have minimal downtime. ![]() Feel free to reply to this post or email sales@idologic.com if you have any more questions. |
|
#7
|
|||
|
|||
|
Sounds good, I don't expect any major jumps just a slow increase over the month and unfortunately I can't go back and look at last month's usage info on the old server or it wouldn't be much of an issue.
|
|
#8
|
|||
|
|||
|
Here's another question that would possibly save some bandwidth but would increase page loading speed for sure. I have a couple pages that query a remote MySQL server for information supplied by software running on that machine locally. Its generally slow, because that machine is at my office with limited upload speed. Would it be possible to mirror that mysql database on the account for that site and have the pages only query the mirrored database?
|
|
#9
|
|||
|
|||
|
Hi there,
I'm not quite sure, but you can certainly upload that MySQL database to your account at Idologic and host it there, instead of at your office. All accounts come with unlimited SQL databases and it'd certainly run faster on whatever server you would be on than your office computer (unless you use a Dual Xeon with a very highspeed connection, then you'd be set ).As for actively mirroring the database, I'm not too sure about that. If you have any more questions, feel free to post them here or email them to sales@idologic.com. Feel free to send a more detailed explanation of the MySQL setup and we can check out some possible options. |
|
#10
|
|||
|
|||
|
I would, but the problem is that the database is central to an application running on the machine and that application updates and uses it regularly. The web queries simply display that information. It seems that it would be more effective to have your server sync a "mirror" database of sorts with one connection, rather than having multiple users try and squeeze all of their queries through my little pipe. It wold indeed be better to have them query your dual xeon server on a very fast connection
I think I've heard of it being done before, as a live/hot backup so to speak, I'll look into it more and see what I can find.
|
|
#11
|
|||
|
|||
|
Okay, that'd be great. My only concern would be server load and resource usage, but if you can find or know of a solution that doesn't have those problems, we'll do our best to make it work for you at Idologic.
|
|
#12
|
|||
|
|||
|
I believe this is exactly what I'm looking to do:
http://dev.mysql.com/doc/refman/4.1/...ion-intro.html Whereby, the database on the idologic server would be the slave and the web pages would execute read only queries off the slave. I'm pretty weak with sql administration of any kind, so this is a bit daunting, but looks possible. Last edited by netstability; 04-07-2006 at 09:32 PM. |
|
#13
|
|||
|
|||
|
Quote:
I'm letting mysql admin run on that machine right now, after a couple days I should have a pretty good idea of the average load, but it has always beem insignificant as far as I could tell. |
|
#14
|
||||
|
||||
|
Unfortunately, this is a server-wide setup, i.e. the MySQL server running on the Idologic would mirror all databases on your server and not contain anything else. So....no exactly practical.
![]() What you could do instead is work out a script to dump the MySQL database each hour or so, copy it up to the Idologic server and then import it. Note: this isn't something we'd be able to do for you but Google is a very good resource on stuff like this. ![]() Quote:
|
|
#15
|
|||
|
|||
|
Hmm, that's unfortunate. The pages need info that's updated every couple of minutes, so an hourly dump wouldn't work. Oh well, thought I'd ask.
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|