Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 36150 10 Older Entries
London roadshow wrap-up, see you in Paris next week
+0 Vote Up -0Vote Down

Just a few days ago, I presented at the MariaDB Roadshow in London, and I had a lot of fun. While I had canned slides, I did know the topic intimately well, so it was good to get further in-depth. In addition, we had these MasterMind sessions, basically the place to get one-on-one time with Anders/Luisa/or me, I noticed that pretty much everyone said they were buying services afterwards (which more or less must mean the event was rather successful from that standpoint!).

In addition to that, I was happy to see that from attendee …

  [Read more...]
Keyring framework
Employee_Team +1 Vote Up -0Vote Down

Security these days is bigger than ever. This statement needs no proof. It seems like it is getting easier and easier to get access to ‘secure data’. As system grows it becomes really hard to secure all endpoints. This is why encrypting data is now the hot topic in the database world.…

Oracle Linux 7, MySQL 5.7.12 and YUM for JSON Document Store Part 1
Employee +1 Vote Up -0Vote Down

Okay, I will admit that I grew up professionally without package management. Well, we did have SSCS and RCS under Unix and a lot of very brilliant shells scripts but nothing modern programmers would deign to touch. Then came Linux Torvalds (and why hasn't he been given a Nobel prize?!?!) and I blundered into the Redhat world with their RPM package manager. RPMS are great but over time I was seduced by Ubuntu and became and became an apt-get fiend.

Now I need to do a demo of the new MySQL 5.7.12 Document store features on an RPM based distro, Oracle 7.1. I could have used a Vagrant or Docker image but ended up using VirtualBox. …

  [Read more...]
MySQL encrypted streaming backups directly into AWS S3
+0 Vote Up -1Vote Down

Overview

Cloud storage is becoming more and more popular for offsite storage and DR solutions for many businesses. This post will help with those people that want to perform this process for MySQL backups directly into Amazon S3 Storage. These steps can probably also be adapted for other processes that may not be MySQL oriented.

Steps

In order to perform this task we need to be able to stream the data, encrypt it, and then upload it to S3. There are a number of ways to do each step and I will try and dive into multiple examples so that way you can mix and match the solution to your desired results.  The AWS S3 CLI …

  [Read more...]
Comment on Significant performance boost with new MariaDB page compression on FusionIO by alexandre
+0 Vote Up -0Vote Down

Hi Jan really thanks for looking over this. Im testing MariaDB 10.1.13 64bit Windows server 2012. rebuild innodb tables with 64k pages and NTFS is 4k clusters. Had to recreate the performance and gtid tables manually (mysqldump) to get rid of missing tables message. The idea is to not punch holes (or avoid it the most). I think i can bear the overhead of 64kpages since my current myisam tables are in windows compressed folders.. . What is hard to bear is that innodb tables+indexes are at least 3 times larger than my MyISAM tables…

compression is zlib (tried with compression level from 1 to 9) and the installer …

  [Read more...]
ProxySQL versus MaxScale for OLTP RO workloads
+1 Vote Up -0Vote Down

In this blog post, we’ll discuss ProxySQL versus MaxScale for OLTP RO workloads.

Continuing my series of READ-ONLY benchmarks (you can find the other posts here: https://www.percona.com/blog/2016/04/07/mysql-5-7-sysbench-oltp-read-results-really-faster/ and https://www.percona.com/blog/2016/03/28/mysql-5-7-primary-key-lookup-results-is-it-really-faster), in this post I want …

  [Read more...]
Properly removing users in MySQL
+0 Vote Up -1Vote Down

Removing users in MySQL is an easy task, but there are some drawbacks to check carefully before dropping a user. Not taking these possible issues into consideration can render your application unusable.

First it is important to understand the concept of user in MySQL. A user has three main functions: authentication, privileges and resources. This is different from other databases: in MySQL users don’t own objects. An object belongs to a database and there is no direct relationship between objects and users. This simplifies the process of deleting a user because no objects will be erased.

But users, as I wrote before, have an associated set of …

  [Read more...]
Planets9s - Download our MySQL Replication Blueprint Whitepaper
+0 Vote Up -0Vote Down

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Download our MySQL Replication Blueprint Whitepaper

Our new whitepaper, The MySQL Replication Blueprint, discusses all aspects of a MySQL Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies as ProxySQL, MaxScale and HAProxy. This is a great resource for …

  [Read more...]
Comment on Significant performance boost with new MariaDB page compression on FusionIO by alexandre
+0 Vote Up -0Vote Down

Im currently using mariadb 10.1.13 on windows and i would like to know if xtradb does support compression on windows. do i need to swap xtradb for innodb plugin in order to have compression? does index pages get compressede too?

MySQL/MariaDB cursors and temp tables
+0 Vote Up -0Vote Down

In MariaDB and MySQL, cursors create a temporary table.

Does this statement deserve a whole blog post? Apparently not. However, in some cases one does not expect a temporary table to be created:

  • SELECT ... FOR UPDATE: An exclusive lock is created, yes, but you still read data from a temporary table.
  • SELECT FROM a temporary table: you are reading from a temporary tables, yes, but an internal temporary table is created anyway.
  • Impossible WHERE and LIMIT 0.

A quick example:

CREATE TEMPORARY TABLE …
  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 36150 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.