klwillis
Posts: 428
|
| Posted: 11/20/2004, 4:02 PM |
|
Has anyone experienced problems with using
mysql_pconnect() vs mysql_connect() within their PHP pages?
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
 |
 |
Norbert
|
| Posted: 11/20/2004, 9:00 PM |
|
I have experienced that, unfortunately.
My conclusion was that CCS generated pages crashed when I tried to switch my project to non-persistent connection mode. I didn't have to much time to solve it and I left my application in persistent mode.
Anyway for other projects I swiched to postgres when I realized that either me or my client has to buy mysql license.
And non-persistent connections work well in postgresql.
Brgs
Norbert
|
|
|
|
klwillis
Posts: 428
|
| Posted: 11/20/2004, 9:18 PM |
|
Thanks for that bit of info.
Were the page crashes intermitent, or consistent?
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
RonB
Posts: 228
|
| Posted: 11/23/2004, 5:02 AM |
|
Why would you need to buy a liscence from mysql. It's free.
In windows with apache persistent connections can cause problems because each thread is seen as a new connection. This means an existent connection is not re-used but left open. This means that you can reach the max connections for your mysql server very fast. That's a windows problem, not a mysql problem
|
|
|
|
klwillis
Posts: 428
|
| Posted: 11/23/2004, 7:23 AM |
|
Do you know if the same problem exists on a Linux system
running Apache with MySQL and PHP?
Quote RonB:
Why would you need to buy a liscence from mysql. It's free.
In windows with apache persistent connections can cause problems because each thread is seen as a new connection. This means an existent connection is not re-used but left open. This means that you can reach the max connections for your mysql server very fast. That's a windows problem, not a mysql problem
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
RonB
Posts: 228
|
| Posted: 12/18/2004, 2:37 AM |
|
As far as I know this should not be a problem when running under linux.
|
|
|
|
klwillis
Posts: 428
|
| Posted: 12/18/2004, 8:54 AM |
|
MySQL connections are so quick that I'll stick with non-persistent
connections until I start seeing performance problems.
Quote RonB:
As far as I know this should not be a problem when running under linux.
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
Norbert
|
| Posted: 01/09/2005, 3:48 PM |
|
Quote RonB:
Why would you need to buy a liscence from mysql. It's free.
Hi,
I thought so, but according to my knowledge it is not so simple.
It is free as long as you do not sell your products, that are mysql based.
As I was in doubt I asked MySQL directly, and here is their answer:
Quote :
We appreciate your interest in MySQL. You can 1 1) release your "entire" application as GPL http://www.gnu.org/copyleft/gpl.html and include MySQL, also under GPL, in your application for free, or
2) if you do not wish to be restricted by the GPL and want to keep your application proprietary, you will need to purchase commercial non-GPL licenses for each copy you distribute.
Best regards
Norbert
|
|
|
|
RonB
Posts: 228
|
| Posted: 01/14/2005, 7:24 AM |
|
Quote :include MySQL, also under GPL,in your application for free
Thatīs the key part here. Using mysql as a backend is NOT the same as including it in your application. So for creating a web app you generaly do not include mysql in your application you just comunicate with it. Thatīs something entirely different.
If I create a website for a client who has an isp that offers mysql support I do not need a liscence, and neither does my client.
If I were to create an application and take mysql code and integrate it in my app...and I would not want to GPL my app I would need a liscence.
|
|
|
|
Norbert
|
| Posted: 01/15/2005, 6:34 AM |
|
I am not native english and maybe that's way it was not so clear to me.
Quote :
If I create a website for a client who has an isp that offers mysql support I do not need a liscence, and neither does my client.
Ron could you please tell me what to do when my customer is not using isp? I am developing web application used in my customer's intranet. He will have linux server with apache and database server. For this particular project I use postgresql but I also like mysql and not always want to use postgresql. Having that license issue solved could help me a lot.
Does it make any difference from your point of view if my customer is not using isp? I offered him application development + full environment setup including database, server, etc. One could say that I delivered application and database for it. I don't want my customer to get into any trouble due to not fully clear licenses issues that's way I went for postgresql.
If the license issue was solved I could use mysql next time.
I do appreciate your comments, thank you.
Best regards
Norbert
|
|
|
|
feha
Posts: 712
|
| Posted: 01/15/2005, 9:48 AM |
|
The mySQL license is not clear to much
http://www.mysql.com/company/legal/licensing/
Quote :The Commercial License, which allows you to provide commercial software licenses to your customers or distribute MySQL-based applications within your organization.
This would mean any application that uses MySQL DB ...
But you still find script or applications (commercial) that uses MySQL and costs $25USD.
MySQL Classic Commercial license costs: 250 Euro .
(This wouls mean foe each of your delivered or sold application you must add a cost of 250 Euro )
If I make my WebApplication use of Microsoft SQL Server Microsoft does not ask me to buy a commercial license but the company who installed and use SQL server.
By other means they must state more clear something like:
"IF YOUR APPLICATION IS NOT in other words they do not want to comply with the GNU General Public License (GPL)."
THEY CAN'T USE MySQL DB AS BACK-END"
Else it is cheaper to make PostgreSQL / or Microsoft SQL applications.
But be happy CodeChargeStudio provide us with great tool so you can use any DB you want unless you use DB specific functions within your custom code.
regards
feha
www.vision.to
Time to prepare my CMS even for PostgreSQL as an option.
_________________
Regards
feha
www.vision.to
feedpixel.com |
|
|
|
feha
Posts: 712
|
| Posted: 01/15/2005, 10:33 AM |
|
More info:
Quote :The Ins and Outs of Licensing
Both MySQL and PostgreSQL have different licenses, and understanding how they work is important when incorporating these products into enterprise projects. Different licenses fulfill different needs, and they have different requirements.
MySQL AB, the company that owns and produces MySQL, has two licenses available for its database product:
GNU General Public License (GPL) for GPL projects. If your project is 100 percent GPL in its distribution, you can use this license. To fully comply, you must distribute your application, along with the source code. You also can use this license if you don't intend to ever distribute your project internally or externally.
Commercial License for commercial applications. An example of the use for this license is when you don't want to distribute the source code for your application. This includes database drivers as well. You can't use the MySQL database drivers with a commercial application unless it's either distributed under the GPL license or you have a Commercial License.
PostgreSQL has a much simpler licensing scheme. It is released under the Berkley License, which allows for any use as long as a copy of the Berkley License is included with it. This means that you can release a commercial product that uses PostgreSQL or is a derivative of PostgreSQL without including source code.
_________________
Regards
feha
www.vision.to
feedpixel.com |
|
|
|
feha
Posts: 712
|
| Posted: 01/15/2005, 10:37 AM |
|
http://www.devx.com/dbzone/Article/20743
_________________
Regards
feha
www.vision.to
feedpixel.com |
|
|
|
feha
Posts: 712
|
| Posted: 01/15/2005, 10:39 AM |
|
Migrate your site from MySQL to PostgreSQL
http://www.sitepoint.com/article/site-mysql-postgresql-1
_________________
Regards
feha
www.vision.to
feedpixel.com |
|
|
|
RonB
Posts: 228
|
| Posted: 01/26/2005, 10:54 AM |
|
re: Norbert
Your client will have no trouble at all. You are not using any mysql source code IN your application. The mysql database is free to use so installing it for your client will also cause no troubles.
Again... The liscence is only needed if you take source code and re use it with your own code wich you do not want to give to mysql. So installing mysql for a client does not require the client to have a liscence. You do not need one either.
|
|
|
|
Norbert
|
| Posted: 04/10/2005, 2:57 PM |
|
Long time no answer from me.
But it is never too late, I guess.
I'd like to thank all of you for your valuable answers.
Best regards
Norbert
|
|
|
|
