You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Rob <bu...@gmail.com> on 2008/06/20 23:01:22 UTC
[users@httpd] MYSQL Domain ?
Hey there,
wondering if some one could point me on the right direction. I have no idea
what its actually called but i want to asign my MYSQL to a domain name.
So instead of using local host they can use mysql.domainname.com
Basically want this to make my database accessible to our other servers
which are hosted at all diffrent places around the world.
Could any one give me a brief idea on how this is done ? and the pro's and
cons of it.
I did trying searching for it but seams i dont actually know whats its
properly called i came up with very little. I thinking this is done in
apache ? im just guessing here
thanks,
rob
Re: [users@httpd] MYSQL Domain ?
Posted by Dragon <dr...@crimson-dragon.com>.
Rob wrote:
>Hey there,
>
>wondering if some one could point me on the right direction. I have
>no idea what its actually called but i want to asign my MYSQL to a
>domain name.
>
>So instead of using local host they can use
><http://mysql.domainname.com>mysql.domainname.com
>
>Basically want this to make my database accessible to our other
>servers which are hosted at all diffrent places around the world.
>
>Could any one give me a brief idea on how this is done ? and the
>pro's and cons of it.
>
>I did trying searching for it but seams i dont actually know whats
>its properly called i came up with very little. I thinking this is
>done in apache ? im just guessing here
>
>thanks,
>
>rob
---------------- End original message. ---------------------
What you want to do is partly a DNS configuration issue (setting up
an A record with the appropriate host name for the MySQL server
machine) and partly a MySQL configuration issue. You need to
configure MySQL to respond to TCP/IP on whatever port you choose to
run it on (default is something in the range of 3300 or so, I forget
the exact default).
Apache has nothing to do with either of those things.
Now... pros? You can access the server remotely.
Cons? Attackers can access the server remotely. Be sure you know what
you are doing and set up the security of the MySQL server correctly.
This is not a trivial task and if you get it wrong, somebody may
maliciously screw up your database.
Dragon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Venimus, Saltavimus, Bibimus (et naribus canium capti sumus)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
RE: [users@httpd] MYSQL Domain ?
Posted by Doug Harvey <oh...@gmail.com>.
Well, in all the years that I used to play with ms's sql, we always used
port numbers and then connected with odbc. With that in mind, you could
basically do the same thing in this case. If you wanted someone to be able
to connect, retrieve, write, delete records in a MySQL data base that you
are hosting, it would seem to me that it would be better to do it that way.
Having your SQL server advertised as a sub domain might could be a big
security risk because it would then be published as if it were a web site
and that would allow people to start cracking on it till it breaks.
If you use something like 123.123.123.123:3310 and you have it set up
through a VPN to the other sites that you want connection to, then that
would provide a ton more security.
Doug
_____
From: Rob [mailto:bubaphex@gmail.com]
Sent: Friday, June 20, 2008 2:16 PM
To: users@httpd.apache.org
Subject: Re: [users@httpd] MYSQL Domain ?
oh awesome, i thought using a records as i've seen in the past places doing
that like dreamhost.com etc. Is this port better security or something ?
what is this actually called ?
cheers, rob
On Sat, Jun 21, 2008 at 9:17 AM, Doug Harvey <oh...@gmail.com> wrote:
Rob. I would think that you would want to use a port number instead of a
domain name. I think the port number is 3310, so you would have someone
connect by going to: domainname.com:3310
Doug
_____
From: Rob [mailto:bubaphex@gmail.com]
Sent: Friday, June 20, 2008 2:01 PM
To: users@httpd.apache.org
Subject: [users@httpd] MYSQL Domain ?
Hey there,
wondering if some one could point me on the right direction. I have no idea
what its actually called but i want to asign my MYSQL to a domain name.
So instead of using local host they can use mysql.domainname.com
Basically want this to make my database accessible to our other servers
which are hosted at all diffrent places around the world.
Could any one give me a brief idea on how this is done ? and the pro's and
cons of it.
I did trying searching for it but seams i dont actually know whats its
properly called i came up with very little. I thinking this is done in
apache ? im just guessing here
thanks,
rob
Re: [users@httpd] MYSQL Domain ?
Posted by Rob <bu...@gmail.com>.
oh awesome, i thought using a records as i've seen in the past places doing
that like dreamhost.com etc. Is this port better security or something ?
what is this actually called ?
cheers, rob
On Sat, Jun 21, 2008 at 9:17 AM, Doug Harvey <oh...@gmail.com> wrote:
> Rob. I would think that you would want to use a port number instead of a
> domain name. I think the port number is 3310, so you would have someone
> connect by going to: domainname.com:3310
>
> Doug
>
>
> ------------------------------
> *From:* Rob [mailto:bubaphex@gmail.com]
> *Sent:* Friday, June 20, 2008 2:01 PM
> *To:* users@httpd.apache.org
> *Subject:* [users@httpd] MYSQL Domain ?
>
> Hey there,
>
> wondering if some one could point me on the right direction. I have no idea
> what its actually called but i want to asign my MYSQL to a domain name.
>
> So instead of using local host they can use mysql.domainname.com
>
> Basically want this to make my database accessible to our other servers
> which are hosted at all diffrent places around the world.
>
> Could any one give me a brief idea on how this is done ? and the pro's and
> cons of it.
>
> I did trying searching for it but seams i dont actually know whats its
> properly called i came up with very little. I thinking this is done in
> apache ? im just guessing here
>
> thanks,
>
> rob
>
Re: [users@httpd] MYSQL Domain ?
Posted by Danie Qian <da...@bestningning.com>.
this is the official website for the info you need http://dev.mysql.com/doc/refman/5.1/en/replication.html
at this point the time frame you are looking at is probably that of reading and getting to understand the solution and how to impliment it. once you grasp the idea it is no more than installing two mysql servers and set a few parameters. have fun and good luck.
----- Original Message -----
From: Rob
To: users@httpd.apache.org ; Danie Qian
Sent: Friday, June 20, 2008 5:54 PM
Subject: Re: [users@httpd] MYSQL Domain ?
That seams like an awesome suggestion Danie, i think this is by far better way. 1 problem with this how-ever, i have no idea on how to go about doing all this. Are you able to toss me a few links my way to read up on this. Whats the time frame we looking here to do all this ? and is this all basicly MYSQL based ? not apache at all ? does it require any special license to do it ?
cheers
rob
On Sat, Jun 21, 2008 at 9:45 AM, Danie Qian <da...@bestningning.com> wrote:
In your situation, why dont you do it this way:
location1: 4 sites <-> mysql server1, as a master for these 4 local sites and replicate slave for the 2 sites in the other location.
location2: 2 sites <-> mysql server2, as a master for these 2 local sites and replicate slave for the 4 sites in the other location
not only this will be more efficient but also it will be more reliable as you have sort of a real time backup db server.
----- Original Message -----
From: Rob
To: users@httpd.apache.org ; Danie Qian
Sent: Friday, June 20, 2008 5:26 PM
Subject: Re: [users@httpd] MYSQL Domain ?
To explain abit more about my situation,
I have 6 joomla sites, 4 on one server 2 on another, with more to follow. What im needing to do is setup a simple form for people to fill out. This basicly will inject the database of each joomla site with the information from the form into them. The problem is that the servers are in two sperate locations so i presumed this would be a good way to connect to the databases from mulitlple locations.
Danie, it is possible to have sql running on localhost and over a domain at the same time ?
is any one able to point me to some reading material or walkthrough so i could get a better idea on what needs to be done ?
cheers
rob
On Sat, Jun 21, 2008 at 9:19 AM, Danie Qian <da...@bestningning.com> wrote:
it is mysql.domainname.com:3306 you should connect to. I recomment you keep a local database for each of your location, local i mean on the same network. mysql connection from one location to another in the backend causes performance issue. you might consider replicating the same db all across your different locations.
----- Original Message -----
From: Doug Harvey
To: users@httpd.apache.org
Sent: Friday, June 20, 2008 5:17 PM
Subject: RE: [users@httpd] MYSQL Domain ?
Rob. I would think that you would want to use a port number instead of a domain name. I think the port number is 3310, so you would have someone connect by going to: domainname.com:3310
Doug
----------------------------------------------------------------------
From: Rob [mailto:bubaphex@gmail.com]
Sent: Friday, June 20, 2008 2:01 PM
To: users@httpd.apache.org
Subject: [users@httpd] MYSQL Domain ?
Hey there,
wondering if some one could point me on the right direction. I have no idea what its actually called but i want to asign my MYSQL to a domain name.
So instead of using local host they can use mysql.domainname.com
Basically want this to make my database accessible to our other servers which are hosted at all diffrent places around the world.
Could any one give me a brief idea on how this is done ? and the pro's and cons of it.
I did trying searching for it but seams i dont actually know whats its properly called i came up with very little. I thinking this is done in apache ? im just guessing here
thanks,
rob
Re: [users@httpd] MYSQL Domain ?
Posted by Rob <bu...@gmail.com>.
That seams like an awesome suggestion Danie, i think this is by far better
way. 1 problem with this how-ever, i have no idea on how to go about doing
all this. Are you able to toss me a few links my way to read up on this.
Whats the time frame we looking here to do all this ? and is this all
basicly MYSQL based ? not apache at all ? does it require any special
license to do it ?
cheers
rob
On Sat, Jun 21, 2008 at 9:45 AM, Danie Qian <da...@bestningning.com> wrote:
> In your situation, why dont you do it this way:
> location1: 4 sites <-> mysql server1, as a master for these 4 local
> sites and replicate slave for the 2 sites in the other location.
> location2: 2 sites <-> mysql server2, as a master for these 2 local
> sites and replicate slave for the 4 sites in the other location
> not only this will be more efficient but also it will be more reliable as
> you have sort of a real time backup db server.
>
> ----- Original Message -----
> *From:* Rob <bu...@gmail.com>
> *To:* users@httpd.apache.org ; Danie Qian <da...@bestningning.com>
> *Sent:* Friday, June 20, 2008 5:26 PM
> *Subject:* Re: [users@httpd] MYSQL Domain ?
>
> To explain abit more about my situation,
>
> I have 6 joomla sites, 4 on one server 2 on another, with more to follow.
> What im needing to do is setup a simple form for people to fill out. This
> basicly will inject the database of each joomla site with the information
> from the form into them. The problem is that the servers are in two sperate
> locations so i presumed this would be a good way to connect to the databases
> from mulitlple locations.
>
> Danie, it is possible to have sql running on localhost and over a domain at
> the same time ?
>
> is any one able to point me to some reading material or walkthrough so i
> could get a better idea on what needs to be done ?
>
> cheers
>
> rob
>
> On Sat, Jun 21, 2008 at 9:19 AM, Danie Qian <da...@bestningning.com>
> wrote:
>
>> it is mysql.domainname.com:3306 you should connect to. I recomment you
>> keep a local database for each of your location, local i mean on the same
>> network. mysql connection from one location to another in the backend causes
>> performance issue. you might consider replicating the same db all across
>> your different locations.
>>
>> ----- Original Message -----
>> *From:* Doug Harvey <oh...@gmail.com>
>> *To:* users@httpd.apache.org
>> *Sent:* Friday, June 20, 2008 5:17 PM
>> *Subject:* RE: [users@httpd] MYSQL Domain ?
>>
>> Rob. I would think that you would want to use a port number instead of a
>> domain name. I think the port number is 3310, so you would have someone
>> connect by going to: domainname.com:3310
>>
>> Doug
>>
>>
>> ------------------------------
>> *From:* Rob [mailto:bubaphex@gmail.com]
>> *Sent:* Friday, June 20, 2008 2:01 PM
>> *To:* users@httpd.apache.org
>> *Subject:* [users@httpd] MYSQL Domain ?
>>
>> Hey there,
>>
>> wondering if some one could point me on the right direction. I have no
>> idea what its actually called but i want to asign my MYSQL to a domain name.
>>
>>
>> So instead of using local host they can use mysql.domainname.com
>>
>> Basically want this to make my database accessible to our other servers
>> which are hosted at all diffrent places around the world.
>>
>> Could any one give me a brief idea on how this is done ? and the pro's and
>> cons of it.
>>
>> I did trying searching for it but seams i dont actually know whats its
>> properly called i came up with very little. I thinking this is done in
>> apache ? im just guessing here
>>
>> thanks,
>>
>> rob
>>
>>
>
Re: [users@httpd] MYSQL Domain ?
Posted by Danie Qian <da...@bestningning.com>.
In your situation, why dont you do it this way:
location1: 4 sites <-> mysql server1, as a master for these 4 local sites and replicate slave for the 2 sites in the other location.
location2: 2 sites <-> mysql server2, as a master for these 2 local sites and replicate slave for the 4 sites in the other location
not only this will be more efficient but also it will be more reliable as you have sort of a real time backup db server.
----- Original Message -----
From: Rob
To: users@httpd.apache.org ; Danie Qian
Sent: Friday, June 20, 2008 5:26 PM
Subject: Re: [users@httpd] MYSQL Domain ?
To explain abit more about my situation,
I have 6 joomla sites, 4 on one server 2 on another, with more to follow. What im needing to do is setup a simple form for people to fill out. This basicly will inject the database of each joomla site with the information from the form into them. The problem is that the servers are in two sperate locations so i presumed this would be a good way to connect to the databases from mulitlple locations.
Danie, it is possible to have sql running on localhost and over a domain at the same time ?
is any one able to point me to some reading material or walkthrough so i could get a better idea on what needs to be done ?
cheers
rob
On Sat, Jun 21, 2008 at 9:19 AM, Danie Qian <da...@bestningning.com> wrote:
it is mysql.domainname.com:3306 you should connect to. I recomment you keep a local database for each of your location, local i mean on the same network. mysql connection from one location to another in the backend causes performance issue. you might consider replicating the same db all across your different locations.
----- Original Message -----
From: Doug Harvey
To: users@httpd.apache.org
Sent: Friday, June 20, 2008 5:17 PM
Subject: RE: [users@httpd] MYSQL Domain ?
Rob. I would think that you would want to use a port number instead of a domain name. I think the port number is 3310, so you would have someone connect by going to: domainname.com:3310
Doug
--------------------------------------------------------------------------
From: Rob [mailto:bubaphex@gmail.com]
Sent: Friday, June 20, 2008 2:01 PM
To: users@httpd.apache.org
Subject: [users@httpd] MYSQL Domain ?
Hey there,
wondering if some one could point me on the right direction. I have no idea what its actually called but i want to asign my MYSQL to a domain name.
So instead of using local host they can use mysql.domainname.com
Basically want this to make my database accessible to our other servers which are hosted at all diffrent places around the world.
Could any one give me a brief idea on how this is done ? and the pro's and cons of it.
I did trying searching for it but seams i dont actually know whats its properly called i came up with very little. I thinking this is done in apache ? im just guessing here
thanks,
rob
Re: [users@httpd] MYSQL Domain ?
Posted by Rob <bu...@gmail.com>.
To explain abit more about my situation,
I have 6 joomla sites, 4 on one server 2 on another, with more to follow.
What im needing to do is setup a simple form for people to fill out. This
basicly will inject the database of each joomla site with the information
from the form into them. The problem is that the servers are in two sperate
locations so i presumed this would be a good way to connect to the databases
from mulitlple locations.
Danie, it is possible to have sql running on localhost and over a domain at
the same time ?
is any one able to point me to some reading material or walkthrough so i
could get a better idea on what needs to be done ?
cheers
rob
On Sat, Jun 21, 2008 at 9:19 AM, Danie Qian <da...@bestningning.com> wrote:
> it is mysql.domainname.com:3306 you should connect to. I recomment you
> keep a local database for each of your location, local i mean on the same
> network. mysql connection from one location to another in the backend causes
> performance issue. you might consider replicating the same db all across
> your different locations.
>
> ----- Original Message -----
> *From:* Doug Harvey <oh...@gmail.com>
> *To:* users@httpd.apache.org
> *Sent:* Friday, June 20, 2008 5:17 PM
> *Subject:* RE: [users@httpd] MYSQL Domain ?
>
> Rob. I would think that you would want to use a port number instead of a
> domain name. I think the port number is 3310, so you would have someone
> connect by going to: domainname.com:3310
>
> Doug
>
>
> ------------------------------
> *From:* Rob [mailto:bubaphex@gmail.com]
> *Sent:* Friday, June 20, 2008 2:01 PM
> *To:* users@httpd.apache.org
> *Subject:* [users@httpd] MYSQL Domain ?
>
> Hey there,
>
> wondering if some one could point me on the right direction. I have no idea
> what its actually called but i want to asign my MYSQL to a domain name.
>
> So instead of using local host they can use mysql.domainname.com
>
> Basically want this to make my database accessible to our other servers
> which are hosted at all diffrent places around the world.
>
> Could any one give me a brief idea on how this is done ? and the pro's and
> cons of it.
>
> I did trying searching for it but seams i dont actually know whats its
> properly called i came up with very little. I thinking this is done in
> apache ? im just guessing here
>
> thanks,
>
> rob
>
>
Re: [users@httpd] MYSQL Domain ?
Posted by Danie Qian <da...@bestningning.com>.
it is mysql.domainname.com:3306 you should connect to. I recomment you keep a local database for each of your location, local i mean on the same network. mysql connection from one location to another in the backend causes performance issue. you might consider replicating the same db all across your different locations.
----- Original Message -----
From: Doug Harvey
To: users@httpd.apache.org
Sent: Friday, June 20, 2008 5:17 PM
Subject: RE: [users@httpd] MYSQL Domain ?
Rob. I would think that you would want to use a port number instead of a domain name. I think the port number is 3310, so you would have someone connect by going to: domainname.com:3310
Doug
------------------------------------------------------------------------------
From: Rob [mailto:bubaphex@gmail.com]
Sent: Friday, June 20, 2008 2:01 PM
To: users@httpd.apache.org
Subject: [users@httpd] MYSQL Domain ?
Hey there,
wondering if some one could point me on the right direction. I have no idea what its actually called but i want to asign my MYSQL to a domain name.
So instead of using local host they can use mysql.domainname.com
Basically want this to make my database accessible to our other servers which are hosted at all diffrent places around the world.
Could any one give me a brief idea on how this is done ? and the pro's and cons of it.
I did trying searching for it but seams i dont actually know whats its properly called i came up with very little. I thinking this is done in apache ? im just guessing here
thanks,
rob
RE: [users@httpd] MYSQL Domain ?
Posted by Doug Harvey <oh...@gmail.com>.
Rob. I would think that you would want to use a port number instead of a
domain name. I think the port number is 3310, so you would have someone
connect by going to: domainname.com:3310
Doug
_____
From: Rob [mailto:bubaphex@gmail.com]
Sent: Friday, June 20, 2008 2:01 PM
To: users@httpd.apache.org
Subject: [users@httpd] MYSQL Domain ?
Hey there,
wondering if some one could point me on the right direction. I have no idea
what its actually called but i want to asign my MYSQL to a domain name.
So instead of using local host they can use mysql.domainname.com
Basically want this to make my database accessible to our other servers
which are hosted at all diffrent places around the world.
Could any one give me a brief idea on how this is done ? and the pro's and
cons of it.
I did trying searching for it but seams i dont actually know whats its
properly called i came up with very little. I thinking this is done in
apache ? im just guessing here
thanks,
rob