Re: Downloading database tables
sqlyog or navicat are both great mysql management tools and have free editions. there is of course free mysql admin (part of mysql tools now, i think) downloadable from mysql website. since it is your vps, you can install one of these there as well, and configure remote access to your db, or just manually do a sql dump on the vps and download the .sql file it to your desktop and execute it to update your local db copy. beats phpmyadmin by a 1000 miles... in all cases make sure you back everything (database-wise) first before doing dumps/restoring. Azadi On 19/02/2011 04:58 , Rob Voyle wrote: > Hi Nathan > > I am using mySQL. On the VPS i have php based myadmin. Doesn't do a lot for > me and then I tried to download that to my local machine. After dowloading and > supposedly installing it I wasted a day scouring the web trying to configure > it. I > gave up in utter disgust at my inability to get it to run. Even cursed the > existence of whoever wrote the %$#%^ thing. > > On my local machine I use mySQL workbench. While it was easy to install and > runs well I have not found it intuitively easy to use (I am a real newbie to > mySQL and databases in general) > I actually find it easier to use the windows command line to create and alter > tables. > > My basic tables are not going to be large I am just looking for a way in CF to > export the data in the web table and include it into the local table. possibly > exporting as a CSV file or creating a cfinclude on my local machine that > access > the web file. > > I don't think I need anything as extensive as your project, I just want to > access > the data in already formed tables. Yes it will take some time, but after the > time I > have wasted on propriety stuff like php I would rather create something that I > know how it works and meets my needs. And once it is done can be applied to > several other projects I have in the works. > > Rob > Robert J. Voyle, Psy.D. > Director, Clergy Leadership Institute > For Coaching and Training in Appreciative Inquiry > Author: Restoring Hope: Appreciative Strategies > to Resolve Grief and Resentment > http://www.appreciativeway.com/ > 503-647-2378 or 503-647-2382 > > > > On 18 Feb 2011 at 13:16, Nathan Strutz wrote: > >> This one comes up from time to time. The best way to do it is with >> you >> chosen database's own development and management tools. If you use >> MS SQL >> Server Management Studio, they have integrated tools to copy a >> database. If >> you use Toad, they have something too. I have always had... let's >> say >> "limited" luck with those, but if you can get by with that, you >> should >> >> Now, if you wanted to do this in CF, it probably means work. I >> actually have >> a semi-functioning model of downloading one database and applying it >> to >> another, even works across database engines (e.g. download from >> oracle and >> apply to derby). Plus it takes snapshots so you can save versions of >> the >> database, including basic schema snapshots that you can import into >> another >> database, too. Then I got distracted, lost interest and have a 75% >> finished >> program. I'd open source it, but like I said it's not fully >> functional (not >> even fully baked), and I don't know that there's a real market for >> it. >> >> Umm, I can probably hook you up with a copy, no promises that it >> will even >> compile. >> >> nathan strutz >> [http://www.dopefly.com/] [http://hi.im/nathanstrutz] >> >> >> On Fri, Feb 18, 2011 at 12:32 PM, Rob Voyle >> wrote: >> >>> Hi folks >>> >>> What is the best way of downloading web database to a local >> desktop >>> machine. >>> >>> clients register for programs and the information is on the web >> database. >>> I want to use coldfusion to update my local desktop database >>> >>> Thanks >>> Rob >>> >>> >>> >> >> ~| >> Order the Adobe Coldfusion Anthology now! >> http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= >> houseoffusion >> Archive: >> http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 >> 2443 >> Subscription: >> http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm >> Unsubscribe: >> http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Feedback on this approach to "many sites, one codebase" (MSOC)
On Fri, Feb 18, 2011 at 11:36 AM, Rick Faircloth wrote: > When a user visits www.xyz.com, onApplicationStart() runs a > query that retrieves, among other variables, the absolute path > to those images. Realize, the application that I'm referencing > is a "global site manager" (single codebase) for managing > site content on multiple sites (each with a separate codebase, > as these are custom sites). The end user sites are completely > different. I'm using the "global site manager", at this point, > to simply provide a single app to supply CRUD functionality > to the users for their site content. Even the databases for > these sites have little in common. I just decided that instead > of building CRUD functionality over-and-over for each site manager, > I'd build "one site manager to rule them all." :o) That doesn't really sounds like you're running multiple different sites off one unified codebase - you're providing a library that is intended to be reused across multiple, separate applications :) > The userImages path gets set when the application is first run > by onApplicationStart() and a query, qGetApplicationVariables, is run > that retrieves info such as the userImages path, or, in this case, > qGetApplicationVariables.userImagesPathAbsolute. Then, the query > value for the userImages path is cfset to application.userImagesPathAbsolute > for use throughout the site. I have a site object containing all the site-specific settings. When a request comes in, the domain in the URL is mapped to a site object, and that is used throughout the request for any site-specific info. Site objects are cached for efficiency, of course. This allows me to clearly separate code / data that is common across all sites from that which varies. > If I have the same application name, wouldn't the userImages path > variable be overwritten when another user visits another site using > the same site manager codebase and onApplicationStart() is run again? onApplicationStart() is run once for the entire system in my model. I don't use bare application variables anywhere (because I use a framework that has all the services injected as needed, or uses a bean factory accessible within the framework). -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
using a function in CFReport buider
I've set up a function (taken from the Adobe site) which concatenates address
fields and is suppose to return one nice address block...
i've placed the function on the report detail band and reference
report.Format_address(query.ADDR1, query.ADDR2, etc) ...all my address fields
in the Expression Builder.
when I try to run the report i get the following error message
Diagnostics:Invalid ColdFusion expression in report. If the expression is a
string, ensure that it is within quotes. Error:
#report.Format_Address("query.ADDR1","query.ADDR2")# is not a valid ColdFusion
expression. The error occurred on line -1.
I've tried referencing the function name and variables with single quotes,
double quotes, with #, without # and still the same error message as above
I've also made sure there is data in both address fields i am testing with and
still the same error.
What can I be doing wrong ??
Any suggestions would be greatly appreciated.thank you very much
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading database tables
Navicat has scheduled, automated backups (any frequency). Works flawlessly. >Hi folks > >What is the best way of downloading web database to a local desktop machine. > >clients register for programs and the information is on the web database. >I want to use coldfusion to update my local desktop database > >Thanks >Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading database tables
Hi Nathan I am using mySQL. On the VPS i have php based myadmin. Doesn't do a lot for me and then I tried to download that to my local machine. After dowloading and supposedly installing it I wasted a day scouring the web trying to configure it. I gave up in utter disgust at my inability to get it to run. Even cursed the existence of whoever wrote the %$#%^ thing. On my local machine I use mySQL workbench. While it was easy to install and runs well I have not found it intuitively easy to use (I am a real newbie to mySQL and databases in general) I actually find it easier to use the windows command line to create and alter tables. My basic tables are not going to be large I am just looking for a way in CF to export the data in the web table and include it into the local table. possibly exporting as a CSV file or creating a cfinclude on my local machine that access the web file. I don't think I need anything as extensive as your project, I just want to access the data in already formed tables. Yes it will take some time, but after the time I have wasted on propriety stuff like php I would rather create something that I know how it works and meets my needs. And once it is done can be applied to several other projects I have in the works. Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 On 18 Feb 2011 at 13:16, Nathan Strutz wrote: > > This one comes up from time to time. The best way to do it is with > you > chosen database's own development and management tools. If you use > MS SQL > Server Management Studio, they have integrated tools to copy a > database. If > you use Toad, they have something too. I have always had... let's > say > "limited" luck with those, but if you can get by with that, you > should > > Now, if you wanted to do this in CF, it probably means work. I > actually have > a semi-functioning model of downloading one database and applying it > to > another, even works across database engines (e.g. download from > oracle and > apply to derby). Plus it takes snapshots so you can save versions of > the > database, including basic schema snapshots that you can import into > another > database, too. Then I got distracted, lost interest and have a 75% > finished > program. I'd open source it, but like I said it's not fully > functional (not > even fully baked), and I don't know that there's a real market for > it. > > Umm, I can probably hook you up with a copy, no promises that it > will even > compile. > > nathan strutz > [http://www.dopefly.com/] [http://hi.im/nathanstrutz] > > > On Fri, Feb 18, 2011 at 12:32 PM, Rob Voyle > wrote: > > > > > Hi folks > > > > What is the best way of downloading web database to a local > desktop > > machine. > > > > clients register for programs and the information is on the web > database. > > I want to use coldfusion to update my local desktop database > > > > Thanks > > Rob > > > > > > > > > ~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= > houseoffusion > Archive: > http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 > 2443 > Subscription: > http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: > http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading database tables
This one comes up from time to time. The best way to do it is with you chosen database's own development and management tools. If you use MS SQL Server Management Studio, they have integrated tools to copy a database. If you use Toad, they have something too. I have always had... let's say "limited" luck with those, but if you can get by with that, you should Now, if you wanted to do this in CF, it probably means work. I actually have a semi-functioning model of downloading one database and applying it to another, even works across database engines (e.g. download from oracle and apply to derby). Plus it takes snapshots so you can save versions of the database, including basic schema snapshots that you can import into another database, too. Then I got distracted, lost interest and have a 75% finished program. I'd open source it, but like I said it's not fully functional (not even fully baked), and I don't know that there's a real market for it. Umm, I can probably hook you up with a copy, no promises that it will even compile. nathan strutz [http://www.dopefly.com/] [http://hi.im/nathanstrutz] On Fri, Feb 18, 2011 at 12:32 PM, Rob Voyle wrote: > > Hi folks > > What is the best way of downloading web database to a local desktop > machine. > > clients register for programs and the information is on the web database. > I want to use coldfusion to update my local desktop database > > Thanks > Rob > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Feedback on this approach to "many sites, one codebase" (MSOC)
Good points about the single application name. However, it brings into question my entire approach to application variables. Take, for instance, my path to userImages. When a user visits www.xyz.com, onApplicationStart() runs a query that retrieves, among other variables, the absolute path to those images. Realize, the application that I'm referencing is a "global site manager" (single codebase) for managing site content on multiple sites (each with a separate codebase, as these are custom sites). The end user sites are completely different. I'm using the "global site manager", at this point, to simply provide a single app to supply CRUD functionality to the users for their site content. Even the databases for these sites have little in common. I just decided that instead of building CRUD functionality over-and-over for each site manager, I'd build "one site manager to rule them all." :o) Now, for one site, the userImages path is, say, e:\inetpub\webroot\siteOne\userImages and for another site, the userImages path is e:\inetpub\webroot\siteTwo\userImages The userImages path gets set when the application is first run by onApplicationStart() and a query, qGetApplicationVariables, is run that retrieves info such as the userImages path, or, in this case, qGetApplicationVariables.userImagesPathAbsolute. Then, the query value for the userImages path is cfset to application.userImagesPathAbsolute for use throughout the site. If I have the same application name, wouldn't the userImages path variable be overwritten when another user visits another site using the same site manager codebase and onApplicationStart() is run again? Rick -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: Friday, February 18, 2011 1:24 PM To: cf-talk Subject: Re: Feedback on this approach to "many sites, one codebase" (MSOC) On Fri, Feb 18, 2011 at 6:14 AM, Eric Cobb wrote: > One thing you may want to take into consideration, if you plan on having > many sites run through this codebase, is NOT giving each site a unique > application name. I always take the approach of a single application name - for the reasons Eric presents - and I also typically have one DSN and all sites are in a single multi-tenant schema (and I'll be explaining all this in my Multi-Tenant Architecture talk at cf.Objective() BTW). Re: ?reinit=1 situations - what do you normally need to do that for? Refreshing the cache for a particular site? Design that into your admin system. Refreshing code after pushing a new file? As Eric points out, you need to reinit *every* application in that situation so you'd end up restarting the entire server. With MSOC, you need to consider your DB schema as part of your code too - that "OC" part means "One Schema" too. "OC" really means "One Application" otherwise you're going to be running multiple identical copies of your code and wasting memory. Steve asked "wouldn't it make sense to push it into the server scope?" - that can interfere with running any other applications on the server - and you probably want an admin application running alongside your multiple user applications. Now, you may share code between the admin and the user applications but it will be lower level components, if any, and you typically only have one admin application so you're at most running two copies of your code. You've also got startup issues to think about - if you have multiple applications and need to initialize server scope, there's no safe hook to do that (until we got CF9's onServerStart() / Server.cfc). Some things to think about... If you're at cf.Objective() and want to hear more on this topic, attend my talk and catch me in the bar afterward! If you're not yet registered for cf.Objective()... It'll be a great conference: five tracks this year, lots of awesome topics from great speakers, all packed into three days in a relatively central location (Minneapolis). You've missed the early bird now but it's still great value at under $1k! In addition to my Multi-Tenant Architecture talk, I'm giving an Introduction to Functional Programming session which addresses things like careful management of shared data and why side-effect-free code is easier to test and easier to get right in the first place (amongst many other functional techniques, some of which you can apply directly to CFML and some of which will at least make you think differently about solving problems). -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342442 Subscription: http://www.houseoffusion.com/gr
Downloading database tables
Hi folks What is the best way of downloading web database to a local desktop machine. clients register for programs and the information is on the web database. I want to use coldfusion to update my local desktop database Thanks Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Precision Value from SQL Server & CF9
CF will read in bit values from SQL Server and evaluate them as
equivalent to true/false or yes/no. However, SQL Server expects 0 or 1
from ColdFusion when writing to a bit field. There's probably a UDF on
CFLib.org that converts CF boolean values into strict bit values, but
here's one I wrote for this purpose:
HTH,
Carl
On 2/18/2011 10:38 AM, Nicki Tabb wrote:
> sorry,
> I guess I meant that, when using CF, I have never had issues with No or False
> or 0 being read as the same by the SQL Server
>
>
>
>> No it doesn't.
>>
>> Here is an example on SQL 2005:
>>
>> declare @test table (
>> testVal bit
>> )
>>
>> insert into @test (testval) values (0);
>> insert into @test (testval) values ('Yes'); -- Results in error
>> Conversion failed when converting the varchar value 'Yes' to data type
>> bit.
>> insert into @test (testval) values ('True'); -- Results in error
>> Conversion failed when converting the varchar value 'True' to data type
>> bit.
>> insert into @test (testval) values ('No'); -- Results in error
>> Conversion failed when converting the varchar value 'No' to data type
>> bit.
>> insert into @test (testval) values ('False'); -- Results in error
>> Conversion failed when converting the varchar value 'False' to data type
>> bit.
>>
>> select * from @test
>>
>> Sql expects data types that match. ColdFusion isn't strongly typed so
>> false and no are equivalent to 0.
>>
>> Steve
>>
>>
>>
>> SQL will read a NO or FALSE or 0 as the same
>
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342440
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Precision Value from SQL Server & CF9
sorry,
I guess I meant that, when using CF, I have never had issues with No or False
or 0 being read as the same by the SQL Server
>No it doesn't.
>
>Here is an example on SQL 2005:
>
>declare @test table (
> testVal bit
>)
>
>insert into @test (testval) values (0);
>insert into @test (testval) values ('Yes'); -- Results in error
>Conversion failed when converting the varchar value 'Yes' to data type
>bit.
>insert into @test (testval) values ('True'); -- Results in error
>Conversion failed when converting the varchar value 'True' to data type
>bit.
>insert into @test (testval) values ('No'); -- Results in error
>Conversion failed when converting the varchar value 'No' to data type
>bit.
>insert into @test (testval) values ('False'); -- Results in error
>Conversion failed when converting the varchar value 'False' to data type
>bit.
>
>select * from @test
>
>Sql expects data types that match. ColdFusion isn't strongly typed so
>false and no are equivalent to 0.
>
>Steve
>
>
>
>SQL will read a NO or FALSE or 0 as the same
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342439
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Invalid Precision Value from SQL Server & CF9
No it doesn't.
Here is an example on SQL 2005:
declare @test table (
testVal bit
)
insert into @test (testval) values (0);
insert into @test (testval) values ('Yes'); -- Results in error
Conversion failed when converting the varchar value 'Yes' to data type
bit.
insert into @test (testval) values ('True'); -- Results in error
Conversion failed when converting the varchar value 'True' to data type
bit.
insert into @test (testval) values ('No'); -- Results in error
Conversion failed when converting the varchar value 'No' to data type
bit.
insert into @test (testval) values ('False'); -- Results in error
Conversion failed when converting the varchar value 'False' to data type
bit.
select * from @test
Sql expects data types that match. ColdFusion isn't strongly typed so
false and no are equivalent to 0.
Steve
-Original Message-
From: Nicki Tabb [mailto:vnt...@alaska.edu]
Sent: Friday, February 18, 2011 1:17 PM
To: cf-talk
Subject: Re: Invalid Precision Value from SQL Server & CF9
SQL will read a NO or FALSE or 0 as the same
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342438
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Precision Value from SQL Server & CF9
SQL will read a NO or FALSE or 0 as the same >Surely a bit field will need 0 or 1, not a string? Or was that not what you >meant? > > > >The default is NO so it always has a value > >> What is the value of #FORM.LoanerYN# when you try to insert it in the >> bit field? >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Feedback on this approach to "many sites, one codebase" (MSOC)
On Fri, Feb 18, 2011 at 6:14 AM, Eric Cobb wrote: > One thing you may want to take into consideration, if you plan on having > many sites run through this codebase, is NOT giving each site a unique > application name. I always take the approach of a single application name - for the reasons Eric presents - and I also typically have one DSN and all sites are in a single multi-tenant schema (and I'll be explaining all this in my Multi-Tenant Architecture talk at cf.Objective() BTW). Re: ?reinit=1 situations - what do you normally need to do that for? Refreshing the cache for a particular site? Design that into your admin system. Refreshing code after pushing a new file? As Eric points out, you need to reinit *every* application in that situation so you'd end up restarting the entire server. With MSOC, you need to consider your DB schema as part of your code too - that "OC" part means "One Schema" too. "OC" really means "One Application" otherwise you're going to be running multiple identical copies of your code and wasting memory. Steve asked "wouldn't it make sense to push it into the server scope?" - that can interfere with running any other applications on the server - and you probably want an admin application running alongside your multiple user applications. Now, you may share code between the admin and the user applications but it will be lower level components, if any, and you typically only have one admin application so you're at most running two copies of your code. You've also got startup issues to think about - if you have multiple applications and need to initialize server scope, there's no safe hook to do that (until we got CF9's onServerStart() / Server.cfc). Some things to think about... If you're at cf.Objective() and want to hear more on this topic, attend my talk and catch me in the bar afterward! If you're not yet registered for cf.Objective()... It'll be a great conference: five tracks this year, lots of awesome topics from great speakers, all packed into three days in a relatively central location (Minneapolis). You've missed the early bird now but it's still great value at under $1k! In addition to my Multi-Tenant Architecture talk, I'm giving an Introduction to Functional Programming session which addresses things like careful management of shared data and why side-effect-free code is easier to test and easier to get right in the first place (amongst many other functional techniques, some of which you can apply directly to CFML and some of which will at least make you think differently about solving problems). -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Auto Suggest CFC Path
You need to use the same URL path that you would expect to use if from the
url, so in your case it is.
autosuggest="cfc: traumasystem.tcda.cfc.users.autoSuggestUsers()"
Regards,
Andrew Scott
http://www.andyscott.id.au/
> -Original Message-
> From: Evik James [mailto:e...@evikjames.com]
> Sent: Saturday, 19 February 2011 4:42 AM
> To: cf-talk
> Subject: Auto Suggest CFC Path
>
>
> I am trying to use the autosuggest parameter in a cfinput. I can't quite
figure
> out how to bind the autosuggest to the CFC.
>
> I have tried:
>
> autosuggest="cfc:users.autoSuggestUsers()"
> autosuggest="cfc:cfc.users.autoSuggestUsers()"
> autosuggest="cfc.users.autoSuggestUsers()"
> autosuggest="...cfc.users.autoSuggestUsers()"
>
> In my application.cfc file, I refer to my cfc like this:
>
> ro = structNew();
> ro.users = createObject('component', 'traumasystem.tcda.cfc.users');
>
> The error I get is... "The specified CFC users could not be found."
>
> Can you help?
>
>
>
>
> ~~
> ~~~|
> Order the Adobe Coldfusion Anthology now!
> http://www.amazon.com/Adobe-Coldfusion-
> Anthology/dp/1430272155/?tag=houseoffusion
> Archive: http://www.houseoffusion.com/groups/cf-
> talk/message.cfm/messageid:342434
> Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
> Unsubscribe: http://www.houseoffusion.com/groups/cf-
> talk/unsubscribe.cfm
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342435
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Auto Suggest CFC Path
I am trying to use the autosuggest parameter in a cfinput. I can't quite
figure out how to bind the autosuggest to the CFC.
I have tried:
autosuggest="cfc:users.autoSuggestUsers()"
autosuggest="cfc:cfc.users.autoSuggestUsers()"
autosuggest="cfc.users.autoSuggestUsers()"
autosuggest="...cfc.users.autoSuggestUsers()"
In my application.cfc file, I refer to my cfc like this:
ro = structNew();
ro.users = createObject('component', 'traumasystem.tcda.cfc.users');
The error I get is... "The specified CFC users could not be found."
Can you help?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342434
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Precision Value from SQL Server & CF9
Surely a bit field will need 0 or 1, not a string? Or was that not what you meant? - Original Message From: Nicki Tabb To: cf-talk Sent: Fri, 18 February, 2011 15:32:19 Subject: Re: Invalid Precision Value from SQL Server & CF9 The default is NO so it always has a value > What is the value of #FORM.LoanerYN# when you try to insert it in the > bit field? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Inline structure notation as argument fails
I'm using 9,0,1,274733. Jason Durham On Wed, Feb 16, 2011 at 5:43 PM, Sean Corfield wrote: > > CF9 or CF9.0.1? ISTR a bug in this area that got fixed sometime along > the way...? > > On Wed, Feb 16, 2011 at 1:05 PM, Jason Durham wrote: > > > > I'm re-writing an event handler to utilize CF9s scripting enhancement. > The > > majority of the handler was already written in cfscript, including the > line > > of code I'm having problems with. After making the change to full > script, > > I'm getting an exception indicating "Variable EVENT is undefined". > > > > http://coldbox.pastebin.com/CGRVf25z > > > > By moving the structure to its own variable, the code executes without > > error. Is this expected behavi > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Precision Value from SQL Server & CF9
The default is NO so it always has a value > What is the value of #FORM.LoanerYN# when you try to insert it in the > bit field? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd webservice request... Result vs Return
I think we finally decided that the binding types being RPC on the CF side and DOC on the MS side was the real issue and that there really isnt a way around it in CF (please correct me if I'm wrong there). That being the case, the only option was to support both on the .NET side. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Friday, February 18, 2011 9:20 AM To: cf-talk Subject: Odd webservice request... Result vs Return Hi all, This is a pretty odd request. I actually found someone asking a similar question all over the place back in 2003 but they never found an answer as far as I can tell. Basically, we have multiple products. All of those products are .NET with exception to the one I work on (the better one!!) which is obviously ColdFusion. (8.0.1). All of the products have a similar web service and they all work and clients can use them fine. We offer our products individually or as a suite. As a suite, management wants a single wrapper service that handles calling all of the individual product web services. That makes sense, better product integration = a better experience. However, management does not want that wrapper to cater to the products, they want the products to cater to that wrapper. Ive lost that battle about 4 times now so the only option is conformity at this point. The problem with that are the many differences in the resulting stubs between the CF product and the .NET products. I have worked with the guy developing the wrapper to get all of the complex data types worked out (almost) and there is one more nagging issue. Lets say the method in the service is called myMethod... all of the .NET WSDLs have something like the following. http://Integrations/> The result from the CF webservice looks more like: http://schemas.xmlsoap.org/sopa/encoding/ xmlns:ns1=http://Integrations/> http://some.path> The difference that the other developer believes is causing an issue is instead of Obviously, that isnt something I am stubbing out manually; Axis is doing that behind the scenes. We've been able to force the complex definitions in the stub to be more like what we need them to be by using some custom object CFCs and defining argument types like customType[]. However, I've not found ANYTHING that would allow me to override the "Return" to "Result". I have a hard time believing this is really the problem but I can't prove that unless I can get it returned that way. Does anyone have any idea on whether or not this is even possible in CF and, if so, how it can be done? I've been at this one for a while and would really appreciate any guidance you can offer. Thanks! .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Ha ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Feedback on this approach to "many sites, one codebase" (MSOC)
I've never used the server scope in apps, so it's not a question I can answer...perhaps others will chime in on this one. And, as part of this situation, there are almost no variables that are shared between applications, so I don't see that there would be many variables to put into the server scope. Every site has its own database, paths, etc. Rick -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Friday, February 18, 2011 10:11 AM To: cf-talk Subject: RE: Feedback on this approach to "many sites, one codebase" (MSOC) Probably a stupid question, but if the data was used across applications wouldn't it make sense to push it into the server scope? That would allow you to have one copy of the needed items, but still let you keep the applications separate. I know that a lot of the time having a different application name for each application while troubleshooting can be extremely helpful. I don't have a situation like this and I hardly ever look at the server scope, so I'm just asking because it will help further my knowledge. :) Steve -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Friday, February 18, 2011 9:15 AM To: cf-talk Subject: Re: Feedback on this approach to "many sites, one codebase" (MSOC) One thing you may want to take into consideration, if you plan on having many sites run through this codebase, is NOT giving each site a unique application name. (as in ). I once worked on a MSOC system that ran somewhere around 2700 websites, and each site had its own application name. So, every time we cached a CFC in the application scope, we had 2700 separate instances of it, even though they were all identical. We had 2700 "application.dsn" variables stored in memory, even though they were all identical. We had multiple CF servers each trying to store and manage the same 2700 separate applications, all of which were completely identical. And the worst part was, there was no passing "?reinit=1" if we made code changes and needed to reset the application scope, we had to restart each CF server and take all 2700 sites offline in order to reset all of the applications. To me, this always seemed inefficient, and a gross waste of CF processes and memory. Just some thoughts I wanted to throw out there. Definitely something to think about if you're planning on having a large number of sites on your system. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Feedback on this approach to "many sites, one codebase" (MSOC)
Thanks for the feedback, Eric. Wouldn't sharing an application name cause some sharing of variables between sites? And: So using ?reinit=1 or something similar resets variables within *every* application, even with different application names? I thought the main reason for using different application names was to prevent application, session, etc variable bleed-over and to allow reinitializing of one application without affecting others, even on the same codebase. ??? -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Friday, February 18, 2011 9:15 AM To: cf-talk Subject: Re: Feedback on this approach to "many sites, one codebase" (MSOC) One thing you may want to take into consideration, if you plan on having many sites run through this codebase, is NOT giving each site a unique application name. (as in ). I once worked on a MSOC system that ran somewhere around 2700 websites, and each site had its own application name. So, every time we cached a CFC in the application scope, we had 2700 separate instances of it, even though they were all identical. We had 2700 "application.dsn" variables stored in memory, even though they were all identical. We had multiple CF servers each trying to store and manage the same 2700 separate applications, all of which were completely identical. And the worst part was, there was no passing "?reinit=1" if we made code changes and needed to reset the application scope, we had to restart each CF server and take all 2700 sites offline in order to reset all of the applications. To me, this always seemed inefficient, and a gross waste of CF processes and memory. Just some thoughts I wanted to throw out there. Definitely something to think about if you're planning on having a large number of sites on your system. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com On 2/17/2011 8:59 PM, Rick Faircloth wrote: > Your approach at Broadchoice sounds exactly like what I'm > anticipating implementing... > > > -Original Message- > From: Sean Corfield [mailto:seancorfi...@gmail.com] > Sent: Thursday, February 17, 2011 5:58 PM > To: cf-talk > Subject: Re: Feedback on this approach to "many sites, one codebase" (MSOC) > > > On Thu, Feb 17, 2011 at 10:21 AM, Robert Harrison > wrote: >> 1. Your relationship with the client changes and the client wants to > take the site and move. Now you are faced with either holding the client's > site hostage or giving away your multi-site base code framework (possibly > even to a competitor). Neither of those is an attractive option. > > It really depends on how you set up the contract and the expectations. > Broadchoice (where I worked in 2008) has a software-as-a-service CMS > which hosts a number of high-profile client sites. It's very clear to > the clients that they're using a multi-tenant SaaS platform and > therefore they know upfront that this isn't a site they can just "take > over" (although there is an option to license the codebase for an > internal installation). > >> 2. Also, assume one or more clients keeps coming back to you to make > adjustments and additions. Now your code is getting more and more mucked up > with custom-code exceptions. That's also not cool. Eventually that will > make your framework really difficult to manage and upgrade. > > At Broadchoice we tackled this by designing a pluggable, modular > architecture for "applications" that could literally be dropped into > the (single) codebase and then configured to be available on any > client sites. The nice thing about this is that one client may pay for > the module to be developed but it's still provided to them as a > service - they're not purchasing the code - and then it can be offered > to other clients, as a paid option if appropriate. > > The key is really in deciding whether you're "just" hosting a number > of sites or whether you're offering a "website platform" in a SaaS > model. > > You might also want to read Steve "Cutter" Blades blog series about MSOC: > > http://blog.cutterscrossing.com/index.cfm/MSOC > > At World Singles, we have about 50 sites all running on a single > codebase. Mostly the sites differ in branding and look'n'feel but > there are functional differences between many of the sites, managed > with a similar model to what we used at Broadchoice. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342428 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Odd webservice request... Result vs Return
Hi all, This is a pretty odd request. I actually found someone asking a similar question all over the place back in 2003 but they never found an answer as far as I can tell. Basically, we have multiple products. All of those products are .NET with exception to the one I work on (the better one!!) which is obviously ColdFusion. (8.0.1). All of the products have a similar web service and they all work and clients can use them fine. We offer our products individually or as a suite. As a suite, management wants a single wrapper service that handles calling all of the individual product web services. That makes sense, better product integration = a better experience. However, management does not want that wrapper to cater to the products, they want the products to cater to that wrapper. Ive lost that battle about 4 times now so the only option is conformity at this point. The problem with that are the many differences in the resulting stubs between the CF product and the .NET products. I have worked with the guy developing the wrapper to get all of the complex data types worked out (almost) and there is one more nagging issue. Lets say the method in the service is called myMethod... all of the .NET WSDLs have something like the following. http://Integrations/> The result from the CF webservice looks more like: http://schemas.xmlsoap.org/sopa/encoding/ xmlns:ns1=http://Integrations/> http://some.path> The difference that the other developer believes is causing an issue is instead of Obviously, that isnt something I am stubbing out manually; Axis is doing that behind the scenes. We've been able to force the complex definitions in the stub to be more like what we need them to be by using some custom object CFCs and defining argument types like customType[]. However, I've not found ANYTHING that would allow me to override the "Return" to "Result". I have a hard time believing this is really the problem but I can't prove that unless I can get it returned that way. Does anyone have any idea on whether or not this is even possible in CF and, if so, how it can be done? I've been at this one for a while and would really appreciate any guidance you can offer. Thanks! .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Ha ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Feedback on this approach to "many sites, one codebase" (MSOC)
Probably a stupid question, but if the data was used across applications wouldn't it make sense to push it into the server scope? That would allow you to have one copy of the needed items, but still let you keep the applications separate. I know that a lot of the time having a different application name for each application while troubleshooting can be extremely helpful. I don't have a situation like this and I hardly ever look at the server scope, so I'm just asking because it will help further my knowledge. :) Steve -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Friday, February 18, 2011 9:15 AM To: cf-talk Subject: Re: Feedback on this approach to "many sites, one codebase" (MSOC) One thing you may want to take into consideration, if you plan on having many sites run through this codebase, is NOT giving each site a unique application name. (as in ). I once worked on a MSOC system that ran somewhere around 2700 websites, and each site had its own application name. So, every time we cached a CFC in the application scope, we had 2700 separate instances of it, even though they were all identical. We had 2700 "application.dsn" variables stored in memory, even though they were all identical. We had multiple CF servers each trying to store and manage the same 2700 separate applications, all of which were completely identical. And the worst part was, there was no passing "?reinit=1" if we made code changes and needed to reset the application scope, we had to restart each CF server and take all 2700 sites offline in order to reset all of the applications. To me, this always seemed inefficient, and a gross waste of CF processes and memory. Just some thoughts I wanted to throw out there. Definitely something to think about if you're planning on having a large number of sites on your system. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Feedback on this approach to "many sites, one codebase" (MSOC)
One thing you may want to take into consideration, if you plan on having many sites run through this codebase, is NOT giving each site a unique application name. (as in ). I once worked on a MSOC system that ran somewhere around 2700 websites, and each site had its own application name. So, every time we cached a CFC in the application scope, we had 2700 separate instances of it, even though they were all identical. We had 2700 "application.dsn" variables stored in memory, even though they were all identical. We had multiple CF servers each trying to store and manage the same 2700 separate applications, all of which were completely identical. And the worst part was, there was no passing "?reinit=1" if we made code changes and needed to reset the application scope, we had to restart each CF server and take all 2700 sites offline in order to reset all of the applications. To me, this always seemed inefficient, and a gross waste of CF processes and memory. Just some thoughts I wanted to throw out there. Definitely something to think about if you're planning on having a large number of sites on your system. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com On 2/17/2011 8:59 PM, Rick Faircloth wrote: > Your approach at Broadchoice sounds exactly like what I'm > anticipating implementing... > > > -Original Message- > From: Sean Corfield [mailto:seancorfi...@gmail.com] > Sent: Thursday, February 17, 2011 5:58 PM > To: cf-talk > Subject: Re: Feedback on this approach to "many sites, one codebase" (MSOC) > > > On Thu, Feb 17, 2011 at 10:21 AM, Robert Harrison > wrote: >> 1. Your relationship with the client changes and the client wants to > take the site and move. Now you are faced with either holding the client's > site hostage or giving away your multi-site base code framework (possibly > even to a competitor). Neither of those is an attractive option. > > It really depends on how you set up the contract and the expectations. > Broadchoice (where I worked in 2008) has a software-as-a-service CMS > which hosts a number of high-profile client sites. It's very clear to > the clients that they're using a multi-tenant SaaS platform and > therefore they know upfront that this isn't a site they can just "take > over" (although there is an option to license the codebase for an > internal installation). > >> 2. Also, assume one or more clients keeps coming back to you to make > adjustments and additions. Now your code is getting more and more mucked up > with custom-code exceptions. That's also not cool. Eventually that will > make your framework really difficult to manage and upgrade. > > At Broadchoice we tackled this by designing a pluggable, modular > architecture for "applications" that could literally be dropped into > the (single) codebase and then configured to be available on any > client sites. The nice thing about this is that one client may pay for > the module to be developed but it's still provided to them as a > service - they're not purchasing the code - and then it can be offered > to other clients, as a paid option if appropriate. > > The key is really in deciding whether you're "just" hosting a number > of sites or whether you're offering a "website platform" in a SaaS > model. > > You might also want to read Steve "Cutter" Blades blog series about MSOC: > > http://blog.cutterscrossing.com/index.cfm/MSOC > > At World Singles, we have about 50 sites all running on a single > codebase. Mostly the sites differ in branding and look'n'feel but > there are functional differences between many of the sites, managed > with a similar model to what we used at Broadchoice. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342425 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
Try http://www.scribblar.com/latestrooms.cfm The CF server is UK racked, the DB is US-East on EC2 (micro instance, RDS would arguably perform better). The page runs an uncached query to grab the latest rooms. The plan is to move everything onto EC2. Cheers Stefan On 18 Feb 2011, at 10:47, Jochem van Dieten wrote: > > On Fri, Feb 18, 2011 at 5:57 AM, Chris wrote: >> >> Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept >> from what I'm reading at least, sounds great. >> >> I currently use shared hosting with CF and MySQL. I'm pouring over the >> documentation but most of it is over my head as I'm not familiar with Amazon >> web services and/or MySQL server administration. >> >> From what I'm getting though, I can create the MySQL database there, import >> data into it, and then connect to it from the CF server during CFQUERY calls. > > In theory yes. In practice you may encounter the following problems: > - firewalls preventing your shared host from connecting to the database; > - latency between your shared host and the database. > > The last one can be a killer. Let's presume the network latency is > about 50 ms. For setting up a database connection you first have the > TCP SYN/ACK and then MySQL authentication. Your best case scenario is > now 100 ms to set up the connection. Doing a query? First send the > PREPARE statement, then execute it. So that is another 100 ms. But > wait, once the results are in the driver will do additional calls to > get the metadata that describe the columns. So doing a query over a > new connection is now 250 ms, and over an existing connection 150 ms. > And that is without the unpredictability of the latency inside the > Amazon cloud. > > Amazon RDS may be a good solution if your app is hosted at Amazon too, > but otherwise I don't think it is a good idea for interactive > applications. And if you are hosting your servers on Amazon, why not > load MySQL on your instance there? > > > But the great thing about all the Amazon Cloud services is the cost > for a short test. Since it costs you about 0.11$ per hour to just test > it, so why not try it and tell us how it goes :) > > Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
I would presume you are not using amazon for a 24/7 database connection as this would be prohibitively expensive, much more than having your own VPS or using database hositng, so I presume you are using it only for occasional access, in which case caching your queries is a must and will overcome the latency issue. -- Russ Michaels www.bluethunderinternet.com : Business hosting services & solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
On Fri, Feb 18, 2011 at 5:57 AM, Chris wrote: > > Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept > from what I'm reading at least, sounds great. > > I currently use shared hosting with CF and MySQL. I'm pouring over the > documentation but most of it is over my head as I'm not familiar with Amazon > web services and/or MySQL server administration. > > From what I'm getting though, I can create the MySQL database there, import > data into it, and then connect to it from the CF server during CFQUERY calls. In theory yes. In practice you may encounter the following problems: - firewalls preventing your shared host from connecting to the database; - latency between your shared host and the database. The last one can be a killer. Let's presume the network latency is about 50 ms. For setting up a database connection you first have the TCP SYN/ACK and then MySQL authentication. Your best case scenario is now 100 ms to set up the connection. Doing a query? First send the PREPARE statement, then execute it. So that is another 100 ms. But wait, once the results are in the driver will do additional calls to get the metadata that describe the columns. So doing a query over a new connection is now 250 ms, and over an existing connection 150 ms. And that is without the unpredictability of the latency inside the Amazon cloud. Amazon RDS may be a good solution if your app is hosted at Amazon too, but otherwise I don't think it is a good idea for interactive applications. And if you are hosting your servers on Amazon, why not load MySQL on your instance there? But the great thing about all the Amazon Cloud services is the cost for a short test. Since it costs you about 0.11$ per hour to just test it, so why not try it and tell us how it goes :) Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
You'll most likely want your CF server in close proximity to the cloud based MySQL server, i.e. your server would want to be an EC2 instance. I've a few servers setup in the Amazon cloud and for the most part it is really neat. Things to be aware of though are outages, servers have a habit of "disappearing" (not a frequent issue, but it is there). If using EC2 for servers, having a backup and restoration plan is paramount. A copy of your latest server image should be ready to be booted up at a snap and all data should be stored on a detachable volume and backed up regularly (Amazon Elastic Storage for detachable volumes and potentially S3 for backup). It would be interesting to see how connecting to the RDS would work from a non Amazon hosted server, I imagine it would suffer lag - pretty cheap to find out though :) HTH Dominic On 18 February 2011 04:57, Chris . wrote: > > Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the > concept from what I'm reading at least, sounds great. > > I currently use shared hosting with CF and MySQL. I'm pouring over the > documentation but most of it is over my head as I'm not familiar with Amazon > web services and/or MySQL server administration. > > From what I'm getting though, I can create the MySQL database there, import > data into it, and then connect to it from the CF server during CFQUERY > calls. > > Has anyone looked into this or tried something like this? I'm skeptical > and imagine there'd be overhead that would make it unusable but I'm not > finding anything to back that up.. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
I've not used RDS (yet) due to the costs involved but it certainly is an attractive option as your operations grow as backup and replication are 'built in'. Overhead that would make it unusable? Why do you think that? It's designed to perform well. However what I have used (in fact just put live into production recently) is MySQL on EC2 using two micro instances in a Master-Slave setup. Arguably this will work fine for small to medium sized sites which run less complex queries. So far it is working a treat for a site that pushes around 2,000 daily sessions and a few thousand inserts (mainly logging) and a few simple CRUD queries. My setup is as follows: - 2 EC2 micro instances running Ubuntu 10.10 and MySQL 5.1 - One MySQL instance configured as master, the other as slave. CF talks to the master. This allows me to dump the slave daily without table locks on the master database. - MySQL dumps daily to S3 using s3fs (allows you to mount an S3 bucket as a filesystem) - slave talks to master on the EC2 private IP - if my master was to go down for any reason I could switch the elastic IP over to the slave and resume very quickly that way. With EC2 this can also be automated I'm by no means an EC2 expert but have spent the last two weeks experimenting a lot with the platform. The more I learn about it the better it gets. One thing that I have not yet figured out is how to work around the one-IP-per-instance limit - I need two services on port 80 (FMS and Apache) on another instance but this does not seem possible at this time... :-/ Regards, Stefan On 18 Feb 2011, at 04:57, Chris . wrote: > > Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept > from what I'm reading at least, sounds great. > > I currently use shared hosting with CF and MySQL. I'm pouring over the > documentation but most of it is over my head as I'm not familiar with Amazon > web services and/or MySQL server administration. > > From what I'm getting though, I can create the MySQL database there, import > data into it, and then connect to it from the CF server during CFQUERY calls. > > Has anyone looked into this or tried something like this? I'm skeptical and > imagine there'd be overhead that would make it unusable but I'm not finding > anything to back that up.. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
