Feed: What's New. You can now record configuration changes to AWS Elastic Beanstalk resource types using AWS Config. AWS Elastic Beanstalk is a service for deploying and scaling web applications and services developed in multiple languages. You upload your code and Elastic Beanstalk automatically handles the deployment from capacity provisioning, load balancing, auto-scaling to application health monitoring. With Config, you can track changes to Elastic Beanstalk applications, application versions, environments, and all the resources configured within that environment. For example, you can view changes to your environment platform version, deployment and scaling policies, health policies, and tags. This information is ... Read More

Feed: What's New. AWS Auto Scaling allows you to discover scalable resources underlying your application and scale them all using a single scaling plan. Previously, AWS Auto Scaling discovered application resources based on an Amazon CloudFormation stack. Now, AWS Auto Scaling can also discover scalable resources that you have categorized for your application using resource tags. Resource tag-based AWS Auto Scaling is available for Amazon EC2, Amazon EC2 Spot Fleets, Amazon DynamoDB tables and Global Secondary Indexes (GSIs), and Amazon Aurora Replicas. Amazon ECS services cannot be discovered through tags at this time, and are currently supported by AWS Auto ... Read More

Feed: Big Data Made Simple - One source. Many perspectives.. Author: Baiju NT. Big Data and analytical skills are becoming an important part of the IT industry worldwide. Hence, there is a growing demand for people who possess the required skills and above all, are competent to work in these core sectors. However, acquiring big data and analytical skills is not as difficult as one tends to believe. Generally, there are many other online courses that are available for free, while you can take paid, specialized courses to improve your skills. Here we list nine top free online courses to ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dave Avery  | April 24, 2018 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL, Replication PREVIOUS POST In this blog post on Percona Live 2018 sessions, we’ll talk with Shuhoa Wu, Software Developer for Shopify, Inc. about how Ghostferry is the Swiss Army knife of live data migrations. Existing tools like mysqldump and replication cannot migrate data between GTID-enabled MySQL and non-GTID-enabled MySQL – a common configuration across multiple cloud providers that cannot be changed. These tools are also cumbersome to operate and error-prone, thus requiring a DBA’s attention for each data migration. Shopify’s team ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dave Avery  | April 24, 2018 |  Posted In: Cloud and MySQL, MariaDB, MySQL, Percona Live, PostgreSQL PREVIOUS POST In this blog post on Percona Live 2018 sessions, we’ll talk with Jun Su, Principal Engineering Manager at Microsoft about how Microsoft built MySQL, PostgreSQL and MariaDB for the cloud. Offering MySQL, PostgreSQL and MariaDB database services in the cloud is different than doing so on-premise. Latency, connection redirection, optimal performance configuration are just a few challenges. In this session, Jun Su walked us through Microsoft’s journey to not only offer these popular OSS RDBMS in Microsoft ... Read More

Feed: Planet MySQL; Author: Markus Winand; “Still using SQL-92?” is the opening question of my “Modern SQL” presentation. When I ask this question, an astonishingly large portion of the audience openly admits to using 25 years old technology. If I ask who is still using Windows 3.1, which was also released in 1992, only a few raise their hand…but they’re joking, of course.Clearly this comparison is not entirely fair. It nevertheless demonstrates that the know-how surrounding newer SQL standards is pretty lacking. There were actually five updates since SQL-92—many developers have never heard of them. The latest version is SQL:2016.As ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dave Avery  | April 24, 2018 |  Posted In: MySQL, Percona Live, PostgreSQL PREVIOUS POST In this blog post on Percona Live 2018 sessions, we’ll talk with Christian Antognini, Senior Principal Consultant at Trivadis about the differences between MySQL and PostgreSQL query optimizers. MySQL and PostgreSQL are two of the most popular open-source relational databases. Why would you pick one over the other to support your applications? Of course, it depends on the use case, environment and workload. To help with choosing between them, the people at Trivadis ran a comparison of their query optimizers. The aim of ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dave Avery  | April 24, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Benchmarks, MariaDB, MongoDB, MySQL PREVIOUS POST Welcome to Percona Live 2018 keynotes, day one! Percona Live 2018 is up and running! We call this day one, but in reality, yesterday was filled with tutorials that provided excellent and practical information on how to get your MySQL, MongoDB, MariaDB and PostgreSQL environments up, running and optimized. Today we started with keynote presentations from Percona, a technology panel, Oracle and Netflix. You can view the recording of today’s keynotes here. Percona Welcome Laurie ... Read More

Feed: Planet MySQL; Author: Michael "Monty" Widenus; Last week, Oracle announced the general availability of MySQL 8.0. This is good news for database users, as it means Oracle is still developing MySQL.I decide to celebrate the event by doing a quick test of MySQL 8.0. Here follows a step-by-step description of my first experience with MySQL 8.0. Note that I did the following without reading the release notes, as is what I have done with every MySQL / MariaDB release up to date; In this case it was not the right thing to do.I pulled MySQL 8.0 from ghit@github.com:mysql/mysql-server.git I ... Read More

Feed: Planet MySQL; Author: Severalnines; Today we are excited to announce the 1.6 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases - and load balancers - in any environment: on-premise or in the cloud. ClusterControl 1.6 introduces a new set of cloud features in BETA status that allow users to deploy and manage their open source database clusters on public clouds such AWS, Google Cloud and Azure. The release also provides a Point In Time Recovery functionality for MySQL/MariaDB systems, as well as new topology ... Read More