Tag: MySQL

Feed: Microsoft Azure Blog. Author: Sunitha Muthukrishna. Today, we’re announcing a cool new feature (in preview) for Web developers using Azure App Service to create Web applications that use MySQL. MySQL in-app enables developers to run the MySQL server side-by-side with their Web application within the same environment, which makes it easier to develop and test PHP applications that use MySQL. We’re also making it very easy to get started with this feature via the Azure portal. During the creation of your Web App, you’ll be able to select a “MySQL in-app (preview)” provider for your database, which will help ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. It's All About the DATA Here's Larry Ellison's critique of Workday. "Workday does not use a database, they use an object store. So, they can't really do reporting. They use flash. So, they can't run on iPhones or iPads. Besides that, they're great!"  Here's the overview Workday application architecture (from Workday). Workday uses object model and stores the objects MySQL table as a blob instead of normalizing and storing the data in multiple tables, tuples, and columns. Object store makes object-relational mapping, object disassembly/assembly unnecessary. Because you store objects, you lose some benefits of RDBMS: query ... Read More

Feed: AWS Big Data Blog. This is a guest post by Takumi Sakamoto, a software engineer at SmartNews. SmartNews in their own words: "SmartNews is a machine learning-based news discovery app that delivers the very best stories on the Web for more than 18 million users worldwide." Data processing is one of the key technologies for SmartNews. Every team’s workload involves data processing for various purposes. The news team at SmartNews uses data as input to their machine learning algorithm for delivering the very best stories on the Web. The product team relies on data to run various A/B ... Read More

Feed: AWS Big Data Blog. Lots to see on the Big Data Blog in June! Please take a look at the summaries below for something that catches your interest. Use Sqoop to Transfer Data from Amazon EMR to Amazon RDS Customers commonly process and transform vast amounts of data with EMR and then transfer and store summaries or aggregates of that data in relational databases such as MySQL or Oracle. In this post, learn how to transfer data using Apache Sqoop, a tool designed to transfer data between Hadoop and relational databases. Analyze Realtime Data from Amazon Kinesis ... Read More

Feed: AWS Big Data Blog. Sai Sriparasa is a consultant with AWS Professional Services Customers commonly process and transform vast amounts of data with Amazon EMR and then transfer and store summaries or aggregates of that data in relational databases such as MySQL or Oracle. This allows the storage footprint in these relational databases to be much smaller, yet retain the ability to process larger, more granular datasets using the Hadoop ecosystem in Amazon EMR. In this post, I will show you how to transfer data using Apache Sqoop, which is a tool designed to transfer data between ... Read More

Feed: AWS Big Data Blog. Bob Strahan is a Senior Consultant with AWS Professional Services AWS Lambda has emerged as excellent compute platform for modern microservices architecture, driving dramatic advancements in flexibility, resilience, scale and cost effectiveness. Many customers can take advantage of this transformational technology from within their existing relational database applications. In this post, we explore how to integrate your Amazon EC2-hosted Oracle or PostgreSQL database with AWS Lambda, allowing your database application to use a microservices architecture. Here are a few reasons why you might find this capability useful: Instrumentation: Use database triggers ... Read More

Feed: Planet MySQL Author: MySQL Performance Blog Thank you for attending my 22nd July 2016 webinar titled “Top Most Overlooked MySQL Performance Optimizations“. In this blog, I will provide answers to the Q & A for that webinar. For hardware, which disk raid level do you suggest? Is raid5 suggested performance-wise and data-integrity-wise? RAID 5 comes with high overhead, as each write turns into a sequence of four physical I/O operations, two reads and two writes. We know that RAID 5s have some write penalty, and it could affect the performance on spindle disks. In most cases, we advise using alternative ... Read More

Feed: Google Cloud Platform Blog Author: GCP Team Posted by Brett Hesterberg, Product Manager, Google Cloud Platform Five years ago, we launched the First Generation of Google Cloud SQL and have helped thousands of companies build applications on top of it. In that time, Google Cloud Platform’s innovations on Persistent Disk dramatically increased IOPS for Google Compute Engine, so we built Second Generation on Persistent Disk, allowing us to offer a far more performant MySQL solution at a fraction of the cost. Cloud SQL Second Generation now runs 7X faster and has 20X more storage capacity than its predecessor — ... Read More

Feed: Google Cloud Platform Blog Author: GCP Team Posted by Dominic Preuss, Lead Product Manager for Storage and Databases We are committed to making Google Cloud Platform the best public cloud for your database workloads. From our managed database services to self-managed versions of your favorite relational or NoSQL database, we want enterprises with databases of all sizes and types to experience the best price-performance with the least amount of friction. Today, we're excited to announce that all of our database storage products are generally available and covered by corresponding Service Level Agreements (SLAs). We're also releasing new performance and ... Read More

Feed: Google Cloud Platform Blog Author: GCP Team Posted by Amir Rouzrokh, Product Manager Developers running Python on Google App Engine have long asked for support for Python 3 and third-party Python packages. Today we're excited to announce the beta release of the Python runtime on App Engine Flexible Environment with support for Python 3.4 and 2.7. You can now develop applications in the Python version you prefer and create performant mobile and web backends using the frameworks and libraries of your choice. Meanwhile, developers benefit from App Engine's built-in services, such as autoscaling, load balancing, microservices support and traffic ... Read More