Tag: transactions

Feed: Planet MySQL; Author: David Yeager; Duration: 10 min Level: Beginner This tutorial will show you how to install Dynimize. We'll then use it to optimize a live MySQL process that's been running the Sysbench OLTP benchmark, obtaining a 46% increase in performance by applying Dynimize. Part 1:  Quickstart Here's a quick overview of how to use Dynimize. To install Dynimize, run the following commands. wget https://dynimize.com/install -O installwget https://dynimizecloud.com/install.sha256 -O install.sha256sha256sum -c install.sha256; if [ $? -eq 0 ]; then sudo bash ./install -d; fi Use your access token to start a subscription license for your host. $ sudo ... Read More

Feed: Big Data Made Simple. Author: Rodney Laws. Maintaining stable finances is a core concern of almost every business, regardless of the size or type, because — unless you happen to be independently wealthy and willing to throw good money after bad — you can’t keep operating once your funds run dry. But it’s often a complicated matter. Payments big and small stack up, economic circumstances shift, and revenue varies. Even if you’re smart and careful, you can still have great difficulty.In recent years, though, the field of big data has moved from an interesting consideration to an influential practical ... Read More

Feed: Blog – Hazelcast. Author: Dan Ortega. Stream processing refers to real-time management of data entering a banking system (or any information system, actually) at high speed and volume, usually from a broad range of sources. The “management” aspect means data is wholly or partially processed and contextualized before entering an in-memory (operational) system, where pre-processing can significantly accelerate response times. Before in-memory technologies, transactional data was managed as a batch process and analyzed every hour, once a day, etc., depending on the data involved, the bank’s policies for handling data, regulatory and compliance requirements, and so on. While having ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Recently I had a customer where every single query was running in a transaction, as well as even the simplest selects. Unfortunately, this is not unique and many connectors like Java love to do that.In their case, the Java connector changed autocommit=off for the connection itself at the beginning, and as these were permanent connections they never or almost never reconnected.In the slow query log we could see after every select there was a commit. So why is this a problem?Test CaseLike always, the best way to deal with a problem to test ... Read More

Feed: R-bloggers. Author: kjytay. I recently learned how to use the choroplethr package through a short tutorial by the package author Ari Lamstein (youtube link here). To cement what I learned, I thought I would use this package to visualize flood insurance claims. I am using the FIMA NFIP redacted claims dataset from FEMA, and it contains more than 2 million claims transactions going all the way back to 1970. (The dataset can be accessed from this URL.) From what I can tell, this dataset is updated somewhat regularly. For this post, the version of the dataset used was published ... Read More

Feed: AWS Big Data Blog. Modern data lakes depend on extract, transform, and load (ETL) operations to convert bulk information into usable data. This post walks through implementing an ETL orchestration process that is loosely coupled using AWS Step Functions, AWS Lambda, and AWS Batch to target an Amazon Redshift cluster.Because Amazon Redshift uses columnar storage, it is well suited for fast analytical insights using the convenient ANSI SQL queries. You can rapidly scale your Amazon Redshift clusters up and down in minutes to meet the demanding workloads for both your end-user reports and timely data refresh into the data ... Read More

Feed: Big Data Made Simple. Author: Bo Romans. As a college student, I have many places I need to be. Between my college classes, my dorm, restaurants, concerts, my family home, grocery stores, friends’ apartments, meetings, hiking trails, local events, coffee shops, hot springs, sports games and an internship, I am constantly on the go. It is not unusual for me to spend over three hours commuting every day. Normally these commutes would be something to dread, but I have actually found them to be what I look forward to during my day.Why personalization works: a use caseA few years ... Read More

Feed: Planet MySQL; Author: MinervaDB; Table of Contents Delayed Replication – You can deliberately execute transactions later than the master by a specific duration of time , Why you do that and for what ? Consider this, Accidentally someone did a wrong UPDATE / DELETE in the master and the transaction is committed, Now how can DBA rollback the database system to the last known good condition ? This is when we benefit from MySQL delayed slave replication investment. The default replication delay in MySQL is “0” seconds, To delay the slave by N seconds use the CHANGE MASTER TO MASTER_DELAY = ... Read More

Author: . Financial services firms have been on the leading edge of technology adoption for decades, starting with the pneumatic capsules you can use at drive-up bank windows to make deposits or withdrawals, followed by credit cards starting in 1950, and the automated teller machine in 1967. The innovations since then have only accelerated as technology has evolved.While many feel like we’ve been talking about digital transformation forever, the conversation really started with the introduction of the iPhone in 2007. Putting a powerful computer - connected to the internet - in the hands of billions of people has radically changed ... Read More

Feed: All Oracle Press Releases. GoCardless, a global direct debit network headquartered in the UK, has selected Oracle NetSuite to support its mission to take the pain out of getting paid for businesses with recurring revenue. With NetSuite, the fintech company, which grew by 60 percent in the last year, has been able to automate financial management and help reduce the complexities of operating across multiple markets, currencies and tax laws as it rapidly expands its international operations. Founded in 2012, GoCardless has created a global bank debit network to rival credit and debit cards, as well as a platform ... Read More