Home > Blogs > VMware vFabric Blog > Tag Archives: JDBC

Tag Archives: JDBC

Scaling and Modernizing .NET and Java: SQLFire Performance Test Blows Away Traditional RDBMS

We all know the devil is in the details when it comes to technology.

Yet, our recent vFabric SQLFire performance test (a benchmark from vFabric SQLFire Best Practices Guide) is certainly worth review if you need to scale a Java app, .NET app, or other legacy data source.

If you don’t know what vFabric SQLFire is, it is basically what happens when Apache Derby gets married to vFabric GemFire:

  • Apache Derby is used for its RDBMS components, JDBC driver, query engine, and network server.
  • The partitioning technology of GemFire is used to implement horizontal partitioning features of vFabric SQLFire.
  • vFabric SQLFire specifically enhances the Apache Derby components, such as the query engine, the SQL interface, data persistence, and data eviction, as well as adding additional components like SQL commands, stored procedures, system tables, functions, persistence disk stores, listeners, and locators, to operate a highly distributed and fault tolerant data management cluster.

Continue reading

3 Signs Your Relational Database Must Go

Application and operations teams sometimes reach a point where they must upgrade the database. Whether it’s due to data growth, lack of throughput, too much downtime, the need to share data globally, adding ETLs, or otherwise, it’s never a small project. Since these projects are expensive, any recommendation requires a solid justification.  This article a) characterizes 3 signs where traditional databases hit a wall, b) explains how vFabric SQLFire provides an advantage over traditional databases in each case, and c) should help you make a case for moving towards an in-memory, distributed data grid based on SQL.

For those of us tasked with upgrading (or architecting) the data layer, we all go through similar steps. We build a project plan, make projections and sizing estimates, perform architecture and code reviews, create configuration checklists, provide hardware budgets and plans, talk to vendors about options, and more.  Then, we work to plan the deployment with the least downtime, procure hardware and software, test different data load times, evaluate project risks, develop back-up plans, prepare communications to users about downtime, etc. You know the drill. These projects can take months and consume a fair amount of internal resources or consulting dollars. If you are starting or working on one of these types of projects with a traditional database architecture in mind, are you considering these 3 signs as you consider your options? Continue reading

3 Key Stages to Evolve from Legacy Databases to a Modern Cloud Data Grid

How do you plan a roadmap for moving from a legacy data architecture to a cloud-enabled data grid? In this article, we will offer a pragmatic, three-stage approach. At SpringOne-2012, the “Effective design patterns with NewSQL” session (see presentation embedded below) generated a lot of interest. (Thank you to everyone who joined us!) Jags Ramnarayan and I discussed problems with legacy RDBMS systems, NewSQL driving principles, SQLFire architecture, application design patterns as well as data consistency and reliability.

We went deep into vFabric SQLFire which is a pragmatic solution that addresses these data challenges:

  • How do I architect my data tier for very high concurrent workloads?
  • How do I achieve predictability both for data access response time and availability?
  • How do I distribute data efficiently and real time to multiple data centers (and to external clouds)? 
  • How do I process these large quantities of data in an efficient manner to allow for better real-time decision-making? 

Continue reading

Understanding the Difference between Spring Insight Developer & Insight Operations

Every developer knows Byte Code Instrumentation (BCI) is useful. It automates how you instrument your code, and let’s you see exactly how data is being transferred and manipulated within your application. The level of detail is essential to writing and debugging good code.

The Spring Framework has its own BCI tool, called Spring Insight. It comes in two flavors: Spring Insight Developer Edition (Insight) and Spring Insight Operations (Insight Operations). It is also bundled with AppInsight as part of the vFabric Application Performance Suite, and currently only works on Java/Spring code, a fact that is open to change with the upcoming Split-Agent Architecture.

So what is the difference?

Continue reading

4 Ways VMware transforms Postgres for the Cloud

In a nutshell, relational databases weren’t built for the cloud. With vFabric Postgres, VMware customers can get a proven, enterprise database integrated with VMware virtualization and ready for cloud computing.

As announced earlier this week, vFabric Postgres (vPostgres) is now available within vFabric Suite 5.1 Advanced. With vPostgres, the well-respected, open-source database gains built in best practices, optimized configuration, and cloud-ready features.  While vFabric Postgres is synced up to PostgreSQL 9.1.3 minor release and includes all the new features of this version of the database (see PostgreSQL wiki for more), vFabric adds many features and considerable improvements in three categories:

1. Development and deployment become simpler, smarter, and cloud ready
2. Performance improvements with elastic memory and more
3. Monitoring and administration get an upgrade
4. Lower TCO and increased staff efficiency


Development and Deployment with vFabric Postgres

First, vPostgres is available in two form factors:

  • vPostgres Virtual Appliance
  • vPostgres RPMs for 64-bit Linux Servers (RHEL 6, Suse 11 sp1+)

Continue reading

VMware Partner Q&A: 10 Things About vFabric Worth Hearing

This interview is with Jeff Reed, Application Development Executive with Logicalis.

Q1: How have you partnered with VMware?

Answer: Logicalis is a Global Systems Integrator and premier partner of VMware.  Virtualization and Cloud Computing are major world-wide practices for us, with proven experience not only in VMware’s virtualization suite of products, but also in VMware vFabric application development, deployment, and management suite of products. We provide public cloud solutions to our customers utilizing the VMware products, as well as help our customers deploy their own private clouds.  VMware is the market leader in virtualization and a leader in the transition to cloud computing. We’re collaborating on solutions and opportunities to address the needs of today’s Enterprises as well as tomorrow’s.

JeffR_Logicalis_Pt1_FINALHD_605x300

Jeff Reed, Logicalis on working with VMware vFabric

Q2) What’s your firm’s background with Java, Spring, and Applications Development and Deployment?

Continue reading