The Oracle Linux and Virtualization Documentation Team is seeking
an experienced Technical Writer
with a focus on writing documentation for the Oracle Linux
product. (The MySQL Documentation Team is part of that group as
well.)
Applicants should be located in either Ireland, the UK, Sweden, Norway, …
[Read more]
The Oracle Linux and Virtualization Documentation Team is seeking
an experienced Technical Writer
with a focus on writing documentation for the Oracle Linux
product. (The MySQL Documentation Team is part of that group as
well.)
Applicants should be located in either Ireland, the UK, Sweden, Norway, …
[Read more]Similar to my other catch-all pages on Server Variables, Changelogs, and Documentation, I’ve added a new ‘Downloads’ section.
Basically, it’s just a single source containing links to all of your favorite MySQLs and related products, such as MySQL, MariaDB, XtraDB, Xtrabackup, MySQL Proxy, Connectors and more:
http://www.chriscalender.com/?page_id=831
Hope this helps.
I'm pleased to announce the release of Spider storage engine
version 2.28(beta) and Vertical Partitioning storage engine
version 0.17(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical
partitioning for a table.
http://launchpad.net/vpformysql
Please use the following for downloading binary file.
http://spiderformysql.com/download_spider.html
The main changes in this version are following.
Spider
- Support parallel searching. ("spider_bgs_mode > 0")
The table using the Spider bundled MySQL and table partitioning
performs parallel search of each partition. However, parallel
search is not …
We are excited to announce that we’ve been named as one of ten finalists selected for the startup showcase at the O’Reilly Strata “Making Data Work” Conference at the end of this month in Santa Clara, California. The startup showcase will be held on February 29th, starting at 6:30 pm.
The conference offers a great overview of the big data space, with tracks on Data Science, Business and Industry, Visualization and Interfaces, Hadoop Applied, Hadoop Tech, Policy and Privacy, and Domain Data. With all of the “NoSQL” buzz and sessions at the show (Hadoop gets two tracks!), we are glad …
[Read more]
In a previous post, I had explained how to use MySQL's optimizer tracing, a new
feature which appeared in MySQL 5.6.3.
As a developer, it feels really good to see others adopt my work
and make something useful out of it! My colleague Dimitri
Kravtchuk, who is one of our top Benchmarking experts, has
written a blog post where he shows how the optimizer tracing has
helped him to figure out why, under load, once in a while and
randomly, a query performed badly. His investigation technique
may be reusable by other people, so I encourage you to read more
about it, here.
After the recent update to pt-table-checksum, I’ve seen a few FAQs about it.
Q: is it still multi-threaded/parallel? A: No, that was a pile of bugs and complexity. If you need to run the tool in parallel to take advantage of powerful hardware, you can run several instances, say, one per database.
Q: what chunk size should I use? A: None, let the tool adjust itself dynamically.
Q: what if it skips a table or chunk because it’s oversized? A: this should be rare unless you have tables without any indexes; if you want to do the table in one chunk, run the tool again and specify to checksum only that table, with an appropriately large chunk size. This is one of the rare cases where you will need to specify a chunk size.
Q: what commandline options should I use after upgrading? A: It has sensible defaults for everything, and is designed to run without any options at all in most cases. If you’re upgrading from …
[Read more]It might surprise you to hear this, but I had no idea whether my talks would be accepted. The committee decided on that, and neither I nor anyone else at Percona is on the committee. In any case, I’ll be giving some tutorials again this year, and two of my talks have been accepted: Measuring Scalability and Performance With TCP and Diagnosing intermittent performance problems.
This seems like an appropriate place to mention a few words about the conference organization. The number of people involved is staggering (100+). The logistics — the number of tasks, vendors, …
[Read more]Percona is glad to announce the release of Percona Server 5.5.20-24.1 on February 9th, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.20, including all the bug fixes in it, Percona Server 5.5.20-24.1 is now the current stable release in the 5.5 series. All of Percona ‘s software is open-source and free, all the details of the release can be found in the 5.5.20-24.1 milestone at Launchpad.
Full release notes available here: …
[Read more]Un-maned Failover Operations
I have video of two MySQL servers (one master, on slave) failing over from Master to Slave. The Master becomes the Slave and vise-verse with the slave becoming read-only. Next some load testing and then I’ll post how I did it with FREE software.