servers on SWiK

CreditScheduler - Xen Wiki

Thu, 14 Aug 2008 06:05:29 -0700

Current Status Extension for Firefox

Wed, 13 Aug 2008 12:04:52 -0700

Using Federated Servers in MySQL? 5.1

Fri, 01 Aug 2008 04:07:31 -0700

[HoneyMonitor is a MySQL? GUI Tool for Windows? Systems. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com]

This is a short tutorial on the features implemented in HoneyMonitor for the use and administration of Federated Servers . It could be useful for Users who are new to the product and want to get start with it or to whom want to learn the basis of Federated Servers in MySQL? 5.1

More details on the HoneyMonitor Reference Manual at http://www.honeysoftware.com/honeymonitor/doc.

Introduction
Federated Server Metadata
Retrieving the list of Federated Servers
The Federated Server Editor
Creating a Federated Table Using the Create Table Wizard
Other Resources
About the Author

1. Introduction

Starting from MySQL? v.5.1.15-beta you can use the CREATE / ALTER / DROP SERVER syntax to manage your Federated Servers.

This can help you creating a FEDERATED table in a fast and more efficient way. In fact if you first create a Federated Server using the CREATE SERVER syntax, then you can create a federated table using the following simple create table option

CONNECTION = ‘federated_server_name’

instead of the longer

CONNECTION = ‘mysql://user_name [:password]@host_name[:port_num] /db_name/tbl_name’

Note that starting from version 5.1.26-rc, the FEDERATED storage engine is disabled by default in binary distributions. The engine is still available and can be enabled by starting the server with the –federated option.

For more information about Federated Server, please visit http://dev.mysql.com/doc/refman/5.1/en/federated-storage-engine.html.

2. Federated Server Metadata

In the database mysql there is a table - mysql.servers ? where all the information about the Federated Servers are stored:

mysql> SELECT * FROM mysql.servers LIMIT 1\G
*************************** 1. row ***************************
Server_name: server1
       Host: localhost
         Db: mysql
   Username: root
   Password:
       Port: 6005
     Socket:
    Wrapper: mysql
      Owner:
1 row in set (0.00 sec)

3. Retrieving the list of Federated Servers

Federated Servers are listed in the Federated Servers node of the Server Objects List (Fig. 1).

Fig.1: Server Objects List - Federated Servers

You can create / edit / drop a Federated Server using node’s popup menu.

4. The Federated Server Editor

The Federated Server Editor (Fig. 2), allows you to create / edit a Federated Server.

Fig. 2: The Federated Server Editor - Advanced Tab

You have to set the server name and (at least) one option to create a Federated Server.

After you set the Server’s parameters you can click on the button ‘Test Connection’ to test the connection to the MySQL? Server.

After the creation of the Server, the SQL Tab (Fig. 3) ? now enabled - will contain the SQL syntax for recreating the current Server.

Fig. 3: The Federated Server Editor - SQL Tab

5. Creating a Federated Table Using the Create Table Wizard

The Create Table Wizard helps you creating tables in a simply and fast way (Fig. 4).

Fig. 4: The Create Table Wizard

