When we first started building Pinterest, we used Python as our development language, which helped us build quickly and reliably. Over the years we built many  tools around Python, including Pinball, MySQL_utils and pymemcache, as well as a set of libraries  used  daily for service communication and configuration management. Today we’re releasing this toolset, KingPin, as our latest open-source package. 

KingPin contains some of the best practices we learned when scaling Pinterest, including:

• A local daemon to deal with the ZooKeeper’s single point of failure (SPOF) …

Percona is glad to announce the release of Percona Server 5.5.48-37.8 on March 4, 2016. Based on MySQL 5.5.48, including all the bug fixes in it, Percona Server 5.5.48-37.8 is now the current stable release in the 5.5 series.

Percona Server is open-source and free. Details of the release can be found in the 5.5.48-37.8 milestone on Launchpad. Downloads are available here and from the …

In this example i am going to show you how to generate randomly alphanumeric string OR number in PHP when you need you generate random alphanumeric string for your unique field then you can easily create using substr md5 rand uniqid mtrand time and strshuffle php function you c

Whenever you need to use each loop in jquery then you can follow this example code each with html class you can get whole object of that class using this jquery function In following example you can see i get attribute dataid using thisdataid that means you can take current class data

In the coming weeks, Oracle Technology Network welcomes you to join the Virtual Technology Summit which is a half-day online conference with multiple tracks.  This time there is a MySQL track, and I will do a presentation on Analyze & Tune MySQL Queries for Better Performance.  The MySQL track also contains a presentation on MySQL 5.7, and a presentation on how to use Oracle Enterprise Manager to manage MySQL databases.
There will be three events with the same program, but at different times to best suit different parts of the world.   The first opportunity is the Americas event on March 8.  Later, there will be events for Asia/Pacific (March 15) and Europe/Middle East/Africa (April 5).  
To register, go to the pages for the …

When using a multi-threaded slave, the STOP SLAVE command could take a long time to return because the slave waited for workers to catch up processing the queue. This blog post is about improvements that have been made in MySQL 5.6.26 and later to ensure that STOP SLAVE returns quickly when using a multi-threaded slave (MTS).…

In this post we have learn how to import CSV file using LOAD DATA INFILE statementthis is a very simple example for a import file to the databaseHere we have provide a full sysntax for LOAD DATA INFILE statementstrongSysntaxstrongpre classlanguagemysqlLOAD DATA LOWPRIORITY C

In this post we have learn how to import CSV file using LOAD DATA INFILE statementthis is a very simple example for a import file to the databaseHere we have provide a full sysntax for LOAD DATA INFILE statementstrongSysntaxstrongpre classlanguagemysqlLOAD DATA LOWPRIORITY C

That means we’ve accomplished all our planned overhauls of client APIs and backward-incompatible protocol changes. See the release notes for what’s new. We’re now working closely with several users who are evaluating Vitess and providing feedback on the use cases that are important for their particular applications and production environments. If you’re at the same stage, we welcome you to join the discussion by posting on the mailing list. We’re also trying out Slack for more conversational topics.

Unfortunately (or fortunately?), no privilege is required to execute native functions (including SLEEP).

The SLEEP() attack can be dangerous. Think about websites: if SQL is injected into the SQL queries that read data necessary to make the home page appear, and there is no caching system, no user will be able to see the home page for X seconds.

If you don’t trust your applications, IMHO, there is only one way to prevent those attacks: on MariaDB and old MySQL versions, it’s MaxScale; on MySQL 5.7 it’s the query rewriting plugin.

Another way could be only GRANTing the permission to execute stored procedures… but if you can do that, your company has control on the applications, so simpler solutions are possible.