RE: Stored procedures on Apache Geode.
efault-server --log-level=config *--locators=localhost[10334]* Now, I connect... gfsh>connect Connecting to Locator at [host=localhost, port=10334] .. Connecting to Manager at [host=10.99.199.5, port=1099] .. Successfully connected to: [host=10.99.199.5, port=1099] And `list members`... gfsh>list members Name| Id -- | -- *AnnotationConfiguredGeodeServerApplication* | 10.99.199.5(AnnotationConfiguredGeodeServerApplication:57663):1024 *ServerA*| 10.99.199.5(ServerA:57704):1025 *ServerB*| 10.99.199.5(ServerB:57711):1026 As some people seem to think "MAGIC", ;-) After I am connected in *Gfsh* (to the AnnotationConfiguredGeodeServerApplication application), I can even start another Geode Server and it will connect *without* me having to explicitly specify the --locators option to `start server` now, because *Gfsh* is connect to the DS (cluster) defined by my AnnotationConfiguredGeodeServerApplication application... gfsh>start server --name=*ServerC* --disable-default-server --log-level=config gfsh>list members Name| Id -- | -- *AnnotationConfiguredGeodeServerApplication* | 10.99.199.5(AnnotationConfiguredGeodeServerApplication:57663):1024 *ServerA*| 10.99.199.5(ServerA:57704):1025 *ServerB*| 10.99.199.5(ServerB:57711):1026 *ServerC*| 10.99.199.5(ServerC:57759):1027 Anyway, there are many ways to go about it. Technically, we are just scratching the surface of what the new SDG Annotation based configuration model can do. There are many more powerful annotations available that do so much more. They all greatly simplify the *getting started* experience and *get users up and running* as *easily* and *quickly* as possible, with the minimal fuss, as in, no need to go into *Gfsh* to do menial tasks (e.g. create Regions, Indexes, etc) anymore, yuck! Although, keep in mind, the Annotations are not a replacement for *Gfsh* where advance UC are concerned. However, a developer should not have to leave his/her IDE (and use a shell too) to quickly prototype his/her application. Anyway, I will be planning a series of blog posts and webinars soon to showcase these new capabilities. Stay tuned! -j On Wed, Aug 2, 2017 at 1:17 PM, marios390 <[hidden email]> wrote: > Hi John, > > Thanks for providing these details. I am gonna update clone and verify. > I am also have another question for you. I noticed that while executing > "list members" only application listed as member. Locators and servers > are not supposed to be listed as well? > > Thanks > Marios > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Wednesday, August 02, 2017 10:48 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Hi Marios- > > That is strange. Seems your problem is this... > > Failed to instantiate [org.springframework.data.gemfire.CacheFactoryBean]: > Factory method 'gemfireCache' threw exception; nested exception is > *java.lang.NoSuchMethodError*: *org.springframework.data.* > *gemfire.util.CollectionUtils.nullSafeList(Ljava/util/List;) > Ljava/util/List;* > > However, I just ran the example it it started up fine for me (from my > IDE) > > . ___ _ _ > /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ > ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ > \\/ ___)| |_)| | | | | || (_| | ) ) ) ) > ' || .__|_| |_|_| |_\__, | / / / / > =|_|==|___/=/_/_/_/ > :: Spring Boot :: (v2.0.0.M3) > > [info 2017/08/02 12:29:32.694 PDT tid=0x1] Starting > AnnotationConfiguredGeodeServerApplication on jblum-mbpro-2.local with PID > 57158 > (/Users/jblum/pivdev/spring-data-examples-workspace/contacts-application- > workspace/configuration-example/target/classes > started by jblum in > /Users/jblum/pivdev/spring-data-examples-workspace/contacts-application- > workspace/configuration-example/target) > > [info 2017/08/02 12:29:32.695 PDT tid=0x1] No active profile set, > falling back to default profiles: default > > [info 2017/08/02 12:29:32.741 PDT tid=0x1] Refreshing > org.springframework.context.annotation.AnnotationConfigApplicationCon > text@1e81f160: > startup date [Wed Aug 02 12:29:32 PDT 2017]; root of context hierarchy > > ... > > Build-Date: 2017-
RE: Stored procedures on Apache Geode.
-- *AnnotationConfiguredGeodeServerApplication* | 10.99.199.5(AnnotationConfiguredGeodeServerApplication:57663):1024 *ServerA*| 10.99.199.5(ServerA:57704):1025 *ServerB*| 10.99.199.5(ServerB:57711):1026 As some people seem to think "MAGIC", ;-) After I am connected in *Gfsh* (to the AnnotationConfiguredGeodeServerApplication application), I can even start another Geode Server and it will connect *without* me having to explicitly specify the --locators option to `start server` now, because *Gfsh* is connect to the DS (cluster) defined by my AnnotationConfiguredGeodeServerApplication application... gfsh>start server --name=*ServerC* --disable-default-server --log-level=config gfsh>list members Name| Id -- | -- *AnnotationConfiguredGeodeServerApplication* | 10.99.199.5(AnnotationConfiguredGeodeServerApplication:57663):1024 *ServerA*| 10.99.199.5(ServerA:57704):1025 *ServerB*| 10.99.199.5(ServerB:57711):1026 *ServerC*| 10.99.199.5(ServerC:57759):1027 Anyway, there are many ways to go about it. Technically, we are just scratching the surface of what the new SDG Annotation based configuration model can do. There are many more powerful annotations available that do so much more. They all greatly simplify the *getting started* experience and *get users up and running* as *easily* and *quickly* as possible, with the minimal fuss, as in, no need to go into *Gfsh* to do menial tasks (e.g. create Regions, Indexes, etc) anymore, yuck! Although, keep in mind, the Annotations are not a replacement for *Gfsh* where advance UC are concerned. However, a developer should not have to leave his/her IDE (and use a shell too) to quickly prototype his/her application. Anyway, I will be planning a series of blog posts and webinars soon to showcase these new capabilities. Stay tuned! -j On Wed, Aug 2, 2017 at 1:17 PM, marios390 <[hidden email]> wrote: > Hi John, > > Thanks for providing these details. I am gonna update clone and verify. > I am also have another question for you. I noticed that while executing > "list members" only application listed as member. Locators and servers > are not supposed to be listed as well? > > Thanks > Marios > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Wednesday, August 02, 2017 10:48 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Hi Marios- > > That is strange. Seems your problem is this... > > Failed to instantiate [org.springframework.data.gemfire.CacheFactoryBean]: > Factory method 'gemfireCache' threw exception; nested exception is > *java.lang.NoSuchMethodError*: *org.springframework.data.* > *gemfire.util.CollectionUtils.nullSafeList(Ljava/util/List;) > Ljava/util/List;* > > However, I just ran the example it it started up fine for me (from my > IDE) > > . ___ _ _ > /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ > ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ > \\/ ___)| |_)| | | | | || (_| | ) ) ) ) > ' || .__|_| |_|_| |_\__, | / / / / > =|_|==|___/=/_/_/_/ > :: Spring Boot :: (v2.0.0.M3) > > [info 2017/08/02 12:29:32.694 PDT tid=0x1] Starting > AnnotationConfiguredGeodeServerApplication on jblum-mbpro-2.local with PID > 57158 > (/Users/jblum/pivdev/spring-data-examples-workspace/contacts-application- > workspace/configuration-example/target/classes > started by jblum in > /Users/jblum/pivdev/spring-data-examples-workspace/contacts-application- > workspace/configuration-example/target) > > [info 2017/08/02 12:29:32.695 PDT tid=0x1] No active profile set, > falling back to default profiles: default > > [info 2017/08/02 12:29:32.741 PDT tid=0x1] Refreshing > org.springframework.context.annotation.AnnotationConfigApplicationCon > text@1e81f160: > startup date [Wed Aug 02 12:29:32 PDT 2017]; root of context hierarchy > > ... > > Build-Date: 2017-07-12 07:18:53 -0700 > Build-Id: abaker 0 > Build-Java-Version: 1.8.0_121 > Build-Platform: Mac OS X 10.12.3 x86_64 > Product-Name: Apache Geode > Product-Version: 1.2.0 > Source-Date: 2017-07-11 09:31:40 -0700 > Source-Repository: release/1.2.0 > Source-Revision: 964f2749065ce9c6898fd27983b43f1bd9fc77d0 > Native version: native code unavailable > > ... > > [info 2017/08/02 12:29:35.236 PDT tid=0x1] Ca
RE: Stored procedures on Apache Geode.
Hi John, Thanks for providing these details. I am gonna update clone and verify. I am also have another question for you. I noticed that while executing "list members" only application listed as member. Locators and servers are not supposed to be listed as well? Thanks Marios From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n2493...@n6.nabble.com] Sent: Wednesday, August 02, 2017 10:48 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Hi Marios- That is strange. Seems your problem is this... Failed to instantiate [org.springframework.data.gemfire.CacheFactoryBean]: Factory method 'gemfireCache' threw exception; nested exception is *java.lang.NoSuchMethodError*: *org.springframework.data.* *gemfire.util.CollectionUtils.nullSafeList(Ljava/util/List;)Ljava/util/List;* However, I just ran the example it it started up fine for me (from my IDE) . ___ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' || .__|_| |_|_| |_\__, | / / / / =|_|==|___/=/_/_/_/ :: Spring Boot :: (v2.0.0.M3) [info 2017/08/02 12:29:32.694 PDT tid=0x1] Starting AnnotationConfiguredGeodeServerApplication on jblum-mbpro-2.local with PID 57158 (/Users/jblum/pivdev/spring-data-examples-workspace/contacts-application-workspace/configuration-example/target/classes started by jblum in /Users/jblum/pivdev/spring-data-examples-workspace/contacts-application-workspace/configuration-example/target) [info 2017/08/02 12:29:32.695 PDT tid=0x1] No active profile set, falling back to default profiles: default [info 2017/08/02 12:29:32.741 PDT tid=0x1] Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@1e81f160: startup date [Wed Aug 02 12:29:32 PDT 2017]; root of context hierarchy ... Build-Date: 2017-07-12 07:18:53 -0700 Build-Id: abaker 0 Build-Java-Version: 1.8.0_121 Build-Platform: Mac OS X 10.12.3 x86_64 Product-Name: Apache Geode Product-Version: 1.2.0 Source-Date: 2017-07-11 09:31:40 -0700 Source-Repository: release/1.2.0 Source-Revision: 964f2749065ce9c6898fd27983b43f1bd9fc77d0 Native version: native code unavailable ... [info 2017/08/02 12:29:35.236 PDT tid=0x1] CacheServer Configuration: port=12480 max-connections=800 max-threads=0 notify-by-subscription=true socket-buffer-size=32768 maximum-time-between-pings=6 maximum-message-count=23 message-time-to-live=180 eviction-policy=none capacity=1 overflow directory=. groups=[] loadProbe=ConnectionCountProbe loadPollInterval=5000 tcpNoDelay=true [info 2017/08/02 12:29:35.238 PDT tid=0x1] Cache server connection listener bound to address 0.0.0.0/0.0.0.0:40404 with backlog 1,000. [info 2017/08/02 12:29:35.239 PDT tid=0x1] CacheServer Configuration: port=40404 max-connections=800 max-threads=0 notify-by-subscription=true socket-buffer-size=32768 maximum-time-between-pings=6 maximum-message-count=23 message-time-to-live=180 eviction-policy=none capacity=1 overflow directory=. groups=[] loadProbe=ConnectionCountProbe loadPollInterval=5000 tcpNoDelay=true [info 2017/08/02 12:29:35.250 PDT tid=0x1] Started AnnotationConfiguredGeodeServerApplication in 2.83 seconds (JVM running for 4.218) ... Indeed, I am also able to connect to this *Spring* configure Geode server in *Gfsh*... jblum-mbpro-2:lab jblum$ gfsh _ __ / _/ __/ __/ // / / / __/ /___ /_ / _ / / /__/ / / _/ / // / /__/_/ /__/_//_/1.2.0 Monitor and Manage Apache Geode gfsh>connect Connecting to Locator at [host=localhost, port=10334] .. Connecting to Manager at [host=10.99.199.5, port=1099] .. Successfully connected to: [host=10.99.199.5, port=1099] gfsh>list members Name| Id -- | -- AnnotationConfiguredGeodeServerApplication | 10.99.199.5(AnnotationConfiguredGeodeServerApplication:57158):1024 I have updated the dependencies recently and I just checked in a change to the parent pom and configuration-example pom to base the examples on Apache Geode (rather than Pivotal GemFire). Can you please update your clone and verify again. Thanks, John On Wed, Aug 2, 2017 at 12:20 PM, marios390 <[hidden email] > wrote: > Hi John, > > Thanks a lot for getting back to me. This is the example am trying , > > > https://github.com/jxblum/contacts-application/blob/ > master/configuration-example/src/main/java/example/app/ > spring/annotation/geode/server/AnnotationConfiguredGeodeServe > rApplication.java > > Please find below the output along with errors: > > >
RE: Stored procedures on Apache Geode.
uchMethodError: org.springframework.data.gemfire.util.CollectionUtils.nullSafeList(Ljava/util/List;)Ljava/util/List; at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE] at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE] ... 31 common frames omitted Caused by: java.lang.NoSuchMethodError: org.springframework.data.gemfire.util.CollectionUtils.nullSafeList(Ljava/util/List;)Ljava/util/List; at org.springframework.data.gemfire.config.annotation.AbstractCacheConfiguration.jndiDataSources(AbstractCacheConfiguration.java:684) ~[spring-data-gemfire-1.9.6.RELEASE.jar:na] at org.springframework.data.gemfire.config.annotation.AbstractCacheConfiguration.setCommonCacheConfiguration(AbstractCacheConfiguration.java:602) ~[spring-data-gemfire-1.9.6.RELEASE.jar:na] at org.springframework.data.gemfire.config.annotation.AbstractCacheConfiguration.constructCacheFactoryBean(AbstractCacheConfiguration.java:567) ~[spring-data-gemfire-1.9.6.RELEASE.jar:na] at org.springframework.data.gemfire.config.annotation.PeerCacheConfiguration.gemfireCache(PeerCacheConfiguration.java:57) ~[spring-data-gemfire-1.9.6.RELEASE.jar:na] at org.springframework.data.gemfire.config.annotation.CacheServerConfiguration$$EnhancerBySpringCGLIB$$5807f1bc.CGLIB$gemfireCache$42() ~[spring-data-gemfire-1.9.6.RELEASE.jar:na] at org.springframework.data.gemfire.config.annotation.CacheServerConfiguration$$EnhancerBySpringCGLIB$$5807f1bc$$FastClassBySpringCGLIB$$29225ea5.invoke() ~[spring-data-gemfire-1.9.6.RELEASE.jar:na] at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) ~[spring-core-4.3.10.RELEASE.jar:4.3.10.RELEASE] at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:358) ~[spring-context-4.3.10.RELEASE.jar:4.3.10.RELEASE] at org.springframework.data.gemfire.config.annotation.CacheServerConfiguration$$EnhancerBySpringCGLIB$$5807f1bc.gemfireCache() ~[spring-data-gemfire-1.9.6.RELEASE.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_131] at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE] ... 32 common frames omitted From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n24899...@n6.nabble.com] Sent: Wednesday, August 02, 2017 6:20 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Hi Marios- To which example are you referring and what is the error you are getting? Also, if you could please share a small snippet of code showing how you used the annotations, that would be helpful. The new Annotation based configuration (beginning with 1 of... @ClientCacheApplication, @PeerCacheApplication or @CacheServerApplication) *applies to both GemFire and Geode*. @ClientCacheApplication is probably going to be the most widely used annotation while the later 2 are used to embed either a GemFire/Geode data node in your application or just configure 1. Finally, while I am still in the process of building examples/documentation for the new Annotations, there are plenty of tests in the SDG test suite showing them in action and how they work... https://github.com/spring-projects/spring-data-geode/tree/master/src/test/java/org/springframework/data/gemfire/config/annotation Regards, -j On Wed, Aug 2, 2017 at 8:04 AM, marios390 <[hidden email]> wrote: > Hi John, > > I am following you example for setting up geode cluster using annotation > but getting > a few errors. Do these annotations apply only for gemfire? > > Thanks > Marios > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Wednesday, July 19, 2017 6:13 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Hi Marios- > > Regarding... > > *> Do you think this indeed will have a huge impact on the performance?* > > There are many factors that affect performance. A few things to consider > might be... > > 1. How well you planned and organized the data (e.g. partitioning strategy, > possible collocation). > 2. How large are the data entries. > 3. What type of queries you may be performing (which might be an important > factor in collocation, with the ability to run queries local to the node).
RE: Stored procedures on Apache Geode.
Hi John, I am following you example for setting up geode cluster using annotation but getting a few errors. Do these annotations apply only for gemfire? Thanks Marios From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n2447...@n6.nabble.com] Sent: Wednesday, July 19, 2017 6:13 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Hi Marios- Regarding... *> Do you think this indeed will have a huge impact on the performance?* There are many factors that affect performance. A few things to consider might be... 1. How well you planned and organized the data (e.g. partitioning strategy, possible collocation). 2. How large are the data entries. 3. What type of queries you may be performing (which might be an important factor in collocation, with the ability to run queries local to the node). 4. What data management policies are in effect (e.g. eviction, expiration). 5. What the logic in your SPs are doing and how effectively they can be parallelized. 6. etc. *> Is there any best practises for doing this or any demo you could provide demonstrating this process?(SP to geode/gemfire functions)* I know of customers who have migrated or are migrating from a RDBMS to an IMDG like Geode/GemFire, but I do not know the results of their work. I am in R&D and not regularly exposed to that type of information. Others on this list might have better information for you. Regards, John On Tue, Jul 18, 2017 at 10:59 PM, marios390 < [hidden email]> wrote: > Hi John, > > As mentioned the other day, we are interested in lift all the stored > procedures up into the > cluster.Do > you think this indeed will have a huge impact on the > performance? Is there any best practises for doing this or any demo you > could provide demonstrating this process?(SP to geode/gemfire functions) > I would really appreciate it if you could provide any material related to > this. > > Thanks > Marios > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Friday, July 14, 2017 6:35 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Hi Marios- > > I may not be the best person to answer this. There is a Pivotal GemFire / > Greenplum Connector available for download here... > > https://network.pivotal.io/products/pivotal-gemfire/#/ > releases/5376/file_groups/495 smbkFovlp6IgDkajN0nKt4CrX58E5K46E5Gas7UCAFodHRwOi8vc2Nhbm1ha > WwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9MS1UbzJSR211OUx2TE > NHdk1HTXFNMXliTUZtU0xZV293d2dsYWNUMHJBJnU9aHR0cHMlM2ElMmYlMm > ZuZXR3b3JrJTJlcGl2b3RhbCUyZWlvJTJmcHJvZHVjdHMlMmZwaXZvdGFsLW > dlbWZpcmUlMmYlMjMlMmZyZWxlYXNlcyUyZjUzNzYlMmZmaWxlJTVmZ3JvdXBzJTJmNDk1> > > More information on the Connector can be found here... > > http://ggc.docs.pivotal.io/ggc/relnotes/release_notes30.html > 7o1EZnK4vhJL646E5Gas7UCAFodHRwOi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_ > Yz03NDIyJmQ9MS1UbzJSR211OUx2TENHdk1HTXFNMXliTUZtU0xZV293d3dq > T0pPbHJnJnU9aHR0cCUzYSUyZiUyZmdnYyUyZWRvY3MlMmVwaXZvdGFsJTJl > aW8lMmZnZ2MlMmZyZWxub3RlcyUyZnJlbGVhc2UlNWZub3RlczMwJTJlaHRtbA..> > > As you may know, Apache Geode is the open source core of Pivotal GemFire ( > https://pivotal.io/pivotal-gemfire avpjDplcz8GhyxNakFqKyxR0D7vFnF2EyHNgs3HhSye46E5Gas7UCAFodHRw > Oi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9MS1UbzJSR211OUx2TE > NHdk1HTXFNMXliTUZtU0xZV293d3R4Yk1DZ3JnJnU9aHR0cHMlM2ElMmYlMm > ZwaXZvdGFsJTJlaW8lMmZwaXZvdGFsLWdlbWZpcmU.>). Theoretically, it probably > would/should work to connect Geode with Greenplum, though I have not done > this and I am not sure it is a combination Pivotal nor the Apache Geode > community supports. > > There is example of using this Connector with Geode here... > > https://github.com/mgoddard-pivotal/FraudDetection-wwko mhVyYn6hNXwW9OLdPgBcsVH6ty0EvvNRtbL2w9DhzRm46E5Gas7UCAFodHRw > Oi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9MS1UbzJSR211OUx2TE > NHdk1HTXFNMXliTUZtU0xZV293dzBxUHBDa19nJnU9aHR0cHMlM2ElMmYlMm > ZnaXRodWIlMmVjb20lMmZtZ29kZGFyZC1waXZvdGFsJTJmRnJhdWREZXRlY3 > Rpb24td3drbw..> > > Which was the basis for this presentation/article... > > https://content.pivotal.io/blog/big-data-meets-fast-data- > to-fight-fraud-and-more FcCwMktO46E5Gas7UCAFodHRwOi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_ > Yz03NDIyJmQ9MS1UbzJSR211OUx2TENHdk1HTXFNMXliTUZtU0xZV293MXNt > T2NEem9nJnU9aHR0cHMlM2ElMmYlMmZjb250ZW50JTJlcGl2b3RhbCUyZWlv > JTJmYmxvZyUyZmJpZy1kYXRhLW1lZXRzLWZhc3QtZGF0YS10by1maWdodC1m > cmF1ZC1hbmQtbW9yZQ..> > > -j > > > > On Thu, Jul 13, 2017 at 11:33 PM, marios390 < > [hidden email]> wrote: > > > Hi John, > > > > Just a quick one, > > Geode could be integrated
RE: Stored procedures on Apache Geode.
Hi John, As mentioned the other day, we are interested in lift all the stored procedures up into the cluster.Do you think this indeed will have a huge impact on the performance? Is there any best practises for doing this or any demo you could provide demonstrating this process?(SP to geode/gemfire functions) I would really appreciate it if you could provide any material related to this. Thanks Marios From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n24351...@n6.nabble.com] Sent: Friday, July 14, 2017 6:35 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Hi Marios- I may not be the best person to answer this. There is a Pivotal GemFire / Greenplum Connector available for download here... https://network.pivotal.io/products/pivotal-gemfire/#/releases/5376/file_groups/495 More information on the Connector can be found here... http://ggc.docs.pivotal.io/ggc/relnotes/release_notes30.html As you may know, Apache Geode is the open source core of Pivotal GemFire ( https://pivotal.io/pivotal-gemfire). Theoretically, it probably would/should work to connect Geode with Greenplum, though I have not done this and I am not sure it is a combination Pivotal nor the Apache Geode community supports. There is example of using this Connector with Geode here... https://github.com/mgoddard-pivotal/FraudDetection-wwko Which was the basis for this presentation/article... https://content.pivotal.io/blog/big-data-meets-fast-data-to-fight-fraud-and-more -j On Thu, Jul 13, 2017 at 11:33 PM, marios390 < [hidden email]> wrote: > Hi John, > > Just a quick one, > Geode could be integrated with green plum and if not what alternatives for > this. > > Thanks > Ms > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Thursday, July 13, 2017 11:33 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Hi Marios- > > It seems you and your team could be / mostly are likely dealing with a > high-volume of sensitive information, but without knowing a lot about your > UC(s) or particular application requirements/SLAs, I would recommend > starting small, simple and scale based on need. > > Geode is a highly concurrent and distributed system with strong consistency > guarantees. Prematurely breaking the logic down into many individual > microservices early (especially for individual Stored Procedures... how > complex are these?) might unduly add complexity to your application and > system architecture. > > So my advice is to really evaluate the need to create individual > microservices first (which usually involves a platform like [Pivotal's] > CloudFoundry on an IaaS (or private infra) to manage effectively) vs. > starting small and just converting the Stored Procs into Geode Functions. > > Geode Function executions can be distributed across the cluster (similarly > to Map-Reduce, but far more robust) in a highly available and reliable > fashion. > > You might want to also read up on Geode's Partitioned Regions [1] for > effectively managing (partitioning and distributing/arranging your data). > > Hope this helps. > > -John > > [1] > http://gemfire90.docs.pivotal.io/geode/developing/ > partitioned_regions/chapter_overview.html yrjldnY3TtixZu9rDvLgvAx0M0bPn0iR_AzXTlMikrJPQ7v4gcrUCAFodHRwOi8 > vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9aXRubjJWd0otbE1xQm > NKbU01T3Q1RU1ZSHRrUWgyc1E4Q08zemVsZjZnJnU9aHR0cCUzYSUyZiUyZm > dlbWZpcmU5MCUyZWRvY3MlMmVwaXZvdGFsJTJlaW8lMmZnZW9kZSUyZmRldm > Vsb3BpbmclMmZwYXJ0aXRpb25lZCU1ZnJlZ2lvbnMlMmZjaGFwdGVyJTVmb3 > ZlcnZpZXclMmVodG1s> > > > On Thu, Jul 13, 2017 at 1:09 PM, marios390 <[hidden > email] > > wrote: > > > > > > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > > [hidden email]] > > Sent: Thursday, July 13, 2017 9:16 PM > > To: Marios Sofocleous/IT/CREDITSAFE > > Subject: Re: Stored procedures on Apache Geode. > > > > Right. > > > > You can also review the Apache Geode documentation on Function Execution > > [1]. And if you are a *Spring* user, you can use *Spring Data Geode's* > > convenient Function annotation support for both Function implementation > as > > well as execution, here [2]. > > > > NOTE: you will probably notice the link [2] refers to *Spring Data > > GemFire's* docs. *Spring Data GemFire* and *Spring Data Geode* are > > virtually the same with no differences. Eventually *Spring Data Geode* > > will have its own home with its own doc locations
RE: Stored procedures on Apache Geode.
Thanks Micheal From: Michael Stolz [via Apache Geode (Incubating) Developers Forum] [ml+s70738n24402...@n6.nabble.com] Sent: Saturday, July 15, 2017 12:37 AM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Pivotal provides a closed-source connector to link commercial GemFire to commercial Greenplum. Pivotal has no intention of opening that connector at this time. -- Mike Stolz Principal Engineer, GemFire Product Manager Mobile: +1-631-835-4771 On Fri, Jul 14, 2017 at 2:33 AM, marios390 <[hidden email] > wrote: > Hi John, > > Just a quick one, > Geode could be integrated with green plum and if not what alternatives for > this. > > Thanks > Ms > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Thursday, July 13, 2017 11:33 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Hi Marios- > > It seems you and your team could be / mostly are likely dealing with a > high-volume of sensitive information, but without knowing a lot about your > UC(s) or particular application requirements/SLAs, I would recommend > starting small, simple and scale based on need. > > Geode is a highly concurrent and distributed system with strong consistency > guarantees. Prematurely breaking the logic down into many individual > microservices early (especially for individual Stored Procedures... how > complex are these?) might unduly add complexity to your application and > system architecture. > > So my advice is to really evaluate the need to create individual > microservices first (which usually involves a platform like [Pivotal's] > CloudFoundry on an IaaS (or private infra) to manage effectively) vs. > starting small and just converting the Stored Procs into Geode Functions. > > Geode Function executions can be distributed across the cluster (similarly > to Map-Reduce, but far more robust) in a highly available and reliable > fashion. > > You might want to also read up on Geode's Partitioned Regions [1] for > effectively managing (partitioning and distributing/arranging your data). > > Hope this helps. > > -John > > [1] > http://gemfire90.docs.pivotal.io/geode/developing/ > partitioned_regions/chapter_overview.html yrjldnY3TtixZu9rDvLgvAx0M0bPn0iR_AzXTlMikrJPQ7v4gcrUCAFodHRwOi8 > vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9aXRubjJWd0otbE1xQm > NKbU01T3Q1RU1ZSHRrUWgyc1E4Q08zemVsZjZnJnU9aHR0cCUzYSUyZiUyZm > dlbWZpcmU5MCUyZWRvY3MlMmVwaXZvdGFsJTJlaW8lMmZnZW9kZSUyZmRldm > Vsb3BpbmclMmZwYXJ0aXRpb25lZCU1ZnJlZ2lvbnMlMmZjaGFwdGVyJTVmb3 > ZlcnZpZXclMmVodG1s> > > > On Thu, Jul 13, 2017 at 1:09 PM, marios390 <[hidden > email] > > wrote: > > > > > > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > > [hidden email]] > > Sent: Thursday, July 13, 2017 9:16 PM > > To: Marios Sofocleous/IT/CREDITSAFE > > Subject: Re: Stored procedures on Apache Geode. > > > > Right. > > > > You can also review the Apache Geode documentation on Function Execution > > [1]. And if you are a *Spring* user, you can use *Spring Data Geode's* > > convenient Function annotation support for both Function implementation > as > > well as execution, here [2]. > > > > NOTE: you will probably notice the link [2] refers to *Spring Data > > GemFire's* docs. *Spring Data GemFire* and *Spring Data Geode* are > > virtually the same with no differences. Eventually *Spring Data Geode* > > will have its own home with its own doc locations since it is finally > > becoming a top-level SD module [3]. > > > > -j > > > > [1] > > http://geode.apache.org/docs/guide/11/developing/function_< > redir.aspx?REF=9WC8AmXblm4Q_zDPwbP3MZWeTU5A8b8TcK6A7zAo07x > PQ7v4gcrUCAFodHRwOi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_ > Yz03NDIyJmQ9aXRubjJWd0otbE1xQmNKbU01T3Q1RU1ZSHRrUWgyc1E4QzIx > bWVsWTd3JnU9aHR0cCUzYSUyZiUyZmdlb2RlJTJlYXBhY2hlJTJlb3JnJTJm > ZG9jcyUyZmd1aWRlJTJmMTElMmZkZXZlbG9waW5nJTJmZnVuY3Rpb24lNWY.> > > exec/chapter_overview.html<http://scanmail.trustwave.com/?c=7422&d= > keRPQ7v4gcrUCAFodHRwOi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9> > > j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnKkha5eWJQ&u=http%3a%2f% > > 2fgeode%2eapache%2eorg%2fdocs%2fguide%2f11%2fdeveloping% > > 2ffunction%5fexec%2fchapter%5foverview%2ehtml> > > [2] > > http://docs.spring.io/spring-data-gemfire/docs/current/ FeI05aGSUMelSXs5C8eNCYF4w7WOQTrcPuikgbSqvPtPQ7v4gcrUCAFodHRw > Oi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9aXRubjJWd0o
RE: Stored procedures on Apache Geode.
Hi John, Thank you very much for all this information. I will check it out. Appreciate it!. Thanks MS From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n24351...@n6.nabble.com] Sent: Friday, July 14, 2017 6:35 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Hi Marios- I may not be the best person to answer this. There is a Pivotal GemFire / Greenplum Connector available for download here... https://network.pivotal.io/products/pivotal-gemfire/#/releases/5376/file_groups/495 More information on the Connector can be found here... http://ggc.docs.pivotal.io/ggc/relnotes/release_notes30.html As you may know, Apache Geode is the open source core of Pivotal GemFire ( https://pivotal.io/pivotal-gemfire). Theoretically, it probably would/should work to connect Geode with Greenplum, though I have not done this and I am not sure it is a combination Pivotal nor the Apache Geode community supports. There is example of using this Connector with Geode here... https://github.com/mgoddard-pivotal/FraudDetection-wwko Which was the basis for this presentation/article... https://content.pivotal.io/blog/big-data-meets-fast-data-to-fight-fraud-and-more -j On Thu, Jul 13, 2017 at 11:33 PM, marios390 < [hidden email]> wrote: > Hi John, > > Just a quick one, > Geode could be integrated with green plum and if not what alternatives for > this. > > Thanks > Ms > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Thursday, July 13, 2017 11:33 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Hi Marios- > > It seems you and your team could be / mostly are likely dealing with a > high-volume of sensitive information, but without knowing a lot about your > UC(s) or particular application requirements/SLAs, I would recommend > starting small, simple and scale based on need. > > Geode is a highly concurrent and distributed system with strong consistency > guarantees. Prematurely breaking the logic down into many individual > microservices early (especially for individual Stored Procedures... how > complex are these?) might unduly add complexity to your application and > system architecture. > > So my advice is to really evaluate the need to create individual > microservices first (which usually involves a platform like [Pivotal's] > CloudFoundry on an IaaS (or private infra) to manage effectively) vs. > starting small and just converting the Stored Procs into Geode Functions. > > Geode Function executions can be distributed across the cluster (similarly > to Map-Reduce, but far more robust) in a highly available and reliable > fashion. > > You might want to also read up on Geode's Partitioned Regions [1] for > effectively managing (partitioning and distributing/arranging your data). > > Hope this helps. > > -John > > [1] > http://gemfire90.docs.pivotal.io/geode/developing/ > partitioned_regions/chapter_overview.html yrjldnY3TtixZu9rDvLgvAx0M0bPn0iR_AzXTlMikrJPQ7v4gcrUCAFodHRwOi8 > vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_Yz03NDIyJmQ9aXRubjJWd0otbE1xQm > NKbU01T3Q1RU1ZSHRrUWgyc1E4Q08zemVsZjZnJnU9aHR0cCUzYSUyZiUyZm > dlbWZpcmU5MCUyZWRvY3MlMmVwaXZvdGFsJTJlaW8lMmZnZW9kZSUyZmRldm > Vsb3BpbmclMmZwYXJ0aXRpb25lZCU1ZnJlZ2lvbnMlMmZjaGFwdGVyJTVmb3 > ZlcnZpZXclMmVodG1s> > > > On Thu, Jul 13, 2017 at 1:09 PM, marios390 <[hidden > email] > > wrote: > > > > > > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > > [hidden email]] > > Sent: Thursday, July 13, 2017 9:16 PM > > To: Marios Sofocleous/IT/CREDITSAFE > > Subject: Re: Stored procedures on Apache Geode. > > > > Right. > > > > You can also review the Apache Geode documentation on Function Execution > > [1]. And if you are a *Spring* user, you can use *Spring Data Geode's* > > convenient Function annotation support for both Function implementation > as > > well as execution, here [2]. > > > > NOTE: you will probably notice the link [2] refers to *Spring Data > > GemFire's* docs. *Spring Data GemFire* and *Spring Data Geode* are > > virtually the same with no differences. Eventually *Spring Data Geode* > > will have its own home with its own doc locations since it is finally > > becoming a top-level SD module [3]. > > > > -j > > > > [1] > > http://geode.apache.org/docs/guide/11/developing/function_< > redir.aspx?REF=9WC8AmXblm4Q_zDPwbP3MZWeTU5A8b8TcK6A7zAo07x > PQ7v4gcrUCAFodHRwOi8vc2Nhbm1haWwudHJ1c3R3YXZlLmNvbS8_ > Yz03NDIyJmQ9aXRubj
RE: Stored procedures on Apache Geode.
Hi John, Just a quick one, Geode could be integrated with green plum and if not what alternatives for this. Thanks Ms From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n24325...@n6.nabble.com] Sent: Thursday, July 13, 2017 11:33 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Hi Marios- It seems you and your team could be / mostly are likely dealing with a high-volume of sensitive information, but without knowing a lot about your UC(s) or particular application requirements/SLAs, I would recommend starting small, simple and scale based on need. Geode is a highly concurrent and distributed system with strong consistency guarantees. Prematurely breaking the logic down into many individual microservices early (especially for individual Stored Procedures... how complex are these?) might unduly add complexity to your application and system architecture. So my advice is to really evaluate the need to create individual microservices first (which usually involves a platform like [Pivotal's] CloudFoundry on an IaaS (or private infra) to manage effectively) vs. starting small and just converting the Stored Procs into Geode Functions. Geode Function executions can be distributed across the cluster (similarly to Map-Reduce, but far more robust) in a highly available and reliable fashion. You might want to also read up on Geode's Partitioned Regions [1] for effectively managing (partitioning and distributing/arranging your data). Hope this helps. -John [1] http://gemfire90.docs.pivotal.io/geode/developing/partitioned_regions/chapter_overview.html On Thu, Jul 13, 2017 at 1:09 PM, marios390 <[hidden email] > wrote: > > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Thursday, July 13, 2017 9:16 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Right. > > You can also review the Apache Geode documentation on Function Execution > [1]. And if you are a *Spring* user, you can use *Spring Data Geode's* > convenient Function annotation support for both Function implementation as > well as execution, here [2]. > > NOTE: you will probably notice the link [2] refers to *Spring Data > GemFire's* docs. *Spring Data GemFire* and *Spring Data Geode* are > virtually the same with no differences. Eventually *Spring Data Geode* > will have its own home with its own doc locations since it is finally > becoming a top-level SD module [3]. > > -j > > [1] > http://geode.apache.org/docs/guide/11/developing/function_ > exec/chapter_overview.html<http://scanmail.trustwave.com/?c=7422&d= > j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnKkha5eWJQ&u=http%3a%2f% > 2fgeode%2eapache%2eorg%2fdocs%2fguide%2f11%2fdeveloping% > 2ffunction%5fexec%2fchapter%5foverview%2ehtml> > [2] > http://docs.spring.io/spring-data-gemfire/docs/current/ > reference/html/#function-annotations<http://scanmail. > trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqf > FPnPsrbJ3BIQ&u=http%3a%2f%2fdocs%2espring%2eio%2fspring- > data-gemfire%2fdocs%2fcurrent%2freference%2fhtml%2f%23function-annotations > > > [3] > http://projects.spring.io/spring-data/<http://scanmail. > trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqf > FPnPshbJGVdw&u=http%3a%2f%2fprojects%2espring%2eio%2fspring-data%2f> > > > On Thu, Jul 13, 2017 at 6:04 AM, Anthony Baker <[hidden > email]> wrote: > > > A geode Function is conceptually similar to a stored proc but the > > implementation is different. It's a java class that would use geode apis > to > > execute logic within the cluster. > > > > Anthony > > > > > On Jul 12, 2017, at 11:13 PM, marios390 > com> wrote: > > > > > > Hi, > > > > > > I noticed that Apache Geode supports stored procedures as functions > > running > > > on nodes. > > > Could you please elaborate on that since I am confused a little a bit. > > > Can I run for example Oracle SP directly on cache servers (nodes) or > do I > > > have to transform them somehow into microservices ( i.e spring boot) > > which > > > expose functions on nodes. > > > > > > > > > > > > -- > > > View this message in context: > > > http://apache-geode- > > incubating-developers-forum.70738.x6.nabble.com/Stored- > tp://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqf > FPnPUhb5PCJw&u=http%3a%2f%2fincubating-developers-forum% > 2e70738%2ex6%2enabble%2ecom%2fStored-> > > procedures-on-Apache-Geode-tp24279.html > &g
RE: Stored procedures on Apache Geode.
Hi John, Thank you so much for your advise. I will go through the links you provided and get back to you if I have a question. I really appreciate it! Marios From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n24325...@n6.nabble.com] Sent: Thursday, July 13, 2017 11:33 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Hi Marios- It seems you and your team could be / mostly are likely dealing with a high-volume of sensitive information, but without knowing a lot about your UC(s) or particular application requirements/SLAs, I would recommend starting small, simple and scale based on need. Geode is a highly concurrent and distributed system with strong consistency guarantees. Prematurely breaking the logic down into many individual microservices early (especially for individual Stored Procedures... how complex are these?) might unduly add complexity to your application and system architecture. So my advice is to really evaluate the need to create individual microservices first (which usually involves a platform like [Pivotal's] CloudFoundry on an IaaS (or private infra) to manage effectively) vs. starting small and just converting the Stored Procs into Geode Functions. Geode Function executions can be distributed across the cluster (similarly to Map-Reduce, but far more robust) in a highly available and reliable fashion. You might want to also read up on Geode's Partitioned Regions [1] for effectively managing (partitioning and distributing/arranging your data). Hope this helps. -John [1] http://gemfire90.docs.pivotal.io/geode/developing/partitioned_regions/chapter_overview.html On Thu, Jul 13, 2017 at 1:09 PM, marios390 <[hidden email] > wrote: > > > From: John Blum [via Apache Geode (Incubating) Developers Forum] [ > [hidden email]] > Sent: Thursday, July 13, 2017 9:16 PM > To: Marios Sofocleous/IT/CREDITSAFE > Subject: Re: Stored procedures on Apache Geode. > > Right. > > You can also review the Apache Geode documentation on Function Execution > [1]. And if you are a *Spring* user, you can use *Spring Data Geode's* > convenient Function annotation support for both Function implementation as > well as execution, here [2]. > > NOTE: you will probably notice the link [2] refers to *Spring Data > GemFire's* docs. *Spring Data GemFire* and *Spring Data Geode* are > virtually the same with no differences. Eventually *Spring Data Geode* > will have its own home with its own doc locations since it is finally > becoming a top-level SD module [3]. > > -j > > [1] > http://geode.apache.org/docs/guide/11/developing/function_ > exec/chapter_overview.html<http://scanmail.trustwave.com/?c=7422&d= > j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnKkha5eWJQ&u=http%3a%2f% > 2fgeode%2eapache%2eorg%2fdocs%2fguide%2f11%2fdeveloping% > 2ffunction%5fexec%2fchapter%5foverview%2ehtml> > [2] > http://docs.spring.io/spring-data-gemfire/docs/current/ > reference/html/#function-annotations<http://scanmail. > trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqf > FPnPsrbJ3BIQ&u=http%3a%2f%2fdocs%2espring%2eio%2fspring- > data-gemfire%2fdocs%2fcurrent%2freference%2fhtml%2f%23function-annotations > > > [3] > http://projects.spring.io/spring-data/<http://scanmail. > trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqf > FPnPshbJGVdw&u=http%3a%2f%2fprojects%2espring%2eio%2fspring-data%2f> > > > On Thu, Jul 13, 2017 at 6:04 AM, Anthony Baker <[hidden > email]> wrote: > > > A geode Function is conceptually similar to a stored proc but the > > implementation is different. It's a java class that would use geode apis > to > > execute logic within the cluster. > > > > Anthony > > > > > On Jul 12, 2017, at 11:13 PM, marios390 > com> wrote: > > > > > > Hi, > > > > > > I noticed that Apache Geode supports stored procedures as functions > > running > > > on nodes. > > > Could you please elaborate on that since I am confused a little a bit. > > > Can I run for example Oracle SP directly on cache servers (nodes) or > do I > > > have to transform them somehow into microservices ( i.e spring boot) > > which > > > expose functions on nodes. > > > > > > > > > > > > -- > > > View this message in context: > > > http://apache-geode- > > incubating-developers-forum.70738.x6.nabble.com/Stored- > tp://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqf > FPnPUhb5PCJw&u=http%3a%2f%2fincubating-developers-forum% > 2e70738%2ex6%2enabble%2ecom%2fStored-> > > procedure
RE: Stored procedures on Apache Geode.
From: John Blum [via Apache Geode (Incubating) Developers Forum] [ml+s70738n24312...@n6.nabble.com] Sent: Thursday, July 13, 2017 9:16 PM To: Marios Sofocleous/IT/CREDITSAFE Subject: Re: Stored procedures on Apache Geode. Right. You can also review the Apache Geode documentation on Function Execution [1]. And if you are a *Spring* user, you can use *Spring Data Geode's* convenient Function annotation support for both Function implementation as well as execution, here [2]. NOTE: you will probably notice the link [2] refers to *Spring Data GemFire's* docs. *Spring Data GemFire* and *Spring Data Geode* are virtually the same with no differences. Eventually *Spring Data Geode* will have its own home with its own doc locations since it is finally becoming a top-level SD module [3]. -j [1] http://geode.apache.org/docs/guide/11/developing/function_exec/chapter_overview.html<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnKkha5eWJQ&u=http%3a%2f%2fgeode%2eapache%2eorg%2fdocs%2fguide%2f11%2fdeveloping%2ffunction%5fexec%2fchapter%5foverview%2ehtml> [2] http://docs.spring.io/spring-data-gemfire/docs/current/reference/html/#function-annotations<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnPsrbJ3BIQ&u=http%3a%2f%2fdocs%2espring%2eio%2fspring-data-gemfire%2fdocs%2fcurrent%2freference%2fhtml%2f%23function-annotations> [3] http://projects.spring.io/spring-data/<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnPshbJGVdw&u=http%3a%2f%2fprojects%2espring%2eio%2fspring-data%2f> On Thu, Jul 13, 2017 at 6:04 AM, Anthony Baker <[hidden email]> wrote: > A geode Function is conceptually similar to a stored proc but the > implementation is different. It's a java class that would use geode apis to > execute logic within the cluster. > > Anthony > > > On Jul 12, 2017, at 11:13 PM, marios390 com> wrote: > > > > Hi, > > > > I noticed that Apache Geode supports stored procedures as functions > running > > on nodes. > > Could you please elaborate on that since I am confused a little a bit. > > Can I run for example Oracle SP directly on cache servers (nodes) or do I > > have to transform them somehow into microservices ( i.e spring boot) > which > > expose functions on nodes. > > > > > > > > -- > > View this message in context: http://apache-geode- > incubating-developers-forum.70738.x6.nabble.com/Stored-<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnPUhb5PCJw&u=http%3a%2f%2fincubating-developers-forum%2e70738%2ex6%2enabble%2ecom%2fStored-> > procedures-on-Apache-Geode-tp24279.html > > Sent from the Apache Geode (Incubating) Developers Forum mailing list > archive at > Nabble.com.<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnPR_aZzGKg&u=http%3a%2f%2fNabble%2ecom> > Hi John I really appreciate it for getting back to me. I will check it out. We are basically having a bunch of stored procedures and thinking to create as many microservices as the SPs in order to load them in geode. I know that this makes nosense. How would you suggest resolving this? -- -John john.blum10101 (skype) If you reply to this email, your message will be added to the discussion below: http://apache-geode-incubating-developers-forum.70738.x6.nabble.com/Stored-procedures-on-Apache-Geode-tp24279p24312.html<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnPUub5LDIw&u=http%3a%2f%2fapache-geode-incubating-developers-forum%2e70738%2ex6%2enabble%2ecom%2fStored-procedures-on-Apache-Geode-tp24279p24312%2ehtml> To unsubscribe from Stored procedures on Apache Geode., click here<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnKwhaJ3DIA&u=http%3a%2f%2fapache-geode-incubating-developers-forum%2e70738%2ex6%2enabble%2ecom%2ftemplate%2fNamlServlet%2ejtp%3fmacro%3dunsubscribe%5fby%5fcode%26node%3d24279%26code%3dbWFyaW9zLnNvZm9jbGVvdXNAY3JlZGl0c2FmZS5jb218MjQyNzl8MTczMDMwODYwMA%3d%3d>. NAML<http://scanmail.trustwave.com/?c=7422&d=j7nn2bxZOwcngUOelB5ZmyW7oHpBqfFPnPggOJ3DJQ&u=http%3a%2f%2fapache-geode-incubating-developers-forum%2e70738%2ex6%2enabble%2ecom%2ftemplate%2fNamlServlet%2ejtp%3fmacro%3dmacro%5fviewer%26id%3dinstant%5fhtml%2521nabble%253Aemail%2enaml%26base%3dnabble%2enaml%2enamespaces%2eBasicNamespace-nabble%2eview%2eweb%2etemplate%2eNabbleNamespace-nabble%2eview%2eweb%2etemplate%2eNodeNamespace%26breadcrumbs%3dnotify%5fsubscribers%2521nabble%253Aemail%2enaml-instant%5femails%2521nabble%253Aemail%2enaml-send%5finstant%5femail%2521nabble%253Aemail%2enaml> Notes: Terms and Conditions: 'All quotes, offers, contracts and agreements
Stored procedures on Apache Geode.
Hi, I noticed that Apache Geode supports stored procedures as functions running on nodes. Could you please elaborate on that since I am confused a little a bit. Can I run for example Oracle SP directly on cache servers (nodes) or do I have to transform them somehow into microservices ( i.e spring boot) which expose functions on nodes. -- View this message in context: http://apache-geode-incubating-developers-forum.70738.x6.nabble.com/Stored-procedures-on-Apache-Geode-tp24279.html Sent from the Apache Geode (Incubating) Developers Forum mailing list archive at Nabble.com.