The Wizard includes a ‘Connection’ option; when creating a Federated Table you can fill it with the connection string (’mysql://user_name[:password]@ host_name [:port_num]/db_name/tbl_name’) or just with the name of the Federated Server you created with Federated Server Editor.

By clicking on button at the right of the ‘Connection’ field, the Federated Server List will be opened thus helping you choosing an existing Federated Server - without the need of writing its name - or creating one more (Fig. 5).

Fig. 5: The Federated Server List

6. Other Resources

If you want to learn more on HoneyMonitor please visit the Project Home Page, at http://www.honeysoftware.com/honeymonitor, or check out one of the following resources:

7. About the Author

Santo Leto is a two years experience MySQL? DBA and Developer.
Leader and main programmer of the HoneyMonitor Project, he graduated in physics and he lives in Italy, where he works from home.

[from obrun] HP ProLiant DL Servers At a glance - HP Large Enterprise Business products

Wed, 23 Jul 2008 17:53:45 -0700

freshmeat.net: Project details for smtp2mix

Mon, 21 Jul 2008 05:46:31 -0700

Hoe krijg je URL rewriting htaccess werkend op localhost

Mon, 14 Jul 2008 05:54:33 -0700

Hoe krijg je URL rewriting htaccess werkend op localhost

Mon, 14 Jul 2008 05:54:33 -0700

Hoe krijg je URL rewriting htaccess werkend op localhost

Mon, 14 Jul 2008 05:54:31 -0700

What is Microsoft exchange hosting?

Tue, 08 Jul 2008 02:57:57 -0700

Exchange Server is a messaging and collaborative software product developed by Microsoft which is made available by hosting companies to clients looking for Exchange hosting solutions. Microsoft’s Exchange server provides industry leading defensive security technologies especially developed to maximize productivity while reducing spam and viruses. Business can rest assured that Exchange server delivers robust communication [...]

Mano's Tech World " Blog Archive " Running multiple JBoss instances on the same machine

Wed, 02 Jul 2008 11:47:39 -0700

Applications | JumpBox Inc.

Fri, 27 Jun 2008 19:56:39 -0700

What is managed web hosting?

Wed, 25 Jun 2008 15:03:58 -0700

Companies have found that with the constant increase in internet based business, networking reliance has become an increasing concern requiring immediate attention. Managed web hosting or dedicated server hosting, is a form of internet hosting that provides improved scalability for consumers requiring full control over the server without needing to invest a huge amount of [...]

What is web server collocation?

Wed, 25 Jun 2008 15:03:58 -0700

Server collocation is a new method for maintaining mission-critical data in which customers allocate their servers, networks and storage equipment in a datacenter usually referred to as a Collocation Center. In essence these customers will store their own hardware and all other network equipment in a datacenter alongside that of other customers, to be interconnected [...]

Ubuntu 8.04 Active Directory Integration w/ Likewise Open

Tue, 24 Jun 2008 04:59:37 -0700

[from bushwald] Parallels Server for Mac released

Wed, 18 Jun 2008 06:21:27 -0700

15 Tools to Help You Develop Faster Web Pages - Six Revisions

Thu, 12 Jun 2008 16:17:22 -0700

freshmeat.net: Project details for Fenice

Thu, 12 Jun 2008 08:16:48 -0700

Postfix Rate Controls

Mon, 09 Jun 2008 06:53:32 -0700

<sep/>is one thing; building one that does not knock over other systems is a different story [...] Postfix tries to be a fast mailer and a good neighbor at the same time."

Build your own Google

Fri, 06 Jun 2008 05:55:25 -0700

[from bushwald] HP blade server targets cloud computing

Fri, 30 May 2008 14:47:11 -0700

In response to IBM's iDataPlex?

[from bushwald] Dell Touts Gains in Cloud Server War - Data Center Knowledge

Fri, 30 May 2008 14:47:08 -0700

[from bushwald] Few Data Centers Sharing Info With EPA

Fri, 30 May 2008 14:47:07 -0700

"Just 54 data centers have volunteered to provide data on their energy usage to the Environmental Protection Agency, which hopes to use the information to develop an Energy Star certification for data center facilities."

Public SIP Servers

Thu, 29 May 2008 16:46:20 -0700

How to do data portability (Scripting News)

Tue, 27 May 2008 05:21:02 -0700

How to Install and Setup IPCop as your Linux based router. creating a DMZ for hosting your own web server or mail server and the Copfilter proxy for filtering web and email traffic.

Tue, 20 May 2008 14:15:37 -0700

Samba GUI Information

Tue, 20 May 2008 07:15:27 -0700

Nexenta Systems - ZFS-based software storage solutions - Front Page

Tue, 20 May 2008 05:18:07 -0700

Server Virtualization Technology Tools and News | VirtualizationManager.com

Tue, 20 May 2008 04:26:09 -0700

Awesome virtualization software with excellent presentation.

Server Virtualization Technology Tools and News | VirtualizationManager.com

Tue, 20 May 2008 03:24:11 -0700

Radar

Fri, 16 May 2008 13:24:21 -0700

Radar is a virtual machine deployment & management engine.

servers on SWiK

CreditScheduler - Xen Wiki

Current Status Extension for Firefox

Using Federated Servers in MySQL? 5.1

[HoneyMonitor is a MySQL? GUI Tool for Windows? Systems. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com]

Contents

1. Introduction

2. Federated Server Metadata

3. Retrieving the list of Federated Servers

4. The Federated Server Editor

5. Creating a Federated Table Using the Create Table Wizard

6. Other Resources

7. About the Author

[from obrun] HP ProLiant DL Servers At a glance - HP Large Enterprise Business products

freshmeat.net: Project details for smtp2mix

Hoe krijg je URL rewriting htaccess werkend op localhost

Hoe krijg je URL rewriting htaccess werkend op localhost

Hoe krijg je URL rewriting htaccess werkend op localhost

What is Microsoft exchange hosting?

Mano's Tech World " Blog Archive " Running multiple JBoss instances on the same machine

Applications | JumpBox Inc.

What is managed web hosting?

What is web server collocation?

Ubuntu 8.04 Active Directory Integration w/ Likewise Open

[from bushwald] Parallels Server for Mac released

15 Tools to Help You Develop Faster Web Pages - Six Revisions

freshmeat.net: Project details for Fenice

Postfix Rate Controls

Build your own Google

[from bushwald] HP blade server targets cloud computing

[from bushwald] Dell Touts Gains in Cloud Server War - Data Center Knowledge

[from bushwald] Few Data Centers Sharing Info With EPA

Public SIP Servers

How to do data portability (Scripting News)

How to Install and Setup IPCop as your Linux based router. creating a DMZ for hosting your own web server or mail server and the Copfilter proxy for filtering web and email traffic.

Samba GUI Information

Nexenta Systems - ZFS-based software storage solutions - Front Page

Server Virtualization Technology Tools and News | VirtualizationManager.com

Server Virtualization Technology Tools and News | VirtualizationManager.com

Radar