Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 66 Next 6 Older Entries

Displaying posts with tag: Technical (reset)

Load Delimited Data – CSV to MySQL, Excel to MySQL Database
+1 Vote Up -0Vote Down
Loading csv to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. In this article I will explain you about all different scenarios and explain you how to get the data loaded directly from csv to MySQL database […]
MySQL Memory Usage Limits on 32 bit Linux
+0 Vote Up -0Vote Down
I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the maximum capacity of the address space is 2^32 bytes and that is where these limits come from. * For MYSQL 5.0: Following are memory (storage) […]
MySQL Certification Free Retake: Get TWO chances to get MySQL Certified
+1 Vote Up -0Vote Down
Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) - MySQL 5.0 DBA Part I Certification (CX-310-810) - MySQL 5.0 DBA Part II Certification (CX-310-811) 2. MySQL 5.0 Developer Certification (SCMDEV) - MySQL 5.0 Developer […]
Monty: Help Saving MySQL – The Oracle & EC
+0 Vote Up -0Vote Down
And I looked back and thought of updating this post… We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that a business will always seek profit; so will Oracle. And thats where worries and fear for existance of MySQL as an open-source and future growth […]
MySQL Stored procedure – Split Delimited string into Rows
+0 Vote Up -0Vote Down
This procedure will split  a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And we want output as follows: So again I wrote a procedure. Procedure will read a data from “tmp” table and will split data by my_delimiter […]
MySQL Stored procedure – Execute query if table or Column exists
+0 Vote Up -0Vote Down
Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to particular table if it exists. Basically I created it to satisfy a need of altering a table if column exists. Now it can be used […]
Stored procedure to Find database objects
+0 Vote Up -0Vote Down
This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables. It uses information schema database to gather information and storing in a temporary table. [ad#ad-2-300x250] Usage: call xplore(database-name); - Procedure will search through information schema […]
MySQL master master replication monitor with php code
+0 Vote Up -0Vote Down
For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it Well this is fairly simple php code for monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following details: […]
Calculate Mysql Memory Usage – Quick Stored Proc
+0 Vote Up -0Vote Down
While going through mysql doc and MySQL Server Memory Usage, I noted following quick points regarding how mysql uses memory. We have global buffers which are allocated irrespective of connections as and when mysql server is started. Along with that mysql server allocates memory to each thread to perform respective tasks. So the formula goes: Mysql […]
Scheduled Backup MySQL Administrator & Windows Scheduler – Odd
+1 Vote Up -0Vote Down
Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4, Windows XP, Enough RAM Logs: General, Error & irrelevant here though Slow query. Prologue: Administrator performs scheduled backup properly in normal scenario. What I was […]
Monitor multiple mysql replication using php: Updated
+0 Vote Up -0Vote Down
Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication we know commands like: Show slave status; Show master status; Refer: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-replication.html But when it comes to non-gui interface, it becomes little tedious. With some […]
Quick Multi MySQL Server Installation with Master-Master Replication on Same Windows Box
+0 Vote Up -0Vote Down
This article is a brief step-by-step tutorial on the subject task which is divided into the following main parts: Installing two MySQL Server Instances Setting up master-slave replication Setting up slave-master replication Let’s begin covering those points… Installing Two MySQL Server Instances on Windows: 1. Install MySQL: Download MySQL Binaries from dev.mysql.com. Install normal MSI […]
Replication slave lag monitoring using heartbeat and windows batch scripts
+0 Vote Up -0Vote Down
“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter in monitoring and maintaining replication. This article explains us a way to monitor replication slave lag time. It also includes a sample batch scripts to […]
Search / find through all databases, tables, columns in MySQL
+0 Vote Up -0Vote Down
What will you do if one day some one ask you to find single string in all databases, all tables and in all columns? I just read such question and tried to find a “ready made” solution. Reusability is Key Concept !! But I ended up finding no “copy-paste” material. Some of the posts like http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm helped me […]
MySQL Master Master Replication and auto_increment_increment / auto_increment_offset
+0 Vote Up -0Vote Down
In this post we will see importance of replication related variables auto_increment_increment & auto_increment_offset with respect to MySQL Master Master setup. Consider we’ve already set a master-master replication. Now create following table on Server1: CREATE TABLE `temp` ( `id` int(10) NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; The table will will […]
Internal metadata, and why we recommend it
+2 Vote Up -0Vote Down

One of the things that repeatedly seem to puzzle users about the DRBD is the question of whether to use internal or external metadata. Remember, DRBD sets aside a small area on a local disk (on every cluster node) where it keeps the Activity Log, the quick-sync bitmap, data generation UUIDs, and a few other bits and pieces for local housekeeping.

The specific aspect that is to be discussed here is the Activity Log. Without going into too much detail, let’s be satisfied with the factoid that DRBD

  [Read more...]
My love affair with MySQL Cluster (contains benchmark stories)
+2 Vote Up -1Vote Down

As someone may have noticed, I recently wrote a trilogy on how to dive into the MySQL Cluster source code. Unfortunately my overtures towards the MySQL Cluster source code ended up being only a look-but-don't-touch affair, as I failed to actually get to touch her internals with my text editor. Even so, in this post I'd like to tell about the background to my love affair with this beauty, by relating to some benchmarks I've been working on together with my customers.

Oh, and I'd like to apologize already, that I cannot mention where these benchmarks were done, what the schema looked like and the exact numbers. If you want that kind of real benchmarks, you should read Mikael's blog, or watch the slides from this webinar

  [Read more...]
Look mom, no hands: I can fix MySQL Cluster bugs by just staring at them (part III)
+0 Vote Up -0Vote Down

(Continued from part II where I tried to fix a bug and found out that the affected part of the code had been rewritten, so the bug didn't exist anymore.)

Magnus gives a helpful hint...

read more

Actually trying to do something techical, part II: HowTo fix a MySQL Cluster bug without touching a single line of code!
+0 Vote Up -0Vote Down

This is part II of my efforts to prove myself that I can do programming. In part one I successfully created a MySQL Cluster branch for myself and compiled it.

Let's go to the public MySQL bug database and see if there are any trivial MySQL Cluster bugs I could sharpen my teeth on. Heh, sure enough #32658 looks simple enough. There is a typo in an output string - so I could fix that without even doing any C++ code! (Funnily, a MySQL internal comment to the bug says something about it being embarrassing. Guess it is a good bug for me then, as patching over embarrasments is what Sales Engineers do routinely :-)

Let me see...

read more

Actually trying to do something techical: branch a MySQL Cluster bzr repository - part 1, branch and build
+0 Vote Up -0Vote Down

My collagues Anders and even Ivan sometimes blog about the grandeur of being a Sales Engineer. And I agree, it is a great job, probably the best I ever had, so far. But let me share a secret: It's not as technical as you'd think. Sure, they call me a "pre-sales consultant" alright, but I would be ashamed of comparing my own work with those of the real consultants. I sometimes jokingly say that the most amazing technical things in my job are airplanes (they fly in the air!) and how to make a nice slideshow. (OpenOffice Impress sucks btw, and I always envy my OS X + Keynote using friends on this one

  [Read more...]
A few seats still left in DRBD Total on-line training
+0 Vote Up -0Vote Down

By popular demand, we are now offering an on-line incarnation of our DRBD Total training sessions, normally taught in a 4-day on-site course. The next such training commences on May 18 (next Monday), and we still have a few seats left — so if you’re interested, grab one while you still can!

What’s covered in this course?

Here is an overview of the course highlights:

  • Introduction to High Availability Clustering & DRBD
  • Setting up a DRBD resource and common failure scenarios
  • Configuring and running the Heartbeat/Pacemaker cluster stack
  • Highly available NFS, MySQL, and virtualization
  • DRBD performance tuning and optimization
  • DRBD integration with Red Hat Cluster Suite
  • Recent and future DRBD development

Every course attendee gets a virtual

  [Read more...]
Upload Image to MySQL using PHP
+0 Vote Up -0Vote Down
Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload. For Image Upload code, I’ve added code download link upload-image-mysql-demo.zip at the […]
Difference MyISAM and InnoDB Storage Engines Mysql
+0 Vote Up -0Vote Down
MyISAM InnoDB Default since version 3.23 Relatively newer Files storage: FRM: table definition, MYD: Actual Data MYI: Index File FRM: table definition .ibd file (concept of table space) or single huge .ibdataX No transation, Foreign key ACID Transactions, Foreign key, Rollback Low disk and memory utilisation Relatively high storage requirements (Almost 3 times disk space) […]
Choosing between MyISAM and INNODB – MySQL Storage Engines
+0 Vote Up -0Vote Down
After reading at a lot of places for the the single repeatative question, “What engine shall I choose – MyISAM or Innodb?”, this is what I’ve got. Following are points of consideration for MyISAM – MySQL storage engine: Tables are really fast for select-heavy loads Table level locks limit their scalability for write intensive multi-user […]
Using MySQLTuner – MySQL Optimization Tool
+0 Vote Up -0Vote Down
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. Downloading MySQLTuner: wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl Using MySQLTuner Script for Lampp systems: Just […]
Perl Script for Analyze – Optimize – Repair Mysql Databases
+0 Vote Up -0Vote Down
The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize and Repair you may ofcourse refer dev.mysql.com. OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you […]
DRBD for Dolphin Express Webinar
+0 Vote Up -0Vote Down

As part of our partnership with Dolphin Interconnect Solutions, we are presenting two webinars on DRBD for Dolphin Express on Nov. 5 (European business hours) and Nov. 12 (American business hours).

Both DRBD and Dolphin Express already being a fixture in the MySQL (http://www.mysql.com) universe, this webinar should be particularly interesting to those of you who want to minimize database write latency while maintaining fully redundant and transaction-safe high availability. However, it’s also a must see for virtualization and mail service DRBD users, who also typically have a need for low latency.

This is, of


  [Read more...]
Public draft of DRBD Users’ Guide released
+0 Vote Up -0Vote Down

A public draft version of the all-new DRBD Users’ Guide has just been released. Feedback is more than welcome.

You may want to read the announcement as well.


  [Read more...]
DRBD 8.2.3 released; boasts online device verification, CPU affinity optimization
+0 Vote Up -0Vote Down

DRBD 8.2.3 was released today. Even though just a micro release in terms of version numbering, it comes with a couple of very handy brand new features: on-line device verification, and tunable processor affinity.
(more…)



  [Read more...]
Step-by-step upgrade from DRBD 0.7 to DRBD 8
+0 Vote Up -0Vote Down

I’ve been asked by a number of people on how to do an upgrade from DRBD version 0.7 to DRBD 8. This upgrade does necessitate some minimal service down time, but it’s really not rocket science. And no, it does not force you to sync all of your data all over again.

Here’s my quick write-up.

An initial word of caution

Do not, I repeat do not attempt your upgrade unless you have at least read this blog entry to the finish.

Getting ready

First, you need to make sure that you have both your DRBD 8 userland binaries and kernel module ready to install. For our support customers, this means that you simply download two RPMs (or .debs) from our support web site. Make sure you have the right packages; you want those that match your system architecture and (for the kernel module) also your running


  [Read more...]
Previous 30 Newer Entries Showing entries 31 to 60 of 66 Next 6 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.