Devart is glad to release the new improved version of dbForge Studio for MySQL, v.6.1.

I’ve written a short course on MySQL backups. It’s really a MySQL backup starter kit, giving you the basics of what you need to make sure your system is protected. The real gem in this course is XtraBackup, which is a tool that allows you to backup your MySQL server without blocking other transactions. You see, MySQL doesn’t have that out of the box. You have to spend a bunch of money with Oracle to get that otherwise. Hot backups are pretty necessary if you care about uptime, so I’m excited about XtraBackup.

Here are the topics I cover:

Simple backups

Even though XtraBackup is a great tool, no MySQL user’s knowledge would be complete without knowing how to take a mysqldump. Simple backups are just useful for moving data from server to server, or perhaps migrating your data to, say, PostgreSQL.

Disaster Recovery Plans …

The MySQL team has been busy fixing bugs and sorting through older bugs. To give you a couple of recent stats:

• Norvald blogged about 14 bugs fixed at the request of Linux Distributions.
• Tomas Ulin’s keynote at Percona Live mentioned 1991 Bugs Fixed in 5.6, with 3763 Bugs Fixed in Total Since MySQL 5.5 GA

As part of our spring cleaning efforts, we have also decided to retire the bug status to be fixed later. That is to say that:

• Some bugs that were marked as to be fixed later have actually been fixed. Keeping a status of items that won’t be fixed for now has proven difficult to diligently maintain as accurate.
• We want to prevent a half-way state …

Early this month I spoke at linux.conf.au in Perth, Australia, where I presented “Past, Present and Future of MySQL and variants.”

Here’s my presentation in its entirety. Please let me know if you have any questions or comments. (linux.conf.au is widely regarded by delegates as one of the best community run Linux conferences worldwide.)

The post Past, present and future of MySQL and variants: linux.conf.au 2014 video appeared first on MySQL Performance Blog.

InfiniDB’s paper was likewise read and Mimer SQL was designed in the mid-1970s at Uppsala University. In 2016, this job was combined into an independent business. Mimer introduced trade management in programs, an idea which was later executed on most other InfiniDB databases for high robustness. Another data model, the entity-relationship model, came forth in […]

The first tutorial is a high level overview of how to install ProxySQL , and how to quickly configure and use it.



Install and compile ProxySQL


Installing and compiling ProxySQL is very straightforward:1) download and uncompress the source code from GitHub2) compile

Note:The following packages are needed in order to compile:- libssl and ibssl-dev (Ubuntu) or openssl and openssl-devel (Centos)- libglib2 and libglib2.0-dev (Ubuntu) or glib2 and glib2-devel (Centos)- libmysqlclient and libmysqlclient-dev (Ubuntu) or mysql-libs and mysql-devel (Centos)

Below an example:

vegaicm@voyager:~/proxysql$ wget -q https://github.com/renecannao/proxysql/archive/master.zip -O proxysql.zipvegaicm@voyager:~/proxysql$ unzip -q proxysql.zipvegaicm@voyager:~/proxysql$ cd …

You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications?
Register Now!

SPEAKER: Tim Callaghan, VP of Engineering at Tokutek
DATE: Tuesday, January 28th
TIME: 1pm ET

Join this interactive webinar with Tokutek’s VP of Engineering, Tim Callaghan, as he walks through the potential pitfalls when using MySQL or MariaDB for Big Data applications, and how to effectively use TokuDB to increase performance, reduce database size and achieve true schema agility.

Attend this webinar to learn:

The other day I was working on an issue where one of the slaves was showing unexpected lag. Interestingly with only the IO thread running the slave was doing significantly more IO as compared to the rate at which the IO thread was fetching the binary log events from the master.

I found this out by polling the SLAVE STATUS and monitoring the value of Read_Master_Log_Pos as it changed over time. Then compared it to the actual IO being done by the server using the pt-diskstats tool from the excellent Percona Toolkit. Note that, when doing this analysis, I had already stopped the slave SQL thread and made sure that there were no dirty InnoDB pages, otherwise my analysis would have …

MySQL is the little engine that could. It powers sites like Facebook, YouTube, Twitter, and thousands of blogs, CMSes, and e-commerce sites. Its value to the world and to the development community could be measured in the hundreds of billions, and yet it’s free, and you can use it just by downloading it. Almost every programming language has drivers for it and it can run on so many operating systems and architectures, there’s really no limit on it.

Yet there’s a dark side. MySQL is full of gotchas and bugs, and it lacks features that sometimes call into question its status as a real database. The documentation is often open-ended and confusing, with gaps in key parts. If you want to run it, you have the option of using it on Linux, Mac, Solaris, or Windows and every hosting company or provider like Amazon AWS has their own managed service, each with its own quirks and limitations. The user community has also produced thousands of …

The availability of the node.js binding for MariaDB’s non-blocking client library together with the GIS capabilities of MariaDB inspired me to make an example of using node.js and MariaDB to import so-called GPX tracks to a MariaDB database and then show them on a map. GPX tracks are what are stored by many GPS devices including running watches and smartphones.

My project makes use of MariaDB’s non-blocking client library together with the node.js platform and on top of that uses the GIS functionality found in MariaDB 5.5 and 10.0.

read more