Игорь Олемской — практические заметки по системному администрированию Linux CentOS

MySQL Worbench, the modeling, development and administration graphical tool for MySQL databases is now available as 5.2.40 (GA = stable). RPM for fedora and Enterprise Linux 6 are available in remi repository.

Read the Changes in MySQL Workbench 5.2.40.
RPM are available in my repository for fedora 13 to 17 and Enterprise Linux 6 (RHEL, CentOS, ...)
As always :
yum --enablerepo=remi install mysql-workbench
Of course, it was build with mysql-5.5.24.
This build still doesn't use the system mysql-connector-c++, because the bundled version includes not... Lire mysql-workbench-5.2.40

RPM of MySQL Community Server 5.5.24 GA are available in remi repository for fedora and Enterpise Linux (RHEL, CentOS, ...).

To read :

Introduction to MySQL 5.5
Changes in MySQL 5.5.24
MySQL 5.5 Reference Manual

This build use a spec file close to the one from Rawhide
WARNING: before upgrading, a full backup of your databases seems mandatory (a logical dump using mysqldump for example).
 
Simple to install, via yum:
yum --enablerepo=remi update mysql-server... Lire mysql-5.5.24

RPM of mydumper, a high-performance MySQL backup (and restore) tool, are available in remi repository for Fedora and Enterprise Linux.

This package will only work with MySQL 5.5.23 (and above) from my repository (see Bug mydumper #803982 and Bug RH #728634)
Installation :
yum --enablerepo=remi install mydumperIn addition to the speed, I really appreciate the backup layout
one folder for the backup
one file for the schema of each table
one file for the data of each table

To... Lire mydumper-0.2.3

RPM of MySQL Community Server 5.5.23 GA are available in remi repository for fedora and Enterpise Linux (RHEL, CentOS, ...).

To read :

Introduction to MySQL 5.5
Changes in MySQL 5.5.22
MySQL 5.5 Reference Manual

This build use a spec file close to the one from Rawhide
WARNING: before upgrading, a full backup of your databases seems mandatory (a logical dump using mysqldump for example).
 
Simple to install, via yum:
yum --enablerepo=remi update mysql-server... Lire mysql-5.5.23

RPM of the new major version of phpMyAdmin are available in remi repository for fedora and enterprise linux (RHEL, CentOS, ...).

Official web site : http://www.phpmyadmin.net/
This new major version will be available in the official updates for fedora or in EPEL-6. The package available in my repository also provides the official and compatible themes (even if this is against the packaging Guidelines :
1 source = 1 package). So, it is available for fedora 11 to 17 and... Lire phpMyAdmin version 3.5

My quest to get better at Python led me to create a new project on GitHub. It's called mysql-json-bridge and it's ready for you to use.

Why do we need a JSON API for MySQL?
The real need sprang from a situation I was facing daily at Rackspace. We have a lot of production and pre-production environments which are in flux but we need a way to query data from various MySQL servers for multiple purposes. Some folks need data in ruby or python scripts while others need to drag in data with .NET and Java. Wrestling with the various adapters and all of the user privileges on disparate database servers behind different firewalls on different networks was less than enjoyable.

That's where this bridge comes in.

The bridge essentially gives anyone the ability to talk to multiple database servers across different environments by talking to a single endpoint with easily configurable security and encryption. As long as the remote user can make an HTTP POST and parse some JSON, they can query data from multiple MySQL endpoints.

How does it work?
It all starts with a simple HTTP POST. I've become a big fan of the Python requests module. If you're using it, this is all you need to submit a query:

import requests
payload = {'sql': 'SELECT * FROM some_tables WHERE some_column=some_value'}
url = "http://localhost:5000/my_environment/my_database"
r = requests.post(url, data=payload)
print r.text

The bridge takes your query and feeds it into the corresponding MySQL server. When the results come back, they're converted to JSON and returned via the same HTTP connection.

What technology does it use?
Flask does the heavy lifting for the HTTP requests and Facebook's Tornado database class wraps the MySQLdb module in something a little more user friendly. Other than those modules, PyYAML and requests are the only other modules not provided by the standard Python libraries.

Is it fast?
Yes. I haven't done any detailed benchmarks on it yet, but the overhead is quite low even with a lot of concurrency. The biggest slowdowns come from network latency between you and the bridge or between the bridge and the database server. Keep in mind that gigantic result sets will take a longer time to transfer across the network and get transformed into JSON.

I found a bug. I have an idea for an improvement. You're terrible at Python.
All feedback (and every pull request) is welcome. I'm still getting the hang of Python (hey, I've only been writing in it seriously for a few weeks!) and I'm always eager to learn a new or better way to accomplish something. Feel free to create an issue in GitHub or submit a pull request with a patch.

mysql-json-bridge: a simple JSON API for MySQL is a post from: Major Hayden's Racker Hacker blog.

Thanks for following the blog via the RSS feed. Please don't copy my posts or quote portions of them without attribution.

• munin-node installed via epel repository.
• Install perl-Cache-Cache:
  # yum install munin-node perl-Cache-Cache
• Create file «/etc/munin/plugin-conf.d/mysql» with below contents:
  [mysql*]<br />env.mysqluser munin<br />env.mysqlpassword {PASS}
• Create mysql user and assign corresponding privileges:
  mysql> create user munin@localhost identified by '{PASS}';<br />mysql> GRANT PROCESS, SUPER ON *.* TO 'munin'@'localhost';<br />mysql> GRANT SELECT ON `mysql`.* TO 'munin'@'localhost';<br />mysql> flush privileges
• Check the suggestions and install the plugins:
  munin-node-configure  --suggest 2>/dev/null |grep mysql<br />munin-node-configure  --shell | grep mysql | sh
• Test via:
  # cd /etc/munin/plugins<br /># munin-run mysql_connections

read more

RPM of MySQL Community Server 5.5.22 GA are available in remi repository for fedora and Enterpise Linux (RHEL, CentOS, ...).

To read :

Introduction to MySQL 5.5
Changes in MySQL 5.5.22
MySQL 5.5 Reference Manual

This build use a spec file close to the one from Rawhide
WARNING: before upgrading, a full backup of your databases seems mandatory (a logical dump using mysqldump for example).
 
Simple to install, via yum:
yum --enablerepo=remi update mysql-server... Lire mysql-5.5.22

MySQL Worbench, the modeling, development and administration graphical tool for MySQL databases is now available as 5.2.38 (GA = stable). RPM for fedora ≥ 13 and Enterprise Linux 6 are available in remi repository and will be soon in official updates for fedora ≥ 15.

Read the Changes in MySQL Workbench 5.2.38.
RPM are available in my repository for fedora 13 to 16 and Enterprise Linux 6 (RHEL, CentOS, ...)
As always :
yum --enablerepo=remi install mysql-workbench
Of course, it was build with mysql-5.5.21.
This version will be soon available in official updates for:

fedora 16
fedora 15

This build... Lire mysql-workbench-5.2.38

RPM of MySQL Community Server 5.5.21 GA are available in remi repository for fedora and Enterpise Linux (RHEL, CentOS, ...).

To read :

Introduction to MySQL 5.5
Changes in MySQL 5.5.21
MySQL 5.5 Reference Manual

This build use a spec file close to the one from Rawhide
WARNING: before upgrading, a full backup of your databases seems mandatory (a logical dump using mysqldump for example).
 
Simple to install, via yum:
yum --enablerepo=remi update mysql-server... Lire mysql-5.5.21