With the recent Heartbleed bug, people are clearly more interested in their MariaDB/MySQL running with SSL and if they have problems. First up, you should read the advisory notes: MariaDB, Percona Server (blog), and MySQL (blog).
Next, when you install MariaDB (or a variant) you are usually dynamically linked to the OpenSSL library that the …
[Read more]Ok, so I wanted to look into the new compression options of MEB 3.10.
And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.
An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.
So, these tests are solely about backup. I’ll do restore when I get some *more* time.
First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:
Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.
mysqlbackup --user=root --password=oracle --socket=/tmp/mysql5614.sock \ --backup-dir=/home/mysql/MEB/test --with-timestamp …[Read more]
Ok, so I wanted to look into the new compression options of MEB 3.10.
And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.
An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.
So, these tests are solely about backup. I’ll do restore when I get some *more* time.
First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:
Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.
mysqlbackup --user=root --password=oracle --socket=/tmp/mysql5614.sock \ --backup-dir=/home/mysql/MEB/test --with-timestamp …[Read more]
Continuent would like to better understand the relationships and data flows that exist between different database systems that you are using to understand your replication and data integration needs better. In particular, we'd like to know about any heterogeneous data exchanges, including manual dump/load and automated process, and whether non-database sources, such as Twitter and Facebook,
Welcome to another post of the MySQL for Excel team, this
time we will talk about another cool feature you can find since
version 1.2.0, which can be downloaded directly from
our MySQL Installer downloads page.
If you want to learn how you can easily edit
connections directly from the main MySQL for Excel panel now
please read this post.
If you would like to give us your feedback and propose new
features you would like to see on future versions of MySQL for
Excel we encourage you to please visit our forum and leave us a comment.
Thank you for your support!
A potential customer asked my about porting her application from
Oracle Database to MySQL.
I always try to start with the "why" (a dear friend bought me
this book, recommended:
http://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447).
She said "cloud!". I said "OK!".
I conducted a short research, found many things in many places
all over the place, brought them to a nice email I sent her back
and then thought I'll post it here and make it public as it might
be useful for us all. If you feel that I missed something, add
comments, send feedback.
These are the leading tools to do the actual migration of the
data structure, data export/import, sprocs, triggers, etc.:
MySQL Fabric Testing :
MySQL Fabric is a simple and easy to use management system to handle High Availability and Sharding. MySQL SysQA team is responsible to test the MySQL Fabric at a system level.We do
1) Feature/Functional/Regression Testing
2) Complex/Integration/concurrent Testing
3) Scalability testing
4) Performance/Atomic Testing
5) Fabric Recovery/Security Testing
There are few test scenario examples below that the team is
performed to get a stable,robust application.
MySQL Fabric Testing Examples:
1) multiple activities performed at same time. e.g.
Shard split
promote a slave
insert records in a shard
demote another group
Dear MySQL Users,
MySQL Connector/NET 6.7.5, a new version of the all-managed .NET
driver for MySQL has been released. This is a Maintenance
release. It is recommended for production environments. It
is appropriate for use with MySQL server versions 5.0-5.7.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads
and mirror sites (note that not all mirror sites may be up to
date at this point-if you can't find this version on some mirror,
please try again later or choose another download site.)
Also Nuget packages are available:
http://www.nuget.org/packages/MySql.Data/6.7.5
…
Introduction
MySQL Enterprise Backup (MEB) 3.10 introduces support for encrypted backups by allowing backup images, or single-file backups, to be encrypted. However, backups stored in multiple files in a backup directory can not be encrypted.
Any MEB command that produces a backup image can be optionally requested to encrypt it. The encrypted backup image can be stored in a file or tape in the same way as an unencrypted backup image. Similarly, any MEB command that reads data from a backup image accepts also an encrypted backup image. This means that encrypted backups can be used in all the same situations as unencrypted backup images.
MEB encrypts data with Advanced Encryption Standard (AES) algorithm in CBC mode with 256-bit keys. AES is a symmetric block cipher which means that the same key is used both for encryption and decryption. The AES cipher has been adopted by the U.S. government and it is now used worldwide. …
[Read more]Today marks the release of several exciting pieces of software from Oracle. In addition to MySQL server 5.7.4 DMR, MySQL Fabric is out as a release candidate 1.4.2 and Connector/J 5.1.30 has full support. MySQL Fabric is a new way to implement high-availability and scale-out with MySQL server. It provides a way to group sets of servers into high-availability groups with automatic replication configuration. If scale-out is important, sharding can be defined in terms of these high-availability groups.
To use Connector/J with Fabric, you only need to add the jar to your classpath. If you are still using Java 5, you will need to manually load the com.mysql.fabric.jdbc.FabricMySQLDriver class to register the driver. Fabric-aware connections are made with a JDBC URL of the form jdbc:mysql:fabric://host:port/db. Several connection properties are available to influence the behavior of Fabric-aware connections. You can find the documentation for …
[Read more]