The latest pip versions will fail on you when the packages it needs to install are not hosted on PyPI. When you try to install MySQL Connector/Python the usually way, you get following message is:

shell> pip install mysql-connector-python
  Could not find any downloads that satisfy the requirement 
    mysql-connector-python
  Some externally hosted files were ignored 
    (use --allow-external mysql-connector-python to allow).

I have updated the download URL to include the MD5 checksum, and MySQL Connector/Python should now install using pip using following command:

shell> pip install --allow-external mysql-connector-python \
  mysql-connector-python

Yes, you have to repeat the mysql-connector-python name. …

Atos is an international information technology services company with annual revenue of EUR 8.8 billion and 77,100 employees in 52 countries. Serving a global client base, it delivers IT services in 3 domains, Consulting & Technology Services, Systems Integration and Managed Services & BPO and transactional services through Worldline.

In 2009 Atos was asked to drastically reduce the costs of the UCS application (Universal Clearing System): the compensation engine for the Euronext Cash (stocks and bonds) and derivatives markets in the Euro zone. In the financial sector, clearing is exercised by aggregating all purchases and sales by the type of product/assets held by each account holder, resulting in a balance of net payables or receivables as well as the net flows of securities delivered or received.

Challenges 

• Migrate from a proprietary HP NonStop-SQL/MP environment towards an open source …

We've got a few exciting things going on and we wanted to keep everyone in the loop.

MySQL Newsletter

We've started a MySQL Newsletter which is something we've decided to do after we couldn't find any good summary MySQL newsletters out there.

The goals are:

• Publish exactly ten articles summaries per week

• Cover the most interesting MySQL and related news stories, blog posts, and open source projects

• Engage with the community about important stuff

So, please signup, tell your friends, check out our first issue, and email interesting things to info@mysqlnewsletter.com.

Percona Live Santa Clara

We are sponsors for …

Recently I checked a MySQL database for duplicate indexes using common_schema, and I want to share my approach. Before I get into the details, I want to define what I mean by duplicate indexes. In the past I've used the terms duplicate index and redundant index somewhat interchangeably, so now that I have my own definitions straight I want to write them down:

• A duplicate index is an index of the same type (BTREE, HASH, FULLTEXT, etc) that includes the same column(s) in the same order as another index. For example KEY name2 (name) is a duplicate of KEY name1 (name), and KEY (name) is a duplicate of UNIQUE KEY (name).
• A redundant index is an index of the same type that includes a prefix of another index. For example if a table has both KEY …

I write this post over to have a quick access to this tutorial than to promote the blog. The problem For Several times this has happened to me, always install a new server, or personal machine. I install mysql ,… Continue Reading →

Continue reading Correcting mysql.sock connection error

Related posts:

1. Corrigindo erro de conexão com mysql.sock
2. zend framework 2 with lighttpd
3. Main Subversion commands

Over the years you collect datasets you have created for various types of testing, seeding databases etc. I have always thought one needs to better manage this for future re-use. Recently I wanted to do some “Big Data” playing and again that question of what datasets can I use let me to review the past collated list at Seeking public data for benchmarks.

The types of things I was wanting to do lead me to realize a lot of content is “public domain” and Project Gutenberg is just one great source of text in multiple languages. This was just one aspect of my wish list but text based data is used from blogs, comments, articles, microblogs etc, and multiple languages was important from some text analysis.

With a bit of thinking about the building blocks, I created …

Troubleshooting MySQL on Amazon can be a real test of patience. There are quite a few different things to watch out for in terms of connectivity & networking. Sometimes a checklist can help. Join 16,000 others and follow Sean Hull on twitter @hullsean. Here’s my exhaustive list of things that can block you. 1. Be […]

It is common practice to grant your application the privileges of “GRANT SELECT, INSERT, UPDATE, DELETE ON yourdb.* TO user@host”.

But what if you want to ensure you cannot DELETE data from just one table?

Ideally I want to be able to “REVOKE DELETE ON yourdb.important_table FROM user@host”. You cannot do currently this with the MySQL privilege system.

If your schema has 100 tables, and you want to remove DELETE from one, you have to define DELETE for the 99 others, and remember that for each new table, you need to remember to also modify user privileges.

The MariaDB CONNECT Storage Engine allows to access heterogeneous data sources. In my previous post I show you how to use the MariaDB CONNECT Storage Engine to access an Oracle database. This is quite easy through the CONNECT Storage Engine ODBC table type.

For most architectures where heterogeneous databases are involved an ETL (Extract-Transform-Load) is [...]

Whenever I have a problem query in MySQL, I say to myself, I know, I’ll use Explain Plan. Now I have two problems. I run the explain plan, but then I have to look up all the cryptic terms and read through the documentation to know what in the world is going on. Well, over the weekend, I decided to solve my own problem. I created a simple page that allows you to run an explain plan, and then each of those obscure, abbreviated terms is annotated with a tooltip that explains exactly what’s going on. I’m calling it MySQL Explain Explained.

I created a demo using the sample employees database (which you can download here). Here’s a sample query:

select gender, count(emp_no) as manager_cnt, sum(cnt) as sum, avg(cnt) as avg
from
(
    select m.emp_no, m.gender, count(de.emp_no) as cnt
    from …