Whitney  Durgan

Whitney Durgan

1620697440

Oracle Melds Analytics with OLTP in MySQL DB

Oracle is moving to make it possible to combine OLTP and OLAP workloads using a managed cloud database service.

Oracle today unfurled an Oracle MySQL Database Service with the MySQL Analytics Engine that for the first time embeds an analytics engine within the open-source relational database.

Businesses have been employing MySQL to process transactions for years. However, analyzing MySQL transaction data required IT teams to provision and manage a separate database. Now Oracle is moving to make it possible to combine Online Transaction Processing (OLTP) and Online Analytics Processing (OLAP) workloads using a database service that is only available as a managed service on its Oracle Cloud Infrastructure (OCI).

The MySQL Analytics Engine provides access to a columnar data store designed to run in-memory to process analytics workload in real-time in a way that is 2.7 times faster than a rival Amazon Web Services (AWS) Redshift service at a much lower cost, says Edwin Desouza, vice president of MySQL product management for Oracle.

#analytics #sql #mysql

What is GEEK

Buddha Community

Oracle Melds Analytics with OLTP in MySQL DB
Joe  Hoppe

Joe Hoppe

1595905879

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

HTML to Markdown

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. DigitalOcean is quickly building its reputation as the developers cloud by providing an affordable, flexible and easy to use cloud platform for developers to work with. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? In this post, we are going to compare the top two providers, DigitalOcean Managed Databases for MySQL vs. ScaleGrid MySQL hosting on DigitalOcean.

At a glance – TLDR
ScaleGrid Blog - At a glance overview - 1st pointCompare Throughput
ScaleGrid averages almost 40% higher throughput over DigitalOcean for MySQL, with up to 46% higher throughput in write-intensive workloads. Read now

ScaleGrid Blog - At a glance overview - 2nd pointCompare Latency
On average, ScaleGrid achieves almost 30% lower latency over DigitalOcean for the same deployment configurations. Read now

ScaleGrid Blog - At a glance overview - 3rd pointCompare Pricing
ScaleGrid provides 30% more storage on average vs. DigitalOcean for MySQL at the same affordable price. Read now

MySQL DigitalOcean Performance Benchmark
In this benchmark, we compare equivalent plan sizes between ScaleGrid MySQL on DigitalOcean and DigitalOcean Managed Databases for MySQL. We are going to use a common, popular plan size using the below configurations for this performance benchmark:

Comparison Overview
ScaleGridDigitalOceanInstance TypeMedium: 4 vCPUsMedium: 4 vCPUsMySQL Version8.0.208.0.20RAM8GB8GBSSD140GB115GBDeployment TypeStandaloneStandaloneRegionSF03SF03SupportIncludedBusiness-level support included with account sizes over $500/monthMonthly Price$120$120

As you can see above, ScaleGrid and DigitalOcean offer the same plan configurations across this plan size, apart from SSD where ScaleGrid provides over 20% more storage for the same price.

To ensure the most accurate results in our performance tests, we run the benchmark four times for each comparison to find the average performance across throughput and latency over read-intensive workloads, balanced workloads, and write-intensive workloads.

Throughput
In this benchmark, we measure MySQL throughput in terms of queries per second (QPS) to measure our query efficiency. To quickly summarize the results, we display read-intensive, write-intensive and balanced workload averages below for 150 threads for ScaleGrid vs. DigitalOcean MySQL:

ScaleGrid MySQL vs DigitalOcean Managed Databases - Throughput Performance Graph

For the common 150 thread comparison, ScaleGrid averages almost 40% higher throughput over DigitalOcean for MySQL, with up to 46% higher throughput in write-intensive workloads.

#cloud #database #developer #digital ocean #mysql #performance #scalegrid #95th percentile latency #balanced workloads #developers cloud #digitalocean droplet #digitalocean managed databases #digitalocean performance #digitalocean pricing #higher throughput #latency benchmark #lower latency #mysql benchmark setup #mysql client threads #mysql configuration #mysql digitalocean #mysql latency #mysql on digitalocean #mysql throughput #performance benchmark #queries per second #read-intensive #scalegrid mysql #scalegrid vs. digitalocean #throughput benchmark #write-intensive

