Tag: Oracle

Feed: Featured Blog Posts - Data Science Central. Author: Igor Bobriakov. Apache Spark is a powerful open-source processing engine built around speed, ease of use, and sophisticated analytics. It has originally been developed at UC Berkeley in 2009, while Databricks was founded later by the creators of Spark in 2013. The Spark engine runs in a variety of environments, from cloud services to Hadoop or Mesos clusters. It is used to perform ETL, interactive queries (SQL), advanced analytics (e.g., machine learning) and streaming over large datasets in a wide range of data stores (e.g., HDFS, Cassandra, HBase, S3). Spark supports ... Read More

Feed: Planet MySQL; Author: HowToForge; Nextcloud is a free (Open Source) Dropbox-like software, a fork of the ownCloud project. Nextcloud is written in PHP and JavaScript, it supports many database systems such as MySQL/MariaDB, PostgreSQL, Oracle Database, and SQLite. In order to keep your files synchronized between Desktop and your own server, Nextcloud provides applications for Windows, Linux, and Mac desktops and a mobile app for Android and iOS. Nextcloud is not just a Dropbox clone, it provides additional features like Calendar, Contacts, Schedule tasks, and streaming media with Ampache etc. In this tutorial, we will show you how to ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Vadim Tkachenko | July 13, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0, Percona Server for MySQL PREVIOUS POST Recently, Dimitri published the results of measuring MySQL 8.0 on Intel Optane storage device. In this blog post, I wanted to look at this in more detail and explore the performance of MySQL 8, MySQL 5.7 and Percona Server for MySQL using a similar set up. The Intel Optane is a very capable device, so I was puzzled that Dimitri chose MySQL options that are either not safe or not recommended for production workloads. Since we have an ... Read More

Feed: Planet MySQL; Author: Severalnines; Before you attempt to perform any schema changes on your production databases, you should make sure that you have a rock solid rollback plan; and that your change procedure has been successfully tested and validated in a separate environment. At the same time, it’s your responsibility to make sure that the change causes none or the least possible impact acceptable to the business. It’s definitely not an easy task. In this article, we will take a look at how to perform database changes on MySQL and MariaDB in a controlled way. We will talk about ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. It’s time for us to admit what we have all known is true for a long time; NoSQL is the wrong tool for many of the modern application use cases, and it’s time that we move on. NoSQL came into existence because the databases at the time couldn’t handle the scale required. The rise of this new generation of data services solved many of the problems of web scale and rapidly growing data sets when it was created more than a decade ago. NoSQL also offered a new, cost-effective method for cold storage/occasional batch ... Read More

Feed: Planet MySQL; Author: Serge Frezefond; Oracle has done a great technical work with MySQL. Specifically a nice job has been done around security. There is one useful feature that exists in Oracle MySQL and that currently does not exist in MariaDB.Oracle MySQL offers the possibility from within the server to generate asymetric key pairs. It is then possible use them from within the MySQL server to encrypt, decrypt or sign data without exiting the MySQL server. This is a great feature. This is defined as a set of UDF (User Defined Function : CREATE FUNCTION asymmetric_decrypt, asymmetric_encrypt, asymmetric_pub_key … ... Read More

Feed: Planet MySQL; Author: Alexander Rubin; Alexander Rubin | July 12, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0 PREVIOUS POST MySQL stored procedures, functions and triggers are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a customer visit, I set out to create some simple tests to measure the impact of triggers on database performance. The outcome might surprise you. Why stored routines are not optimal performance wise: short version Recently, I worked with a customer to profile ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; In the old days, when we wanted to strengthen our skills the only option was to buy a good book (this one litteraly changed my life, but also this one, this one, …). Nowadays one can find a lot of resources on the Internet, however quality is often poor :(. Fortunately there are still some great people who are brave enough to write new books that will hopefully have an impact on the new generation of women and men (and the current generation as well) who build modern applications with MySQL, the world’s most ... Read More

Feed: Striving for Optimal Performance. The Appendix A of the Using Oracle Autonomous Data Warehouse Cloud guide describes the DBMS_CLOUD package. Unfortunately, it documents only a subset of the subroutines. And, for some of them, the description could also be enhanced. Therefore, while I was testing all the subroutines the DBMS_CLOUD package provides, I took a number of notes. By the end of my tests, I got what I can call my personal reference guide to the package. Since it might help others, here it is… Introduction To interact with other cloud services, the Oracle Autonomous Data Warehouse Cloud service ... Read More

Feed: What's New. Publishing logs to CloudWatch allows you to maintain continuous visibility into database activity and errors in your databases. For example, you can set up CloudWatch Alarms to notify you on frequent restarts that are recorded in the alert log. Similarly, alarms for events recorded in audit logs can be created to alert on unwanted changes made to your databases. CloudWatch Logs provide a durable archive destination for your database logs. You can specify a retention period to indicate how long you want CloudWatch to retain your logs. Additionally, with CloudWatch Logs, you can perform ad hoc searches ... Read More