Showing entries 151 to 160 of 36801
« 10 Newer Entries | 10 Older Entries »
MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs)

The MySQL development team just published a Labs release of the MySQL Server (available under “MySQL Server 8.0.0 Optimizer”).
A prominent feature of this release, which I developed, is [Recursive] Common Table Expressions, also known as

  • [recursive] CTE,
  • [recursive] subquery factoring,
  • WITH [RECURSIVE] clause.

Database Sharding - How does it work?

Database systems with large data sets or high throughput applications can challenge the capacity of a single database server. High query rates can exhaust CPU capacity, I/O resources, RAM or even network bandwidth.

Horizontal scaling is often the only way to scale out your infrastructure. You can upgrade to more powerful hardware, but there is a limit on how much load a single host can handle. You may be able to purchase the most expensive and the fastest CPU or storage on the market, but it still may not be enough to handle your workload. The only feasible way to scale beyond the constraints of a single host is to utilize multiple hosts working together as a part of a cluster or connected using replication.

Horizontal scaling has its limits too, though. When it comes to scaling reads, it is very efficient - just add a node and you can utilize additional processing power. With writes, things are completely different. Consider a …

[Read more]
Introducing MySQL InnoDB Cluster – A Hands-On Tutorial

Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea).…

Introducing MySQL InnoDB Cluster – Demo Video

Today we are introducing a new MySQL feature called MySQL InnoDB Cluster. Make sure to watch the demo video on the MySQL YouTube Channel!

Find out more by looking into the MySQL InnoDB Cluster documentation.

If you got questions or feedback please feel free to post on the MySQL Forums.…

Introducing MySQL InnoDB Cluster – MySQL HA: Out-of-Box, Easy to use High Availability

Introducing the new MySQL InnoDB Cluster Feature

MySQL has had good support for replication for a long time. After all, it is one of the key features that have enabled companies like Facebook, Booking, Twitter and so many others to grow and scale to such extreme scale with MySQL as their primary database engine.…

How to Install Redmine 3.2 with Nginx on Ubuntu 16.04

Redmine is an open source project management and issue tracking tool based on the Ruby on Rails Framework. This tutorial covers the Redmine 3 installation with Nginx as the web server and MySQL as the database on Ubuntu 16.04 (Xenial Xerus) operating system.

MySQL 8.0: Performance Schema Instrumentation of Server Errors

In MySQL 8.0.0, the Performance Schema can now instrument server errors. There are 5 new summary tables introduced:

mysql> show tables like "%by_error%";
| Tables_in_performance_schema (%by_error%) |
| events_errors_summary_by_account_by_error |
| events_errors_summary_by_host_by_error    |
| events_errors_summary_by_thread_by_error  |
| events_errors_summary_by_user_by_error    |
| events_errors_summary_global_by_error     |
5 rows in set (0.02 sec)

As names suggest, statistics of errors in these tables are aggregated by error.…

Replication from Oracle to MariaDB - Part 3

This is the third part of a series of blogs on how to do Change Data Capture from Oracle in an effort to be able to replicate that data to MariaDB. Part 1 dealt with some basics on the Oracle side of things regarding the Oracle redo log which we use as a source for out CDC efforts and Part 2 was about how to get this to work. We left part2 with an example of how to Replicate INSERTs from Oracle to MariaDB, but that is hardly good enough, we also have to deal with UPDATE and DELETE to make it at least somewhat complete, and this is what we will have a look at in this post.

And I know what you are asking your selves now, you spent all that …

[Read more]
Load balanced MySQL Galera setup - Manual Deployment vs ClusterControl

If you have deployed databases with high availability before, you will know that a deployment does not always go your way, even though you’ve done it a zillion times. You could spend a full day setting everything up and may still end up with a non-functioning cluster. It is not uncommon to start over, as it’s really hard to figure out what went wrong.

So, deploying a MySQL Galera Cluster with redundant load balancing takes a bit of time. This blog looks at how long time it would take to do it manually vs using ClusterControl to perform the task. For those who have not used it before, ClusterControl is an agentless management and automation software for databases. It supports MySQL (Oracle and Percona server), MariaDB, MongoDB (MongoDB inc. and Percona), and PostgreSQL.

For manual deployment, we’ll be using the popular “Google university” to …

[Read more] talks at Oracle Open World 2016

If you are in San Francisco for Oracle Open World, here is the list of talks by

MySQL’s State of the Dolphin and Customer Experiences:Experience from Nicolai Plum, MySQL System Design and Operations at MySQL X Protocol: Talking to MySQL Directly over the Wire MySQL Architecture Cookbook

I am not there myself, but feel free to go meet my colleagues and ask

Showing entries 151 to 160 of 36801
« 10 Newer Entries | 10 Older Entries »