Justyn  Ortiz

Justyn Ortiz

1603465200

Oracle Kills 402 Bugs in Massive October Patch Update

Business software giant Oracle is urging customers to update their systems in the October release of its quarterly Critical Patch Update (CPU), which fixes 402 vulnerabilities across various product families.

Well over half (272) of these vulnerabilities open products up to remote exploitation without authentication. That means that the flaw may be exploited over a network without requiring user credentials.

The majority of the flaws are in Oracle Financial Services Applications (53), Oracle MySQL (53), Oracle Communications (52), Oracle Fusion Middleware (46), Oracle Retail Applications (28) and Oracle E-Business Suite (27). But overall, 27 Oracle product families are affected by the flaws. Users can find a patch availability document for each product, available here.

“Oracle continues to periodically receive reports of attempts to maliciously exploit vulnerabilities for which Oracle has already released security patches,” according to the company’s release on Tuesday. “In some instances, it has been reported that attackers have been successful because targeted customers had failed to apply available Oracle patches. Oracle therefore strongly recommends that customers remain on actively-supported versions and apply Critical Patch Update security patches without delay.”

While details of the flaws themselves are scant, two of the critical vulnerabilities disclosed by Oracle rank the highest severity score – 10 out of 10 – on the CVSS scale.

These include a flaw in the self-service analytics component of Oracle Healthcare Foundation, which is a unified healthcare-analytics platform that is part of the Oracle Health Science Applications suite. The flaw (CVE-2020-1953), which can be remotely exploited without requiring any user credentials, requires no user interaction and is easy to exploit, according to Oracle. Affected supported versions include 7.1.1, 7.2.0, 7.2.1 and 7.3.0.

The second severe flaw (CVE-2020-14871) exists in the pluggable authentication module of Oracle Solaris, its enterprise operating system for Oracle Database and Java applications (part of the Oracle Systems risk matrix). The flaw is also remotely exploitable without user credentials, requires no user interaction and is a “low-complexity” attack. Versions 10 and 11 are affected.

Sixty-five of the vulnerabilities also had a CVSS base score of 9.8 (and six had a score of 9.4) out of 10, making them critical in severity.

Oracle did offer some workarounds, advising that for attacks that require certain privileges or access to certain packages, removing the privileges or the ability to access the packages from users that do not need the privileges may help reduce the risk of successful attack. Users can also reduce the risk of successful attack by blocking network protocols required by an attack.

However, both these approaches may break application functionality, and Oracle does not recommend that either approach be considered a long-term solution as neither corrects the underlying problem.

“Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply Critical Patch Update security patches as soon as possible,” according to the company.

Oracle releases its CPUs on the Tuesday closest to the 17th day of January, April, July and October.

Previous quarterly updates have stomped out hundreds of bugs across the company’s product lines, including one in April that patched 405. There are also out-of-band updates; in June for instance, Oracle warned of a critical remote code-execution flaw in its WebLogic Server being actively exploited in the wild.

#vulnerabilities #web security #cpu #critical patch update #cve-2020-14871 #cve-2020-1953 #oracle #oracle communications #oracle e-business suite #oracle financial services applications #oracle fusion middleware #oracle mysql #oracle retail applications #quarterly patch update #remote code execution #security update

Whitney  Durgan

Whitney Durgan

1620697440

Oracle Melds Analytics with OLTP in MySQL DB

Oracle is moving to make it possible to combine OLTP and OLAP workloads using a managed cloud database service.

Oracle today unfurled an Oracle MySQL Database Service with the MySQL Analytics Engine that for the first time embeds an analytics engine within the open-source relational database.

Businesses have been employing MySQL to process transactions for years. However, analyzing MySQL transaction data required IT teams to provision and manage a separate database. Now Oracle is moving to make it possible to combine Online Transaction Processing (OLTP) and Online Analytics Processing (OLAP) workloads using a database service that is only available as a managed service on its Oracle Cloud Infrastructure (OCI).

The MySQL Analytics Engine provides access to a columnar data store designed to run in-memory to process analytics workload in real-time in a way that is 2.7 times faster than a rival Amazon Web Services (AWS) Redshift service at a much lower cost, says Edwin Desouza, vice president of MySQL product management for Oracle.

#analytics #sql #mysql

Ananya Gupta

Ananya Gupta

1599222949

5 Steps To Get An Oracle Database Certification

So, do you have to become Oracle Certified? it has been a debatable issue for a short time, but one thing is certain: the Oracle Certification provides an accurate measure of your technical abilities.

Additionally, it gives you a foothold over people competing for the database administration positions you desire. Join Oracle online certification course and get complete guidance

Here are the steps to getting an Oracle Database certification:

  1. Associate Certification

The first step to getting your Oracle is getting the Associate Certification, which needs that the person passes two tests to become an Oracle Certified Associate (OCA). With this qualification, you’ll add junior management as a team member or an application developer. to urge the associate certification, you’ve got to pass in one among the three tests explained below and therefore the final “Oracle Database 11g: Administration I” test.Join best Oracle online training program to improve your skills.

Step 1: Take one among the subsequent three courses

Oracle Database 12c: SQL Fundamentals 1Z0-061

The examination tests ability to make, retrieve, maintain, and edit data during a database. Mainly, this involves a grasp of important database administration concepts like an electronic database. Additionally, the necessity to know and use SQL is extremely important, because the test would require you to demonstrate your SQL programming skills.

Oracle Database SQL Expert 1Z0-047

In general, this is often a complicated version of the “Introduction to Oracle9i SQL” test. you’ll need proficiency in 76 topics to achieve this exam. you would like to possess a high understanding of database objects, control privileges, and system-level queries. The questions require a deep understanding of SQL, and are multiple parts in nature, requiring the application of concepts instead of mere memorization of answers. Experience in database administration will offer you a notable advantage during this test.

Oracle Database 11g: SQL Fundamentals I 1Z0-051

This test is an improved version of the “Introduction to Oracle9i SQL” test. The content is newer and includes set and conditional operators, which are absent within the older version. Therefore, you’d be happier choosing this test over the previous.

Step 2: Oracle Database 11g: Administration I 1Z0-052

The test requires knowledge on the way to found out database environments and secure Oracle instances in any network environment. Other concepts needed to pass this exam include understanding of database backup and recovery, Oracle Database Architecture, also as the configuration of security instances. The questions require the application of concepts, not just memorization of data.

  1. Professional Certification

The professional certification allows you to manage large databases and develop large-scale database applications. In summary, to become an Oracle Certified Professional (OCP), you’ve got to require an instructor-led course, an exam, and a hands-on course.

Step 1: Be an Oracle Certified Associate

You must have the OCA certification as a pre-requisite for this course.

Step 2: Take an Exam

The second step within the OCP certification process is to require a course from a variety of about 50 courses and sit an exam. The list of those courses is out there on the Oracle site. The broad selection means you’ll choose the course that most accurately fits your training requirements. Note that you simply cannot meet the wants of this course through self-study; you’ve got to require an instructor-led class, a virtual class, or learn through training-on-demand.

Step 3: Submission of an Already Completed Course

In this step, you’re required to submit a previously completed course from an inventory of 21 courses. Alternatively, Oracle allows submissions from courses taken within the previous step.

Step 4: Oracle Database 11g: Administration II 1Z0-053

This is the ultimate exam within the OCP certification process. Once you pass this exam, you’ll proceed to the ultimate process.

Step 5: Submit a course completion form
Once you pass this exam, you only need to complete a course submission because of the final step within the OCP certification process.

Master Certification

This is the very best Oracle certification you’ll get. With this qualification, you’ll well-suited to figure in senior levels in IT departments handling sensitive database system issues and applications. you’ll need an OCP certification to urge started. then you’ll take a two-day exam then a hands-on course.

Conclusion:
In general, Oracle Certified database administrators have the knowhow to run databases both at the junior and senior levels, counting on the certification level. Some people might argue that there’s little point to being certified because the process involves the memorization of theoretical concepts and taking a multiple-choice test. However, while there’s credence to the very fact that certification does little to catch up on the shortage of technical competence obtained through experience, it does give validity to such claims. As an Oracle Certified database services, potential employers and clients are more easily convinced of your capabilities within the field.

