Results 1 to 10 of 10
  1. #1

    Default Server SQL modes

    What are server SQL modes?

  2. #2
    Join Date
    Apr 2011
    Posts
    213

    Default

    Basically, it allows MySQL server to work in various SQL modes, means that you can apply these modes in an altered way for different clients. Overall, this enables each application to adapt the server’s operating mode to its own need.

  3. #3

    Default

    For more details you can refer the link -
    http://www.mysqlab.net/knowledge/kb/...ration/id/5787

  4. #4

    Default

    Which are the important SQL modes? How to set the SQL mode?

  5. #5

    Default

    The different SQL modes are as follows -
    High-Performance Mode.
    High Safety Mode.
    High safety with automatic failover.

    Please refer to http://kb.bodhost.com/sql-database-m...erating-modes/ for more details.

  6. #6
    Join Date
    Jan 2015
    Posts
    28

    Default

    Hello can you please elaborate what is the use of these modes and when are they appropriate to use..?
    Thanks -Van

  7. #7
    Join Date
    Jan 2015
    Posts
    8

    Default

    Quote Originally Posted by Van View Post
    Hello can you please elaborate what is the use of these modes and when are they appropriate to use..?
    Thanks -Van
    Hello Van,

    The High-performance mode can be useful in a disaster-recovery scenario in which the principal and mirror servers are separated by a significant distance and where you do not want small errors to impact the principal server..

    Thanks,
    Bruce
    Bruce Norman Earn up to $350 with bodHOST Web Hosting Affiliate Program
    Contact us: Live Chat | Email: sales[@]bodHOST[dot]com
    Ph: 866-662-0909, +1.302.294.5628

  8. #8
    Join Date
    Jan 2015
    Posts
    28

    Default

    Hello Bruce,
    Thank you for the information. However I wanted to know about all the three modes mentioned..

  9. #9
    Join Date
    Jan 2015
    Posts
    8

    Default

    Quote Originally Posted by Van View Post
    Hello Bruce,
    Thank you for the information. However I wanted to know about all the three modes mentioned..
    Hello Van,

    Sorry for delay..

    Here are the uses of other 2 modes we have on our SQL servers:
    1) High Safety Mode:
    The High-safety mode protects your data by requiring the data to be synchronized between two places. All the committed transactions are guaranteed to be written to disk on the mirror server.

    2) High Safety Mode with Automatic Fail-over:
    The High Safety Mode with Automatic fail-over provides high availability by ensuring that the database is still served after the loss of one server. Automatic fail-over requires that the session possess a third server instance, the witness, which ideally resides on a third computer. The following figure shows the configuration of a high-safety mode session that supports automatic failover.

    Best Regards,
    Bruce Norman Earn up to $350 with bodHOST Web Hosting Affiliate Program
    Contact us: Live Chat | Email: sales[@]bodHOST[dot]com
    Ph: 866-662-0909, +1.302.294.5628

  10. #10
    Join Date
    Jan 2015
    Posts
    28

    Default

    Quote Originally Posted by Bruce View Post
    Hello Van,

    Sorry for delay..

    Here are the uses of other 2 modes we have on our SQL servers:
    1) High Safety Mode:
    The High-safety mode protects your data by requiring the data to be synchronized between two places. All the committed transactions are guaranteed to be written to disk on the mirror server.

    2) High Safety Mode with Automatic Fail-over:
    The High Safety Mode with Automatic fail-over provides high availability by ensuring that the database is still served after the loss of one server. Automatic fail-over requires that the session possess a third server instance, the witness, which ideally resides on a third computer. The following figure shows the configuration of a high-safety mode session that supports automatic failover.

    Best Regards,
    Hello Bruce,
    Thank you for the short and informative description.. I was Expecting it little earlier as by now I have already got the answer to my question. :D -Van.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •