Come see Doron Levari speak about MySQL scalability at Seattle MySQL meetup: http://t.co/qdsUkSsG
May
03
2012
May
03
2012
The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides here.
I got a lot of questions, and did not have enough time to answer all of them, so let me try to answer some of the remaining questions here.
Q: Isn’t it possible to take all the locks required in the beginning to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that would cause blocking that would defeat the purpose of the tool.
Q: When you say bail out, what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting a run. will that cleanup ? Q: dose the tool exit gracefully while interupted? The tool doesn’t clean up the temporary table or triggers. It is designed …
[Read more]
May
03
2012
I got a really intriguing email today. As you might imagine, I get a lot of email offering to advertise, or trade links, or guest post, etc etc. But this is the most compelling one I’ve ever gotten: I came across your blog /blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/ a few weeks ago as while conducting research for a website that I contribute to. The website aims to look at the progressive areas of early childhood psychology.
May
02
2012
Today we will talk how do you can easily rename a database in
MySQL.
At the MySQL version 5.1.7 was added a command to do this job
named RENAME DATABASE
RENAME {DATABASE | SCHEMA} db_name TO new_db_name;
But it was removed on the MySQL version 5.1.23 because maybe it would result in data lost’s like you can see on this link of MySQL documentation
Then, lets see some ways which we can do this:
1. Using the RENAME TABLE command
As long as two databases are on the same file system, you can use RENAME TABLE to move a table from one database to another:
RENAME TABLE current_db.tbl_name TO
other_db.tbl_name;
RENAME TABLE Syntax na Documentacao do MySQL
…[Read more]
May
02
2012
MySQL storage engine provider joins forces with leading database consultants to deliver support for growing number of MySQL and MariaDB customers
Lexington, MA – (May 2, 2012) – Tokutek, the leader in high-performance and agile database storage engines, today announced a strategic partnership with PalominoDB, a premier database operations and engineering consultancy, to provide database services and support to joint customers. Tokutek’s storage engine will be complemented with PalominoDB’s operational excellence, 24×7 on-call support and access to the company’s skilled team of professional database administrators (DBAs).
“TokuDB has immeasurably improved our ability to react to changing business …
[Read more]
May
02
2012
www.accelerationdb.com
Table of Contents Background 3 MySQL High
Availability and synchronous replication 3 About Continuent
Tungsten 3 About MySQL MHA 4 Production Readiness 4 Development
Tools 5 Architecture 5 MHA 5 MHA deployment diagram 6 MHA
failover diagram 7 Continuent Tungsten 8 Tungsten Deployment
Diagram 11 Tungsten Failover Diagram 12 Installation 13 MHA 13
Tungsten 13 Management 13 MHA 13 Tungsten 14 Open Source 14
Conclusion
BackgroundWe selected two MySQL High Availability solutions - MHA
from http://code.google.com/p/mysql-master-ha/and
Continuent Tungsten Enterprise from www.continuent.com. Both suites of applications
MHA and Tungsten deliver MySQL high availability, both of them
operate in asynchronous …
May
02
2012
The MySQL Connect Call for Papers closes on May 6 so you only have a few days left to submit your session proposals! Thanks to all of you who already submitted conference sessions and BOFs.
MySQL Connect represents a tremendous opportunity for you to present your real-world experience and share your expertise and best practices with the MySQL community.
Interested in sponsorship and exhibit opportunities? You will find more information here.
We look forward to hearing from you!
May
02
2012
Following my previous benchmarks of SATA SSD cards I got
Intel SSD 520 240GB into my hands. In this
post I show the results of raw IO performance of this card.
The benchmark methodology I described in previous posts, so let me jump directly to results.
First case is random write asynchronous 8 threads IO,
the test is done just after a secure erase operation on the
card.
The card is doing stable 380 …
[Read more]
May
02
2012
Please join me tomorrow (Wednesday) for a webinar about the new version of pt-online-schema-change, Percona Toolkit’s tool for performing nonblocking ALTER TABLE operations. Registration is free. I will explain how the tool works and cover some typical use scenarios. This might be helpful if you’re trying to decide whether the tool is right for you. I am also planning to leave plenty of time for questions!
Further Reading:
[Read more]
May
01
2012
Recently, got an opportunity to do some implementation using Ajax and PHP. Having previously used NetBeans IDE 6.1/6.5 for PHP, it was an obvious choice to come back to NetBeans IDE again.
Although, I am yet to download the latest version, I am currently using 6.8 and I enjoyed every bit of it, while playing with CSS and jQuery for the first time, while implementing Ajax with PHP.
As I am gonna stay with PHP for sometime now, so I guess I better get my NetBeans IDE upgraded, before I miss out on any useful features.
It’s good to be back