MariaDB 10.0.7 was recently released (it is the latest MariaDB 10.0), is currently "beta", and is available for download here:
https://downloads.mariadb.org/mariadb/10.0.7/
I just wanted to note a couple of the main highlights, which are:
We are pleased to announce that MySQL Enterprise Monitor 3.0.6 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud with the February update in about 1 week. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.
You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.
You will also find the binaries on the Oracle Software Delivery Cloud in approximately 1 week. Choose "MySQL Database" …
[Read more]William Zola over at MongoDB gave a great talk called “The (Only) Three Reasons for Slow MongoDB Performance”. It reminded me of an interesting characteristic of updates in MongoDB. Because MongoDB’s main data store is a flat file and secondary indexes store offsets into the flat file (as I explain here), if the location of a document changes, corresponding entries in secondary indexes must also change. So, an update to an unindexed field that causes the document to move also causes modifications to every secondary index, which, as William points out, can be expensive. If a document has indexed an array, this problem is exacerbated.
What …
[Read more]
The first blogpost in this series did a quick
introduction to MaxScale, but now it is time start getting our
hands dirty. We will get a more practical view on MaxScale and
begin to put it to work. The following is based on a simple Proof
of Concept that I did recently. The application is a mid-size
web-based online shop where scalability is becoming an issue.
They use PHP and with an old and rather inflexible framework, so
even though changing how the database is used is possible, it's
not easy and having database routing in the application code
isn't a very good idea either.
The scalability issues affects reads, but as all traffic is
directed to one database server, when this server gets slow,
writes, like when entering an order, gets very slow, and this is
unacceptable. So what was needed is a way to redirect reads to …
Here in Percona Support, we’re receiving several requests per day for help with Percona Cloud Tools installation steps.
So I decided to prepare a step-by-step example of the installation process with some comments based on experience. Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses. After a brief setup, you’ll unlock new information about your database and how to improve your applications. You can sign up here to request access to the free beta, currently under way.
Some notes
FOSDEM in Brussels, Belgium was a great community event again this year. The MySQL community booth was maned by Oracle MySQL, Percona, Galera and MariaDB. Thanks Kenny, Liz & co for also organising a fun community dinner on Saturday! The MySQL dev room was packed with participants listening to some very interesting presentations, amongst them MaxScale, which got some considerable interest from the audience.
I came across a scenario where we were concerned about the size of a table, a 134G table, its a pretty huge table and growing fast. The nature of the table – its a table which contains logs , sort of a audit table. Some fundamental questions around this table’s use: 1) would it have a lot of reads ? — Answer – No 2) is it always insert only? — Answer – Yes 3) current strategy to restrict size ? — Answer – delete data from table. 4) does one need backup of the table, i.e. is it very important ? — Answer – No Well based on the above, it would seem that logging is the theme. Schema of the table: CREATE TABLE `SystemLogs` ( `column1` varchar(255) DEFAULT NULL, `column2` varchar(255) DEFAULT NULL, `column3` varchar(255) DEFAULT NULL, `column4` varchar(255) DEFAULT NULL, `column5` text, `column6` text, `timestamp` datetime DEFAULT NULL, `id` int(11) …
[Read more]Hi I installed mysql on ubuntu 12.04 LTS with ActivedDirectory Integration, I followed your step, and I amd getting two errors. One is with PHPMYADMIN, I gett the following message. “#1698 Cannot log in to the MySQL server”.
The second error is with mysqlworkbench I get the following error:
Failed to Connect to MySQL at 192.168.0.12:3306 with user bmilitzer.
Access denied for user ‘bmilitzer’@’mgc-01.mgc.com’ I tried adding the user by using the following command.
create user ‘bmilitzer’@’mgc-01.mgc.com’ identified with auth_pam;
But no luck, I just am stuck at this point.
This is the first in a series of posts highlighting a few of the seldom-used but still handy Percona Toolkit tools.
Have you ever had a problem understanding the EXPLAIN statement output? And are you the type of person who would rather use the command line than a GUI application? Then I would recommend that you use Percona’s pt-visual-explain toolkit. This is one of many Percona Toolkit tools that is useful for those who want to have a different view and an easier time understanding the EXPLAIN output aside from the usual table and vertical views.
As described in the documentation – http://www.percona.com/doc/percona-toolkit/2.2/pt-visual-explain.html#description
“pt-visual-explain reverse-engineers …
[Read more]Whether you are a database administrator, database application developer, web developer, system administrator or system architect, if you are working with a database system such as the MySQL Server, you will want to ensure the best possible performance.
To learn about the great performance you can get from a MySQL Database, visit Dimitri's blog.
If you have experience maintaining a database server, can use MySQL tools and have knowledge of general SQL statements and SQL tuning principles, consider taking the MySQL Performance Tuning course. In this 4-day instructor-led course, you will learn about: