move database with Java
Hey Guys, i know this is not necessarily a cf question. i know next to nothing about java, other then creating a scheduled job to copy a table. now my employer has tasked me with moving or backing up a MySQL DB from one server to another. to me this sounds crazy. but i am not supposed to use cf, or built in MySqlEnterprise tools. Have any of you guys done this with java before? are there any links/examples you could suggest. i don't think it can be done quickly, as in from midnight to 5am kinda thing. any help would be Massively appreciated! Thank you! ~m ~| 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:356802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: move database with Java
Super simple, as long as you don't try and reinvent the wheel (i.e. don't do it with CF). Use mysqldump to create a dump of the db, then put that file wherever you need it to be. There are a variety of data transfer options out there, but it'll depend upon your servers, etc. HTH On Tue, Sep 17, 2013 at 9:14 AM, morchella morchella.delici...@gmail.comwrote: Hey Guys, i know this is not necessarily a cf question. i know next to nothing about java, other then creating a scheduled job to copy a table. now my employer has tasked me with moving or backing up a MySQL DB from one server to another. to me this sounds crazy. but i am not supposed to use cf, or built in MySqlEnterprise tools. Have any of you guys done this with java before? are there any links/examples you could suggest. i don't think it can be done quickly, as in from midnight to 5am kinda thing. any help would be Massively appreciated! Thank you! ~m ~| 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:356803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Distributed Caching with TerraCotta
Ping... anybody? On Sun, Sep 15, 2013 at 12:32 AM, Rick Root rick.r...@gmail.com wrote: Hi, A little over a year ago, I went through a process setting up terracotta caching server for an application that is using cf clustering.. three instances of coldfusion powering the application, and I wanted to be able to efficiently cache data between instances. This worked really well, but now I'm more or less disassocaited with the company and they've asked me to set up TerraCotta again on their new server, which is running Coldfusion 10. Things are different, of course, but much the same Here's what I've done. I installed the latest version of TerraCotta open source (3.7.5) which comes with a newer version of ehcache. I copied all these jar files into each instances libf older and renamed any older versions with a .old extension ehcache-core-2.6.6.jar ehcache-terracotta-2.6.6.jar slf4j-api-1.6.1.jar slf4j-jdk14-1.6.1.jar slf4j-log4j12-1.6.1.jar terracotta-toolkit-1.6-runtime-5.5.0.jar Then modified the ehcache.xml as follows: I added this line above my defaultcache: terracottaConfig url=localhost:9510 rejoin=true / I added this section BELOW my defaultCache, which essentially adds a new cache region named distributedCache cache name=distributedCache maxElementsInMemory=1 eternal=false timeToIdleSeconds=86400 timeToLiveSeconds=86400 overflowToDisk=false diskSpoolBufferSizeMB=30 maxElementsOnDisk=1000 diskPersistent=false diskExpiryThreadIntervalSeconds=3600 memoryStoreEvictionPolicy=LRU clearOnFlush=true terracotta clustered=true nonstop immediateTimeout=true timeoutBehavior type=noop / /nonstop /terracotta /cache Now that I've done all this, I did some testing with a cf page that looks like this... if the request is made on instance 2, put something in the cache, then retrieve it and display it. If it's on another instance, just retrieve the value and display it. cache name=distributedCache maxElementsInMemory=1 eternal=false timeToIdleSeconds=86400 timeToLiveSeconds=86400 overflowToDisk=false diskSpoolBufferSizeMB=30 maxElementsOnDisk=1000 diskPersistent=false diskExpiryThreadIntervalSeconds=3600 memoryStoreEvictionPolicy=LRU clearOnFlush=true terracotta clustered=true nonstop immediateTimeout=true timeoutBehavior type=noop / /nonstop /terracotta /cache This doesn't fail, but it doesn't appear to be using the terracotta server, because the item is not available on the other instances. I don't know where to go from here. As always, your combined help is appreciated! Rick Root -- *The beatings will continue until morale improves.* ~| 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:356804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Distributed Caching with TerraCotta
Try contacting Rob Brooks-Bilson, he's the ehcache expert in CF http://rob.brooks-bilson.com/ (Also a super nice guy) =] On Tue, Sep 17, 2013 at 12:15 PM, Rick Root rick.r...@gmail.com wrote: Ping... anybody? On Sun, Sep 15, 2013 at 12:32 AM, Rick Root rick.r...@gmail.com wrote: Hi, A little over a year ago, I went through a process setting up terracotta caching server for an application that is using cf clustering.. three instances of coldfusion powering the application, and I wanted to be able to efficiently cache data between instances. This worked really well, but now I'm more or less disassocaited with the company and they've asked me to set up TerraCotta again on their new server, which is running Coldfusion 10. Things are different, of course, but much the same Here's what I've done. I installed the latest version of TerraCotta open source (3.7.5) which comes with a newer version of ehcache. I copied all these jar files into each instances libf older and renamed any older versions with a .old extension ehcache-core-2.6.6.jar ehcache-terracotta-2.6.6.jar slf4j-api-1.6.1.jar slf4j-jdk14-1.6.1.jar slf4j-log4j12-1.6.1.jar terracotta-toolkit-1.6-runtime-5.5.0.jar Then modified the ehcache.xml as follows: I added this line above my defaultcache: terracottaConfig url=localhost:9510 rejoin=true / I added this section BELOW my defaultCache, which essentially adds a new cache region named distributedCache cache name=distributedCache maxElementsInMemory=1 eternal=false timeToIdleSeconds=86400 timeToLiveSeconds=86400 overflowToDisk=false diskSpoolBufferSizeMB=30 maxElementsOnDisk=1000 diskPersistent=false diskExpiryThreadIntervalSeconds=3600 memoryStoreEvictionPolicy=LRU clearOnFlush=true terracotta clustered=true nonstop immediateTimeout=true timeoutBehavior type=noop / /nonstop /terracotta /cache Now that I've done all this, I did some testing with a cf page that looks like this... if the request is made on instance 2, put something in the cache, then retrieve it and display it. If it's on another instance, just retrieve the value and display it. cache name=distributedCache maxElementsInMemory=1 eternal=false timeToIdleSeconds=86400 timeToLiveSeconds=86400 overflowToDisk=false diskSpoolBufferSizeMB=30 maxElementsOnDisk=1000 diskPersistent=false diskExpiryThreadIntervalSeconds=3600 memoryStoreEvictionPolicy=LRU clearOnFlush=true terracotta clustered=true nonstop immediateTimeout=true timeoutBehavior type=noop / /nonstop /terracotta /cache This doesn't fail, but it doesn't appear to be using the terracotta server, because the item is not available on the other instances. I don't know where to go from here. As always, your combined help is appreciated! Rick Root -- *The beatings will continue until morale improves.* ~| 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:356805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF10 404 issues - a new kind of problem?
I've seen and dealt with plenty of CF10 404 issues since my install yesterday, but this appears to be a new one: This is my first CF10 installation. I am running with Update 11 in place. Win2k8 R2/64bit. 1. CF Admin's missing template handler residing in the cfusion wwwroot is nonfunctional. The site wide template handler in the same location works fine. 2. The err404.cfm 404 handler I have executing via IIS works, but get this... the url is supposed to be relative to *site* root, right? In IIS, on a site that is not the default web site, where CF is using its default web root location and IIS is using an entirely different one (nonstandard on a different folder tree) *the IIS 404 page is executing from the CF web root*. That shouldn't be possible. Took me hours to realize it was happening. I have ensured that I have unique filenames in place and can't see any reason why IIS - in this one case - treats the 'site root' as the default cf webroot location. Here is my missing template handler, kept simple: cfheader statuscode=404 statustext=Not Found h1404/h1pPage not found/p cfoutput#now()#/cfoutput There's more. The IIS missing template handler works fine for non-CF pages. For foo.htm I get display and 404 header as expected. For foo.CFM I get... nothing (with a 200 status code). I have IIS doing failed request traces and for foo.htm I get a failed url of http://[domain]:80/foo.htm but foo.cfm's request trace gives the failed url of http://[domain]:80/jakarta/isapi_redirect.dll Anyone? I have been all over stack overflow and it has helped me through other issues (adding /jakarta virtual directory etc.) but this has me stumped. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.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:356807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: move database with Java
Hmm... I think I would download a manager for mysql written in java (I seem to recall one on sourceforge) and just tell your boss - look, I'm using Java! -Mark -Original Message- From: morchella [mailto:morchella.delici...@gmail.com] Sent: Tuesday, September 17, 2013 8:14 AM To: cf-talk Subject: move database with Java Hey Guys, i know this is not necessarily a cf question. i know next to nothing about java, other then creating a scheduled job to copy a table. now my employer has tasked me with moving or backing up a MySQL DB from one server to another. to me this sounds crazy. but i am not supposed to use cf, or built in MySqlEnterprise tools. Have any of you guys done this with java before? are there any links/examples you could suggest. i don't think it can be done quickly, as in from midnight to 5am kinda thing. any help would be Massively appreciated! Thank you! ~m ~| 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:356806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Distributed Caching with TerraCotta
Hah, thanks yeah I already sent him email, no response yet, but he's offered input on my terra cotta issues in the past. On Tuesday, September 17, 2013, Alan Rother wrote: Try contacting Rob Brooks-Bilson, he's the ehcache expert in CF http://rob.brooks-bilson.com/ (Also a super nice guy) = -- *The beatings will continue until morale improves.* ~| 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:356808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFLDAP Fieldname Aliases?
Thanks Dave! This worked great. Dan On 9/16/2013 12:22 PM, Dave Watts wrote: Is there and equivalent to: select LName as Last_Name for CFLDAP? If not, what other workarounds are there to make those query results have the names you want rather than the fieldnames from the LDAP server? cflooping over a QueryNew? Seems onerous. Since CFLDAP returns a query object, you could use Query of Queries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:356809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
