tailieunhanh - Pro MySQL experts voice in open source phần 9

Tham khảo tài liệu 'pro mysql experts voice in open source phần 9', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 18 Replication Imagine for a moment that there was a single physical phone book for the entire country where you lived. This phone book was housed in a building in one city and had specific hours in which you were permitted to visit. Imagine that phone numbers weren t available from any other source. To look up a friend s phone number or find the number to call to make a reservation for dinner you d be required to travel to the phone book building get in line and wait for your turn to flip through the pages. You might imagine that over time special services would arise in which you could call in a request to the phone book office or a third-party service that would retrieve the number for you. You might argue that this arrangement makes having the phone book pointless and the data stored in the book of little value to anyone who needs immediate access to the data or who doesn t live within close proximity to the phone book office. Much like our phone book example organizations or applications often require multiple instances of their database either within the same physical space for scalability or redundancy or spread halfway around the world for geographic diversity. In either case the data needs to be available in multiple instances to provide value to the organization. Although issues with geographic diversity can sometimes be solved with good network connections there are plenty of cases in which having a separate instance of the data better serves the needs of the organization. Fortunately we don t live in a world where data has to be confined to a single physical location. With replication a MySQL database can exist partially or in its entirety in many different locations with each replicated instance following close behind the primary database. In the context of databases replication means creating a copy of the data in an alternate location. In most instances this means the data is available via a second or third server either in the same location

TÀI LIỆU LIÊN QUAN
TỪ KHÓA LIÊN QUAN
crossorigin="anonymous">
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.