MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.0 version is an alpha release of this product that intents to introduce users to the new features in this version.
One thing that gets tedious in the IT community and Oracle community is the penchant for Windows only solutions. While Microsoft does an excellent job in certain domains, I remain a loyal Apple customer. By the way, you can install Oracle Client software on Mac OS X and run SQL Developer against any Oracle Database server. You can even run MySQL Workbench and MySQL server natively on the Mac OS X platform, which creates a robust development platform and gives you more testing options with the MySQL monitor (the client software).
Notwithstanding, some Windows users appear to malign Apple and the Mac OS X on compatibility, but they don’t understand that it’s a derivative of the Research Unix, through BSD (Berkeley Software …
[Read more]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 Workbench has a migration feature: http://www.mysql.com/products/workbench/migrate/
- MySQLYog can be used to migrate: …
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
…