Feed: Planet MySQL. Author: MySQL Server Dev Team. In the first part of this series you learned how to setup an InnoDB cluster using Oracle Cloud. In this second part, you are going to learn how and when to use some of the advanced functions available in MySQL Shell. Validating Instances Before doing anything else, you may want to […]
Read More
Feed: IBM Big Data & Analytics Hub – All Content . Author: andrea-braida. Most of us are privileged enough to live in societies where clean water is a given. When our physicians and the media advise us to stay hydrated, it’s a simple health consideration. But in many countries, access to water is a huge […]
Read MoreFeed: Databasejournal.com – Feature Database Articles. Author: . Transactions are the lifeblood of a relational database and Oracle is no exception. Key to this concept is the ability to replay those transactions should the need arise to recover ‘lost’ data due to a database crash, or worse, corruption requiring a restore and recovery. Yes, recording […]
Read More
Feed: Planet MySQL. Author: The Pythian Group. In this post I will explain how to transfer a multi terabyte size database between two MySQL instances using mydumper, which is a logical backup and restore tool that works in parallel. I will also cover the case where you need to transfer only a subset of data. Big […]
Read More
Feed: Planet MySQL. Author: Kristian Nielsen. New MariaDB/MySQL storage engines such as MyRocks and TokuDB have renewed interest in using engines other than InnoDB. This is great, but also presents new challenges. In this article, I will describe work that I am currently finishing, and which addresses one such challenge. For example, the left bar […]
Read More
Feed: Planet MySQL. Author: Markus Winand. Here is the most noteworthy news since my last “Big News In Databases” post from November 2016. A new SQL standard was released (SQL:2016) In December 2016, ISO released a new version of the SQL standard. It introduces new features such as row pattern matching, listagg, date and time […]
Read More
Feed: Planet MySQL. Author: The Pythian Group. Isolation levels are a rare subject in MySQL literature. The documentation provides a terse description and focuses mainly on locking issues, but does not discuss the semantics of each isolation level. This is not only a problem that affects MySQL documentation but also the SQL standard itself. Both […]
Read More
Feed: Planet PostgreSQL. Here is the most noteworthy news since my last “Big News In Databases” post from November 2016. A new SQL standard was released (SQL:2016) In December 2016, ISO released a new version of the SQL standard. It introduces new features such as row pattern matching, listagg, date and time formatting, and JSON […]
Read More
Feed: Planet PostgreSQL. There are a number of applications out there that have a high number of connections to Postgres. What’s high? That all depends on your application, but generally when you get to the few hundred connection area in Postgres you’re in the higher end. Anything in the thousands is definitely in the high […]
Read More
Feed: Planet PostgreSQL. Transactions are an important feature in any database and PostgreSQL has them. We want to be “ACID Compliant” and ensure that all data is read and written in a consistent state. All changes in the transaction either commit or rollback together. You never change just one table, without also changing all the […]
Read More
Recent Comments