Professional Web Applications Themes

PHP and Servlet Access to MySQL - MySQL

I am working on a website with two applications on the server - both accessing the MySql database. PHP applications are reading and writing to the database and a Java servlet (running under Tomcat) is also accessing the database. Currently the software in both applications is under development so there is very little in the way of actual database accesses, however, someone has suggested that we will have problems in the operational system because both Java and PHP applications will be attempting to access the same database. My understanding of MySQL is that it can handle these accesses without a ...

  1. #1

    Default PHP and Servlet Access to MySQL

    I am working on a website with two applications on the server - both
    accessing the MySql database. PHP applications are reading and writing
    to the database and a Java servlet (running under Tomcat) is also
    accessing the database. Currently the software in both applications is
    under development so there is very little in the way of actual database
    accesses, however, someone has suggested that we will have problems in
    the operational system because both Java and PHP applications will be
    attempting to access the same database.

    My understanding of MySQL is that it can handle these accesses without
    a problem.

    I would appreciate any comments on the potential problems that we might
    see.

    Thanks,

    Mike

    Mikey Guest

  2. #2

    Default Re: PHP and Servlet Access to MySQL

    Thanks for your comments, Gary.

    Gary L. Burnore wrote:
    > On 17 Jan 2006 13:00:53 -0800, "Mikey" <mike.gunncomcast.net> wrote:
    >
    > >I am working on a website with two applications on the server - both
    > >accessing the MySql database. PHP applications are reading and writing
    > >to the database and a Java servlet (running under Tomcat) is also
    > >accessing the database. Currently the software in both applications is
    > >under development so there is very little in the way of actual database
    > >accesses, however, someone has suggested that we will have problems in
    > >the operational system because both Java and PHP applications will be
    > >attempting to access the same database.
    > >
    > >My understanding of MySQL is that it can handle these accesses without
    > >a problem.
    > >
    > That's correct. Two apps accessing should be fine. Two instances of
    > PHP or TWO instances of a Java servelet wouldn't be much difference
    > than one of each unless the database isn't set up to handle locking.
    >
    > >I would appreciate any comments on the potential problems that we might
    > >see.
    >
    > Just make sure you use proper locking so both apps (or more than one
    > occurance of the same app) try to modify the same record at the same
    > time.
    > --
    > gburnore at DataBasix dot Com
    > ---------------------------------------------------------------------------
    > How you look depends on where you go.
    > ---------------------------------------------------------------------------
    > Gary L. Burnore | ۳ݳ޳ݳۺݳ޳ݳݳ޳ݳ۳
    > | ۳ݳ޳ݳۺݳ޳ݳݳ޳ݳ۳
    > Official .sig, Accept no substitutes. | ۳ݳ޳ݳۺݳ޳ݳݳ޳ݳ۳
    > | 0 1 7 2 3 / ݳ 3 74 9 3 0 ۳
    > Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
    > ================================================== =========================
    Mikey Guest

Similar Threads

  1. Replies: 1
    Last Post: November 30th, 03:31 AM
  2. MS Access vs MySQL
    By xcoldnet in forum Dreamweaver AppDev
    Replies: 3
    Last Post: February 24th, 07:13 PM
  3. Access to mySQL db
    By IPT in forum ASP Database
    Replies: 3
    Last Post: June 22nd, 05:39 AM
  4. MySQL to Access!
    By janet in forum ASP Database
    Replies: 1
    Last Post: August 28th, 02:08 AM
  5. ms access to MYSQL
    By manjunatha in forum ASP Database
    Replies: 1
    Last Post: July 22nd, 10:00 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139