Replication in MySQL
This chapter describes the various replication features provided by MySQL. It introduces replication concepts, shows how to set up replication servers, and serves as a reference to the available replication options.

---

Advanced MySQL Replication Techniques
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.

---

A Quick Look at MySQL 5.4
There are other enhancements in MySQL 5.4 as well such as the introduction of DTrace support for MySQL on the Solaris platform, and a replication heartbeat, which helps ensure that master/slave topologies are up and running. All in all, the 5.4 release focuses quite a lot on transparent performance improvements and extra diagnostic and error handling capabilities, which are things normally always welcomed by developers and DBAs.

---

Modifying your MySQL databases to be UTF-8 compliant
Most of us have had problems with UTF-8 problems in PHP and MySQL. Here is how to modify your database and table to be UTF-8 compliant. Most of the time we do set the character set to utf8 but forget to set the collation set to utf8.

---

Optimize MySQL tables for speed
MySQL logo Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.

---

Building a High-Availability MySQL Cluster
Serious business services really can't go down, whether due to hardware or software failures. If your necessary services rely on MySQL, clustering and high availability can prevent failures. How MySQL Cluster and Heartbeat to provide redundant, failure-proof replication and availability of their data.

---

Optimize MySQL tables simple
Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db. Speed in MySQL is all about how fast the...

---

Creating Users and Setting Permissions in MySQL
MySQL is an extremely powerful database, but in order to properly maximize its potential you may need to learn how to set up users and their respective permissions. In this article take a look at using the MySQL console application to create users and grant permissions to them. We also shows us how to grant permissions from remote hosts, how to reduce user privledges and more. MySQL is an extremely powerful database, but in order to properly maximize its potential, you may need to learn how to set up users and their respective permissions.

---

Introduction to MySQL
MySQL is the most popular open source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.

---

Developing Database Applications Using MySQL Connector/C++
This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database.

---

MySQL Database Instructions
You can create up to 4 MySQL databases using the "Add MySQL Database" function of your Control Panel.

---

Backing Up And Restoring Your MySQL Database
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.

---

Backing Up/Restoring MySQL Databases
If you happen to have data stored in a MySQL database, it is good for you to learn how to backup and restore the database.

---

Introduction to MySQL database
MySql is a powerful database. This tutorial will explains an introduction of MySQL database.

---

MySQL 5.4: Up To 90% Faster Response
Sun Microsystems, Inc. today announced MySQL 5.4, a new version of the world's most popular open source database, designed to deliver significant performance and scalability improvements to MySQL applications.

---

What is MySQL
MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. It provides a very high performance and it is multi threaded and multi user Relational Database management system.

---

Build Your Own Database Driven Website Using PHP & MySQL: Part 4
you'll learn how to take information stored in a database and display it on a Web page for all to see. So far you have installed and learned the basics of MySQL, a relational database engine, and PHP, a server-side scripting language. Now you'll see how to use these two new tools together to create a true database-driven Web site!.

---

Using a MySQL database with PHP
It's time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination of PHP and MySQL. This article introduces the beginner to using MySQL with PHP.

---

Improve The Performance Of Your MySQL Server
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! Learn how to get the best performance from you MySQL database server.

---

What is MySQL?
MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use.

---

MySQL and SQL
In this tutorial, we cover the following topics:A short introduction to relational databases and relational modeling, A quick start guide to the winestore database and its full entity-relationship model, The MySQL command interpreter and the basic features of MySQL, Using SQL to create and modify databases, tables, and indexes, Using SQL to insert, delete, and update data, The SQL SELECT statement for querying, with examples of simple and advanced queries, Functions and operators in SQL and MySQL, Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL.

---

Getting to Grips with mySQL
This tutorial will show you how to create and query a database using SQL and the mySQL command terminal.

---

Open Tools for MySQL Administrators
The MySQL distribution provides several tools for database developers and administrators, but they don't always work everywhere. Fortunately, the worldwide MySQL community has produced plenty of useful tools.

---

How to Upgrade from MySQL v 3.x to MySQL 4.x
This tutorial will walk you through step by step to upgrade your MySQL database to version 4.x on a Windows Machine. We are going to assume to that you already have MySQL version 3.x or earlier installed on your Windows machine.

---

MySQL Basics
This MySQL tutorial is a guide for new MySQL users, providing a reference of very basic, step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time.

---

MySQL Made Easy With MySQL Front
MySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial see how to get up and running with MySQL Front.

---

Backup and Restore MySQL Databases
It is a good idea to backup your MySQL data occasionally as a precautionary measure. It is also a good idea to create a backup before making any major changes, incase something goes wrong and you need to revert to the unmodified version. Database backups can also be used to transfer your database from one server to another if you change web hosts.

---

MySQL SELECT query from PHP script
This tutorial will show you how to use MySQL querys to database in your PHP scripts.

---

Mysql Sub Queries, introduction
Mysql icon Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don't need to do that much programming in PHP, just let mysql do the work :-)

---

How fast can you sort data with MySQL?
See how much MySQL can sort 1.000.000 rows, or rather return top 10 rows from sorted result set which is the most typical way sorting is used in practice.

---

MySQL Optimization Hints
Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.

---

MySQL create user
In this MySQL create user article I try to summarize how you can add a new user to your MySQL database.

---

Understanding Various MySQL Executable Files
Learn how to the execute mysql file. MySQL Provide the executable file and uses the MySQL Client interactive file by this command "shell> mysql db_name ".

---

Build Your Own Database Driven Website Using PHP & MySQL: Part 2
This second installment covers an introduction to databases, logging on to MySQL, defining SQL, inserting data in a table, and modifying stored data.

---

Create Database and Table
Basic steps on how to setup a mysql database. Includes creating a tables, adding tables, and exporting a database.

---

Introduction to MySQL
Modern day web sites seem to be relying more and more on complex database systems. These systems store all of their critical data, and allow for easy maintenance in some cases. The Structured Query Language (SQL) is a very popular database language, and its standardization makes it quite easy to store, update and access data. One of the most powerful SQL servers out there is called MySQL and surprisingly enough.

---

Create New MySQL Database
You need to use mysqladmin to create MySQL database.

---

MySQL System Architecture
In this article, we're going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together.

---

Build Your Own Database Driven Website Using PHP & MySQL: Part 3
In this chapter, we'll introduce the PHP server-side scripting language. In addition to the basic features we'll explore here, this language has full support for communication with MySQL databases.

---

Writing Syslog Messages to MySQL
In this tutorial, I describe how to write syslog messages to a MySQL database.

---