Results 1 to 4 of 4

Thread: Pros and cons of using an external MySQL database?

  1. #1
    Wannabe Geek
    Join Date
    Jan 2007
    Location
    Navan, Co Meath
    Posts
    107
    Post Thanks / Like

    Default Pros and cons of using an external MySQL database?

    Hi All,
    I am working on a site where I may have to use an external MySQL database, in other words a database that is not with the same host.
    I have no experience with this and have read this can be done quiet easily by using the database IP address.
    I would however have a few questions:
    -Security: is it as secure as using an internal DB, I would be working from an HTTPS domain thus the info exchanged with the server would not necessarily be of a very sensitive nature.
    -Speed: if there a noticeable difference in speed, again as opposed to an internal DB
    -Errors: i read somewhere that there can be difficulty from time to time for the connection to be established, any experience?
    -Can I restrict the IP address from the referrer accepted by the database
    Any other pros / cons any one may have would be of assistance.
    Thank you in advance.

  2. #2
    Hardcore Geek link8r's Avatar
    Join Date
    Nov 2008
    Location
    Limerick
    Posts
    1,647
    Post Thanks / Like

    Default

    Some issues you will face, although it is done frequently:

    1. There will be a latency issue but depending on the data it may not be noticeable
    2. MySQL connections tend to be clear text by default - so you need to take care. Just sending people's e-mail addresses for example, are stricly governed
    3. Errors/Speed - try to keep it stateless (i.e. don't expect you have connection, be prepared to open it with each query)
    4. HTTPS is between the web host and the client user (Browser <-> web server). You won't be connecting on HTTP/HTTPS protocols generally speaking, to the MySQL Server

    Settings like whether or not you can use SSL data transfer, which IP's may access it are down to the admin and not generally open to modification on shared hosting platforms.

  3. #3
    Hardcore Geek ziycon's Avatar
    Join Date
    Jan 2007
    Location
    Dublin
    Posts
    565
    Post Thanks / Like

    Default

    I think link8r covered it but I just want to re-iterate, that you should be wary about the type of data your transmitting over open 'space'. If its personal data like names, DOB, emails, address, or even a payment process you will need to have sufficient security in place like SSL to protect this data as you don't want to be open to legal action should people's personal data get into the wrong hands.

  4. #4
    Frontpage User
    Join Date
    Feb 2011
    Posts
    1
    Post Thanks / Like

    Default Get your database as a service

    Hi,

    One option I recommend you to consider is to have your database provided as a service.

    You can check out our blog post on the pros and cons of deploying it yourself vs. having DBaaS.

    Move Your MySQL Database to the Cloud: DYI or Database Service? | Xeround MySQL Cloud Database Blog

Similar Threads

  1. Connecting to 2 Mysql database in the same script??
    By hypogeum in forum Coding Help
    Replies: 2
    Last Post: 27-04-2010, 11:03 AM
  2. Switching from $ to € - Pros and Cons?
    By robototitico in forum Google Adsense
    Replies: 4
    Last Post: 30-03-2010, 02:09 PM
  3. Affiliate programs, the ins n outs, the pros and cons
    By garycocs in forum Affiliate Programs
    Replies: 10
    Last Post: 30-03-2009, 11:30 PM
  4. Updating a database using PHP/MySQL
    By iorrasnet in forum Coding Help
    Replies: 13
    Last Post: 11-03-2009, 12:08 PM
  5. Connecting to 2 Mysql database in the same script??
    By Ciarán Mc Cann in forum Coding Help
    Replies: 11
    Last Post: 24-07-2007, 10:21 AM

Visitors found this page by searching for:

mysql pros and cons

mysql cons

mysql database pros and cons

pros and cons of mysql database

pros of mysql

pros cons database mysqlMySQL pros consmysql database pros conspros and cons mysqlMySQL pro contrapros and cons about using a database mysql 2008 pros and concons of mysqlpro con mysqlpros and cons of using a databasemysql pro consmysql external access pros conscons of MYsQL databasepros and cons my sqlusing external mysql databasecons mysqlpros and cons of mysql databasespros and cons of using MySQLmysql pro conexternal mysql secure

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •