Recently, Oracle added new certification for MySQL,
MySQL Cloud Service 2018 Implementation Essentials
This exam is all about MySQL Enterprise Edition with MySQL Cloud Service. Best study resource for this exam is “MySQL official documentation”. Along with MySQL Enterprise topics given in exam topics, this exam also includes one major part of MySQL Cloud Service.
Exam Topics:
Hi,
In this post I am going to show some tricks on using BATS
framework + PyTest + Python X Plugin things, to have combined,
simple test solutions.
Let’s describe MySQL X Plugin side, here is the full class:
# Connecting to MySQL and working with a Session
import mysqlx
class MyXPlugin:
def __init__(self, schema_name, collection_name):
# Connect to a dedicated MySQL server
self.session = mysqlx.get_session({
'host': 'localhost',
'port': 33060,
'user': 'bakux',
'password': 'Baku12345',
'ssl-mode': mysqlx.SSLMode.DISABLED
})
self.schema_name = schema_name
self.collection_name = collection_name
# Getting schema object
self.schema = self.session.get_schema(self.schema_name)
# Creating collection
self.schema.create_collection(self.collection_name, reuse=True)
# Getting collection object …[Read more]
With the next version of MySQL that is MySQL 8, there is a very
nice feature of creating "roles" which can be assigned
certain privileges and then these roles can be assigned to users,
thus helping us in maintaining the principle of least
privilege.
It makes our life as developers and DBAs easier as we do not have
to remember what are the specific privileges assigned to
different users. These "roles" can simply be assigned or
de-assigned from users as necessary.
The setup process is pretty easy and intuitive.
1. Create Role:
CREATE ROLE 'read', 'write', 'read_write';
Which essentially …
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.
This blog post is with Charity Majors, CEO/Cofounder of Honeycomb. Her talk is Debugging with Logs (and Other Events). Her presentation covers some of the lessons every engineer should know (and often learns the hard way): why good logging solutions are so expensive, why treating your logs as strings can be costly and dangerous, how logs can impact code …
[Read more]What is a median value?
The median of an array of numbers is the value of the middle item in the array, assuming the array is sorted. If the array has an even number of items, the median represents the average of the two middle values in the array.
This value is very popular one tries to understand “in which half my value is?”. For example, I got a D (or 80) in my last test at school, am I in the top 50% of my class students or not?
As a practical example, let’s look into the process of retrieving the median value from the following array of school test grades: [55, 80, 95, 100, 99, 70, 60].
Calculating the median value of …
[Read more]This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.
Cloud:
Introducing managed SSL for Google App Engine
Using Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot Application
ClusterControl in the Cloud – All Our Resources
Monitoring Amazon Aurora Audit Events with Amazon CloudWatch
Integrating Teradata with Amazon …
[Read more]We are happy to announce that MySQL team is part of the OpenSource Lisbon 2017 as Gold sponsor. You can find our experts at the booth in expo area as well as you can listen the MySQL talk on Oracle MySQL: "How are you doing?" given by Mario Beck, the MySQL Sales Consulting Manager for EMEA. Mark your calendars for September 28, 2017 for OS Lisbon 2017!!! See more details at OS Lisbon 2017.
In this blog post, we talk about the results of Percona’s time series database poll “What Database Engine Are You Using to Store Time Series Data?”
Time series data is some of the most actionable data available when it comes to analyzing trends and making predictions. Simply put, time series data is data that is indexed not just by value, but by time as well – allowing you to view value changes over time as they occur. Obvious uses include the stock market, web traffic, user behavior, etc.
With the increasing number of smart devices in the Internet of Things (IoT), being able to track data over time is more and more important. With time series data, you can measure and make …
[Read more]This post is the third of a series focusing on the MySQL high availability solutions available in 2017.
The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and mature technologies. In this post, we will look at the emerging MySQL high availability solutions. The “baby” MySQL high availability solutions I chose for the blog are group replication, proxies and distributed storage.
Group replication
Group replication is the Oracle response to Galera. The term “InnoDB cluster” means a cluster using group replication. The goal is offering …
[Read more]Sync MySQL Servers with ProxySQL Cluster
In the two previous blog posts about ProxySQL Cluster we
described how to setup a Cluster, how to add users/rules
and propagate them across the Cluster, how to provision new nodes, how to re-sync nodes
after they have been out of the Cluster, and some features in the
roadmap, especially around the concept of core nodes vs satellite
nodes.
We also mention that there are 4 modules/tables that currently
ProxySQL Cluster is able to sync:
mysql_query_rules
mysql_servers
mysql_users
proxysql_servers
We covered 3 of these, and the last one missing is how to sync
mysql_servers, related to MySQL …