Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost
access to MySQL databases.
Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
kai www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net 12 2820
"filesiteguy" <ab***@127.0.0.1> wrote in message
news:co********************************@4ax.com... Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
My host, www.lunarpages.com (use this link: http://secure.lunarpages.com/trackin...cgi?id=obsydi2) if
you want to sign up and give me affiliate credit), allows you to add as many
valid external hosts as you would like for remote access to the database. I
use that all the time to access my hosted database from my home test server.
For that matter, just about any host that uses a cPanel control panel will
probably do the same.
- Virgil
filesiteguy <ab***@127.0.0.1> wrote in
news:co********************************@4ax.com: Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
kai www.perfectreign.com || www.filesite.org g2004 at g3prod.cotse.net
I don't know what your budget is, but you might consider renting a
dedicated server then you can do whatever you like. You will have root
access (full control). Now a days, you can find dedicated servers for less
than $60 per month. Granted, these are low end servers, but you would not
be sharing with other customers and the net effect might be better
performance than a shared hosting solution.
--
Edward Alfert http://www.rootmode.com/
Multiple Domain Hosting and Reseller Hosting Plans
Coupon Code (Recurring $5/month Discount): newsgroup
In article <co********************************@4ax.com>, ab***@127.0.0.1
says... Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
Why not run a web service that has one web site query the other web site
for information - use some non-standard port.
--
-- sp*********@rrohio.com
(Remove 999 to reply to me)
In article <co********************************@4ax.com>, filesiteguy wrote: Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports
replication?
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
You could do it yourself. But instead of using some obscure portnumber
do it the right way: set up a SSL tunnel between the mysql server and
the client and send all traffic through that tunnel.
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
Tim Van Wassenhove <eu**@pi.be> wrote: Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
--
Daniel Tryba
I would suggest two solutions:
1. on the host where MySQL running you deploy a web based query
service. This can be fully implemented by php script, and can be
accessed from remote host.
2. I can provide you with a hosting plan at $240/year with following
features:
600M space, 10G bandwidth, unlimited pop account, unlimited
databases, and allow remote access (at your own risk:).
Alex Shi Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
kai www.perfectreign.com || www.filesite.org g2004 at g3prod.cotse.net
Daniel Tryba wrote: Tim Van Wassenhove <eu**@pi.be> wrote: Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
Actually all the way back to 3.23.15
--
MVH Jeppe Uhd - NX http://nx.dk
Webhosting for nørder og andet godtfolk
Jeppe Uhd wrote: Daniel Tryba wrote: Tim Van Wassenhove <eu**@pi.be> wrote: Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
Actually all the way back to 3.23.15
Yes but AFAICS its not a distributed database which I suspect is what K
needs.
The sugestion of using a php protocol wrapper to run the queries as if local
could be implemented fairly easily (I reckon about 60 lines of code) and
would be my bet as the easiest solution.
HTH
C.
Colin McKinnon <co**************@andthis.mms3.com> wrote: BTW mysql 4.x supports replication. Actually all the way back to 3.23.15
Yes but AFAICS its not a distributed database which I suspect is what K needs.
Master/master replication is in 4.1.x (which is not for production last
time I took al ook).
The sugestion of using a php protocol wrapper to run the queries as if local could be implemented fairly easily (I reckon about 60 lines of code) and would be my bet as the easiest solution.
Fastest and safest (networkwise, like http is almost always open or
available by proxy) solution indeed.
--
Daniel Tryba
In article <cc**********@news.tue.nl>, ne****************@canopus.nl
says... Master/master replication is in 4.1.x (which is not for production last time I took al ook).
It wouldn't matter - if they don't allow remote access then they won't
allow a connection for replication.
If he's going to be stuck with no-remote connections to it, the easiest
method would be to write a couple pages that let him pull the raw data
over some for of web page query and automate the process.
--
-- sp*********@rrohio.com
(Remove 999 to reply to me)
On Thu, 08 Jul 2004 09:22:35 +0100, Colin McKinnon
<co**************@andthis.mms3.com> wrote: Jeppe Uhd wrote:
Daniel Tryba wrote: Tim Van Wassenhove <eu**@pi.be> wrote: > Unfortunately, this requires a centralized (or duplicated) MySQL > database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
Actually all the way back to 3.23.15
Yes but AFAICS its not a distributed database which I suspect is what K needs.
The sugestion of using a php protocol wrapper to run the queries as if local could be implemented fairly easily (I reckon about 60 lines of code) and would be my bet as the easiest solution.
Sorry for stepping back in so late - that's kind of what we decided
on. We'll host a database on siteX with various PHP scripts running.
An applicaiton on siteY will call the PHP scripts on siteX which will
return the neccesary encrypted data to siteY for siteY to consume/use.
We've got it pretty much worked out already. (Caffeine is a wonderful
thing!)
K
kai www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net
On Thu, 8 Jul 2004 08:29:20 +0200, "Jeppe Uhd" <ln*********@nx.dk>
wrote: Daniel Tryba wrote: Tim Van Wassenhove <eu**@pi.be> wrote: Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
Actually all the way back to 3.23.15
Now if we could only get the stored procedures to work as I assume
stored procedures should work (ie - like DB2 or MSSQL/Sybase)
K
kai www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mary Grace |
last post by:
I have been using MySQL for awhile, and for the first time someone from
outside our portable /16 needs access to some tables. We have given them
the server IP address, the dB name, the port 3306,...
|
by: Fred |
last post by:
I just started using MySQL, and cannot find how to
configure host access in the my.cnf file. I want
to be able to allow access to a MySQL database
from a remote host, and also from a particular...
|
by: Ian Davies |
last post by:
Hello all
The following code allows me to connect to a local MySQL database on my pc
from a VB6 project.
****************************************************************************
**
Dim...
|
by: Greg Gursky |
last post by:
Hello:
I'm doing some planning on a potential project with which I need
some help. The database at the focus of this question is a
MS Access database that is currently accessed by DAO from a...
|
by: Ike |
last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on
111.111.111.111 allowing all incoming and outgoing ports. I have a username
and password setup, which CAN connect to this database,...
|
by: Martin |
last post by:
Hi all.
I have a fully functional page hosted on my PC that uses PHP and
connects to MySQL on my PC to generate it's code.
I now have some web hosting available which includes both PHP and...
|
by: Jerim |
last post by:
I have a script on one server, trying to access the MySQL database on
another server. The server with the script is on an outside network,
hosted with another company. The MySQL server is here in...
|
by: Kurt Jakobsen |
last post by:
Hello,
I have a client program that I use to access a MySql 5.0 community server. The client can be on the machine where the MySql server is installed or from a remote machine.
The client has...
|
by: Pseudonyme |
last post by:
A Paris
Le 14 Nv MMVII
Dear Madam and Sir,
Do you know how to access a MYSQL DB from an external server ?
We read the information and studied :
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Aftab Ahmad |
last post by:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
| |