MySQL's latest InnoDB engine can now do extensive, high-performance, full text search. A quick primer delivers all the goodies

People everywhere complain that Wordpress is slow, or that they can’t survive a digg. They die if they get more than 10,000 visitors a day, their hosting providers ban them for using too many resources, and they cry because they have to purchase expensive hosting plans. If this describes your plight, before you run over to Survive Digg hosting and plunk down even more money, take a look at your Wordpress setup and LAMP stack. You can make them better.

I spent some time getting MySQL clustering working with Ubuntu after reading a guide on Howto Forge. The guide however went into the details of compiling and installing MySQL from source so I’m creating this to show the steps needed to get it set up on a fresh Ubuntu installation.

There are a few guides out for setting up a MySQL Cluster already; unfortunately the large majority of them aren’t geared towards the beginner, and those that are generally involve a single-server setup. This guide will aim to explain the purpose of each choice and will get you up and running with a basic 3 server setup with a single load-balancing server.

I recently had to move our production database at Listia.com from a custom MySQL installation over to Amazon RDS.  The big benefits of RDS for us were automated backups, automatic failover to another availability zone, quick instance size scaling with no downtime (edit: up to 3 minutes of downtime, can be more if there are issues) , and super easy slave deployment.  We had been managing all of it ourselves over the past year with just 2-3 people (btw, we are well-funded and hiring now!) and it was taking up a lot of our time to maintain everything while scaling from 0 to over 20 million pageviews a month.

Until recently, I've been a fan of the PostgreSQL database, but Mysql's database replication implementation is very slick.

Not to disparage my favorite RDBMS too much, but PostgreSQL's replication mechanisms all seemed sort of kludgey. I'm not interested in creating update/delete triggers on all of my tables, for example. Mysql's mechanism is completely transparent to the client, and doesn't need any table definition changes; it's all done on the server(s).

When I refer to “database replication,” I'm not referring to a bulk file transfer. Nor am I referring to proxy mechanism that sends update/delete statements to multiple database servers. I'm referring to the ability to have a database update against one server reflected on multiple other servers without any additional intervention from the client. All this in what I would call “near real-time.” There is necessarily some propagation delay.

I already wrote about how to move or migrate user accounts from old Linux / UNIX server to a new server including mails and home directories. However, in reality you also need to move MySQL database which may host your blog, forum or just your data stored in MySQL database. The mysqldump command will only export the data and the table structure but it will not include a users grants and privileges. The main function of the MySQL privilege system (which is stored in mysql.user table) is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE.

An Open Source Microkernel DBMS for High Performance Scale-Out Applications

When you have more connections created in Navicat, sometimes it may not be easy to find a particular one in the navigation panel. With Virtual Grouping feature which is supported in Windows, Mac and Linux version, you can manage your connections into logical groups upon your preferences. This feature also applies to tables, views, functions, events, queries, reports, backups and schedules for your database. Thus, you can view connections and database objects in the navigation panel more convenient.

Did you experience any difficulties to find out a table or a view in a large number of connections and databases? If you have many connections and databases and need to access some tables or views frequently, you simply create Navicat table or view shortcuts in your desktop to open your tables or views directly. Both Navicat Windows and Mac versions support this feature. It can reduce the number of clicks to reach your tables or views, such as open Navicat, open connections, open databases and open schema, etc.

Navicat supports to import data from various file formats such as text files, excel files and CSV files, etc. To simplify the import steps, both Windows and Mac version can allow you to drag and drop a file to Navicat to launch the Import Wizard automatically. This feature applies to the import formats supported by Navicat. If an existing table is selected in Navicat, Navicat will import the file to the selected table; otherwise, it will import the file to a new table.