The inaugural Meet-up Oklahoma City MySQL Meetup is Wednesday, July 23, 2014!
As a special guest speaker, Peter Zaitsev (CEO of Percona and co-author of High Performance MySQL) will be giving a presentation on “Best Indexing Practices”, followed by a Q/A session.

Please RSVP if you plan to attend so we can get a good headcount for food and beverages that will be provided and as always, please spread the word to friends or colleagues in the industry.

It should be a great night and great first event for the MySQL user group in OKC!

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result.

Let me describe what we use, and later I will explain why.

Server:

• Chassis: Supermicro SC825TQ-R740LPB 2U Rackmount Chassis
• Motherboard: Supermicro X9DRI-F dual socket
• CPU: Dual Intel Xeon Ivy Bridge E5-2643v2 (6x 3.5Ghz cores, 12x HT cores, 25M L3)
• Memory: 256GB (16x 16GB 256-bit quad-channel) ECC registered DDR3-1600
• Raid: LSI MegaRAID 9260-4i 4-port 6G/s hardware RAID controller, 512M buffer
• MainStorage: PCIe SSD HGST FlashMAX II 4.8TB
• Secondary Storage (OS, logs): RAID 1 over 2x 3TB hard drives

July 22, 2014 By Severalnines

We just wanted to make it official: Severalnines ClusterControl now supports MariaDB 10!

As most of you know will know by now, MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database system. Whilst remaining application-compatible with the MySQL database, it adds many new capabilities to address the most challenging web and enterprise application use cases. Cluster deployments would be based on MariaDB Galera Cluster 10, which is a complete merge of MariaDB 10.0.12 and Galera Cluster. 

ClusterControl for MariaDB Clusters

ClusterControl gives you the power to deploy, manage, monitor and scale entire MariaDB Galera clusters efficiently and …

MySQL Fabric is an extensible framework for managing farms of MySQL Servers. Two features have been implemented - High Availability (HA) and scaling out using data sharding. These features can be used in isolation or in combination. (Ref : www.mysql.com/products/enterprise/fabric.html)


The following setup is configured to prepare the MySQL Fabric HA environment.  (Sharding is to be discussed later.)


Creating the MyGroup1 with 1 Master and 3 slaves as shown above where the port numbers for the MySQL Servers are to be configured as 3316, 3326, 3336 and 3346.  The MySQL Fabric Server has the MySQL as the backing store which the setup uses 3306.  The whole setup with this tutorial is configured on a single machine.  But you can freely extended this to multiple machine …

#DBHangOps 07/24/14 -- More Indexing!

All done for this week! Check out the recording below:

Hello everybody!

Join in #DBHangOps this Thursday, July, 24, 2014 at 11:00am pacific (18:00 GMT), where we pick up on our last conversation about indexing:

• Indexing

  • More discussion on geo spatial indexes
  • Fulltext indexing and ranking
  • MariaDB indexing features (From Gerry!)
  • Anything else indexing!

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the …

Dear MySQL users,

MySQL Connector/Net 6.9.2 a new version of the all-managed .NET driver for MySQL has been released. This is a RC release for 6.9.x and is not recommended for production environments.

It is appropriate for use with MySQL server versions 5.5-5.7.

It is now available in source and binary form fromhttp://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites

(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.)

Enjoy and thanks for the support!

On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on July 21st 2014. Binaries are available from downloads area or from our software repositories. We’re also happy to announce that Ubuntu 14.04 LTS users can now download, install, and upgrade Percona XtraDB Cluster 5.6 from Percona’s software repositories.

Based on Percona Server …

Dear MySQL users,
MySQL for Visual Studio is a product including all of the Visual Studio integration. The 1.2.2 version is a release candidate release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments.
This version is appropriate for use with MySQL server versions 5.5-5.6.

From another web page:

"I'm not sure that loading a 1GB dump file into MySQL is a particularly good idea - it's not the most stable piece of software and I've had issues with smaller dumps than that before." March 29, 2013

It really irritates me when people says stupid things when the problem is their own incompetence or inexperience. Now let's think about this for just a second. MySQL is certainly one of the most popular databases powering the Internet. It is used extensively in tiny little sites like Google and Facebook. It is far from unstable. I routinely work on systems that have uptimes of many months if not years. Normal behavior is that the server is up until it needs be upgraded. I have worked on systems that executes tens of thousands of queries a second as a typical part of their usage patterns. And I have loaded SQL dump files that where well over 100 gigabytes in size. This little …

InfiniDB Adds New Resources and Incentives for Channel Partners, Value Added Resellers and System Integrators to Sell and Build Applications with the InfiniDB High Performance Analytic Database