<div>
It can be effective. In my company we use it too and it works great because we can buy chepers hardware that one really big server.<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/replication.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/replication.html</a><br />
<br />
But remember that you make one server a 'master' and do all updates / inserts / deletes there, you can do selects one any of them. So you actually need to do a lot more selects then other queries.
</div>


It can be effective. In my company we use it too and it works great because we can buy chepers hardware that one really big server.

http://dev.mysql.com/doc/refman/5.0/en/replication.html [http://dev.mysql.com/doc/refman/5.0/en/replication.html]

But remember that you make one server a 'master' and do all updates / inserts / deletes there, you can do selects one any of them. So you actually need to do a lot more selects then other queries.

<div>
Sorry, I left the closing semicolon out on line #5. &nbsp;It should read:<br />
<br />
$sql=&quot;ALTER TABLE xxx etc.&quot;;<br />
<br />
Obviously, your own query goes in there, not mine.
</div>


Sorry, I left the closing semicolon out on line #5.  It should read:

$sql="ALTER TABLE xxx etc.";

Obviously, your own query goes in there, not mine.

<div>
Thanks for pointing the solutions.
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have multiple databases in my environment. Every user have one database with multiple tables.<br />
<br />
1. Is this an effective solutions?<br />
2. How to alter a table in all MySQL databases, if I need some changes?<br />
<br />
Thanks.
</div>
</div>


Experts,

I have multiple databases in my environment. Every user have one database with multiple tables.

1. Is this an effective solutions?
2. How to alter a table in all MySQL databases, if I need some changes?

Thanks.

How to alter a table in all MySQL databases?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.