Big Data

One Billion Tables in MySQL 8.0 with ZFS

one billion tables MySQL

The short version
I created > one billion InnoDB tables in MySQL 8.0 (tables, not rows) just for fun. Here is the proof:

MySQL

$ mysql -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1425329
Server version: 8.0.12 MySQL Community Server – GPL

Copyright (c) 2000, 2018, Oracle and/or its […]

Read more

Don’t Drown in your Data Lake

Don't drown in your data lake

A data lake is “…a method of storing data within a system or repository, in its natural format, that facilitates the collocation of data in various schemata and structural forms…”1. Many companies find value in using a data lake but aren’t clear that they need to properly plan for it and maintain it in […]

Read more

This Week In Data with Colin Charles 37: Percona Live 2018 Wrap Up

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Percona Live Santa Clara 2018 is now over! All things considered, I think it went off quite well; if you have any comments/complaints/etc., please don’t hesitate to drop me a line. I believe a survey […]

Read more

Percona Live 2018: Securing Access to Facebook’s Databases

Andrew Facebook Percona Live 2018

We’re moving along at Percona Live 2018, and there are still packed and energetic talks after lunch.
My next session was with Andrew Regner, Production Engineer at Facebook. His talk was on securing access to Facebook’s databases.
Since the beginning, Facebook has used a conventional username/password to secure access to production MySQL instances. Over the last […]

Read more

This Week In Data with Colin Charles 36: Percona Live 2018

Colin Charles

Percona Live Santa Clara 2018! Last week’s column may have somehow not made it to Planet MySQL, so please don’t miss the good links at: This Week in Data with Colin Charles 35: Percona Live 18 final countdown and a roundup of recent news.
Back to Percona Live – I expect people are still going […]

Read more

Archiving MySQL Tables in ClickHouse

Archiving MySQL Tables in ClickHouse

In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics.
Why Archive?
Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. To name just a few issues:

The larger the table and index, the slower the performance […]

Read more

Percona Live Open Source Database Conference 2018 Call for Papers Is Now Open!

Percona Live

Announcing the opening of the Percona Live Open Source Database Conference 2018 in Santa Clara, CA, call for papers. It will be open from now until December  22, 2017.
Our theme is “Championing Open Source Databases,” with topics of MySQL, MongoDB and other open source databases, including PostgreSQL, time series databases and RocksDB. Sessions tracks include Developers, Operations […]

Read more

Percona Live Open Source Database Conference 2017 Slides and Videos Available

Percona Live

The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions.
To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and […]

Read more

From Percona Live 2017: Thank You, Attendees!

Percona Live

From everyone at Percona and Percona Live 2017, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s conference.
This year’s conference was an outstanding success! The event brought the open source database community together, with a technical emphasis on the core topics of MySQL, MariaDB, MongoDB, PostgreSQL, […]

Read more