#oracle online training #oracle online course #oracle online certification course #oracle certification course #oracle course #oracle training

Loma  Baumbach

Loma Baumbach

1595781840

Exploring MySQL Binlog Server - Ripple

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. However, as the number of slaves increases, they will have a toll on the master resources because the binary logs will need to be served to different slaves working at different speeds. If the data churn on the master is high, the serving of binary logs alone could saturate the network interface of the master.

A classic solution for this problem is to deploy a binlog server – an intermediate proxy server that sits between the master and its slaves. The binlog server is set up as a slave to the master, and in turn, acts as a master to the original set of slaves. It receives binary log events from the master, does not apply these events, but serves them to all the other slaves. This way, the load on the master is tremendously reduced, and at the same time, the binlog server serves the binlogs more efficiently to slaves since it does not have to do any other database server processing.

MySQL Binlog Server Deployment Diagram - ScaleGrid Blog

Ripple is an open source binlog server developed by Pavel Ivanov. A blog post from Percona, titled MySQL Ripple: The First Impression of a MySQL Binlog Server, gives a very good introduction to deploying and using Ripple. I had an opportunity to explore Ripple in some more detail and wanted to share my observations through this post.

1. Support for GTID based replication

Ripple supports only GTID mode, and not file and position-based replication. If your master is running in non-GTID mode, you will get this error from Ripple:

Failed to read packet: Got error reading packet from server: The replication sender thread cannot start in AUTO_POSITION mode: this server has GTID_MODE = OFF instead of ON.

You can specify Server_id and UUID for the ripple server using the cmd line options: -ripple_server_id and -ripple_server_uuid

Both are optional parameters, and if not specified, Ripple will use the default server_id=112211 and uuid will be auto generated.

2. Connecting to the master using replication user and password

While connecting to the master, you can specify the replication user and password using the command line options:

-ripple_master_user and -ripple_master_password

3. Connection endpoint for the Ripple server

You can use the command line options -ripple_server_ports and -ripple_server_address to specify the connection end points for the Ripple server. Ensure to specify the network accessible hostname or IP address of your Ripple server as the -rippple_server_address. Otherwise, by default, Ripple will bind to localhost and hence you will not be able to connect to it remotely.

4. Setting up slaves to the Ripple server

You can use the CHANGE MASTER TO command to connect your slaves to replicate from the Ripple server.

To ensure that Ripple can authenticate the password that you use to connect to it, you need to start Ripple by specifying the option -ripple_server_password_hash

For example, if you start the ripple server with the command:

rippled -ripple_datadir=./binlog_server -ripple_master_address= <master ip> -ripple_master_port=3306 -ripple_master_user=repl -ripple_master_password='password' -ripple_server_ports=15000 -ripple_server_address='172.31.23.201' -ripple_server_password_hash='EF8C75CB6E99A0732D2DE207DAEF65D555BDFB8E'

you can use the following CHANGE MASTER TO command to connect from the slave:

CHANGE MASTER TO master_host='172.31.23.201', master_port=15000, master_password=’XpKWeZRNH5#satCI’, master_user=’rep’

Note that the password hash specified for the Ripple server corresponds to the text password used in the CHANGE MASTER TO command. Currently, Ripple does not authenticate based on the usernames and accepts any non-empty username as long as the password matches.

Exploring MySQL Binlog Server - Ripple

CLICK TO TWEET

5. Ripple server management

It’s possible to monitor and manage the Ripple server using the MySQL protocol from any standard MySQL client. There are a limited set of commands that are supported which you can see directly in the source code on the mysql-ripple GitHub page.

Some of the useful commands are:

  • SELECT @@global.gtid_executed; – To see the GTID SET of the Ripple server based on its downloaded binary logs.
  • STOP SLAVE; – To disconnect the Ripple server from the master.
  • START SLAVE; – To connect the Ripple server to the master.

#cloud #database #developer #high availability #mysql #performance #binary logs #gtid replication #mysql binlog #mysql protocol #mysql ripple #mysql server #parallel threads #proxy server #replication topology #ripple server