Fixing these two misfeatures is exactly the purpose of this article. Using features introduced in MySQL 5.0 and 5.1, it is possible to build a replication system where all nodes act as master and slave at the same time, with a built-in fail-over mechanism.
HuffingtonPost CTO to speak on Enterprise MySQL - 0 views
-
HuffingtonPost CTO to speak on Enterprise MySQL: Heavy-Traffic Management on Aug. 11 at the NYC MySQL Group http://www.meetup.com/mysqlnyc/calendar/10930810/
-
Please note that I added the meetup information which was left out previously
MySQL AB :: MySQL 5.1 Reference Manual :: 24.2.7.25 mysql_stmt_send_long_data() - 0 views
-
mysql_stmt_send_long_data()
-
Return Values Zero if the data is sent successfully to server. Non-zero if an error occurred.
MySQL AB :: MySQL 5.1 Reference Manual :: 24.2.7.4 mysql_stmt_bind_param() - 0 views
-
mysql_stmt_bind_param()
-
Return Values Zero if the bind operation was successful. Non-zero if an error occurred.
MySQL AB :: Using the New MySQL Query Profiler - 1 views
-
When it comes to overall performance, it's important to remember that the #1 contributor is always a good database design. The second highest contributor to performance is well-tuned SQL code.
-
But a better day has come along in MySQL 5.0.37 with the inclusion of the SQL Profiling utility. This interactive diagnostic aid allows a developer or DBA to gain insight into where a set of SQL code spends its time and the resources it is using.